public static List <B2cs> GetB2csGst1Save(DataTable dtInvoice, DataTable dtInvoiceItemRate)
{
#region B2B Section
List <B2cs> _resB2CSList = new List <B2cs>();
#endregion
dtInvoice.Columns.AddRange(new DataColumn[] {
new DataColumn("InvoiceId", typeof(String)),
new DataColumn("typ", typeof(String)),
new DataColumn("pos", typeof(String)),
new DataColumn("etin", typeof(String)),
new DataColumn("sply_ty", typeof(String))
});
var dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] {
new DataColumn("InvoiceId", typeof(String)),
new DataColumn("txval", typeof(String)),
new DataColumn("rt", typeof(String)),
new DataColumn("iamt", typeof(String)),
new DataColumn("csamt", typeof(String))
});
try
{
for (int i = 0; i < dtInvoice.Rows.Count; i++)
{
dt.Clear();
string invoiceId = Convert.ToString(dtInvoice.Rows[i]["InvoiceId"]);
var dr = dtInvoiceItemRate.Select("InvoiceId =" + invoiceId);// fetch data from Datatable with current looping invoiceId
for (int k = 0; k < dr.Count(); k++)
{
dt.Rows.Add(dr[k].ItemArray);
}
for (int j = 0; j < dt.Rows.Count; j++)
{
B2cs _b2cs = new B2cs();
_b2cs.InvoiceId = Convert.ToString(dtInvoice.Rows[i]["InvoiceId"]);
_b2cs.etin = Convert.ToString(dtInvoice.Rows[i]["etin"]);
_b2cs.typ = Convert.ToString(dtInvoice.Rows[i]["typ"]);
_b2cs.pos = Convert.ToString(dtInvoice.Rows[i]["pos"]);
_b2cs.txval = Convert.ToInt32(dt.Rows[j]["txval"]);
_b2cs.rt = Convert.ToInt32(dt.Rows[j]["rt"]);
_b2cs.csamt = Convert.ToInt32(dt.Rows[i]["csamt"]);
_resB2CSList.Add(_b2cs);
}
}
}
catch (Exception ex)
{
}
return(_resB2CSList);
}
public B2cs GetB2cs(GST_TRN_INVOICE ItmB2csInvoice)
{
B2cs invb2cs = new B2cs();
invb2cs.pos = Convert.ToString(ItmB2csInvoice.AspNetUser.StateCode);
// invb2cs.typ = Convert.ToString(ItmB2csInvoice.Type);
var b2bdata = ItmB2csInvoice.GST_TRN_INVOICE_DATA.FirstOrDefault();
if (b2bdata != null)
{
invb2cs.camt = (int?)b2bdata.CGSTAmt;
invb2cs.csamt = (int?)b2bdata.CessAmt;
//invb2cs.etin = ItmB2csInvoice.TinNo;
invb2cs.iamt = (int?)b2bdata.IGSTAmt;
invb2cs.samt = (int?)b2bdata.SGSTAmt;
//invb2cs.sply_ty = ItmB2csInvoice.
invb2cs.txval = (double?)b2bdata.TaxableAmount;
invb2cs.rt = b2bdata.Rate == null ? null : (int?)b2bdata.Rate;
}
return(invb2cs);
}
public B2cs GetB2cs(GST_TRN_OFFLINE_INVOICE ItmB2csInvoice)
{
B2cs invb2cs = new B2cs();
invb2cs.pos = Convert.ToString(ItmB2csInvoice.PlaceofSupply);
invb2cs.typ = Convert.ToString(ItmB2csInvoice.Type);
var b2bdata = ItmB2csInvoice.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault();
if (b2bdata != null)
{
invb2cs.camt = (int?)b2bdata.CGSTAmt;
invb2cs.csamt = (int?)b2bdata.CessAmt;
//invb2cs.etin = ItmB2csInvoice.TinNo;
invb2cs.iamt = (int?)b2bdata.IGSTAmt;
invb2cs.samt = (int?)b2bdata.SGSTAmt;
//invb2cs.sply_ty = ItmB2csInvoice.
invb2cs.txval = (double?)b2bdata.TaxableAmount;
invb2cs.rt = b2bdata.GST_TRN_OFFLINE_INVOICE_RATE == null ? null : (int?)b2bdata.GST_TRN_OFFLINE_INVOICE_RATE.RATE;
}
return(invb2cs);
}
