public DateTime GetBusinessDay()
{
using (var gbData = new UERPDataAccess())
{
return(DateTime.Parse(gbData.GetDataOnDatesetBySqlCommand("SELECT GETDATE()").Tables[0].Rows[0][0].ToString()));
}
}
public int GetSecurityModuleByControllerAction(string controller, string action)
{
using (var gbData = new UERPDataAccess())
{
return(int.Parse(gbData.GetDataOnDatesetBySqlCommand("SELECT AspNetSecurityModuleId FROM AspNetSecurityModule WHERE ControllerName='" + controller + "' AND ActionName='" + action + "'").Tables[0].Rows[0][0].ToString()));
}
}
public DataSet GetDataBySqlCommand(string sql)
{
using (var gbData = new UERPDataAccess())
{
return(gbData.GetDataOnDatesetBySqlCommand(sql));
}
}
