public void AddFPPI(FPPI fPPI, string productName, long grpId, List <EppBulkRefTbl> bulkRefTbls)
{
var prdid = Helper.GetProductIdbyName(productName, _unitofWork);
if (!string.IsNullOrEmpty(fPPI.emp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = fPPI.emp_ProductCode,
ProductId = prdid
};
fPPI.emp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(fPPI.sp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = fPPI.sp_ProductCode,
ProductId = prdid
};
fPPI.sp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(fPPI.ch_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = fPPI.ch_ProductCode,
ProductId = prdid
};
fPPI.ch_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
AddGrpPrdBulkRef(fPPI, bulkRefTbls, productName, grpId);
}
public void AddVOL_CI(VOL_CI vOL_CI, string productName, long grpId, List <EppBulkRefTbl> bulkRefTbls)
{
var prdid = Helper.GetProductIdbyName(productName, _unitofWork);
var grpprdId = Helper.GetRandomNumber();
//AddProductCodes(new ProductCodesViewModel
//{
// ProductCode =vOL_CI.emp_ProductCode,
// ProductId = prdid
//});
_unitofWork.eppGrpprdctRepository.Add(new EppGrpprdct
{
GrpprdctId = grpprdId,
GrpId = grpId,
ProductId = prdid,
CrtdBy = CrtdBy
});
// add Product code
if (!string.IsNullOrEmpty(vOL_CI.emp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = vOL_CI.emp_ProductCode,
ProductId = prdid
};
vOL_CI.emp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(vOL_CI.sp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = vOL_CI.sp_ProductCode,
ProductId = prdid
};
vOL_CI.sp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(vOL_CI.ch_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = vOL_CI.ch_ProductCode,
ProductId = prdid
};
vOL_CI.ch_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
AddGrpPrdBulkRef(vOL_CI, bulkRefTbls, productName, grpId);
}
public static PlanCodeViewModel UpdatePlanCode(PlanCodeViewModel planCodeViewModel, IUnitofWork _unitofWork)
{
var result = _unitofWork.eppProductCodesRepository.Find(x => x.ProductCode == planCodeViewModel.ProductCode && x.ProductId == planCodeViewModel.ProductId).Result.FirstOrDefault();
if (result == null)
{
planCodeViewModel.ProdctCdId = Helper.GetRandomNumber();
var data = new EppProductCodes
{
ProdctCdId = planCodeViewModel.ProdctCdId,
ProductCode = planCodeViewModel.ProductCode,
ProductId = planCodeViewModel.ProductId,
CrtdBy = ""
};
_unitofWork.eppProductCodesRepository.Add(data);
}
else
{
planCodeViewModel.ProdctCdId = result.ProdctCdId;
}
return(planCodeViewModel);
}
private void UpdateProductCode <T>(T product, PlanCodeViewModel planCodeViewModel)
{
var result = _unitofWork.eppProductCodesRepository.Find(x => x.ProductCode == planCodeViewModel.ProductCode && x.ProductId == planCodeViewModel.ProductId).Result.FirstOrDefault();
if (result == null)
{
planCodeViewModel.ProdctCdId = Helper.GetRandomNumber();
var data = new EppProductCodes
{
ProdctCdId = planCodeViewModel.ProdctCdId,
ProductCode = planCodeViewModel.ProductCode,
ProductId = planCodeViewModel.ProductId,
CrtdBy = CrtdBy,
CrtdDt = CreatedDate
};
_unitofWork.eppProductCodesRepository.Add(data);
}
else
{
planCodeViewModel.ProductId = result.ProductId;
}
}
public IActionResult EditEppGrpSetup(GroupSetupModel groupSetupModel)
{
try
{
var grpId = long.Parse(groupSetupModel.GrpId);
var grpMstdata = _unitofWork.GroupMasterRepository.Find(x => x.GrpId == grpId).Result.FirstOrDefault();
if (grpMstdata == null)
{
return(BadRequest("Incorrect group id"));
}
if (!string.IsNullOrEmpty(groupSetupModel.EmlAddrss))
{
// get partner id
var enrlmntPrtnr = _unitofWork.eppEnrlmntPrtnrsRepository.GetEnrlmntPrtnrId(groupSetupModel.EmlAddrss);
if (enrlmntPrtnr != null)
{
groupSetupModel.EnrlmntPrtnrsId = enrlmntPrtnr.EnrlmntPrtnrsId.ToString();
}
else
{
_unitofWork.eppEnrlmntPrtnrsRepository.Add(new EppEnrlmntPrtnrs
{
EnrlmntPrtnrsId = Helper.GetRandomNumber(),
CrtdBy = "",
EmlAddrss = groupSetupModel.EmlAddrss,
EnrlmntPrtnrsNm = groupSetupModel.EnrlmntPrtnrsNm
});
}
}
grpMstdata.GrpNbr = groupSetupModel.GrpNbr;
grpMstdata.GrpNm = groupSetupModel.GrpNm;
grpMstdata.ActvFlg = groupSetupModel.ActvFlg;
grpMstdata.EnrlmntPrtnrsId = long.Parse(groupSetupModel.EnrlmntPrtnrsId);
grpMstdata.AcctMgrNm = groupSetupModel.AcctMgrNm;
grpMstdata.AcctMgrEmailAddrs = groupSetupModel.AcctMgrEmailAddrs;
grpMstdata.GrpEfftvDt = groupSetupModel.GrpEfftvDt;
grpMstdata.GrpSitusSt = groupSetupModel.GrpSitusSt;
grpMstdata.GrpPymnId = groupSetupModel.GrpPymn;
grpMstdata.OccClass = groupSetupModel.OccClass;
grpMstdata.CrtdBy = CrtdBy;
// update group Master
_unitofWork.GroupMasterRepository.Update(grpMstdata);
UpdateAgent(groupSetupModel.GrpAgents, grpId);
// add update enrollment partner
if (!string.IsNullOrEmpty(groupSetupModel.EmlAddrss))
{
// get partner id
var enrlmntPrtnr = _unitofWork.eppEnrlmntPrtnrsRepository.GetEnrlmntPrtnrId(groupSetupModel.EmlAddrss);
if (enrlmntPrtnr != null)
{
groupSetupModel.EnrlmntPrtnrsId = enrlmntPrtnr.EnrlmntPrtnrsId.ToString();
}
else
{
groupSetupModel.EnrlmntPrtnrsId = Helper.GetRandomNumber().ToString();
_unitofWork.eppEnrlmntPrtnrsRepository.Add(new EppEnrlmntPrtnrs
{
EnrlmntPrtnrsId = long.Parse(groupSetupModel.EnrlmntPrtnrsId),
CrtdBy = CrtdBy,
EmlAddrss = groupSetupModel.EmlAddrss,
EnrlmntPrtnrsNm = groupSetupModel.EnrlmntPrtnrsNm
});
}
}
// goup product for existing products
var Grpprdcts = _unitofWork.eppGrpprdctRepository.Find(x => x.GrpId == grpId).Result;
// For Edit
foreach (var prod in Grpprdcts)
{
var prodData = _unitofWork.EppProductRepository.SingleOrDefault(x => x.ProductId == prod.ProductId).Result;
switch (prodData.ProductNm)
{
case "FPPG":
{
var prdid = Helper.GetProductIdbyName(prodData.ProductNm, _unitofWork);
// add Product code
if (!string.IsNullOrEmpty(groupSetupModel.FPPG.emp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.FPPG.emp_ProductCode,
ProductId = prdid
};
groupSetupModel.FPPG.emp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.FPPG.sp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.FPPG.sp_ProductCode,
ProductId = prdid
};
groupSetupModel.FPPG.sp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.FPPG.ch_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.FPPG.ch_ProductCode,
ProductId = prdid
};
groupSetupModel.FPPG.ch_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
UpdateBulkRefTable(groupSetupModel.FPPG, prod.GrpprdctId);
groupSetupModel.isFPPGActive = false;
break;
}
case "ACC_HI":
{
UpdateBulkRefTable(groupSetupModel.ACC_HI, prod.GrpprdctId);
groupSetupModel.isACC_HIActive = false;
break;
}
case "ER_CI":
{
var prdid = Helper.GetProductIdbyName(prodData.ProductNm, _unitofWork);
// add Product code
if (!string.IsNullOrEmpty(groupSetupModel.ER_CI.emp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.ER_CI.emp_ProductCode,
ProductId = prdid
};
groupSetupModel.ER_CI.emp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.ER_CI.sp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.ER_CI.sp_ProductCode,
ProductId = prdid
};
groupSetupModel.ER_CI.sp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.ER_CI.ch_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.ER_CI.ch_ProductCode,
ProductId = prdid
};
groupSetupModel.ER_CI.ch_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
UpdateBulkRefTable(groupSetupModel.ER_CI, prod.GrpprdctId);
groupSetupModel.isER_CIActive = false;
break;
}
case "VOL_CI":
{
var prdid = Helper.GetProductIdbyName(prodData.ProductNm, _unitofWork);
if (!string.IsNullOrEmpty(groupSetupModel.VOL_CI.emp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.VOL_CI.emp_ProductCode,
ProductId = prdid
};
groupSetupModel.VOL_CI.emp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.VOL_CI.sp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.VOL_CI.sp_ProductCode,
ProductId = prdid
};
groupSetupModel.VOL_CI.sp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.VOL_CI.ch_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.VOL_CI.ch_ProductCode,
ProductId = prdid
};
groupSetupModel.VOL_CI.ch_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
UpdateBulkRefTable(groupSetupModel.VOL_CI, prod.GrpprdctId);
groupSetupModel.isVOL_CIActive = false;
break;
}
case "VGL":
{
UpdateBulkRefTable(groupSetupModel.VGL, prod.GrpprdctId);
groupSetupModel.isVGLActive = false;
break;
}
case "BGL":
{
UpdateBulkRefTable(groupSetupModel.BGL, prod.GrpprdctId);
groupSetupModel.isBGLActive = false;
break;
}
case "FPPI":
{
var prdid = Helper.GetProductIdbyName(prodData.ProductNm, _unitofWork);
if (!string.IsNullOrEmpty(groupSetupModel.FPPI.emp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.FPPI.emp_ProductCode,
ProductId = prdid
};
groupSetupModel.FPPI.emp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.FPPI.sp_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.FPPI.sp_ProductCode,
ProductId = prdid
};
groupSetupModel.FPPI.sp_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
if (!string.IsNullOrEmpty(groupSetupModel.FPPI.ch_ProductCode))
{
PlanCodeViewModel planCodeViewModel = new PlanCodeViewModel
{
ProductCode = groupSetupModel.FPPI.ch_ProductCode,
ProductId = prdid
};
groupSetupModel.FPPI.ch_plan_cd = DataHelper.UpdatePlanCode(planCodeViewModel, _unitofWork).ProdctCdId.ToString();
}
UpdateBulkRefTable(groupSetupModel.FPPI, prod.GrpprdctId);
groupSetupModel.isFPPIActive = false;
break;
}
case "HI":
{
UpdateBulkRefTable(groupSetupModel.HI, prod.GrpprdctId);
groupSetupModel.isHIActive = false;
break;
}
}
}
// for New Add
// Add BulkRef data
List <EppBulkRefTbl> bulkRefTbls = new List <EppBulkRefTbl>();
if (groupSetupModel.isFPPGActive)
{
AddFPPG(groupSetupModel.FPPG, "FPPG", grpId, bulkRefTbls);
}
if (groupSetupModel.isACC_HIActive)
{
AddACCHI(groupSetupModel.ACC_HI, "ACC_HI", grpId, bulkRefTbls);
}
if (groupSetupModel.isER_CIActive)
{
AddER_CI(groupSetupModel.ER_CI, "ER_CI", grpId, bulkRefTbls);
}
if (groupSetupModel.isVOL_CIActive)
{
AddVOL_CI(groupSetupModel.VOL_CI, "VOL_CI", grpId, bulkRefTbls);
}
if (groupSetupModel.isVGLActive)
{
AddVGL(groupSetupModel.VGL, "VGL", grpId, bulkRefTbls);
}
if (groupSetupModel.isBGLActive)
{
AddBGL(groupSetupModel.BGL, "BGL", grpId, bulkRefTbls);
}
if (groupSetupModel.isFPPIActive)
{
AddFPPI(groupSetupModel.FPPI, "FPPI", grpId, bulkRefTbls);
}
if (groupSetupModel.isHIActive)
{
AddHI(groupSetupModel.HI, "HI", grpId, bulkRefTbls);
}
if (bulkRefTbls.Count > 0)
{
_unitofWork.eppBulkRefTblRepository.AddRange(bulkRefTbls);
}
var id = _unitofWork.Complete().Result;
return(Ok($"Group No. {groupSetupModel.GrpNbr} updated sucessfully!"));
}
catch (Exception ex)
{
throw ex;
}
}
