public int GroupIDByUserName(string UserName) { SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@UserName", UserName); object GroupID; GroupID = SQLDB.executesalar("sp_GroupIDByUserName", CommandType.StoredProcedure); return int.Parse(GroupID.ToString()); }
public int Users_Login( string UserName,string PassWord) { object result; SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@UserName", UserName); SQLDB.Addparameter("@PassWord", PassWord); result = SQLDB.executesalar("sp_Users_Login", CommandType.StoredProcedure); return int.Parse(result.ToString()); }
public string Gio_Phong_KiemTraStatus(int PhongID) { object status; SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@PhongID", PhongID); status = SQLDB.executesalar("sp_Gio_Phong_KiemTraStatus", CommandType.StoredProcedure); return status.ToString(); }
public decimal Gio_Phong_GiaGoc(int PhongID) { object GiaGoc; SQLDataHelper SQLDB = new SQLDataHelper(); SQLDB.Addparameter("@PhongID", PhongID); GiaGoc = SQLDB.executesalar("sp_Gio_Phong_GiaGoc", CommandType.StoredProcedure); return decimal.Parse(GiaGoc.ToString()); }