update query in linq to sql
/// <summary>
/// Update to user profile for current user.
/// </summary>
/// <returns></returns>
public bool UpdateUserProfile(string FirstName, string LastName, string Email, string Country, string ZipCode, string TimeZone)
{
using (var dbContext = new BMServices_AzureEntities(DataAccess.ConnectionStringManager.ConnectionString))
{
core_Users newUser = new core_Users();
newUser = dbContext.core_Users.Where(usr => usr.userEmail == Email).SingleOrDefault();
if (newUser!=null)
newUser.firstName = FirstName;
newUser.lastName = LastName;
newUser.countryId = Convert.ToInt32(Country);
newUser.zipCode = ZipCode;
newUser.timeZoneId = Convert.ToInt32(TimeZone);
dbContext.SaveChanges();
return true;
}
}
/// <summary>
/// Update to user profile for current user.
/// </summary>
/// <returns></returns>
public bool UpdateUserProfile(string FirstName, string LastName, string Email, string Country, string ZipCode, string TimeZone)
{
using (var dbContext = new BMServices_AzureEntities(DataAccess.ConnectionStringManager.ConnectionString))
{
core_Users newUser = new core_Users();
newUser = dbContext.core_Users.Where(usr => usr.userEmail == Email).SingleOrDefault();
if (newUser!=null)
newUser.firstName = FirstName;
newUser.lastName = LastName;
newUser.countryId = Convert.ToInt32(Country);
newUser.zipCode = ZipCode;
newUser.timeZoneId = Convert.ToInt32(TimeZone);
dbContext.SaveChanges();
return true;
}
}
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|