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); }