public List <SubSiteBankFeeConfigDTO> BankFee(Guid Id)
{
try
{
List <SubSiteBankFeeConfigDTO> SubSiteBankFeeConfigDTOList = new List <SubSiteBankFeeConfigDTO>();
var SubSiteFeeConfig = db.SubSiteFeeConfigs.Where(o => o.emp_CustomerInformation_ID == Id).ToList();
foreach (var item in SubSiteFeeConfig)
{
SubSiteBankFeeConfigDTO SubSiteBankFeeConfig = new SubSiteBankFeeConfigDTO();
List <SubSiteBankFeesConfig> SubSiteBankFeeConfigList = new List <SubSiteBankFeesConfig>();
SubSiteBankFeeConfigList = db.SubSiteBankFeesConfigs.Where(o => o.emp_CustomerInformation_ID == Id && o.SubSiteFeeConfig_ID == item.ID).ToList();
foreach (var BankFees in SubSiteBankFeeConfigList)
{
SubSiteBankFeeConfig.AmountDSK = BankFees.BankMaxFees;
}
SubSiteBankFeeConfig.ServiceorTransmitter = item.ServiceorTransmission == 1 ? (int)EMPConstants.FeesFor.SVBFees : (int)EMPConstants.FeesFor.TransmissionFees;
SubSiteBankFeeConfigDTOList.Add(SubSiteBankFeeConfig);
}
return(SubSiteBankFeeConfigDTOList);
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/BankFee", Id);
return(new List <SubSiteBankFeeConfigDTO>());
}
}
/// <summary>
/// This Method is used to Get the Sub Site Bank Fee Configuration details by ID
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public IQueryable <SubSiteBankFeeConfigDTO> GetSubSiteBankFeeById(Guid userid)
{
try
{
db = new DatabaseEntities();
var data = (from cu in db.SubSiteBankFeesConfigs where cu.emp_CustomerInformation_ID == userid select cu).ToList();
List <SubSiteBankFeeConfigDTO> lstsbsubsiteBankFee = new List <SubSiteBankFeeConfigDTO>();
foreach (var itm in data)
{
SubSiteBankFeeConfigDTO subsiteBFDTO = new SubSiteBankFeeConfigDTO();
subsiteBFDTO.RefId = itm.emp_CustomerInformation_ID.ToString();
subsiteBFDTO.BankID = itm.BankMaster_ID.ToString();
subsiteBFDTO.ServiceorTransmitter = itm.ServiceOrTransmitter ?? 0;
subsiteBFDTO.AmountDSK = itm.BankMaxFees;
subsiteBFDTO.AmountMSO = itm.BankMaxFees_MSO ?? 0;
subsiteBFDTO.QuestionID = itm.QuestionID.ToString();
lstsbsubsiteBankFee.Add(subsiteBFDTO);
}
return(lstsbsubsiteBankFee.AsQueryable());
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/GetSubSiteBankFeeById", userid);
return(null);
}
}
public IQueryable <SubSiteBankFeeConfigDTO> SubSiteOfficeBankFee(Guid UserId)
{
try
{
DropDownService ddService = new DropDownService();
List <EntityHierarchyDTO> EntityHierarchyDTOs = new List <EntityHierarchyDTO>();
EntityHierarchyDTOs = ddService.GetEntityHierarchies(UserId);
Guid ParentId = Guid.Empty;
Guid FeeSourceParentId = Guid.Empty;
if (EntityHierarchyDTOs.Count > 0)
{
var TopFromHierarchy = EntityHierarchyDTOs.OrderByDescending(o => o.Customer_Level).FirstOrDefault();
ParentId = TopFromHierarchy.CustomerId ?? Guid.Empty;
}
db = new DatabaseEntities();
List <int> FeeFor = new List <int>();
FeeFor.Add((int)EMPConstants.FeesFor.SVBFees);
FeeFor.Add((int)EMPConstants.FeesFor.TransmissionFees);
List <SubSiteBankFeeConfigDTO> ListDTO = new List <SubSiteBankFeeConfigDTO>();
if (EntityHierarchyDTOs.Count <= 1)
{
var data = (from fee in db.FeeMasters
//join cust in db.CustomerAssociatedFees on fee.Id equals cust.FeeMaster_ID
where FeeFor.Contains(fee.FeesFor ?? 0) //&& cust.emp_CustomerInformation_ID == ParentId
select new { fee.FeesFor, fee.Amount }).ToList();
var dataa = (from s in data
group s by s.FeesFor into g
select new
{
feesfor = g.Key,
Amount = g.Sum(x => x.Amount)
}).ToList();
foreach (var itm in dataa.ToList())
{
SubSiteBankFeeConfigDTO SubSiteBankFeeConfig = new SubSiteBankFeeConfigDTO();
SubSiteBankFeeConfig.ServiceorTransmitter = itm.feesfor ?? 0;
SubSiteBankFeeConfig.AmountDSK = itm.Amount ?? 0;
ListDTO.Add(SubSiteBankFeeConfig);
}
}
else
{
var data = (from fee in db.FeeMasters
join cust in db.CustomerAssociatedFees on fee.Id equals cust.FeeMaster_ID
where FeeFor.Contains(fee.FeesFor ?? 0) && cust.emp_CustomerInformation_ID == ParentId
select new { fee.FeesFor, cust.Amount }).ToList();
var dataa = (from s in data
group s by s.FeesFor into g
select new
{
feesfor = g.Key,
Amount = g.Sum(x => x.Amount)
}).ToList();
foreach (var itm in dataa.ToList())
{
SubSiteBankFeeConfigDTO SubSiteBankFeeConfig = new SubSiteBankFeeConfigDTO();
SubSiteBankFeeConfig.ServiceorTransmitter = itm.feesfor ?? 0;
SubSiteBankFeeConfig.AmountDSK = itm.Amount;
ListDTO.Add(SubSiteBankFeeConfig);
}
}
return(ListDTO.AsQueryable());
}
catch (Exception ex)
{
EMPPortal.Core.Utilities.ExceptionLogger.LogException(ex.ToString(), "CustomerPaymentOptionsService/SubSiteOfficeBankFee", UserId);
return(null);
}
}
