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;
}
}