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