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