public bool Edit(string name, string password) { try { using (DB_ModelDemo_DBSmartAspEntities dbedt = new DB_ModelDemo_DBSmartAspEntities()) { UserInformation usrinfo1; usrinfo1 = (from i in dbedt.UserInformations where i.UserPassword == password select i).FirstOrDefault(); if (usrinfo1 != null) { usrinfo1.UserName = name; dbedt.SaveChanges(); usrinfo1 = null; usrinfo1 = null; return(true); } else { usrinfo1 = null; return(false); } } } catch { return(false); } }
public bool insert(string name, string password) { try { using (DB_ModelDemo_DBSmartAspEntities dbinsrt = new DB_ModelDemo_DBSmartAspEntities()) { UserInformation usrinfoinset = new UserInformation(); var ExistUserinsrt = (from i in dbinsrt.UserInformations where i.UserPassword == password select i).FirstOrDefault(); if (ExistUserinsrt == null) { usrinfoinset.UserName = name; usrinfoinset.UserPassword = password; dbinsrt.UserInformations.Add(usrinfoinset); dbinsrt.SaveChanges(); usrinfoinset = null; ExistUserinsrt = null; return(true); } else { usrinfoinset = null; return(false); } } } catch { return(false); } }
public bool delete(string password) { try { using (DB_ModelDemo_DBSmartAspEntities dbdel = new DB_ModelDemo_DBSmartAspEntities()) { UserInformation usrinfo1; usrinfo1 = (from i in dbdel.UserInformations where i.UserPassword == password select i).FirstOrDefault(); if (usrinfo1 != null) { usrinfo1.UserPassword = password; dbdel.UserInformations.Remove(usrinfo1); dbdel.SaveChanges(); usrinfo1 = null; usrinfo1 = null; return(true); } else { usrinfo1 = null; return(false); } } } catch { return(false); } }