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 DateTime GetBusinessDay() { using (var gbData = new UERPDataAccess()) { return(DateTime.Parse(gbData.GetDataOnDatesetBySqlCommand("SELECT GETDATE()").Tables[0].Rows[0][0].ToString())); } }
public int ExecuteStoredProcedure <TParamOType>(TParamOType target, string storedProcedure) where TParamOType : class { using (var gbData = new UERPDataAccess()) { return(gbData.ExecuteNonQuery(storedProcedure, target)); } }
public DataSet GetDataWithoutParameter(string storeProcedureName) { using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDatesetWithoutParam(storeProcedureName)); } }
public DataSet GetDataBySqlCommand(string sql) { using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDatesetBySqlCommand(sql)); } }
public DataSet GetDataWithParameter <TParamOType>(TParamOType target, string storeProcedureName) where TParamOType : class { using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public DataSet UpdateAspNetUserName <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "UpdateAspNetUserName"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public DataSet GetReportPermissionModule <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "USP_ReportAccessModule"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public DataSet GetAspNetRoleModule <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "USP_GET_Rolewise_Child_Menu"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public DataSet GetEmployeeForRegister() { var storeProcedureName = "USP_GET_EMPLOYEE_FOR_REGISTER"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDatesetWithoutParam(storeProcedureName)); } }
public DataSet GetAspNetUserList() { var storeProcedureName = "USP_GetAspNetUserList"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDatesetWithoutParam(storeProcedureName)); } }
public DataSet SP_GETAspNetRoleModuleIdIsactiveZero <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "USP_GETAspNetRoleModuleIdIsactiveZero"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public DataSet SP_UPDATEAspNetRoleSecurityLevelId <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "USP_UPDATEAspNetRoleSecurityLevelId"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public int SaveAspNetRoleModule <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "INSERT_AspNetRoleModule"; using (var gbData = new UERPDataAccess()) { return(gbData.ExecuteNonQuery(storeProcedureName, target)); } }
public DataSet GetAspNetSecurityModuleRole <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "USP_AspNetSecurityModuleRole"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target)); } }
public DataSet GetEmployeeForRegister <TParamOType>(TParamOType target) where TParamOType : class { var storeProcedureName = "USP_GET_EMPLOYEE_FOR_REGISTER"; using (var gbData = new UERPDataAccess()) { return(gbData.GetDataOnDateset(storeProcedureName, target));//menuSPService } }