public List <PLRPartyItem> PartyitemTaxesMapping(int PlrPartyAmountId, int ContactId, List <PLRPartyItem> partitemlist)
{
PLRTaxes cl = GetTaxes(ContactId);
Taxes t = new Taxes();
foreach (PLRPartyItem item in partitemlist)
{
if (item.PLRPartyAmountId == PlrPartyAmountId)
{
foreach (PLRPartyItemsTaxes i in item.PLRPartyItemsTaxesList)
{
if (item.ItemType == "L")
{
if (i.Tax_Id == cl.GstLaborTaxId)
{
i.Amount = t.GstAmount(item.GrossAmount, Convert.ToDecimal(cl.GstLaborRate));
i.Tax_Id = cl.GstLaborTaxId;
i.TaxPercentage_Id = cl.GstLaborTaxPercentageId;
}
else if (i.Tax_Id == cl.GstWHLaborTaxId)
{
i.Amount = t.GstWHAmount(item.GrossAmount, Convert.ToDecimal(cl.GstLaborRate), Convert.ToDecimal(cl.GstWHLaborRate));
i.Tax_Id = cl.GstWHLaborTaxId;
i.TaxPercentage_Id = cl.GstWHLaborTaxPercentageId;
}
else if (i.Tax_Id == cl.WHTaxLaborTaxId)
{
i.Amount = t.WHTaxAmount(TypeConversionExtensions.GetNullableValue(item.Amount), Convert.ToDecimal(cl.WHLaborRate));
i.Tax_Id = cl.WHTaxLaborTaxId;
i.TaxPercentage_Id = cl.WHTaxLaborPercentageId;
}
}
else
{
if (i.Tax_Id == cl.WHTaxPartTaxId)
{
i.Amount = t.WHTaxAmount(TypeConversionExtensions.GetNullableValue(item.Amount), Convert.ToDecimal(cl.WHPartRate));
i.Tax_Id = cl.WHTaxPartTaxId;
i.TaxPercentage_Id = cl.WHPartTaxPercentageId;
}
}
}
}
}
return(partitemlist);
}
public decimal TotalGstWHAmount(List <PLRPartyItem> partitemlist, PLRTaxes plaTaxes)
{
decimal totalGstWHAmount = 0;
foreach (PLRPartyItem item in partitemlist)
{
if (item.ItemType != "L")
{
totalGstWHAmount += 0;
}
else
{
if (item.PLRPartyItemsTaxesList[0].Tax_Id == plaTaxes.GstWHLaborTaxId)
{
totalGstWHAmount += item.PLRPartyItemsTaxesList[0].Amount;
}
}
}
return(totalGstWHAmount);
}
private PLRTaxes GetTaxes(int ContactId)
{
PLRTaxes plrTaxes = new PLRTaxes();
try
{
int?RegionId = (from c in _context.CLA_Workshops_VW
where c.ContactId == ContactId
select c.TaxRegion_Id).FirstOrDefault();
string IsCompany = (from c in _context.CLA_Workshops_VW
where c.ContactId == ContactId
select c.isCompany).FirstOrDefault();
SLS_CheckFBRList_Claim_SP_Result Filer = _context.SLS_CheckFBRList_Claim_SP(ContactId).FirstOrDefault();
List <Surveyor_SalesTax_Result> Tax = _context.Surveyor_SalesTax(RegionId).ToList();
if (Filer != null && IsCompany == "Y")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_NTN_C") || x.Name.Contains("WH_Part_NTN_C") || x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst_RTU").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH_RTU").FirstOrDefault().TaxPercentageId;
}
else if (Filer != null && IsCompany == "N")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_NTN_NC") || x.Name.Contains("WH_Part_NTN_NC") || x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_Reg_Gst").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_NTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_NTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_Reg_GstWH").FirstOrDefault().TaxPercentageId;
}
else if (Filer == null && IsCompany == "Y")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_woNTN_C") || x.Name.Contains("WH_Part_woNTN_C") ||
x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst_RTU").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_woPart_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_C").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH_RTU").FirstOrDefault().TaxPercentageId;
}
else if (Filer == null && IsCompany == "N")
{
List <Surveyor_SalesTax_Result> _res = Tax.Where(x => x.Name.Contains("WH_Labor_woNTN_NC") || x.Name.Contains("WH_Part_woNTN_NC") || x.Name.Contains("GST on Labour") || x.Name.Contains("WTax on GST Labor")).ToList();
plrTaxes.GstLaborRate = _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault().TaxPercentage;
plrTaxes.GstLaborTaxId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault().TaxId;
plrTaxes.GstLaborTaxPercentageId = _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault() == null ? 0 : _res.Where(x => x.TaxName == "Lab_UnReg_Gst").FirstOrDefault().TaxPercentageId;
plrTaxes.WHPartRate = Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxPartTaxId = Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHPartTaxPercentageId = Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Part_woNTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.WHLaborRate = Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault().TaxPercentage;
plrTaxes.WHTaxLaborTaxId = Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault().TaxId;
plrTaxes.WHTaxLaborPercentageId = Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault() == null ? 0 : Tax.Where(x => x.Name == "WH_Labor_woNTN_NC").FirstOrDefault().TaxPercentageId;
plrTaxes.GstWHLaborRate = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault().TaxPercentage;
plrTaxes.GstWHLaborTaxId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault().TaxId;
plrTaxes.GstWHLaborTaxPercentageId = Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault() == null ? 0 : Tax.Where(x => x.TaxName == "Lab_UnReg_GstWH").FirstOrDefault().TaxPercentageId;
}
}
catch (Exception ex)
{
LoggerService.LogExceptionsToDebugConsole(ex);
}
return(plrTaxes);
}
