public static bool SaveRecordDB(MISManager manager)
{
string queryText = String.Format("Insert into users values ('{0}','{1}','{2}','{3}',{4})",
manager.FirstName, manager.LastName, manager.UserName, manager.Password, manager.RoleId);
return(MISManagerDB.SqlNonQuery(queryText));
}
public static bool UpdateRecordDB(MISManager manager)
{
string queryText = String.Format("Update users set FirstName = '{0}', LastName = '{1}', " +
" UserName = '******', Password='******', RoleID = {4} where UserID = {5} ",
manager.FirstName, manager.LastName, manager.UserName, manager.Password, manager.RoleId, manager.UserId);
return(MISManagerDB.SqlNonQuery(queryText));
}
public static bool DelRecoredDB(MISManager manager)
{
string queryText = String.Format("Delete From users where UserID = {0} ", manager.UserId);
return(MISManagerDB.SqlNonQuery(queryText));
}