public bool UpdateUser(string email)
{
if (txtEmail.Text != "")
{
bool blSuccess = true;
try
{
NationalBuilderSupplyData.NBSDataDataContext mydb = new NationalBuilderSupplyData.NBSDataDataContext();
var users = from a in mydb.NBSUsers
where a.UserID == Convert.ToInt16(Session["UserId"].ToString())
select a;
foreach (NationalBuilderSupplyData.NBSUser us in users)
{
us.email = email;
}
// Submit the changes to the database.
mydb.SubmitChanges();
lblResult.Visible = true;
lblResult.Text = "user email updated!";
}
catch (Exception ex)
{
//log error somewhere
blSuccess = false;
}
return blSuccess;
}
else
{
return false;
}
}
public void LoadUser(int UserID)
{
NationalBuilderSupplyData.NBSDataDataContext mydb = new NationalBuilderSupplyData.NBSDataDataContext();
NationalBuilderSupplyData.NBSUser user = mydb.NBSUsers.Single(u => u.UserID == UserID);
txtEmail.Text = user.email;
}
