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