protected void lv_Adjust_Advances_ItemInserting(object sender, ListViewInsertEventArgs e) { try { GST_TRN_OFFLINE_INVOICE obj = new GST_TRN_OFFLINE_INVOICE(); LinkButton lkbInsert = (e.Item.FindControl("lkbInsert")) as LinkButton; if (lkbInsert.CommandName == "Insert") { uc_SupplyType uc_SupplyType = (uc_SupplyType)e.Item.FindControl("uc_SupplyType"); obj.ReturnType = ReturnType; obj.SectionType = (byte)EnumConstants.OfflineExcelSection.AdvanceAdjustment; if (uc_SupplyType.ddlPos_SelectedIndex > 0) { obj.PlaceofSupply = Convert.ToByte(uc_SupplyType.ddlPos_SelectedValue); } if (uc_SupplyType.ddlSupplyType_SelectedIndex > 0) { obj.SupplyType = Convert.ToByte(uc_SupplyType.ddlSupplyType_SelectedValue); } } obj.UserID = Common.LoggedInUserID(); obj.CreatedDate = DateTime.Now; obj.CreatedBy = Common.LoggedInUserID(); unitOfwork.OfflineinvoiceRepository.Create(obj); unitOfwork.Save(); lv_Adjust_Advances.EditIndex = -1; BindItems(ReturnType); } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
private At Getatsdata(GST_TRN_OFFLINE_INVOICE atdata) { At at = new At(); at.itms = new List <Itm4>(); // at.pos = atdata.GST_MST_STATE.StateName; at.itms.AddRange(GetItm4(atdata)); at.sply_ty = atdata.SupplyType == 0 ? "INTER" : "INTRA"; return(at); }
protected void lv_B2b_Invoice_Gstr2_ItemUpdating(object sender, ListViewUpdateEventArgs e) { LinkButton lkbUpdate = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("lkbUpdate")) as LinkButton; if (lkbUpdate.CommandName == "Update") { int id = Convert.ToInt32(lkbUpdate.CommandArgument); GST_TRN_OFFLINE_INVOICE invoice = unitOfwork.OfflineinvoiceRepository.Filter(x => x.ValueId == id).SingleOrDefault(); if (invoice != null) { TextBox txtGSTIN = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("txtGSTIN")) as TextBox; if (txtGSTIN != null) { invoice.ReceiverGSTIN = txtGSTIN.Text; } TextBox txtInvoiceNo = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("txtInvoiceNo")) as TextBox; if (txtInvoiceNo != null) { invoice.InvoiceNo = txtInvoiceNo.Text; } TextBox txt_InvoiceDate = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate != null) { invoice.InvoiceDate = Convert.ToDateTime(txt_InvoiceDate.Text); } TextBox txtInvoiceValue = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("txtInvoiceValue")) as TextBox; if (txtInvoiceValue != null) { invoice.TotalInvoiceValue = txtInvoiceValue.Text; } DropDownList ddlPos = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("ddlPos")) as DropDownList; if (ddlPos != null) { invoice.PlaceofSupply = Convert.ToByte(ddlPos.SelectedValue); } DropDownList ddl_SupplyType = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("ddl_SupplyType")) as DropDownList; if (ddl_SupplyType.SelectedIndex > 0) { invoice.SupplyType = Convert.ToByte(ddl_SupplyType.SelectedValue); } DropDownList ddl_InvoiceType = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("ddl_InvoiceType")) as DropDownList; if (ddl_InvoiceType.SelectedIndex > 0) { invoice.InvoiceType = Convert.ToByte(ddl_InvoiceType.SelectedValue); } CheckBox chkReverse = (lv_B2b_Invoice_Gstr2.Items[e.ItemIndex].FindControl("chkReverse")) as CheckBox; invoice.ReverseCharge = chkReverse.Checked; } unitOfwork.OfflineinvoiceRepository.Update(invoice); unitOfwork.Save(); } lv_B2b_Invoice_Gstr2.EditIndex = -1; BindItems(); }
public B2cl GetB2cl(GST_TRN_OFFLINE_INVOICE b2clInvoice) { B2cl b2cldata = new B2cl(); b2cldata.inv = new List <Inv2>(); b2cldata.pos = b2clInvoice.PlaceofSupply.ToString(); foreach (var data in b2clInvoice.GST_TRN_OFFLINE_INVOICE_DATAITEM) { b2cldata.inv.Add(GetInv2(data)); } return(b2cldata); }
public Cdnr Getcdnrdata(GST_TRN_OFFLINE_INVOICE cdnrInvoice) { Cdnr cdnrdatas = new Cdnr(); cdnrdatas.ctin = "Tin";//cdnrInvoice.TIN; cdnrdatas.nt = new List <Nt>(); foreach (var data in cdnrInvoice.GST_TRN_OFFLINE_INVOICE_DATAITEM) { cdnrdatas.nt.Add(GetNt(data)); } return(cdnrdatas); }
protected void lv_B2b_Invoice_Gstr2_ItemInserting(object sender, ListViewInsertEventArgs e) { GST_TRN_OFFLINE_INVOICE obj = new GST_TRN_OFFLINE_INVOICE(); LinkButton lkbInsert = (e.Item.FindControl("lkbInsert")) as LinkButton; if (lkbInsert.CommandName == "Insert") { TextBox txtGSTIN = (e.Item.FindControl("txtGSTIN")) as TextBox; if (txtGSTIN != null) { obj.ReceiverGSTIN = txtGSTIN.Text; } TextBox txtInvoiceNo = (e.Item.FindControl("txtInvoiceNo")) as TextBox; if (txtInvoiceNo != null) { obj.InvoiceNo = txtInvoiceNo.Text; } TextBox txt_InvoiceDate = (e.Item.FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate != null) { obj.InvoiceDate = DateTime.ParseExact(txt_InvoiceDate.Text, "dd/MM/yyyy", null); } //obj.InvoiceDate = Convert.ToDateTime(txt_InvoiceDate.Text); TextBox txtInvoiceValue = (e.Item.FindControl("txtInvoiceValue")) as TextBox; if (txtInvoiceValue != null) { obj.TotalInvoiceValue = txtInvoiceValue.Text; } DropDownList ddlPos = (e.Item.FindControl("ddlPos")) as DropDownList; if (ddlPos.SelectedIndex > 0) { obj.PlaceofSupply = Convert.ToByte(ddlPos.SelectedItem.Value); } DropDownList ddl_SupplyType = (e.Item.FindControl("ddl_SupplyType")) as DropDownList; if (ddl_SupplyType.SelectedIndex > 0) { obj.SupplyType = Convert.ToByte(ddl_SupplyType.SelectedValue); } DropDownList ddl_InvoiceType = (e.Item.FindControl("ddl_InvoiceType")) as DropDownList; if (ddl_InvoiceType.SelectedIndex > 0) { obj.InvoiceType = Convert.ToByte(ddl_InvoiceType.SelectedValue); } CheckBox chkReverse = (e.Item.FindControl("chkReverse")) as CheckBox; obj.ReverseCharge = chkReverse.Checked; } unitOfwork.OfflineinvoiceRepository.Create(obj); unitOfwork.Save(); lv_B2b_Invoice_Gstr2.EditIndex++; BindItems(); }
private Txpd Gettxpdata(GST_TRN_OFFLINE_INVOICE txpddata) { Txpd txpd = new Txpd(); txpd.pos = Convert.ToString(txpddata.PlaceofSupply); txpd.sply_ty = txpddata.SupplyType == 0 ? "INTER" : "INTRA"; foreach (var data in txpddata.GST_TRN_OFFLINE_INVOICE_DATAITEM) { txpd.itms.Add(GetItm7(data)); } return(txpd); }
private List <Itm4> GetItm4(GST_TRN_OFFLINE_INVOICE atdata) { List <Itm4> itm4s = new List <Itm4>(); Itm4 itm4 = new Itm4(); foreach (var data in atdata.GST_TRN_OFFLINE_INVOICE_DATAITEM) { itm4.camt = (double?)data.CGSTAmt; itm4.csamt = (int?)data.CessAmt; itm4.iamt = (double?)data.IGSTAmt; itm4.rt = data.GST_TRN_OFFLINE_INVOICE_RATE == null ? null : (int?)data.GST_TRN_OFFLINE_INVOICE_RATE.RATE; itm4.samt = (int?)data.SGSTAmt; itm4s.Add(itm4); } return(itm4s); }
private Datum GetDatum(GST_TRN_OFFLINE_INVOICE data) { Datum datumSource = new Datum(); datumSource.desc = data.HSNDescription; datumSource.samt = (int?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().SGSTAmt; datumSource.camt = (int?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().CGSTAmt; datumSource.csamt = (int?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().CessAmt; datumSource.hsn_sc = data.HSN; datumSource.num = 12; datumSource.qty = (double?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().TotalQuantity; datumSource.txval = (double?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().TotalTaxableValue; datumSource.iamt = (double?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().IGSTAmt; datumSource.val = (double?)data.GST_TRN_OFFLINE_INVOICE_DATAITEM.FirstOrDefault().TotalValue; datumSource.uqc = "ABC"; return(datumSource); }
public Cdnur Getcdnurdata(GST_TRN_OFFLINE_INVOICE cdnurdata) { Cdnur cdnur = new Cdnur(); cdnur.idt = Convert.ToDateTime(cdnurdata.InvoiceDate).ToString("dd-mm-yyyy"); cdnur.inum = cdnurdata.InvoiceNo; cdnur.nt_dt = Convert.ToString(cdnurdata.Voucher_date); cdnur.nt_num = cdnurdata.Voucher_No; cdnur.ntty = Convert.ToString(cdnurdata.NoteType); cdnur.p_gst = Convert.ToString(cdnurdata.Pre_GST); cdnur.rsn = Convert.ToString(cdnurdata.Issuing_Note); cdnur.val = Convert.ToInt32(cdnurdata.Voucher_Value); cdnur.itms = new List <Itm6>(); foreach (var data in cdnurdata.GST_TRN_OFFLINE_INVOICE_DATAITEM) { cdnur.itms.Add(GetItem6(data)); } return(cdnur); }
private List <Inv3> GetInv3(GST_TRN_OFFLINE_INVOICE expdata) { List <Inv3> invs3 = new List <Inv3>(); Inv3 inv3; foreach (var dataitem in expdata.GST_TRN_OFFLINE_INVOICE_DATAITEM) { inv3 = new Inv3(); inv3.itms = new List <Itm3>(); inv3.idt = Convert.ToDateTime(dataitem.GST_TRN_OFFLINE_INVOICE.InvoiceDate).ToString("dd-mm-yyyy"); inv3.inum = dataitem.GST_TRN_OFFLINE_INVOICE.InvoiceNo; inv3.itms.Add(GetItm3(dataitem)); inv3.sbdt = Convert.ToDateTime(dataitem.GST_TRN_OFFLINE_INVOICE.ShippingBillDate).ToString("dd-mm-yyyy"); inv3.sbnum = Convert.ToInt32(dataitem.GST_TRN_OFFLINE_INVOICE.ShippingBillNo); inv3.sbpcode = dataitem.GST_TRN_OFFLINE_INVOICE.PortCode; inv3.val = (int?)dataitem.TotalTaxableValue; invs3.Add(inv3); } return(invs3); }
private List <Inv> GetInv(GST_TRN_OFFLINE_INVOICE B2B) { List <Inv> invs = new List <Inv>(); Inv inv; foreach (var dataitem in B2B.GST_TRN_OFFLINE_INVOICE_DATAITEM) { inv = new Inv(); inv.itms = new List <Itm>(); inv.idt = Convert.ToDateTime(dataitem.GST_TRN_OFFLINE_INVOICE.InvoiceDate).ToString("dd-mm-yyyy"); inv.inum = dataitem.GST_TRN_OFFLINE_INVOICE.InvoiceNo; inv.inv_typ = dataitem.GST_TRN_OFFLINE_INVOICE.InvoiceType == null ? "" : ((EnumConstants.InvoiceType)dataitem.GST_TRN_OFFLINE_INVOICE.InvoiceType).ToString()[0].ToString(); inv.itms.Add(GetItm(dataitem)); inv.pos = dataitem.GST_TRN_OFFLINE_INVOICE.PlaceofSupply == null ? "" : dataitem.GST_TRN_OFFLINE_INVOICE.GST_MST_STATE.StateCode; inv.rchrg = Convert.ToBoolean(dataitem.GST_TRN_OFFLINE_INVOICE.ReverseCharge) ? "Y" : "N"; inv.val = (int?)dataitem.TotalTaxableValue; invs.Add(inv); } return(invs); }
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); }
protected void lv_crdrUnregister_ItemInserting(object sender, ListViewInsertEventArgs e) { try { GST_TRN_OFFLINE_INVOICE obj = new GST_TRN_OFFLINE_INVOICE(); LinkButton lkbInsert = (e.Item.FindControl("lkbInsert")) as LinkButton; if (lkbInsert.CommandName == "Insert") { obj.ReturnType = ReturnType; obj.SectionType = (byte)EnumConstants.OfflineExcelSection.CreditDebitNonReg; DropDownList ddl_URType = (e.Item.FindControl("ddl_URType")) as DropDownList; if (ddl_URType.SelectedIndex > 0) { obj.URType = Convert.ToByte(ddl_URType.SelectedValue); } TextBox txtVoucherNo = (e.Item.FindControl("txtVoucherNo")) as TextBox; if (txtVoucherNo.Text != null) { obj.Voucher_No = txtVoucherNo.Text.Trim(); } TextBox txt_VoucherDate = (e.Item.FindControl("txt_VoucherDate")) as TextBox; if (txt_VoucherDate.Text != null || txt_VoucherDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_VoucherDate.Text, "dd/MM/yyyy", null); obj.Voucher_date = SOrderDate; } TextBox txt_invoiceno = (e.Item.FindControl("txt_invoiceno")) as TextBox; if (txt_invoiceno.Text != null) { obj.InvoiceNo = txt_invoiceno.Text.Trim(); } TextBox txt_InvoiceDate = (e.Item.FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate.Text != null || txt_InvoiceDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_InvoiceDate.Text.Trim(), "dd/MM/yyyy", null); obj.InvoiceDate = SOrderDate; } DropDownList ddl_DocumentType = (e.Item.FindControl("ddl_DocumentType")) as DropDownList; if (ddl_DocumentType.SelectedIndex > 0) { obj.Document_Type = ddl_DocumentType.SelectedValue; } DropDownList ddl_IssuingNote = (e.Item.FindControl("ddl_IssuingNote")) as DropDownList; if (ddl_IssuingNote.SelectedIndex > 0) { obj.Issuing_Note = Convert.ToInt32(ddl_IssuingNote.SelectedItem.Value); } TextBox txt_VoucherValue = (e.Item.FindControl("txt_VoucherValue")) as TextBox; if (txt_VoucherValue.Text != null) { obj.Voucher_Value = txt_VoucherValue.Text.Trim(); } DropDownList ddlPos = (e.Item.FindControl("ddlPos")) as DropDownList; if (ddlPos.SelectedIndex > 0) { obj.PlaceofSupply = Convert.ToByte(ddlPos.SelectedItem.Value); } DropDownList ddlSupplyType = (e.Item.FindControl("ddlSupplyType")) as DropDownList; if (ddlSupplyType.SelectedIndex > 0) { obj.SupplyType = Convert.ToByte(ddlSupplyType.SelectedValue); } CheckBox chk_PreGST = (e.Item.FindControl("chk_PreGST")) as CheckBox; obj.Pre_GST = chk_PreGST.Checked; } //viveksinha-start obj.UserID = Common.LoggedInUserID(); obj.CreatedBy = Common.LoggedInUserID(); obj.CreatedDate = DateTime.Now; unitOfwork.OfflineinvoiceRepository.Create(obj); unitOfwork.Save(); lv_crdrUnregister.EditIndex = -1; //lv_crdrUnregister.EditIndex++; BindItems(ReturnType); lkbDelete.Visible = true; //end } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
protected void lv_crdrUnregister_ItemUpdating(object sender, ListViewUpdateEventArgs e) { try { LinkButton lkbUpdate = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("lkbUpdate")) as LinkButton; if (lkbUpdate.CommandName == "Update") { int id = Convert.ToInt32(lkbUpdate.CommandArgument); GST_TRN_OFFLINE_INVOICE invoice = unitOfwork.OfflineinvoiceRepository.Filter(x => x.ValueId == id).SingleOrDefault(); if (invoice != null) { DropDownList ddl_URType = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("ddl_URType")) as DropDownList; if (ddl_URType.SelectedIndex > -1) { invoice.URType = Convert.ToByte(ddl_URType.SelectedValue); } TextBox txtVoucherNo = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("txtVoucherNo")) as TextBox; if (txtVoucherNo.Text != null || txtVoucherNo.Text != "") { invoice.Voucher_No = txtVoucherNo.Text.Trim(); } TextBox txt_VocherDate = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("txt_VocherDate")) as TextBox; if (txt_VocherDate.Text != null || txt_VocherDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_VocherDate.Text, "dd/MM/yyyy", null); invoice.Voucher_date = SOrderDate; } TextBox txt_invoiceno = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("txt_invoiceno")) as TextBox; if (txt_invoiceno.Text != null || txt_invoiceno.Text != "") { invoice.InvoiceNo = txt_invoiceno.Text.Trim(); } TextBox txt_InvoiceDate = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate.Text != "-" || txt_InvoiceDate.Text != null) { DateTime SOrderDate = DateTime.ParseExact(txt_InvoiceDate.Text, "dd/MM/yyyy", null); invoice.InvoiceDate = SOrderDate; } DropDownList ddl_DocumentType = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("ddl_DocumentType")) as DropDownList; if (ddl_DocumentType.SelectedIndex > 0) { invoice.Document_Type = ddl_DocumentType.SelectedValue; } DropDownList ddl_IssuingNote = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("ddl_IssuingNote")) as DropDownList; if (ddl_IssuingNote.SelectedIndex > 0) { invoice.Issuing_Note = Convert.ToInt32(ddl_IssuingNote.SelectedItem.Value); } DropDownList ddlPos = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("ddlPos")) as DropDownList; if (ddlPos != null) { invoice.PlaceofSupply = Convert.ToByte(ddlPos.SelectedValue); } TextBox txt_VoucherValue = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("txt_VoucherValue")) as TextBox; if (txt_VoucherValue.Text != null || txt_VoucherValue.Text != "") { invoice.Voucher_Value = txt_VoucherValue.Text.Trim(); } DropDownList ddlSupplyType = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("ddlSupplyType")) as DropDownList; if (ddlSupplyType.SelectedIndex > 0) { invoice.SupplyType = Convert.ToByte(ddlSupplyType.SelectedValue); } CheckBox chk_PreGST = (lv_crdrUnregister.Items[e.ItemIndex].FindControl("chk_PreGST")) as CheckBox; invoice.Pre_GST = chk_PreGST.Checked; } //viveksinha-start invoice.UpdatedDate = DateTime.Now; invoice.UpdatedBy = Common.LoggedInUserID(); invoice.UserID = Common.LoggedInUserID(); //end unitOfwork.OfflineinvoiceRepository.Update(invoice); unitOfwork.Save(); } lv_crdrUnregister.EditIndex = -1; BindItems(ReturnType); } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
protected void lv_Export_ItemInserting(object sender, ListViewInsertEventArgs e) { try { GST_TRN_OFFLINE_INVOICE obj = new GST_TRN_OFFLINE_INVOICE(); LinkButton lkbInsert = (e.Item.FindControl("lkbInsert")) as LinkButton; if (lkbInsert.CommandName == "Insert") { obj.ReturnType = ReturnType; obj.SectionType = (byte)EnumConstants.OfflineExcelSection.ExportInvoice; DropDownList ddl_GSTPayment = (e.Item.FindControl("ddl_GSTPayment")) as DropDownList; if (ddl_GSTPayment.SelectedIndex > 0) { obj.GST_Payment = Convert.ToByte(ddl_GSTPayment.SelectedValue); } TextBox txt_invoiceno = (e.Item.FindControl("txt_invoiceno")) as TextBox; if (txt_invoiceno.Text != null) { obj.InvoiceNo = txt_invoiceno.Text.Trim(); } TextBox txt_InvoiceDate = (e.Item.FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate.Text != null || txt_InvoiceDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_InvoiceDate.Text, "dd/MM/yyyy", null); obj.InvoiceDate = SOrderDate; } //obj.InvoiceDate = DateTime.ParseExact(txt_InvoiceDate.Text, "dd/MM/yyyy", null); TextBox txt_InvoiceValue = (e.Item.FindControl("txt_InvoiceValue")) as TextBox; if (txt_InvoiceValue.Text != null) { obj.TotalInvoiceValue = txt_InvoiceValue.Text.Trim(); } TextBox txt_PortCode = (e.Item.FindControl("txt_PortCode")) as TextBox; if (txt_PortCode.Text != null) { obj.PortCode = txt_PortCode.Text.Trim(); } TextBox txt_ShippingBillNo = (e.Item.FindControl("txt_ShippingBillNo")) as TextBox; if (txt_ShippingBillNo.Text != null) { obj.ShippingBillNo = txt_ShippingBillNo.Text.Trim(); } TextBox txt_ShippingBillDate = (e.Item.FindControl("txt_ShippingBillDate")) as TextBox; if (txt_ShippingBillDate.Text != null || txt_ShippingBillDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_ShippingBillDate.Text, "dd/MM/yyyy", null); obj.ShippingBillDate = SOrderDate; } DropDownList ddl_SupplyType = (e.Item.FindControl("ddl_SupplyType")) as DropDownList; if (ddl_SupplyType.SelectedIndex > 0) { obj.SupplyType = Convert.ToByte(ddl_SupplyType.SelectedValue); } } //viveksinha-start obj.UserID = Common.LoggedInUserID(); obj.CreatedBy = Common.LoggedInUserID(); obj.CreatedDate = DateTime.Now; unitOfwork.OfflineinvoiceRepository.Create(obj); unitOfwork.Save(); lv_Export.EditIndex = -1; //lv_Export.EditIndex++; BindItems(ReturnType); lkbDelete.Visible = true; } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
protected void lv_Export_ItemUpdating(object sender, ListViewUpdateEventArgs e) { try { LinkButton lkbUpdate = (lv_Export.Items[e.ItemIndex].FindControl("lkbUpdate")) as LinkButton; if (lkbUpdate.CommandName == "Update") { int id = Convert.ToInt32(lkbUpdate.CommandArgument); GST_TRN_OFFLINE_INVOICE invoice = unitOfwork.OfflineinvoiceRepository.Filter(x => x.ValueId == id).SingleOrDefault(); if (invoice != null) { DropDownList ddl_GSTPayment = (lv_Export.Items[e.ItemIndex].FindControl("ddl_GSTPayment")) as DropDownList; if (ddl_GSTPayment.SelectedIndex > 0) { invoice.GST_Payment = Convert.ToByte(ddl_GSTPayment.SelectedValue); } TextBox txt_invoiceno = (lv_Export.Items[e.ItemIndex].FindControl("txt_invoiceno")) as TextBox; if (txt_invoiceno.Text != null || txt_invoiceno.Text != "") { invoice.InvoiceNo = txt_invoiceno.Text.Trim(); } TextBox txt_InvoiceDate = (lv_Export.Items[e.ItemIndex].FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate.Text != null || txt_InvoiceDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_InvoiceDate.Text, "dd/MM/yyyy", null); invoice.InvoiceDate = SOrderDate; } TextBox txt_InvoiceValue = (lv_Export.Items[e.ItemIndex].FindControl("txt_InvoiceValue")) as TextBox; if (txt_InvoiceValue.Text != null || txt_InvoiceValue.Text != "") { invoice.TotalInvoiceValue = txt_InvoiceValue.Text.Trim(); } TextBox txt_PortCode = (lv_Export.Items[e.ItemIndex].FindControl("txt_PortCode")) as TextBox; if (txt_PortCode.Text != null || txt_PortCode.Text != "") { invoice.PortCode = txt_PortCode.Text.Trim(); } TextBox txt_ShippingBillNo = (lv_Export.Items[e.ItemIndex].FindControl("txt_ShippingBillNo")) as TextBox; if (txt_ShippingBillNo.Text != null || txt_ShippingBillNo.Text != "") { invoice.ShippingBillNo = txt_ShippingBillNo.Text; } TextBox txt_ShippingBillDate = (lv_Export.Items[e.ItemIndex].FindControl("txt_ShippingBillDate")) as TextBox; if (txt_ShippingBillDate.Text != null || txt_ShippingBillDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_ShippingBillDate.Text, "dd/MM/yyyy", null); invoice.ShippingBillDate = SOrderDate; } DropDownList ddl_SupplyType = (lv_Export.Items[e.ItemIndex].FindControl("ddl_SupplyType")) as DropDownList; if (ddl_SupplyType.SelectedIndex > 0) { invoice.SupplyType = Convert.ToByte(ddl_SupplyType.SelectedValue); } } //viveksinha-start invoice.UpdatedDate = DateTime.Now; invoice.UpdatedBy = Common.LoggedInUserID(); invoice.UserID = Common.LoggedInUserID(); //end unitOfwork.OfflineinvoiceRepository.Update(invoice); unitOfwork.Save(); lv_Export.EditIndex = -1; BindItems(ReturnType); //lkbDelete.Visible = true; } } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
private Exp GetExpData(GST_TRN_OFFLINE_INVOICE expdata) { return(new Exp { exp_typ = "Wpay", inv = GetInv3(expdata) }); }
private B2b GetB2b(GST_TRN_OFFLINE_INVOICE B2B) { return(new B2b { ctin = "tinno", inv = GetInv(B2B) }); }
protected void lv_B2b_Invoice_ItemInserting(object sender, ListViewInsertEventArgs e) { try { GST_TRN_OFFLINE_INVOICE obj = new GST_TRN_OFFLINE_INVOICE(); LinkButton lkbInsert = (e.Item.FindControl("lkbInsert")) as LinkButton; if (lkbInsert.CommandName == "Insert") { obj.ReturnType = ReturnType; obj.SectionType = (byte)EnumConstants.OfflineExcelSection.B2B; uc_SupplyType uc_SupplyType = (uc_SupplyType)e.Item.FindControl("uc_SupplyType"); TextBox txtGSTIN = (e.Item.FindControl("txtGSTIN")) as TextBox; if (txtGSTIN.Text != null) { obj.ReceiverGSTIN = txtGSTIN.Text.Trim(); } TextBox txtInvoiceNo = (e.Item.FindControl("txtInvoiceNo")) as TextBox; if (txtInvoiceNo.Text != null) { obj.InvoiceNo = txtInvoiceNo.Text.Trim(); } TextBox txt_InvoiceDate = (e.Item.FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate.Text != null || txt_InvoiceDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_InvoiceDate.Text, "dd/MM/yyyy", null); obj.InvoiceDate = SOrderDate; } TextBox txtInvoiceValue = (e.Item.FindControl("txtInvoiceValue")) as TextBox; if (txtInvoiceValue.Text != null) { obj.TotalInvoiceValue = txtInvoiceValue.Text.Trim(); } if (uc_SupplyType.ddlPos_SelectedIndex > 0) { obj.PlaceofSupply = Convert.ToByte(uc_SupplyType.ddlPos_SelectedValue); } if (uc_SupplyType.ddlSupplyType_SelectedIndex > 0) { obj.SupplyType = Convert.ToByte(uc_SupplyType.ddlSupplyType_SelectedValue); } DropDownList ddl_InvoiceType = (e.Item.FindControl("ddl_InvoiceType")) as DropDownList; if (ddl_InvoiceType.SelectedIndex > 0) { obj.InvoiceType = Convert.ToByte(ddl_InvoiceType.SelectedValue); } TextBox txtECommerce = (e.Item.FindControl("txtECommerce")) as TextBox; if (txtECommerce.Text != null) { obj.ECommerce_GSTIN = txtECommerce.Text.Trim(); } CheckBox chkReverse = (e.Item.FindControl("chkReverse")) as CheckBox; obj.ReverseCharge = chkReverse.Checked; } //viveksinha-start obj.UserID = Common.LoggedInUserID(); obj.CreatedBy = Common.LoggedInUserID(); obj.CreatedDate = DateTime.Now; //end unitOfwork.OfflineinvoiceRepository.Create(obj); unitOfwork.Save(); lv_B2b_Invoice.EditIndex = -1; BindItems(ReturnType); lkbDelete.Visible = true; } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
protected void lv_B2b_Invoice_ItemUpdating(object sender, ListViewUpdateEventArgs e) { try { LinkButton lkbUpdate = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("lkbUpdate")) as LinkButton; if (lkbUpdate.CommandName == "Update") { int id = Convert.ToInt32(lkbUpdate.CommandArgument); GST_TRN_OFFLINE_INVOICE invoice = unitOfwork.OfflineinvoiceRepository.Filter(x => x.ValueId == id).SingleOrDefault(); if (invoice != null) { uc_SupplyType uc_SupplyType = (uc_SupplyType)lv_B2b_Invoice.Items[e.ItemIndex].FindControl("uc_SupplyType"); TextBox txtGSTIN = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("txtGSTIN")) as TextBox; if (txtGSTIN.Text != null || txtGSTIN.Text != "") { invoice.ReceiverGSTIN = txtGSTIN.Text.Trim(); } TextBox txtInvoiceNo = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("txtInvoiceNo")) as TextBox; if (txtInvoiceNo.Text != null || txtInvoiceNo.Text != "") { invoice.InvoiceNo = txtInvoiceNo.Text.Trim(); } TextBox txt_InvoiceDate = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("txt_InvoiceDate")) as TextBox; if (txt_InvoiceDate.Text != null || txt_InvoiceDate.Text != "-") { DateTime SOrderDate = DateTime.ParseExact(txt_InvoiceDate.Text.Trim(), "dd/MM/yyyy", null); invoice.InvoiceDate = SOrderDate; } TextBox txtInvoiceValue = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("txtInvoiceValue")) as TextBox; if (txtInvoiceValue.Text != null || txtInvoiceValue.Text != "") { invoice.TotalInvoiceValue = txtInvoiceValue.Text.Trim(); } if (uc_SupplyType.ddlPos_SelectedIndex > 0) { invoice.PlaceofSupply = Convert.ToByte(uc_SupplyType.ddlPos_SelectedValue); } if (uc_SupplyType.ddlSupplyType_SelectedIndex > 0) { invoice.SupplyType = Convert.ToByte(uc_SupplyType.ddlSupplyType_SelectedValue); } DropDownList ddl_InvoiceType = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("ddl_InvoiceType")) as DropDownList; if (ddl_InvoiceType.SelectedIndex > 0) { invoice.InvoiceType = Convert.ToByte(ddl_InvoiceType.SelectedValue); } TextBox txtECommerce = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("txtECommerce")) as TextBox; if (txtECommerce.Text != null || txtECommerce.Text != "") { invoice.ECommerce_GSTIN = txtECommerce.Text.Trim(); } CheckBox chkReverse = (lv_B2b_Invoice.Items[e.ItemIndex].FindControl("chkReverse")) as CheckBox; invoice.ReverseCharge = chkReverse.Checked; } //viveksinha-start invoice.UserID = Common.LoggedInUserID(); invoice.UpdatedBy = Common.LoggedInUserID(); invoice.UpdatedDate = DateTime.Now; //end unitOfwork.OfflineinvoiceRepository.Update(invoice); unitOfwork.Save(); } lv_B2b_Invoice.EditIndex = -1; BindItems(ReturnType); } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
private GST_TRN_OFFLINE_INVOICE GetInvoiceInformation(DataRow dataRow, string SupplierGSTIN, byte sheetCode, string UserId, string offlineid) { GST_TRN_OFFLINE_INVOICE invoice = new GST_TRN_OFFLINE_INVOICE(); try { //B2B string stateCode; Boolean ReverseChr; if (sheetCode == 0) { stateCode = dataRow.ItemArray[4].ToString().Split('-')[0]; invoice.ReceiverGSTIN = dataRow.Field <string>("Column0"); invoice.InvoiceNo = dataRow.Field <string>("Column1"); invoice.InvoiceDate = dataRow.Field <DateTime>("Column2"); invoice.TotalInvoiceValue = Convert.ToString(dataRow.ItemArray[3]); invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.ReverseCharge = dataRow.ItemArray[5].ToString() == "Y" ? true : false; invoice.InvoiceType = sheetCode; //Convert.ToByte(dataRow.ItemArray[6]); invoice.ECommerce_GSTIN = dataRow.Field <string>("Column7"); invoice.SectionType = sheetCode; } //B2CL else if (sheetCode == 1) { stateCode = dataRow.ItemArray[3].ToString().Split('-')[0]; invoice.InvoiceNo = Convert.ToString(dataRow.ItemArray[0]); invoice.InvoiceDate = dataRow.Field <DateTime>("Column1"); invoice.TotalInvoiceValue = Convert.ToString(dataRow.ItemArray[2]); invoice.ECommerce_GSTIN = dataRow.Field <string>("Column7"); invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.SectionType = sheetCode; } //B2CS else if (sheetCode == 2) { stateCode = dataRow.ItemArray[1].ToString().Split('-')[0]; invoice.Type = Convert.ToByte((EnumConstants.URType)Enum.Parse(typeof(EnumConstants.OfflineType), dataRow.ItemArray[0].ToString())); //dataRow.Field<string>("Column0"); invoice.ECommerce_GSTIN = dataRow.Field <string>("Column5"); invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.SectionType = sheetCode; } //CDNR else if (sheetCode == 3) { invoice.ReceiverGSTIN = dataRow.Field <string>("Column0"); invoice.InvoiceNo = Convert.ToString(dataRow.ItemArray[1]); invoice.InvoiceDate = Convert.ToDateTime(dataRow.ItemArray[2]); invoice.Voucher_No = Convert.ToString(dataRow.ItemArray[3]); invoice.Voucher_date = Convert.ToDateTime(dataRow.ItemArray[4]); invoice.Document_Type = Convert.ToString(dataRow.ItemArray[5]); string NoteCode = dataRow.ItemArray[6].ToString().Split('-')[0]; invoice.Issuing_Note = unitOfWork.OfflineissuingnoteRepository.Find(x => x.NoteCode == NoteCode).NoteID; stateCode = dataRow.ItemArray[7].ToString().Split('-')[0]; invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.Voucher_Value = Convert.ToString(dataRow.ItemArray[8]); invoice.Pre_GST = dataRow.ItemArray[12].ToString() == "Y" ? true : false; invoice.SectionType = sheetCode; //invoice.InvoiceType = Convert.ToByte(dataRow.Field<string>("Column10")); //invoice.ECommerece_GSTIN = dataRow.Field<string>("Column11"); } //CDNUR else if (sheetCode == 4) { stateCode = dataRow.ItemArray[7].ToString().Split('-')[0]; invoice.URType = Convert.ToByte((EnumConstants.URType)Enum.Parse(typeof(EnumConstants.URType), dataRow.ItemArray[0].ToString())); invoice.Voucher_No = dataRow.Field <string>("Column1"); invoice.Voucher_date = Convert.ToDateTime(dataRow.ItemArray[2]); invoice.Document_Type = Convert.ToString(dataRow.ItemArray[3]);//Convert.ToString((EnumConstants.NoteType)Enum.Parse(typeof(EnumConstants.NoteType), dataRow.ItemArray[3].ToString())); //Convert.ToByte(dataRow.ItemArray[3]); invoice.InvoiceNo = Convert.ToString(dataRow.ItemArray[4]); invoice.InvoiceDate = Convert.ToDateTime(dataRow.ItemArray[5]); string NoteCode = dataRow.ItemArray[6].ToString().Split('-')[0]; invoice.Issuing_Note = unitOfWork.OfflineissuingnoteRepository.Find(x => x.NoteCode == NoteCode).NoteID; invoice.Voucher_Value = Convert.ToString(dataRow.ItemArray[8]); invoice.Pre_GST = dataRow.ItemArray[12].ToString() == "Y" ? true : false; invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.SectionType = sheetCode; } //EXP else if (sheetCode == 5) { invoice.InvoiceType = sheetCode; //invoice.InvoiceType = Convert.ToByte(dataRow.Field<string>("Column0")); invoice.InvoiceNo = Convert.ToString(dataRow.ItemArray[1]); invoice.InvoiceDate = Convert.ToDateTime(dataRow.ItemArray[2]); invoice.TotalInvoiceValue = Convert.ToString(dataRow.ItemArray[3]); invoice.PortCode = Convert.ToString(dataRow.ItemArray[4]); invoice.ShippingBillNo = Convert.ToString(dataRow.ItemArray[5]); invoice.ShippingBillDate = Convert.ToDateTime(dataRow.ItemArray[6]); invoice.SectionType = sheetCode; } //at else if (sheetCode == 6) { stateCode = dataRow.ItemArray[0].ToString().Split('-')[0]; invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.SectionType = sheetCode; } //atadj else if (sheetCode == 7) { stateCode = dataRow.ItemArray[0].ToString().Split('-')[0]; invoice.PlaceofSupply = unitOfWork.StateRepository.Filter(x => x.StateCode == stateCode).FirstOrDefault().StateID; invoice.SectionType = sheetCode; } //exemp else if (sheetCode == 8) { invoice.HSNDescription = dataRow.Field <string>("Column0"); invoice.NilRated = Convert.ToBoolean(dataRow.ItemArray[1]); invoice.IsExempted = Convert.ToBoolean(dataRow.ItemArray[2]); invoice.NonGSTSupplies = Convert.ToBoolean(dataRow.ItemArray[3]); invoice.SectionType = sheetCode; } //hsn else if (sheetCode == 9) { invoice.HSN = Convert.ToString(dataRow.ItemArray[0]); invoice.HSNDescription = dataRow.Field <string>("Column1"); invoice.UQC = Convert.ToByte((EnumConstants.Unit)Enum.Parse(typeof(EnumConstants.Unit), dataRow.ItemArray[2].ToString().Split('-')[0]));//Convert.ToByte(dataRow.ItemArray[2]); invoice.SectionType = sheetCode; } invoice.UserID = UserId; invoice.OfflineID = Convert.ToInt64(offlineid); invoice.CreatedBy = UserId; invoice.CreatedDate = DateTime.Now; unitOfWork.OfflineinvoiceRepository.Create(invoice); unitOfWork.Save(); } catch (DbEntityValidationException ex) { foreach (var eve in ex.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } return(invoice); }