private void SaveBTN_Click(object sender, EventArgs e)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
System.IO.MemoryStream ms = new System.IO.MemoryStream();
ProfilePicPB.Image.Save(ms, ProfilePicPB.Image.RawFormat);
byte[] arrpic = ms.GetBuffer();
ToLet.Database.DBConnectionProvider.getDBConnection();
if (EditPasswordTB.Text != ConfirmEditPasswordTB.Text)
{
EditPasswordTB.Text = "";
EditPasswordTB.Text = "";
MessageBox.Show("Password not matched");
}
else if (EditPasswordTB.Text == "" || ConfirmEditPasswordTB.Text == "")
{
MessageBox.Show("Invalid PassWord");
}
else if (MobileTB.Text == "")
{
MessageBox.Show("Invalid Mobile number");
}
else if (EmailTB.Text == "")
{
MessageBox.Show("Invalid Email");
}
else if (AddressTB.Text == "")
{
MessageBox.Show("Invalid Address");
}
else
{
ToLet.Classes.EditProfile ep = new ToLet.Classes.EditProfile(ConfirmEditPasswordTB.Text, EmailTB.Text, NidTB.Text, AddressTB.Text, int.Parse(MobileTB.Text));
ToLet.DBDataProvider.DBDataProvider.UpdateUser(ep, this.user, arrpic);
Image propic = ToLet.DBDataProvider.DBDataProvider.getProPic(user, pass);
ProPB.Image = propic;
MessageBox.Show("Updated Successfully");
SaveBTN.Visible = false;
EditProfileBTN.Visible = true;
BrowseNewProPicBTN.Visible = false;
EditPasswordLBL.Visible = false;
EditPasswordTB.Visible = false;
ConfirmEditPasswordLBL.Visible = false;
ConfirmEditPasswordTB.Visible = false;
}
}
public static void UpdateUser(ToLet.Classes.EditProfile ep, string username, byte[] arrpic)
{
DataClasses1DataContext cntx = ToLet.Database.DBConnectionProvider.getDBConnection();
User user = cntx.Users.SingleOrDefault(x => x.UserName == username);
user.Password = ep.Password;
int id = user.UserId;
UserInfo uinfo = cntx.UserInfos.SingleOrDefault(y => y.UserId == id);
uinfo.MobileNo = ep.MobileNo;
uinfo.Email = ep.Email;
uinfo.Address = ep.Address;
uinfo.Profile_Pic = arrpic;
cntx.SubmitChanges();
}
