protected void UploadInvoice(string strFlag, int selIndex)
{
try
{
Seller seller = new Seller();
seller.SellerDaTa = new List <Seller>();
//TEMPORARY SOLUTION
Invoice b2bInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BInvoice);
seller.Invoice = b2bInvoice;
seller.SellerDaTa = (List <Seller>)Session["SellerDaTa"];
int result = seller.Invoice.UploadInvoice(seller.SellerDaTa, strInvoiceNo);
if (result > 0)
{
if (Session["SellerDaTa"] != null)
{
Session["SellerDaTa"] = null;
}
BindGrid();
if (strFlag == "all")
{
BtnUpload.Attributes.Add("style", "display:none");
}
else if (strFlag == "single")
{
// GVUploadInvoice.Rows[selIndex].FindControl("lnkUpload").Visible = false;
}
BALAJI.GSP.APPLICATION.User.User masterPage = this.Master as BALAJI.GSP.APPLICATION.User.User;
// masterPage.ShowModalPopupSuccess();
////masterPage.ErrorMessage = "Data Uploaded Successfully !!!";
}
else
{
if (Session["SellerDaTa"] != null)
{
Session["SellerDaTa"] = null;
}
BALAJI.GSP.APPLICATION.User.User masterPage = this.Master as BALAJI.GSP.APPLICATION.User.User;
////masterPage.ShowModalPopup();
////masterPage.ErrorMessage = "Error !!! Unable to Upload Data!";
}
}
catch (Exception ex)
{
cls_ErrorLog ob = new cls_ErrorLog();
cls_ErrorLog.LogError(ex, Common.LoggedInUserID());
}
}
private DataSet ViewInvoice(string SellerGSTN, string FromDt, String Todate)
{
Seller seller = new Seller();
seller.Reciever = new Reciever();
seller.Consignee = new Consignee();
int p = 0; int m = 0;
DataTable dt = new DataTable();
string strInvoiceNo = string.Empty;
#region INVOICE_TYPE
switch (strInvoiceType)
{
case "B2BInvoice":
Invoice b2bInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BInvoice);
seller.Invoice = b2bInvoice;
break;
case "AmendedB2BInvoice":
Invoice AmendedB2BInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BInvoice);
seller.Invoice = AmendedB2BInvoice;
break;
case "B2CLargeInvoice":
Invoice B2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2CLargeInvoice);
seller.Invoice = B2CLargeInvoice;
break;
case "AmendedB2CLargeInvoice":
Invoice AmendedB2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2CLargeInvoice);
seller.Invoice = AmendedB2CLargeInvoice;
break;
case "B2BCreditNotesInvoice":
Invoice B2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BCreditNotesInvoice);
seller.Invoice = B2BCreditNotesInvoice;
break;
case "B2BDebitNotesInvoice":
Invoice B2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BDebitNotesInvoice);
seller.Invoice = B2BDebitNotesInvoice;
break;
case "AmendedB2BCreditNotesInvoice":
Invoice AmendedB2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BCreditNotesInvoice);
seller.Invoice = AmendedB2BCreditNotesInvoice;
break;
case "AmendedB2BDebitNotesInvoice":
Invoice AmendedB2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BDebitNotesInvoice);
seller.Invoice = AmendedB2BDebitNotesInvoice;
break;
case "B2BExportInvoice":
Invoice B2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BExportInvoice);
seller.Invoice = B2BExportInvoice;
break;
case "AmendedB2BExportInvoice":
Invoice AmendedB2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BExportInvoice);
seller.Invoice = AmendedB2BExportInvoice;
break;
}
#endregion
seller.Invoice.LineEntry = new List <LineEntry>();
LineEntry line;
DataSet ds = new DataSet();
ds = seller.Invoice.ViewInvoice(SellerGSTN, FromDt, Todate);
seller.SellerDaTa = new List <Seller>();
if (ds.Tables.Count > 0)
{
#region B2B
if (ds.Tables.Contains("SellerDtls"))
{
if (ds.Tables["SellerDtls"].Rows.Count > 0)
{
int j = ds.Tables[0].Rows.Count;
for (int i = 0; i <= j - 1; i++)
{
seller.SellerInvoice = (ds.Tables[0].Rows[i]["InvoiceNo"]).ToString();
seller.DateOfInvoice = (ds.Tables[0].Rows[i]["Invoicedate"]).ToString();
seller.GSTIN = (ds.Tables[0].Rows[i]["SellerGSTN"]).ToString();
seller.NameAsOnGST = (ds.Tables[0].Rows[i]["SellerName"]).ToString();
seller.Reciever.GSTIN = (ds.Tables[0].Rows[i]["ReceiverGSTN"]).ToString();
seller.Reciever.NameAsOnGST = (ds.Tables[0].Rows[i]["ReceiverName"]).ToString();
seller.Consignee.GSTIN = (ds.Tables[0].Rows[i]["ConsigneeGSTN"]).ToString();
seller.Consignee.NameAsOnGST = (ds.Tables[0].Rows[i]["ConsigneeName"]).ToString();
seller.Address = (ds.Tables[0].Rows[i]["SellerAddress"]).ToString();
seller.SellerStateCode = (ds.Tables[0].Rows[i]["SellerStateCode"]).ToString();
seller.SellerStateName = (ds.Tables[0].Rows[i]["SellerStateName"]).ToString();
seller.SellerStateCodeID = (ds.Tables[0].Rows[i]["SellerStateCodeID"]).ToString();
seller.Reciever.StateCode = (ds.Tables[0].Rows[i]["ReceiverStateCode"]).ToString();
seller.Consignee.StateCode = (ds.Tables[0].Rows[i]["ConsigneeStateCode"]).ToString();
seller.Invoice.Freight = Convert.ToInt32(ds.Tables[0].Rows[i]["Freight"]);
seller.Invoice.Insurance = Convert.ToInt32(ds.Tables[0].Rows[i]["Insurance"]);
seller.Invoice.PackingAndForwadingCharges = Convert.ToInt32(ds.Tables[0].Rows[i]["PackingAndForwadingCharges"]);
seller.SellerGrossTurnOver = Convert.ToDecimal(ds.Tables[0].Rows[i]["SellerGrossTurnOver"]);
seller.SellerFinancialPeriod = (ds.Tables[0].Rows[i]["SellerFinancialPeriod"]).ToString();
seller.Reciever.FinancialPeriod = (ds.Tables[0].Rows[i]["ReceiverFinancialPeriod"]).ToString();
seller.Reciever.StateName = (ds.Tables[0].Rows[i]["ReceiverStateName"]).ToString();
seller.Consignee.StateName = (ds.Tables[0].Rows[i]["ConsigneeStateName"]).ToString();
//if (((ds.Tables[0].Rows[i]["IsElectronicReferenceNoGenerated"]).ToString()) == "True")
//{
// seller.IsElectronicReferenceNoGenerated = true;
//}
//else
//{
// seller.IsElectronicReferenceNoGenerated = false;
//}
//seller.ElectronicReferenceNoGenerated = (ds.Tables[0].Rows[i]["ElectronicReferenceNoGenerated"]).ToString();
//seller.ElectronicReferenceNoGeneratedDate = (ds.Tables[0].Rows[i]["ElectronicReferenceNoGeneratedDate"]).ToString();
seller.Invoice.IsAdvancePaymentChecked = false;
seller.Invoice.IsExportChecked = false;
int n = ds.Tables[1].Rows.Count;
for (m = p; m <= n - 1; m++)
{
if ((ds.Tables[0].Rows[i]["InvoiceNo"]).ToString() == (ds.Tables[1].Rows[m]["InvoiceNo"]).ToString())
{
line = new LineEntry();
line.HSN = new com.B2B.GST.GSTInvoices.HSN();
//InvoiceNo Invoicedate SellerGSTN ReceiverGSTN InvoiceSeed LineID Description HSN Qty Unit Rate Total Discount
//TaxableValue AmountWithTax IGSTRate IGSTAmt CGSTRate CGSTAmt SGSTRate SGSTAmt TotalQty TotalRate TotalAmount TotalDiscount
//TotalTaxableAmount TotalCGSTAmount TotalSGSTAmount TotalIGSTAmount TotalAmountWithTax GrandTotalAmount GrandTotalAmountInWord isHSNNilRated
//isHSNExempted isHSNZeroRated isHSNNonGSTGoods isSACNilRated isSACEcxempted isSACZeroRated isSACNonGSTService IsNotifedGoods IsNotifiedSAC
//IsElectronicReferenceNoGenerated IsInter SellerStateCode SellerStateName ReceiverStateCode ReceiverStateName ConsigneeStateCode ConsigneeStateName
line.LineID = Convert.ToInt32(ds.Tables[1].Rows[m]["LineID"]);
line.HSN.Description = (ds.Tables[1].Rows[m]["Description"]).ToString();
line.HSN.HSNNumber = (ds.Tables[1].Rows[m]["HSN"]).ToString();
line.Qty = Convert.ToDecimal(ds.Tables[1].Rows[m]["Qty"]);
line.HSN.UnitOfMeasurement = (ds.Tables[1].Rows[m]["Unit"]).ToString();
line.PerUnitRate = Convert.ToDecimal(ds.Tables[1].Rows[m]["Rate"]);
line.TotalLineIDWise = Convert.ToDecimal(ds.Tables[1].Rows[m]["Total"]);
line.Discount = Convert.ToDecimal(ds.Tables[1].Rows[m]["Discount"]);
line.TaxValue = Convert.ToDecimal(ds.Tables[1].Rows[m]["TaxableValue"]);
line.AmountWithTax = Convert.ToDecimal(ds.Tables[1].Rows[m]["AmountWithTax"]);
line.HSN.RateIGST = Convert.ToDecimal(ds.Tables[1].Rows[m]["IGSTRate"]);
line.AmtIGSTLineIDWise = Convert.ToDecimal(ds.Tables[1].Rows[m]["IGSTAmt"]);
line.HSN.RateCGST = Convert.ToDecimal(ds.Tables[1].Rows[m]["CGSTRate"]);
line.AmtCGSTLineIDWise = Convert.ToDecimal(ds.Tables[1].Rows[m]["CGSTAmt"]);
line.HSN.RateSGST = Convert.ToDecimal(ds.Tables[1].Rows[m]["SGSTRate"]);
line.AmtSGSTLineIDWise = Convert.ToDecimal(ds.Tables[1].Rows[m]["SGSTAmt"]);
line.HSN.Cess = Convert.ToDecimal(ds.Tables[1].Rows[m]["Cess"]);
seller.TotalQty = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalQty"]);
seller.TotalRate = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalRate"]);
seller.TotalAmount = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalAmount"]);
seller.TotalDiscount = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalDiscount"]);
seller.TotalTaxableAmount = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalTaxableAmount"]);
seller.TotalCGSTAmount = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalCGSTAmount"]);
seller.TotalSGSTAmount = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalSGSTAmount"]);
seller.TotalIGSTAmount = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalIGSTAmount"]);
seller.TotalAmountWithTax = Convert.ToDecimal(ds.Tables[1].Rows[m]["TotalAmountWithTax"]);
seller.GrandTotalAmount = Convert.ToDecimal(ds.Tables[1].Rows[m]["GrandTotalAmount"]);
seller.GrandTotalAmountInWord = Convert.ToString(ds.Tables[1].Rows[m]["GrandTotalAmountInWord"]);
if (((ds.Tables[1].Rows[m]["IsInter"]).ToString()) == "True")
{
line.IsInter = true;
}
else
{
line.IsInter = false;
}
seller.Invoice.LineEntry.Add(line);
p = 1 + p;
}
else
{
break;
}
}
seller.SellerDaTa.Add(seller);
Session["SellerDaTa"] = seller.SellerDaTa;
seller = new Seller();
seller.Reciever = new Reciever();
seller.Consignee = new Consignee();
seller.SellerDaTa = new List <Seller>();
#region INVOICE_TYPE
switch (strInvoiceType)
{
case "B2BInvoice":
Invoice b2bInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BInvoice);
seller.Invoice = b2bInvoice;
break;
case "AmendedB2BInvoice":
Invoice AmendedB2BInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BInvoice);
seller.Invoice = AmendedB2BInvoice;
break;
case "B2CLargeInvoice":
Invoice B2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2CLargeInvoice);
seller.Invoice = B2CLargeInvoice;
break;
case "AmendedB2CLargeInvoice":
Invoice AmendedB2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2CLargeInvoice);
seller.Invoice = AmendedB2CLargeInvoice;
break;
case "B2BCreditNotesInvoice":
Invoice B2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BCreditNotesInvoice);
seller.Invoice = B2BCreditNotesInvoice;
break;
case "B2BDebitNotesInvoice":
Invoice B2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BDebitNotesInvoice);
seller.Invoice = B2BDebitNotesInvoice;
break;
case "AmendedB2BCreditNotesInvoice":
Invoice AmendedB2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BCreditNotesInvoice);
seller.Invoice = AmendedB2BCreditNotesInvoice;
break;
case "AmendedB2BDebitNotesInvoice":
Invoice AmendedB2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BDebitNotesInvoice);
seller.Invoice = AmendedB2BDebitNotesInvoice;
break;
case "B2BExportInvoice":
Invoice B2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BExportInvoice);
seller.Invoice = B2BExportInvoice;
break;
case "AmendedB2BExportInvoice":
Invoice AmendedB2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BExportInvoice);
seller.Invoice = AmendedB2BExportInvoice;
break;
}
#endregion
seller.Invoice.LineEntry = new List <LineEntry>();
if ((List <Seller>)Session["SellerDaTa"] != null)
{
seller.SellerDaTa = (List <Seller>)Session["SellerDaTa"];
}
}
}
}
else
{
//change master page here--Ashish
BALAJI.GSP.APPLICATION.User.User masterPage = this.Master as BALAJI.GSP.APPLICATION.User.User;
////masterPage.ShowModalPopup();
////masterPage.ErrorMessage = "System error occured during data population of SellerDtls table !!!";
}
#endregion
#region ADVANCE
if (ds.Tables.Contains("AdvanceSellerDtls"))
{
p = 0; m = 0;
if (ds.Tables["AdvanceSellerDtls"].Rows.Count > 0)
{
int j = ds.Tables[3].Rows.Count;
for (int i = 0; i <= j - 1; i++)
{
seller.SellerInvoice = (ds.Tables[3].Rows[i]["VoucherNo"]).ToString();
seller.DateOfInvoice = (ds.Tables[3].Rows[i]["Voucherdate"]).ToString();
seller.GSTIN = (ds.Tables[3].Rows[i]["SellerGSTN"]).ToString();
seller.NameAsOnGST = (ds.Tables[3].Rows[i]["SellerName"]).ToString();
seller.Reciever.GSTIN = (ds.Tables[3].Rows[i]["ReceiverGSTN"]).ToString();
seller.Reciever.NameAsOnGST = (ds.Tables[3].Rows[i]["ReceiverName"]).ToString();
seller.Consignee.GSTIN = (ds.Tables[3].Rows[i]["ConsigneeGSTN"]).ToString();
seller.Consignee.NameAsOnGST = (ds.Tables[3].Rows[i]["ConsigneeName"]).ToString();
seller.Address = (ds.Tables[3].Rows[i]["SellerAddress"]).ToString();
seller.SellerStateCode = (ds.Tables[3].Rows[i]["SellerStateCode"]).ToString();
seller.SellerStateName = (ds.Tables[3].Rows[i]["SellerStateName"]).ToString();
seller.SellerStateCodeID = (ds.Tables[3].Rows[i]["SellerStateCodeID"]).ToString();
seller.Reciever.StateCode = (ds.Tables[3].Rows[i]["ReceiverStateCode"]).ToString();
seller.Consignee.StateCode = (ds.Tables[3].Rows[i]["ConsigneeStateCode"]).ToString();
seller.Invoice.Freight = Convert.ToInt32(ds.Tables[3].Rows[i]["Freight"]);
seller.Invoice.Insurance = Convert.ToInt32(ds.Tables[3].Rows[i]["Insurance"]);
seller.Invoice.PackingAndForwadingCharges = Convert.ToInt32(ds.Tables[3].Rows[i]["PackingAndForwadingCharges"]);
seller.Invoice.IsAdvancePaymentChecked = true;
seller.Invoice.IsExportChecked = false;
//if (((ds.Tables[3].Rows[i]["IsElectronicReferenceNoGenerated"]).ToString()) == "True")
//{
// seller.IsElectronicReferenceNoGenerated = true;
//}
//else
//{
// seller.IsElectronicReferenceNoGenerated = false;
//}
//seller.ElectronicReferenceNoGenerated = (ds.Tables[3].Rows[i]["ElectronicReferenceNoGenerated"]).ToString();
//seller.ElectronicReferenceNoGeneratedDate = (ds.Tables[3].Rows[i]["ElectronicReferenceNoGeneratedDate"]).ToString();
int n = ds.Tables[4].Rows.Count;
for (m = p; m <= n - 1; m++)
{
if ((ds.Tables[3].Rows[i]["VoucherNo"]).ToString() == (ds.Tables[4].Rows[m]["VoucherNo"]).ToString())
{
line = new LineEntry();
line.HSN = new com.B2B.GST.GSTInvoices.HSN();
line.LineID = Convert.ToInt32(ds.Tables[4].Rows[m]["LineID"]);
line.HSN.Description = (ds.Tables[4].Rows[m]["Description"]).ToString();
line.HSN.HSNNumber = (ds.Tables[4].Rows[m]["HSN"]).ToString();
line.Qty = Convert.ToDecimal(ds.Tables[4].Rows[m]["Qty"]);
line.HSN.UnitOfMeasurement = (ds.Tables[4].Rows[m]["Unit"]).ToString();
line.PerUnitRate = Convert.ToDecimal(ds.Tables[4].Rows[m]["Rate"]);
line.TotalLineIDWise = Convert.ToDecimal(ds.Tables[4].Rows[m]["Total"]);
line.Discount = Convert.ToDecimal(ds.Tables[4].Rows[m]["Discount"]);
line.TaxValue = Convert.ToDecimal(ds.Tables[4].Rows[m]["TaxableValue"]);
line.AmountWithTax = Convert.ToDecimal(ds.Tables[4].Rows[m]["AmountWithTax"]);
line.HSN.RateIGST = Convert.ToDecimal(ds.Tables[4].Rows[m]["IGSTRate"]);
line.AmtIGSTLineIDWise = Convert.ToDecimal(ds.Tables[4].Rows[m]["IGSTAmt"]);
line.HSN.RateCGST = Convert.ToDecimal(ds.Tables[4].Rows[m]["CGSTRate"]);
line.AmtCGSTLineIDWise = Convert.ToDecimal(ds.Tables[4].Rows[m]["CGSTAmt"]);
line.HSN.RateSGST = Convert.ToDecimal(ds.Tables[4].Rows[m]["SGSTRate"]);
line.AmtSGSTLineIDWise = Convert.ToDecimal(ds.Tables[4].Rows[m]["SGSTAmt"]);
line.HSN.Cess = Convert.ToDecimal(ds.Tables[4].Rows[m]["Cess"]);
seller.TotalQty = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalQty"]);
seller.TotalRate = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalRate"]);
seller.TotalAmount = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalAmount"]);
seller.TotalDiscount = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalDiscount"]);
seller.TotalTaxableAmount = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalTaxableAmount"]);
seller.TotalCGSTAmount = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalCGSTAmount"]);
seller.TotalSGSTAmount = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalSGSTAmount"]);
seller.TotalIGSTAmount = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalIGSTAmount"]);
seller.TotalAmountWithTax = Convert.ToDecimal(ds.Tables[4].Rows[m]["TotalAmountWithTax"]);
seller.GrandTotalAmount = Convert.ToDecimal(ds.Tables[4].Rows[m]["GrandTotalAmount"]);
seller.GrandTotalAmountInWord = Convert.ToString(ds.Tables[4].Rows[m]["GrandTotalAmountInWord"]);
seller.Invoice.LineEntry.Add(line);
p = 1 + p;
}
else
{
break;
}
}
seller.SellerDaTa.Add(seller);
Session["SellerDaTa"] = seller.SellerDaTa;
seller = new Seller();
seller.Reciever = new Reciever();
seller.Consignee = new Consignee();
seller.SellerDaTa = new List <Seller>();
#region INVOICE_TYPE
switch (strInvoiceType)
{
case "B2BInvoice":
Invoice b2bInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BInvoice);
seller.Invoice = b2bInvoice;
break;
case "AmendedB2BInvoice":
Invoice AmendedB2BInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BInvoice);
seller.Invoice = AmendedB2BInvoice;
break;
case "B2CLargeInvoice":
Invoice B2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2CLargeInvoice);
seller.Invoice = B2CLargeInvoice;
break;
case "AmendedB2CLargeInvoice":
Invoice AmendedB2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2CLargeInvoice);
seller.Invoice = AmendedB2CLargeInvoice;
break;
case "B2BCreditNotesInvoice":
Invoice B2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BCreditNotesInvoice);
seller.Invoice = B2BCreditNotesInvoice;
break;
case "B2BDebitNotesInvoice":
Invoice B2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BDebitNotesInvoice);
seller.Invoice = B2BDebitNotesInvoice;
break;
case "AmendedB2BCreditNotesInvoice":
Invoice AmendedB2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BCreditNotesInvoice);
seller.Invoice = AmendedB2BCreditNotesInvoice;
break;
case "AmendedB2BDebitNotesInvoice":
Invoice AmendedB2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BDebitNotesInvoice);
seller.Invoice = AmendedB2BDebitNotesInvoice;
break;
case "B2BExportInvoice":
Invoice B2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BExportInvoice);
seller.Invoice = B2BExportInvoice;
break;
case "AmendedB2BExportInvoice":
Invoice AmendedB2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BExportInvoice);
seller.Invoice = AmendedB2BExportInvoice;
break;
}
#endregion
seller.Invoice.LineEntry = new List <LineEntry>();
if ((List <Seller>)Session["SellerDaTa"] != null)
{
seller.SellerDaTa = (List <Seller>)Session["SellerDaTa"];
}
}
}
}
else
{
//UserInterface.loggedIn_applicationMasterPage masterPage = this.Master as UserInterface.loggedIn_applicationMasterPage;
////masterPage.ShowModalPopup();
////masterPage.ErrorMessage = "System error occured during data population of SellerDtls table !!!";
}
#endregion
#region EXPORT
if (ds.Tables.Contains("EXPORTSellerDtls"))
{
p = 0; m = 0;
if (ds.Tables["EXPORTSellerDtls"].Rows.Count > 0)
{
int j = ds.Tables[6].Rows.Count;
for (int i = 0; i <= j - 1; i++)
{
seller.SellerInvoice = (ds.Tables[6].Rows[i]["ExportNo"]).ToString();
seller.DateOfInvoice = (ds.Tables[6].Rows[i]["Exportdate"]).ToString();
seller.GSTIN = (ds.Tables[6].Rows[i]["SellerGSTN"]).ToString();
seller.NameAsOnGST = (ds.Tables[6].Rows[i]["SellerName"]).ToString();
seller.Reciever.GSTIN = (ds.Tables[6].Rows[i]["ReceiverGSTN"]).ToString();
seller.Reciever.NameAsOnGST = (ds.Tables[6].Rows[i]["ReceiverName"]).ToString();
seller.Consignee.GSTIN = (ds.Tables[6].Rows[i]["ConsigneeGSTN"]).ToString();
seller.Consignee.NameAsOnGST = (ds.Tables[6].Rows[i]["ConsigneeName"]).ToString();
seller.Address = (ds.Tables[6].Rows[i]["SellerAddress"]).ToString();
seller.SellerStateCode = (ds.Tables[6].Rows[i]["SellerStateCode"]).ToString();
seller.SellerStateName = (ds.Tables[6].Rows[i]["SellerStateName"]).ToString();
seller.SellerStateCodeID = (ds.Tables[6].Rows[i]["SellerStateCodeID"]).ToString();
seller.Reciever.StateCode = (ds.Tables[6].Rows[i]["ReceiverStateCode"]).ToString();
seller.Consignee.StateCode = (ds.Tables[6].Rows[i]["ConsigneeStateCode"]).ToString();
seller.Invoice.Freight = Convert.ToInt32(ds.Tables[6].Rows[i]["Freight"]);
seller.Invoice.Insurance = Convert.ToInt32(ds.Tables[6].Rows[i]["Insurance"]);
seller.Invoice.PackingAndForwadingCharges = Convert.ToInt32(ds.Tables[6].Rows[i]["PackingAndForwadingCharges"]);
seller.Invoice.IsAdvancePaymentChecked = false;
seller.Invoice.IsExportChecked = true;
//if (((ds.Tables[6].Rows[i]["IsElectronicReferenceNoGenerated"]).ToString()) == "True")
//{
// seller.IsElectronicReferenceNoGenerated = true;
//}
//else
//{
// seller.IsElectronicReferenceNoGenerated = false;
//}
//seller.ElectronicReferenceNoGenerated = (ds.Tables[6].Rows[i]["ElectronicReferenceNoGenerated"]).ToString();
//seller.ElectronicReferenceNoGeneratedDate = (ds.Tables[6].Rows[i]["ElectronicReferenceNoGeneratedDate"]).ToString();
int n = ds.Tables[7].Rows.Count;
for (m = p; m <= n - 1; m++)
{
if ((ds.Tables[6].Rows[i]["ExportNo"]).ToString() == (ds.Tables[7].Rows[m]["ExportNo"]).ToString())
{
line = new LineEntry();
line.HSN = new com.B2B.GST.GSTInvoices.HSN();
line.LineID = Convert.ToInt32(ds.Tables[7].Rows[m]["LineID"]);
line.HSN.Description = (ds.Tables[7].Rows[m]["Description"]).ToString();
line.HSN.HSNNumber = (ds.Tables[7].Rows[m]["HSN"]).ToString();
line.Qty = Convert.ToDecimal(ds.Tables[7].Rows[m]["Qty"]);
line.HSN.UnitOfMeasurement = (ds.Tables[7].Rows[m]["Unit"]).ToString();
line.PerUnitRate = Convert.ToDecimal(ds.Tables[7].Rows[m]["Rate"]);
line.TotalLineIDWise = Convert.ToDecimal(ds.Tables[7].Rows[m]["Total"]);
line.Discount = Convert.ToDecimal(ds.Tables[7].Rows[m]["Discount"]);
line.TaxValue = Convert.ToDecimal(ds.Tables[7].Rows[m]["TaxableValue"]);
line.AmountWithTax = Convert.ToDecimal(ds.Tables[7].Rows[m]["AmountWithTax"]);
line.HSN.RateIGST = Convert.ToDecimal(ds.Tables[7].Rows[m]["IGSTRate"]);
line.AmtIGSTLineIDWise = Convert.ToDecimal(ds.Tables[7].Rows[m]["IGSTAmt"]);
line.HSN.RateCGST = Convert.ToDecimal(ds.Tables[7].Rows[m]["CGSTRate"]);
line.AmtCGSTLineIDWise = Convert.ToDecimal(ds.Tables[7].Rows[m]["CGSTAmt"]);
line.HSN.RateSGST = Convert.ToDecimal(ds.Tables[7].Rows[m]["SGSTRate"]);
line.AmtSGSTLineIDWise = Convert.ToDecimal(ds.Tables[7].Rows[m]["SGSTAmt"]);
line.HSN.Cess = Convert.ToDecimal(ds.Tables[7].Rows[m]["Cess"]);
seller.TotalQty = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalQty"]);
seller.TotalRate = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalRate"]);
seller.TotalAmount = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalAmount"]);
seller.TotalDiscount = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalDiscount"]);
seller.TotalTaxableAmount = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalTaxableAmount"]);
seller.TotalCGSTAmount = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalCGSTAmount"]);
seller.TotalSGSTAmount = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalSGSTAmount"]);
seller.TotalIGSTAmount = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalIGSTAmount"]);
seller.TotalAmountWithTax = Convert.ToDecimal(ds.Tables[7].Rows[m]["TotalAmountWithTax"]);
seller.GrandTotalAmount = Convert.ToDecimal(ds.Tables[7].Rows[m]["GrandTotalAmount"]);
seller.GrandTotalAmountInWord = Convert.ToString(ds.Tables[7].Rows[m]["GrandTotalAmountInWord"]);
seller.Invoice.LineEntry.Add(line);
p = 1 + p;
}
else
{
break;
}
}
seller.SellerDaTa.Add(seller);
Session["SellerDaTa"] = seller.SellerDaTa;
seller = new Seller();
seller.Reciever = new Reciever();
seller.Consignee = new Consignee();
seller.SellerDaTa = new List <Seller>();
#region INVOICE_TYPE
switch (strInvoiceType)
{
case "B2BInvoice":
Invoice b2bInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BInvoice);
seller.Invoice = b2bInvoice;
break;
case "AmendedB2BInvoice":
Invoice AmendedB2BInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BInvoice);
seller.Invoice = AmendedB2BInvoice;
break;
case "B2CLargeInvoice":
Invoice B2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2CLargeInvoice);
seller.Invoice = B2CLargeInvoice;
break;
case "AmendedB2CLargeInvoice":
Invoice AmendedB2CLargeInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2CLargeInvoice);
seller.Invoice = AmendedB2CLargeInvoice;
break;
case "B2BCreditNotesInvoice":
Invoice B2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BCreditNotesInvoice);
seller.Invoice = B2BCreditNotesInvoice;
break;
case "B2BDebitNotesInvoice":
Invoice B2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BDebitNotesInvoice);
seller.Invoice = B2BDebitNotesInvoice;
break;
case "AmendedB2BCreditNotesInvoice":
Invoice AmendedB2BCreditNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BCreditNotesInvoice);
seller.Invoice = AmendedB2BCreditNotesInvoice;
break;
case "AmendedB2BDebitNotesInvoice":
Invoice AmendedB2BDebitNotesInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BDebitNotesInvoice);
seller.Invoice = AmendedB2BDebitNotesInvoice;
break;
case "B2BExportInvoice":
Invoice B2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.B2BExportInvoice);
seller.Invoice = B2BExportInvoice;
break;
case "AmendedB2BExportInvoice":
Invoice AmendedB2BExportInvoice = InvoiceFactory.CreateInvoice(InvoiceType.AmendedB2BExportInvoice);
seller.Invoice = AmendedB2BExportInvoice;
break;
}
#endregion
seller.Invoice.LineEntry = new List <LineEntry>();
if ((List <Seller>)Session["SellerDaTa"] != null)
{
seller.SellerDaTa = (List <Seller>)Session["SellerDaTa"];
}
}
}
}
else
{
BALAJI.GSP.APPLICATION.User.User masterPage = this.Master as BALAJI.GSP.APPLICATION.User.User;
////masterPage.ShowModalPopup();
////masterPage.ErrorMessage = "System error occured during data population of SellerDtls table !!!";
}
#endregion
}
else
{
BALAJI.GSP.APPLICATION.User.User masterPage = this.Master as BALAJI.GSP.APPLICATION.User.User;
////masterPage.ShowModalPopup();
////masterPage.ErrorMessage = "System Error !!!";
}
if (ds.Tables["SellerDtls"].Rows.Count == 0 && ds.Tables["AdvanceSellerDtls"].Rows.Count == 0 && ds.Tables["EXPORTSellerDtls"].Rows.Count == 0)
{
BALAJI.GSP.APPLICATION.User.User masterPage = this.Master as BALAJI.GSP.APPLICATION.User.User;
////masterPage.ShowModalPopup();
////masterPage.ErrorMessage = "No data to upload !!!";
BtnUpload.Attributes.Add("style", "display:none");
}
return(ds);
}
