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