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