public virtual List <Voucher_Viewer> GetAllVoucher(string Status, string comCode, string OCODE)
{
using (_context)
{
var ParamempID = new SqlParameter("@ApprovalStatus", Status);
var ParamempID1 = new SqlParameter("@Company_Code", comCode);
var ParamempID2 = new SqlParameter("@OCode", OCODE);
string SP_SQL = "Vch_Get_AllAC_VoucherList @ApprovalStatus,@Company_Code,@OCode";
var result = _context.ExecuteStoreQuery <Voucher_Viewer>(SP_SQL, ParamempID, ParamempID1, ParamempID2);
return(result.ToList());
}
}
internal List <RUserAccessRole> GetUserAccessInfoForDelete(string Ocode, string UserId)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var ParamempID = new SqlParameter("@ocode", Ocode);
var ParamempID1 = new SqlParameter("@UserId", UserId);
string SP_SQL = "[HRM_GetUserAccessListByUserId] @ocode,@UserId";
return((_context.ExecuteStoreQuery <RUserAccessRole>(SP_SQL, ParamempID, ParamempID1)).ToList());
}
}
catch (Exception)
{
throw;
}
}
internal List <PPermissionList> getPagePermissionByRoleId(string Ocode, int role)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var ParamempID = new SqlParameter("@ocode", Ocode);
var ParamempID1 = new SqlParameter("@RoleId", role);
string SP_SQL = "[HRM_GetPageParmissionListByRoleId] @ocode,@RoleId";
return((_context.ExecuteStoreQuery <PPermissionList>(SP_SQL, ParamempID, ParamempID1)).ToList());
}
}
catch (Exception)
{
throw;
}
}
//for dropdown list - Lesger list
internal List <Ac_Configuration_Ledger> GetAc_Configuration_Ledger(string OCode, string Company_Code)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var OCode_ = new SqlParameter("@OCode", OCode);
var Company_Code_ = new SqlParameter("@Company_Code", Company_Code);
string SP_SQL = "Leg_Get_AC_LedgerByVoucher @Company_Code,@OCode";
return((_context.ExecuteStoreQuery <Ac_Configuration_Ledger>(SP_SQL, Company_Code_, OCode_)).ToList());
}
}
catch (Exception)
{
throw;
}
}
//for sales User Summary display
internal List <Ac_Sales_Summary> GetAc_SalesSummary(string OCode, string SaleType)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var OCode_ = new SqlParameter("@OCode", OCode);
var SaleType_ = new SqlParameter("@SaleType", SaleType);
string SP_SQL = "EPO_Get_UserSales_Summary @OCode,@SaleType";
return((_context.ExecuteStoreQuery <Ac_Sales_Summary>(SP_SQL, OCode_, SaleType_)).ToList());
}
}
catch (Exception)
{
throw;
}
}
internal IEnumerable <RPage> GetPages(string Ocode)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var ParamempID = new SqlParameter("@OCODE", Ocode);
string SP_SQL = "Adp_GetPageList @OCODE";
return((_context.ExecuteStoreQuery <RPage>(SP_SQL, ParamempID)).ToList());
}
}
catch (Exception)
{
throw;
}
}
//for module main comfiguration
internal List <Ac_Configuration> GetAc_Configuration(string OCode, string ModuleType, string VoucherType)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var OCode_ = new SqlParameter("@OCode", OCode);
var ModuleType_ = new SqlParameter("@ModuleType", ModuleType);
var VoucherType_ = new SqlParameter("@VoucherType", VoucherType);
string SP_SQL = "Conf_Get_Module_Ledger @OCode,@ModuleType,@VoucherType";
return((_context.ExecuteStoreQuery <Ac_Configuration>(SP_SQL, OCode_, ModuleType_, VoucherType_)).ToList());
}
}
catch (Exception)
{
throw;
}
}
internal List <RUserAccessRole> GetUserAccessInfobyModuleandUserId(string Ocode, string UserId, int moduleId, int featureId)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var ParamempID = new SqlParameter("@ocode", Ocode);
var ParamempID1 = new SqlParameter("@UserId", UserId);
var ParamempID2 = new SqlParameter("@moduleId", moduleId);
var ParamempID3 = new SqlParameter("@CategoryId", featureId);
string SP_SQL = "[HRM_GetUserAccessListByUserIdModuleIdAndCategoryId] @ocode,@UserId,@moduleId,@CategoryId";
return((_context.ExecuteStoreQuery <RUserAccessRole>(SP_SQL, ParamempID, ParamempID1, ParamempID2, ParamempID3)).ToList());
}
}
catch (Exception)
{
throw;
}
}
internal IEnumerable <RPage> CategoryesForgridValue(string Ocode, int catagoryValue)
{
try
{
using (var _context = new ERPSSL_AdminEntities1())
{
var ParamempID = new SqlParameter("@OCODE", Ocode);
var CatagoryValue = new SqlParameter("@CatagoryId", catagoryValue);
string SP_SQL = "Adp_GetPageListByCatagoryId @OCODE,@CatagoryId";
return((_context.ExecuteStoreQuery <RPage>(SP_SQL, ParamempID, CatagoryValue)).ToList());
}
}
catch (Exception)
{
throw;
}
}
