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