private static SystemConfigEntity GetSystemConfig()
{
ERPSettingDataContext _context = new ERPSettingDataContext();
Logger.Info(_logMsg.Clear().SetPrefixMsg("GetSystemConfig").ToInputLogString());
try
{
IQueryable <SystemConfigEntity> query = from c in _context.CF_SYSTEM_CONFIG.AsNoTracking()
where c.system_config_id == 1
select new SystemConfigEntity
{
DbSetting = c.db_setting,
DbPurchase = c.db_purchase,
DbSales = c.db_sales,
DbWms = c.db_wms,
DbInventory = c.db_inventory,
DbTransportation = c.db_transportation,
DbProduction = c.db_prodction,
DbPlanning = c.db_planning
};
return(query.Any() ? query.FirstOrDefault() : null);
}
catch (Exception e)
{
Logger.Error("Exception :" + e.Message);
return(null);
}
}
private static PolicyConfigEntity GetSystemConfig()
{
ERPSettingDataContext _context = new ERPSettingDataContext();
Logger.Info(_logMsg.Clear().SetPrefixMsg("GetPolicyConfig").ToInputLogString());
try
{
IQueryable <PolicyConfigEntity> query = from c in _context.CF_POLICY_CONFIG.AsNoTracking()
where c.policy_config_id == 1
select new PolicyConfigEntity
{
MaxLoginFail = c.max_login_fail
};
return(query.Any() ? query.FirstOrDefault() : null);
}
catch (Exception e)
{
Logger.Error("Exception :" + e.Message);
return(null);
}
}
public CommonFacade()
{
_context = new ERPSettingDataContext();
}
