public bool SaleRegister(GST_TRN_INVOICE invoice) { foreach (GST_TRN_INVOICE_DATA item in invoice.GST_TRN_INVOICE_DATA) { var itemType = unitOfWork.ItemRepository.Find(f => f.Item_ID == item.Item_ID).ItemType; // var purchaseItems = unitOfWork.PurchaseDataRepositry.Filter(f => f.Status == true && item.Item_ID == f.Item_ID).Select(s => s.GST_MST_PURCHASE_REGISTER.UserID).ToList(); if (itemType == (byte)EnumConstants.ItemType.HSN) { //string uId = seller.SellerUserID; //int iTem = Convert.ToInt32(item.Item_ID); //decimal LeftQty = purchaseRegister.GetLeftItemQty(iTem, uId); //if (LeftQty > item.Qty) //{ GST_MST_SALE_REGISTER salRegister = new GST_MST_SALE_REGISTER(); salRegister.InvoiceID = invoice.InvoiceID; salRegister.PerUnitRate = item.Rate; salRegister.Item_ID = item.Item_ID; salRegister.Qty = item.Qty; salRegister.CreatedBy = invoice.CreatedBy; salRegister.CreatedDate = DateTime.Now; salRegister.Status = true; salRegister.Id = invoice.SellerUserID; salRegister.SaleStatus = (byte)EnumConstants.SaleStatus.Fresh; unitOfWork.SaleRegisterDataRepositry.Create(salRegister); //q } } } unitOfWork.Save(); return(true); }
public bool SaveInvoiveDataInPurchaseRegister(GST_TRN_INVOICE invoice) { var prData = unitOfWork.PurchaseRegisterDataRepositry.Find(f => f.SupplierInvoiceNo == invoice.InvoiceNo); if (prData == null) { SavePurchaseRegister(Purchase_Register_Data(invoice)); } return(true); }
private At Getatsdata(GST_TRN_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.IsInter == true ? "INTER" : "INTRA"; return(at); }
//public bool UpdateInvoiceDataItemFromPurchaseRegsiter(GST_TRN_INVOICE invoice) //{ // var prData = unitOfWork.PurchaseRegisterDataRepositry.Find(f => f.SupplierInvoiceNo == invoice.InvoiceNo); // if (prData != null) // { // foreach (GST_MST_PURCHASE_DATA data in prData.GST_MST_PURCHASE_DATA) // { // unitOfWork.PurchaseDataRepositry.Delete(data); // } // unitOfWork.Save(); // } // UpdatePurchaseData(invoice); // return true; //} private GST_MST_PURCHASE_REGISTER Purchase_Register_Data(GST_TRN_INVOICE invoice) { GST_MST_PURCHASE_REGISTER PR = new GST_MST_PURCHASE_REGISTER(); if (invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Import) { PR.SellerName = SellerName; //invoice.AspNetUser.OrganizationName; PR.SellerAddress = SellerAddress; //invoice.AspNetUser.Address; PR.SellerGSTN = SellerGSTN; //invoice.AspNetUser.GSTNNo; PR.ReceiverName = ReceiverName; //invoice.AspNetUser1.OrganizationName; PR.ReceiverAddress = ReceiverAddress; //invoice.AspNetUser1.Address; PR.ConsigneeName = ConsigneeName; //invoice.AspNetUser2.OrganizationName; PR.ConsigneeAddress = ConsigneeAddress; //invoice.AspNetUser2.Address; PR.StateCode = StateCode; } else { PR.SellerName = invoice.AspNetUser.OrganizationName; PR.SellerAddress = invoice.AspNetUser.Address; PR.SellerGSTN = invoice.AspNetUser.GSTNNo; PR.ReceiverName = invoice.AspNetUser1.OrganizationName; PR.ReceiverAddress = invoice.AspNetUser1.Address; PR.ConsigneeName = invoice.AspNetUser2.OrganizationName; PR.ConsigneeAddress = invoice.AspNetUser2.Address; PR.StateCode = Convert.ToString(invoice.AspNetUser.StateCode); } PR.UserID = LoggedinUserID; PR.StockInwardDate = DateTime.Now; PR.StockOrderDate = invoice.InvoiceDate; PR.OrderPo = null; //TODO PR.OrderPoDate = null; //TODO PR.SupplierInvoiceNo = invoice.InvoiceNo; PR.SupplierInvoiceDate = invoice.InvoiceDate; PR.SupplierInvoiceMonth = invoice.InvoiceMonth; PR.Freight = invoice.Freight; PR.Insurance = invoice.Insurance; PR.PackingAndForwadingCharges = invoice.PackingAndForwadingCharges; PR.ElectronicReferenceNo = invoice.ElectronicReferenceNo; PR.ElectronicReferenceNoDate = invoice.ElectronicReferenceNoDate; //PR.StateID = getinvocdtls. PR.PurchaseStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); PR.Status = true; PR.CreatedBy = invoice.CreatedBy; PR.CreatedDate = DateTime.Now; List <GST_MST_PURCHASE_DATA> data = new List <GST_MST_PURCHASE_DATA>(); foreach (GST_TRN_INVOICE_DATA invData in invoice.GST_TRN_INVOICE_DATA) { data.Add(PurchaseData(invData)); } PR.GST_MST_PURCHASE_DATA = data; return(PR); }
private void BindInvoice(GST_TRN_INVOICE invoice) { //List<GST_TRN_INVOICE> listInvoice = new List<GST_TRN_INVOICE>(); //listInvoice.Add(invoice); // fvInvoice.DataSource = listInvoice; //fvInvoice.DataBind(); //GridView gv = (GridView)fvInvoice.FindControl("gvItems"); gvInvoice_Items.DataSource = invoice.GST_TRN_INVOICE_DATA; gvInvoice_Items.DataBind(); lkbUpdateInvoice.Visible = true; }
public B2cl GetB2cl(GST_TRN_INVOICE b2clInvoice) { B2cl b2cldata = new B2cl(); b2cldata.inv = new List <Inv2>(); b2cldata.pos = b2clInvoice.AspNetUser.StateCode.ToString(); foreach (var data in b2clInvoice.GST_TRN_INVOICE_DATA) { b2cldata.inv.Add(GetInv2(data)); } return(b2cldata); }
//Test Methods private Txpd Gettxpdata(GST_TRN_INVOICE txpddata) { Txpd txpd = new Txpd(); txpd.pos = Convert.ToString(txpddata.TaxBenefitingState); txpd.sply_ty = txpddata.IsInter == true ? "INTER" : "INTRA"; foreach (var data in txpddata.GST_TRN_INVOICE_DATA) { txpd.itms.Add(GetItm7(data)); } return(txpd); }
public void BindInvoice(GST_TRN_INVOICE invoice) { try { gvInvoice_Items.DataSource = invoice.GST_TRN_INVOICE_DATA; gvInvoice_Items.DataBind(); lkbUpdateInvoice.Visible = true; }catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
private List <Itm4> GetItm4(GST_TRN_INVOICE atdata) { List <Itm4> itm4s = new List <Itm4>(); Itm4 itm4 = new Itm4(); foreach (var data in atdata.GST_TRN_INVOICE_DATA) { itm4.camt = (double?)data.CGSTAmt; itm4.csamt = (int?)data.CessAmt; itm4.iamt = (double?)data.IGSTAmt; itm4.rt = (int?)data.Rate; itm4.samt = (int?)data.SGSTAmt; itm4s.Add(itm4); } return(itm4s); }
private List <B2clAOutward> GetB2CLAJson(List <B2clAOutward> b2cl, GST_TRN_INVOICE invoice) { string b2cJson = string.Empty; B2clAOutward b2clItem = new B2clAOutward(); B2CLAInv inv = new B2CLAInv(); inv.inum = invoice.InvoiceNo; inv.idt = invoice.InvoiceDate.Value.ToString("dd-MM-yyyy"); inv.val = Convert.ToDouble(invoice.GST_TRN_INVOICE_DATA.Sum(s => s.TaxableAmount)); inv.pos = invoice.TaxBenefitingState; //inv.chksum = invoice. //inv.cname = GetNameFromGSTIN(invoice.ReceiverUserID); //inv.etin = //inv.itms = //inv.prs = //TODO:need to change and update according to count according to in invoice item. List <B2CLitem> lineItems = new List <B2CLitem>(); foreach (GST_TRN_INVOICE_DATA itm in invoice.GST_TRN_INVOICE_DATA) { B2CLitem invItem = new B2CLitem(); invItem.num = itm.LineID.Value; B2CLItmDet itemDetail = new B2CLItmDet(); itemDetail.irt = Convert.ToDouble(itm.Rate); itemDetail.txval = Convert.ToDouble(itm.TaxableAmount); itemDetail.iamt = Convert.ToDouble(itm.IGSTAmt); itemDetail.csamt = Convert.ToDouble(itm.CGSTAmt); itemDetail.cssrt = Convert.ToDouble(itm.CessRate); itemDetail.irt = Convert.ToDouble(itm.IGSTRate); itemDetail.hsn_sc = Convert.ToString(itm.Item_ID); //itemDetail.ty invItem.itm_det = itemDetail; lineItems.Add(invItem); } inv.itms = lineItems; List <B2CLAInv> invList = new List <B2CLAInv>(); invList.Add(inv); b2clItem.inv = invList; b2cl.Add(b2clItem); return(b2cl); }
private SaveGSTRData Savegstrdata(GST_TRN_INVOICE invoice) { SaveGSTRData gstrdata = new SaveGSTRData(); gstrdata.gstin = invoice.AspNetUser.GSTNNo; gstrdata.fp = Convert.ToString(invoice.FinYear_ID); gstrdata.gt = Convert.ToInt64(invoice.AspNetUser.GrossTurnOver); gstrdata.cur_gt = Convert.ToInt64(invoice.AspNetUser.GrossTurnOver); List <B2b> b2b = new List <B2b>(); foreach (var crData in invoice.GST_TRN_CRDR_NOTE) { b2b.Add(b2bData(crData)); } // gstrdata.B2b = b2b; return(gstrdata); }
/// <summary> /// Update purchase data items from invoice--check and update qty --done--when ACCEPT Condition by receiver--in mismatch GSTR2 /// </summary> /// <param name="invoice"></param> /// <returns></returns> public bool UpdatePurchaseDataItemFromInvoice(GST_TRN_INVOICE invoice) { List <GST_MST_PURCHASE_DATA> data = new List <GST_MST_PURCHASE_DATA>(); var prData = unitOfWork.PurchaseRegisterDataRepositry.Find(f => f.SupplierInvoiceNo == invoice.InvoiceNo); foreach (GST_MST_PURCHASE_DATA pData in prData.GST_MST_PURCHASE_DATA.ToList()) { unitOfWork.PurchaseDataRepositry.Delete(pData); } unitOfWork.Save(); foreach (GST_TRN_INVOICE_DATA invData in invoice.GST_TRN_INVOICE_DATA) { var item = PurchaseData(invData); item.PurchageRegisterID = prData.PurchageRegisterID; SavePurchaseRegister(item); } return(true); }
private List <Inv3> GetInv3(GST_TRN_INVOICE expdata) { List <Inv3> invs3 = new List <Inv3>(); Inv3 inv3; foreach (var dataitem in expdata.GST_TRN_INVOICE_DATA) { inv3 = new Inv3(); inv3.itms = new List <Itm3>(); inv3.idt = Convert.ToDateTime(dataitem.GST_TRN_INVOICE.InvoiceDate).ToString("dd-mm-yyyy"); inv3.inum = dataitem.GST_TRN_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.TotalAmountWithTax; invs3.Add(inv3); } return(invs3); }
private List <Inv> GetInv(GST_TRN_INVOICE B2B) { List <Inv> invs = new List <Inv>(); Inv inv; foreach (var dataitem in B2B.GST_TRN_INVOICE_DATA) { inv = new Inv(); inv.itms = new List <Itm>(); inv.idt = Convert.ToDateTime(dataitem.GST_TRN_INVOICE.InvoiceDate).ToString("dd-mm-yyyy"); inv.inum = dataitem.GST_TRN_INVOICE.InvoiceNo; inv.inv_typ = dataitem.GST_TRN_INVOICE.InvoiceType == null ? "" : ((EnumConstants.InvoiceType)dataitem.GST_TRN_INVOICE.InvoiceType).ToString()[0].ToString(); inv.itms.Add(GetItm(dataitem)); //inv.pos = dataitem..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.TotalAmountWithTax; invs.Add(inv); } return(invs); }
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); }
private List <B2bAOutward> GetB2BAJson(List <B2bAOutward> b2ba, GST_TRN_INVOICE invoice) { string b2bJson = string.Empty; B2bAOutward b2baItem = new B2bAOutward(); b2baItem.ctin = invoice.AspNetUser2.GSTNNo;//.ConsigneeUserID; B2BAInv inv = new B2BAInv(); inv.inum = invoice.InvoiceNo; inv.idt = invoice.InvoiceDate.Value.ToString("dd-MM-yyyy"); inv.val = Convert.ToDouble(invoice.GST_TRN_INVOICE_DATA.Sum(s => s.TaxableAmount)); inv.pos = invoice.TaxBenefitingState; inv.rchrg = "N"; //TODO:need to change inv.inv_typ = "R"; // //TODO:need to change and update according to count according to in invoice item. List <B2Bitem> lineItems = new List <B2Bitem>(); foreach (GST_TRN_INVOICE_DATA itm in invoice.GST_TRN_INVOICE_DATA) { B2Bitem invItem = new B2Bitem(); invItem.num = itm.LineID.Value; ItmDet itemDetail = new ItmDet(); itemDetail.rt = Convert.ToDouble(itm.Rate); itemDetail.txval = Convert.ToDouble(itm.TaxableAmount); itemDetail.iamt = Convert.ToDouble(itm.IGSTAmt); itemDetail.camt = Convert.ToDouble(itm.CGSTAmt); itemDetail.samt = Convert.ToDouble(itm.SGSTAmt); invItem.itm_det = itemDetail; lineItems.Add(invItem); } inv.itms = lineItems; List <B2BAInv> invList = new List <B2BAInv>(); invList.Add(inv); b2baItem.inv = invList; b2ba.Add(b2baItem); return(b2ba); }
/// <summary> /// /// </summary> /// <param name="invoice"></param> /// <param name="note"></param> /// <returns></returns> private GST_TRN_CRDR_NOTE RefectorNote(GST_TRN_INVOICE invoice) { GST_TRN_CRDR_NOTE item = new GST_TRN_CRDR_NOTE(); item.From_UserID = invoice.SellerUserID; item.To_UserID = invoice.ReceiverUserID; item.InvoiceID = invoice.InvoiceID; item.NoteTypeStatus = (byte)EnumConstants.NoteTypeStatus.Fresh; item.CDN_Date = DateTime.Now; item.NoteType = this.NoteType; item.Description = this.Description; string noteNo = ""; if ((EnumConstants.NoteType) this.NoteType == EnumConstants.NoteType.Credit) { noteNo = "CR" + UniqueNoGenerate.RandomValueNote(); } else if ((EnumConstants.NoteType) this.NoteType == EnumConstants.NoteType.Debit) { noteNo = "DR" + UniqueNoGenerate.RandomValueNote(); } else { noteNo = UniqueNoGenerate.RandomValueNote(); } item.NoteNumber = noteNo; item.CreatedBy = invoice.SellerUserID; item.CreatedDate = DateTime.Now; List <GST_TRN_CRDR_NOTE_DATA> data = new List <GST_TRN_CRDR_NOTE_DATA>(); foreach (GST_TRN_INVOICE_DATA invData in invoice.GST_TRN_INVOICE_DATA) { data.Add(ItemData(invData)); } item.GST_TRN_CRDR_NOTE_DATA = data; return(item); }
public override int SaveInvoiceData(Seller seller) { cls_Invoice invoiceObject = new cls_Invoice(); int result = 0; GST_TRN_INVOICE inv = new GST_TRN_INVOICE(); inv.InvoiceNo = seller.SellerInvoice; inv.InvoiceDate = DateTime.Now;//Convert.ToDateTime(seller.DateOfInvoice); inv.InvoiceMonth = Convert.ToByte(DateTime.Now.Month); // inv.InvoiceMonth = Convert.ToByte(DateTime.Now.Month); inv.SellerUserID = seller.SellerUserID; inv.ReceiverUserID = seller.Reciever.RecieveruserID; inv.ConsigneeUserID = seller.Consignee.ConsigneeUserID; inv.VendorID = seller.Invoice.VendorID; inv.TransShipment_ID = seller.Invoice.TransShipment_ID; inv.Freight = seller.Invoice.Freight; inv.Insurance = seller.Invoice.Insurance; inv.PackingAndForwadingCharges = seller.Invoice.PackingAndForwadingCharges; inv.FinYear_ID = invoiceObject.GetCurrentFinYear(); // Convert.ToInt32(DateTime.UtcNow.Year + "-" + DateTime.UtcNow.AddYears(1));//Convert.ToInt32(seller.SerialNoInvoice.FinancialYear); // inv.IsInter = seller.Reciever.StateCode == seller.Consignee.StateCode ? true : false; inv.ReceiverFinYear_ID = invoiceObject.GetCurrentFinYear(); // Convert.ToInt32(DateTime.UtcNow.Year + "-" + DateTime.UtcNow.AddYears(1));// Convert.ToInt32(seller.SerialNoInvoice.FinancialYear); inv.Status = true; inv.CreatedDate = DateTime.Now; inv.InvoiceStatus = (byte)EnumConstants.InvoiceStatus.Fresh; // inv.InvoiceStatus = (byte)EnumConstants.InvoiceStatus.Fresh; bool isInter = GetConsumptionDestinationOfGoodsOrServices(seller.SellerStateCode, seller.Reciever.StateCode, seller.Consignee.StateCode); inv.IsInter = isInter; inv.TaxBenefitingState = seller.Consignee.StateCode; inv.CreatedBy = seller.CreatedBy; //condition for tax con. //if ((EnumConstants.InvoiceSpecialCondition.Regular).ToString || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.Export) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.Advance) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.JobWork) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.SEZUnit) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.SEZDeveloper) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.DeemedExport) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.B2CS) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.B2CL) || Convert.ToBoolean(EnumConstants.InvoiceSpecialCondition.ECommerce)) if (seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.Regular.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.Export.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.Advance.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.JobWork.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.SEZDeveloper.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.SEZUnit.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.DeemedExport.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.B2CS.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.B2CL.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.ECommerce.ToString()) // if (seller.Invoice.InvoiceSpecialCondition == (EnumConstants.InvoiceSpecialCondition.Regular) || (EnumConstants.InvoiceSpecialCondition.Export) || (EnumConstants.InvoiceSpecialCondition.Advance).ToString() || (EnumConstants.InvoiceSpecialCondition.JobWork).ToString() || (EnumConstants.InvoiceSpecialCondition.SEZUnit).ToString() || (EnumConstants.InvoiceSpecialCondition.SEZDeveloper).ToString() || (EnumConstants.InvoiceSpecialCondition.DeemedExport).ToString() || (EnumConstants.InvoiceSpecialCondition.B2CS).ToString() || (EnumConstants.InvoiceSpecialCondition.B2CL).ToString() || (EnumConstants.InvoiceSpecialCondition.ECommerce).ToString()) { //inv.InvoiceUserID = seller.Reciever.RecieveruserID; inv.InvoiceUserID = seller.SellerUserID; } else { inv.InvoiceUserID = seller.Reciever.RecieveruserID; } inv.InvoiceType = (byte)(EnumConstants.InvoiceType)Enum.Parse(typeof(EnumConstants.InvoiceType), seller.Invoice.InvoiceType); if (inv.InvoiceType == (byte)EnumConstants.InvoiceType.B2C) { var totalBillamount = seller.Invoice.LineEntry.Sum(amt => amt.AmountWithTax); if (totalBillamount > 250000) { inv.InvoiceSpecialCondition = (byte)(EnumConstants.InvoiceSpecialCondition.B2CL); } else { inv.InvoiceSpecialCondition = (byte)(EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), seller.Invoice.InvoiceSpecialCondition); } } else { inv.InvoiceSpecialCondition = (byte)(EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), seller.Invoice.InvoiceSpecialCondition); } if (inv.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.ECommerce) { inv.OrderDate = seller.OrderDate; } var invoiceCreate = unitOfWork.InvoiceRepository.Create(inv); unitOfWork.Save(); if (seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.Export.ToString()) { bool isStateExampted = false; } else { bool isStateExampted = unitOfWork.StateRepository.Find(f => f.StateCode == seller.Consignee.StateCode).IsExempted.Value; } bool isExported = false; if (seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.Export.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.SEZDeveloper.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.SEZUnit.ToString() || seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.DeemedExport.ToString()) { isExported = true; } bool isJobwork = (seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.JobWork.ToString()); bool isImport = (seller.Invoice.InvoiceSpecialCondition == EnumConstants.InvoiceSpecialCondition.Import.ToString()); var stateData = unitOfWork.StateRepository.Find(c => c.StateCode == seller.SellerStateCode); var isUTState = stateData.UT.Value; var isExempted = stateData.IsExempted.Value; var isEcom = false; var isUn = false; var invLineItem = from invo in seller.Invoice.LineEntry select new GST_TRN_INVOICE_DATA { InvoiceID = invoiceCreate.InvoiceID, LineID = invo.LineID, // GST_MST_ITEM = invo.Item, Item_ID = invo.Item.Item_ID, Qty = invo.Qty, Rate = invo.PerUnitRate, TotalAmount = invo.TotalLineIDWise, Discount = invo.Discount, TaxableAmount = invo.TaxableValueLineIDWise, // TotalAmountWithTax = invo.TaxValue, IGSTRate = Calculate.TaxRate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.IGST, invo.TaxableValueLineIDWise, invo.Item.IGST.Value), //isJobwork ? 0 : (isUTState ? 0 : (isInter ? invo.Item.IGST : (isExport ? invo.Item.IGST : (isImport ? invo.Item.IGST : 0)))), IGSTAmt = Calculate.TaxCalculate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.IGST, invo.TaxableValueLineIDWise, invo.Item.IGST.Value), // isJobwork ? 0 : (isUTState ? 0 : (isInter ? Calculate.CalculateIGSTLineIDWise(invo.TaxableValueLineIDWise, invo.Item.IGST.Value) : (isExport ? Calculate.CalculateIGSTLineIDWise(invo.TaxableValueLineIDWise, invo.Item.IGST.Value) : (isImport ? Calculate.CalculateIGSTLineIDWise(invo.TaxableValueLineIDWise, invo.Item.IGST.Value) : 0)))), CGSTRate = Calculate.TaxRate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.CGST, invo.TaxableValueLineIDWise, invo.Item.CGST.Value), CGSTAmt = Calculate.TaxCalculate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.CGST, invo.TaxableValueLineIDWise, invo.Item.CGST.Value), SGSTRate = Calculate.TaxRate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.SGST, invo.TaxableValueLineIDWise, invo.Item.SGST.Value), SGSTAmt = Calculate.TaxCalculate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.SGST, invo.TaxableValueLineIDWise, invo.Item.SGST.Value), UGSTRate = Calculate.TaxRate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.UTGST, invo.TaxableValueLineIDWise, invo.Item.UGST.Value), UGSTAmt = Calculate.TaxCalculate(invo.Item, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.UTGST, invo.TaxableValueLineIDWise, invo.Item.UGST.Value), CessRate = isJobwork ? 0 : invo.Item.CESS, CessAmt = isJobwork ? 0 : Calculate.CalculateCESSLineIDWise(invo.TaxableValueLineIDWise, invo.Item.CESS.Value) }; foreach (GST_TRN_INVOICE_DATA item in invLineItem) { item.TotalAmountWithTax = item.TaxableAmount + item.IGSTAmt + item.CGSTAmt + item.SGSTAmt + item.UGSTAmt + item.CessAmt; item.CreatedDate = DateTime.Now; unitOfWork.InvoiceDataRepository.Create(item); } unitOfWork.Save(); //start- Mapp Regular and Jobwork Challan no. foreach (Int64 itm in seller.ChallanInvoiceIds) { GST_TRN_INVOICE_MAP map = new GST_TRN_INVOICE_MAP(); map.MapfromInvoiceID = itm; map.MaptoInvoiceID = invoiceCreate.InvoiceID; map.Status = true; map.CreatedBy = seller.CreatedBy; map.CreatedDate = DateTime.Now; unitOfWork.InvoiceMapRepository.Create(map); } unitOfWork.Save(); //end foreach (Int64 itm in seller.AdvanceInvoiceIds) { GST_TRN_INVOICE_MAP map = new GST_TRN_INVOICE_MAP(); map.MapfromInvoiceID = itm; map.MaptoInvoiceID = invoiceCreate.InvoiceID; map.Status = true; map.CreatedBy = seller.CreatedBy; map.CreatedDate = DateTime.Now; unitOfWork.InvoiceMapRepository.Create(map); } unitOfWork.Save(); cls_ITC itc = new cls_ITC(); itc.ITCVoucherType = (byte)EnumConstants.ITCVoucherType.TaxInvoice; itc.SaveItc(invoiceCreate); cls_PurchaseRegister purchaseRegister = new cls_PurchaseRegister(); //var allitems = invLineItem.Select(s => s.Item_ID).Distinct(); if (inv.InvoiceSpecialCondition == (byte)(EnumConstants.InvoiceSpecialCondition.Advance)) { //No data will be save in sale and purchase. } else if (inv.InvoiceSpecialCondition != (byte)(EnumConstants.InvoiceSpecialCondition.Import)) //enumm { foreach (GST_TRN_INVOICE_DATA item in invLineItem) { var itemType = unitOfWork.ItemRepository.Find(f => f.Item_ID == item.Item_ID).ItemType; // var purchaseItems = unitOfWork.PurchaseDataRepositry.Filter(f => f.Status == true && item.Item_ID == f.Item_ID).Select(s => s.GST_MST_PURCHASE_REGISTER.UserID).ToList(); if (itemType == (byte)EnumConstants.ItemType.HSN) { string uId = seller.SellerUserID; int iTem = Convert.ToInt32(item.Item_ID); decimal LeftQty = purchaseRegister.GetLeftItemQty(iTem, uId); if (LeftQty > item.Qty) { GST_MST_SALE_REGISTER salRegister = new GST_MST_SALE_REGISTER(); salRegister.InvoiceID = invoiceCreate.InvoiceID; salRegister.PerUnitRate = item.Rate; salRegister.Item_ID = item.Item_ID; salRegister.Qty = item.Qty; salRegister.CreatedBy = seller.CreatedBy; salRegister.CreatedDate = DateTime.Now; salRegister.Status = true; salRegister.Id = uId; salRegister.SaleStatus = (byte)EnumConstants.SaleStatus.Fresh; unitOfWork.SaleRegisterDataRepositry.Create(salRegister); unitOfWork.Save(); } } } } else { //Add stock in PURCHSE Reagister When item is import from seller.. purchaseRegister.LoggedinUserID = invoiceCreate.SellerUserID; purchaseRegister.SellerName = seller.NameAsOnGST; purchaseRegister.SellerAddress = seller.Address; purchaseRegister.SellerGSTN = seller.GSTIN; purchaseRegister.ReceiverName = seller.Reciever.NameAsOnGST; purchaseRegister.ReceiverAddress = seller.Reciever.Address; purchaseRegister.ConsigneeName = seller.Consignee.NameAsOnGST; purchaseRegister.ConsigneeAddress = seller.Consignee.Address; purchaseRegister.StateCode = seller.SellerStateCode; purchaseRegister.SaveInvoiveDataInPurchaseRegister(inv); } if (inv.InvoiceSpecialCondition == (byte)(EnumConstants.InvoiceSpecialCondition.SupplierMissingInvoice)) { GST_TRN_INVOICE_AUDIT_TRAIL IAT = new GST_TRN_INVOICE_AUDIT_TRAIL(); IAT.InvoiceID = invoiceCreate.InvoiceID; IAT.AuditTrailStatus = (byte)EnumConstants.InvoiceAuditTrailSatus.Import2A; IAT.InvoiceAction = (byte)EnumConstants.InvoiceActionAuditTrail.Add; IAT.UserIP = HelperUtility.IP; //IAT.SellerInvoiceAction = "" ; IAT.ReceiverInvoiceAction = (byte)EnumConstants.InvoiceActionAuditTrail.Add; // IAT.SellerInvoiceActionDate = DateTime.Now; IAT.ReceiverInvoiceActionDate = DateTime.Now; IAT.CreatedBy = invoiceCreate.CreatedBy; IAT.CreatedDate = DateTime.Now; unitOfWork.InvoiceAuditTrailRepositry.Create(IAT); unitOfWork.Save(); } //foreach (GST_TRN_INVOICE_DATA item in invLineItem) //{ // itc.UserID = seller.Reciever.RecieveruserID; // itc.Amount = item.IGSTAmt + item.CGSTAmt + item.SGSTAmt + item.UGSTAmt + item.CessAmt; //itc.InvoiceID = invoiceCreate.InvoiceID; // itc.ITCStatus = (byte)(EnumConstants.ITCStatus.Active); // itc.ITCVoucherType = (byte)EnumConstants.ITCMovement.Credit; // itc.ITCDate = DateTime.Now; // itc.ITCMovement = (byte)(EnumConstants.InvoiceSpecialCondition.Import); //// itc.TaxType = item.UGSTAmt; // itc.IGST = item.IGSTAmt; // itc.CGST = item.CGSTAmt; // if (item.SGSTAmt != 0) // { // itc.SGST = item.SGSTAmt; // } // else // { // itc.SGST = item.UGSTAmt; // } // itc.CreatedBy = seller.CreatedBy; // itc.CreatedDate = DateTime.Now; // unitOfWork.ITCRepository.Create(itc); // unitOfWork.Save(); //} //User Current TurnOver GST_MST_USER_CURRENT_TURNOVER turnOver = new GST_MST_USER_CURRENT_TURNOVER(); turnOver.User_ID = inv.SellerUserID; turnOver.Month = inv.InvoiceMonth; turnOver.InvoiceID = invoiceCreate.InvoiceID; turnOver.InvoiceAmountWithTax = invLineItem.Sum(s => s.TotalAmount); turnOver.InvoiceAmountWithoutTax = invLineItem.Sum(s => s.TaxableAmount); turnOver.TurnOverStatus = 0;//TODO:Need to change turnOver.CreatedBy = inv.CreatedBy; turnOver.CreatedDate = DateTime.Now; turnOver.Status = true; unitOfWork.CurrentTurnoverRepositry.Create(turnOver); unitOfWork.Save(); //// ExcelDB exceldb = new ExcelDB(); ////result = exceldb.SaveInvoiceData(seller); // } return(result); }
/// <summary> /// Receiver SIDE ITC ADD/UPDATE /// </summary> /// <param name="invoiceData"></param> /// <returns></returns> public bool SaveItcReceiver(GST_TRN_INVOICE invoiceData) { GST_TRN_ITC item = new GST_TRN_ITC(); item.Amount = invoiceData.GST_TRN_INVOICE_DATA.Sum(s => s.TotalAmountWithTax); item.IGST = invoiceData.GST_TRN_INVOICE_DATA.Sum(s => s.IGSTAmt); if (item.IGST > 0) { item.TaxType = (byte)EnumConstants.TaxType.IGST; } item.CGST = invoiceData.GST_TRN_INVOICE_DATA.Sum(s => s.CGSTAmt); if (item.CGST > 0) { item.TaxType = (byte)EnumConstants.TaxType.CGST; } item.SGST = invoiceData.GST_TRN_INVOICE_DATA.Sum(s => s.SGSTAmt); if (item.SGST > 0) { item.TaxType = (byte)EnumConstants.TaxType.SGST; } if (item.SGST.Value == 0) { item.TaxType = (byte)EnumConstants.TaxType.UTGST; item.SGST = invoiceData.GST_TRN_INVOICE_DATA.Sum(s => s.UGSTAmt); } item.Cess = invoiceData.GST_TRN_INVOICE_DATA.Sum(s => s.CessAmt); item.InvoiceID = invoiceData.InvoiceID; item.ITCStatus = (byte)EnumConstants.ITCStatus.Active; if (invoiceData.InvoiceSpecialCondition.Value == (byte)EnumConstants.InvoiceSpecialCondition.Import || invoiceData.InvoiceSpecialCondition.Value == (byte)EnumConstants.InvoiceSpecialCondition.ReverseCharges) { //item.UserID = invoiceData.ReceiverUserID; // item.ITCMovement = (byte)EnumConstants.ITCMovement.Debit; } else { item.UserID = invoiceData.ReceiverUserID; //item.ITCMovement = (byte)EnumConstants.ITCMovement.Credit; //item.UserID = invoiceData.ReceiverUserID; } if (invoiceData.ParentInvoiceID.HasValue) { item.ITCParentID = null; } item.ITCMovement = GetITCMovementReceiver(invoiceData.InvoiceSpecialCondition); item.ITCVoucherType = this.ITCVoucherType; item.ITCDate = DateTime.Now; item.CreatedDate = DateTime.Now; item.CreatedBy = invoiceData.CreatedBy; bool isSave = false; // if (invoiceData.InvoiceSpecialCondition != (byte)EnumConstants.InvoiceSpecialCondition.RegularRCM || invoiceData.InvoiceSpecialCondition.Value != (byte)EnumConstants.InvoiceSpecialCondition.JobWork) if (invoiceData.InvoiceSpecialCondition.Value == (byte)EnumConstants.InvoiceSpecialCondition.RegularRCM) { isSave = SaveITC(item); } else if (invoiceData.InvoiceSpecialCondition.Value == (byte)EnumConstants.InvoiceSpecialCondition.Regular) { isSave = SaveITC(item); } return(isSave); }
public B2b GetB2b(GST_TRN_INVOICE B2B) { return(new B2b { ctin = "tinno", inv = GetInv(B2B) }); }
private Exp GetExpData(GST_TRN_INVOICE expdata) { return(new Exp { exp_typ = "Wpay", inv = GetInv3(expdata) }); }
/// <summary> /// /// </summary> /// <param name="invoice"></param> /// <param name="note"></param> /// <returns></returns> public bool SaveNote(GST_TRN_INVOICE invoice) { SaveNote(RefectorNote(invoice)); return(true); }
protected void lkbUpdateInvoice_Click(object sender, EventArgs e) { try { // GridView gv = (GridView)fvInvoice.FindControl("gvItems"); List <GST_TRN_INVOICE_DATA> items = GetGVData(); //var it = Invoice; if (Invoice != null) { GST_TRN_INVOICE inv = new GST_TRN_INVOICE(); inv.InvoiceDate = DateTime.Now; inv.InvoiceMonth = Convert.ToByte(DateTime.Now.Month); //var totalInv=unitOfWork.InvoiceRepository.Filter(f => f.SellerUserID == Invoice.AspNetUser.Id).Count();// is //var CurrentSrlNo = totalInv + 1; //if (Invoice.ParentInvoiceID == null) //{ inv.InvoiceNo = Invoice.InvoiceNo;// UniqueNoGenerate.RandomValue();//InvoiceOperation.InvoiceNo(Invoice.AspNetUser, Invoice.FinYear_ID.ToString(), CurrentSrlNo.ToString()); // } inv.SellerUserID = Invoice.SellerUserID; inv.ReceiverUserID = Invoice.ReceiverUserID; inv.ConsigneeUserID = Invoice.ConsigneeUserID; inv.OrderDate = Invoice.OrderDate; inv.VendorID = Invoice.VendorID; inv.TransShipment_ID = Invoice.TransShipment_ID; inv.Freight = Invoice.Freight; inv.Insurance = Invoice.Insurance; inv.PackingAndForwadingCharges = Invoice.PackingAndForwadingCharges; inv.ElectronicReferenceNo = Invoice.ElectronicReferenceNo; inv.ElectronicReferenceNoDate = Invoice.ElectronicReferenceNoDate; inv.InvoiceType = Invoice.InvoiceType; inv.FinYear_ID = Invoice.FinYear_ID; inv.IsInter = Invoice.IsInter; inv.ReceiverFinYear_ID = Invoice.ReceiverFinYear_ID; // inv.ParentInvoiceID = Invoice.InvoiceID; inv.TaxBenefitingState = Invoice.AspNetUser2.StateCode; inv.Status = true; // var invoicePeriod=unitOfWork.FinYearRepository.Find(f=>f.Fin_ID== Invoice.FinYear_ID).Finyear_Format; // GST_TRN_INVOICE updateInvoice = new GST_TRN_INVOICE(); inv.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); inv.InvoiceSpecialCondition = Invoice.InvoiceSpecialCondition; inv.CreatedDate = DateTime.Now; inv.UpdatedDate = DateTime.Now; inv.CreatedBy = Common.LoggedInUserID(); inv.UpdatedBy = Common.LoggedInUserID(); cls_PurchaseRegister insertPurchaseRegsiter = new cls_PurchaseRegister(); insertPurchaseRegsiter.LoggedinUserID = Common.LoggedInUserID(); //-------------End-------- // bool isInter =InvoiceOperation.GetConsumptionDestinationOfGoodsOrServices(Invoice.AspNetUser.StateCode, Invoice.AspNetUser2.StateCode, Invoice.AspNetUser1.StateCode); bool isInter = Invoice.IsInter.Value; bool isStateExampted = unitOfWork.StateRepository.Find(f => f.StateCode == Invoice.AspNetUser2.StateCode).IsExempted.Value; // bool isExport = (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Export || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.SEZDeveloper || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.SEZUnit || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.DeemedExport); bool isExported = false; if (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Export || (byte)Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.SEZDeveloper || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.SEZUnit || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.DeemedExport) { isExported = true; } bool isJobwork = (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.JobWork); bool isImport = (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Import); var stateData = unitOfWork.StateRepository.Find(c => c.StateCode == Invoice.AspNetUser.StateCode); var isUTState = stateData.UT.Value; var isExempted = stateData.IsExempted.Value; var isEcom = false; var isUn = false; var invLineItem = from invo in items select new GST_TRN_INVOICE_DATA { // InvoiceID = invoiceCreate.InvoiceID, InvoiceDataID = invo.InvoiceDataID, LineID = invo.LineID, // GST_MST_ITEM = invo.Item, Item_ID = invo.GST_MST_ITEM.Item_ID, Qty = invo.Qty, Rate = invo.Rate, TotalAmount = invo.TotalAmount, Discount = invo.Discount, TaxableAmount = invo.TaxableAmount, IGSTRate = Calculate.TaxRate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.IGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.IGST.Value), //isJobwork ? 0 : (isUTState ? 0 : (isInter ? invo.Item.IGST : (isExport ? invo.Item.IGST : (isImport ? invo.Item.IGST : 0)))), IGSTAmt = Calculate.TaxCalculate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.IGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.IGST.Value), // isJobwork ? 0 : (isUTState ? 0 : (isInter ? Calculate.CalculateIGSTLineIDWise(invo.TaxableValueLineIDWise, invo.Item.IGST.Value) : (isExport ? Calculate.CalculateIGSTLineIDWise(invo.TaxableValueLineIDWise, invo.Item.IGST.Value) : (isImport ? Calculate.CalculateIGSTLineIDWise(invo.TaxableValueLineIDWise, invo.Item.IGST.Value) : 0)))), CGSTRate = Calculate.TaxRate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.CGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.CGST.Value), CGSTAmt = Calculate.TaxCalculate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.CGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.CGST.Value), SGSTRate = Calculate.TaxRate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.SGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.SGST.Value), SGSTAmt = Calculate.TaxCalculate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.SGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.SGST.Value), UGSTRate = Calculate.TaxRate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.UTGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.UGST.Value), UGSTAmt = Calculate.TaxCalculate(invo.GST_MST_ITEM, isInter, isExported, isImport, isUTState, isJobwork, isEcom, isUn, EnumConstants.TaxType.UTGST, invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.UGST.Value), CessRate = isJobwork ? 0 : invo.GST_MST_ITEM.CESS, CessAmt = isJobwork ? 0 : Calculate.CalculateCESSLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.CESS.Value) //TotalAmountWithTax = invo.TaxableAmount + IGSTAmt, }; bool invoiceHasParent = Invoice.ParentInvoiceID != null ? true : false; if (!invoiceHasParent) { //Update old invoice status that is A or M---------------Start------------- if (Invoice.InvoiceMonth == (byte)DateTime.Now.Month) { var oldInvoice = unitOfWork.InvoiceRepository.Find(f => f.InvoiceID == Invoice.InvoiceID); oldInvoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Amended); // Invoice.InvoiceID = updateInvoice.InvoiceID; var invoiceUpdate = unitOfWork.InvoiceRepository.Update(oldInvoice); unitOfWork.Save(); } else { var oldInvoice = unitOfWork.InvoiceRepository.Find(f => f.InvoiceID == Invoice.InvoiceID); oldInvoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Modified); // updateInvoice.InvoiceID = updateInvoice.InvoiceID; var invoiceUpdate = unitOfWork.InvoiceRepository.Update(oldInvoice); unitOfWork.Save(); } inv.ParentInvoiceID = Invoice.InvoiceID; var invoiceCreate = unitOfWork.InvoiceRepository.Create(inv); unitOfWork.Save(); foreach (GST_TRN_INVOICE_DATA item in invLineItem) { item.InvoiceID = invoiceCreate.InvoiceID; item.TotalAmountWithTax = item.TaxableAmount + item.IGSTAmt + item.CGSTAmt + item.SGSTAmt + item.UGSTAmt + item.CessAmt; unitOfWork.InvoiceDataRepository.Create(item); } unitOfWork.Save(); invoiceItem.AutoCorrectInvoice(invoiceCreate.InvoiceID); bool isSave = insertPurchaseRegsiter.UpdatePurchaseDataItemFromInvoice(inv); GST_TRN_INVOICE_AUDIT_TRAIL auditStatus = new GST_TRN_INVOICE_AUDIT_TRAIL(); auditStatus.InvoiceID = invoiceCreate.InvoiceID; auditStatus.AuditTrailStatus = (byte)EnumConstants.InvoiceAuditTrailSatus.Import2A; auditStatus.InvoiceAction = (byte)EnumConstants.InvoiceActionAuditTrail.Modify; auditStatus.ReceiverInvoiceAction = (byte)EnumConstants.InvoiceActionAuditTrail.Modify; auditStatus.ReceiverInvoiceActionDate = DateTime.Now; // auditStatus.CreatedDate = DateTime.Now; auditStatus.CreatedBy = Common.LoggedInUserID(); unitOfWork.InvoiceAuditTrailRepositry.Create(auditStatus); unitOfWork.Save(); } else { foreach (GST_TRN_INVOICE_DATA item in invLineItem) { // item.InvoiceDataID = invp item.InvoiceID = Invoice.InvoiceID; item.TotalAmountWithTax = item.TaxableAmount + item.IGSTAmt + item.CGSTAmt + item.SGSTAmt + item.UGSTAmt + item.CessAmt; item.CreatedDate = DateTime.Now; unitOfWork.InvoiceDataRepository.Update(item); } unitOfWork.Save(); invoiceItem.AutoCorrectInvoice(Invoice.InvoiceID); bool isSave = insertPurchaseRegsiter.UpdatePurchaseDataItemFromInvoice(Invoice); } gvInvoice_Items.DataSource = null; gvInvoice_Items.DataBind(); lkbUpdateInvoice.Visible = false; Invoice = new GST_TRN_INVOICE(); uc_sucess.SuccessMessage = "Data updated successfully."; if (!string.IsNullOrEmpty(EditFrom)) { if (EditFrom == "GSTR2") { cls_ITC itc = new cls_ITC(); itc.ITCVoucherType = (byte)EnumConstants.ITCVoucherType.Purchase; itc.SaveItcReceiver(inv); } } UpdateInvoiceClick(sender, e); } } catch (Exception ex) { cls_ErrorLog ob = new cls_ErrorLog(); cls_ErrorLog.LogError(ex, Common.LoggedInUserID()); } }
private GST_TRN_INVOICE GetInvoiceInformation(DataRow dataRow, string SupplierGSTIN, byte sheetCode, string UserId) { GST_TRN_INVOICE invoice = new GST_TRN_INVOICE(); try { cls_Invoice invoiceObject = new cls_Invoice(); //B2B if (sheetCode == 0) { var RecieverGSTIN = dataRow.Field <string>("Column0"); var GstnExit = unitOfWork.AspnetRepository.Filter(w => w.GSTNNo == RecieverGSTIN).FirstOrDefault(); invoice.InvoiceNo = dataRow.ItemArray[1].ToString().Contains('.') ? dataRow.ItemArray[1].ToString().Split('.')[0] : dataRow.ItemArray[1].ToString(); invoice.InvoiceDate = dataRow.Field <DateTime>("Column2"); invoice.InvoiceMonth = (byte)invoice.InvoiceDate.Value.Month; invoice.SellerUserID = FindUserId(SupplierGSTIN); invoice.ReceiverUserID = FindUserId(dataRow.Field <string>("Column0")); var ConsigneeUserId = FindUserId(dataRow.Field <string>("Column7")); invoice.ConsigneeUserID = ConsigneeUserId == null ? invoice.ReceiverUserID : ConsigneeUserId; invoice.OrderDate = dataRow.Field <DateTime>("Column2").Date; //invoice.VendorID = invoice.Freight = Convert.ToInt32(dataRow.ItemArray[13].ToString().Split('.')[0]); invoice.Insurance = Convert.ToInt32(dataRow.ItemArray[14].ToString().Split('.')[0]); invoice.PackingAndForwadingCharges = Convert.ToInt32(dataRow.ItemArray[15].ToString().Split('.')[0]); //invoice. = //invoice.ElectronicReferenceNoDate = invoice.InvoiceType = sheetCode; invoice.FinYear_ID = invoiceObject.GetCurrentFinYear(); string getIsinter = GstnExit == null ? "" : GstnExit.GSTNNo; string strStatecode = getIsinter.Substring(0, 2); string Statecod = GstnExit == null ? "" : GstnExit.StateCode; if (strStatecode == Statecod) { invoice.IsInter = false; } else { invoice.IsInter = true; } invoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); // invoice.TaxBenefitingState = invoice.Status = true; EnumConstants.InvoiceSpecialCondition value = (EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), dataRow.ItemArray[6].ToString()); invoice.InvoiceSpecialCondition = (byte)value; } //B2CL else if (sheetCode == 1) { var RecieverGSTIN = dataRow.ItemArray[14].ToString().Contains('.') ? dataRow.ItemArray[14].ToString().Split('.')[0] : dataRow.ItemArray[14].ToString(); var GstnExit = unitOfWork.AspnetRepository.Filter(w => w.GSTNNo == RecieverGSTIN).FirstOrDefault(); invoice.InvoiceNo = dataRow.ItemArray[0].ToString().Contains('.') ? dataRow.ItemArray[0].ToString().Split('.')[0] : dataRow.ItemArray[0].ToString(); invoice.InvoiceDate = dataRow.Field <DateTime>("Column1"); invoice.InvoiceMonth = (byte)invoice.InvoiceDate.Value.Month; invoice.SellerUserID = FindUserId(SupplierGSTIN); invoice.ReceiverUserID = FindUserId(RecieverGSTIN); var ConsigneeUserId = FindUserId(dataRow.Field <string>("Column7")); invoice.ConsigneeUserID = ConsigneeUserId == null ? invoice.ReceiverUserID : ConsigneeUserId; invoice.Freight = Convert.ToInt32(dataRow.ItemArray[10].ToString().Split('.')[0]); invoice.Insurance = Convert.ToInt32(dataRow.ItemArray[11].ToString().Split('.')[0]); invoice.PackingAndForwadingCharges = Convert.ToInt32(dataRow.ItemArray[12].ToString().Split('.')[0]); invoice.InvoiceType = sheetCode; invoice.FinYear_ID = invoiceObject.GetCurrentFinYear(); string getIsinter = GstnExit == null ? "" : GstnExit.GSTNNo; string strStatecode = getIsinter.Substring(0, 2); string Statecod = GstnExit == null ? "" : GstnExit.StateCode; if (strStatecode == Statecod) { invoice.IsInter = false; } else { invoice.IsInter = true; } invoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); invoice.Status = true; EnumConstants.InvoiceSpecialCondition value = (EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), dataRow.ItemArray[6].ToString()); invoice.InvoiceSpecialCondition = (byte)value; } //B2CS else if (sheetCode == 2) { var RecieverGSTIN = dataRow.ItemArray[12].ToString().Contains('.') ? dataRow.ItemArray[12].ToString().Split('.')[0] : dataRow.ItemArray[12].ToString(); var GstnExit = unitOfWork.AspnetRepository.Filter(w => w.GSTNNo == RecieverGSTIN).FirstOrDefault(); invoice.InvoiceNo = dataRow.ItemArray[0].ToString().Contains('.') ? dataRow.ItemArray[0].ToString().Split('.')[0] : dataRow.ItemArray[0].ToString(); invoice.SellerUserID = FindUserId(SupplierGSTIN); invoice.ReceiverUserID = FindUserId(RecieverGSTIN); var ConsigneeUserId = FindUserId(dataRow.Field <string>("Column5")); invoice.ConsigneeUserID = ConsigneeUserId == null ? invoice.ReceiverUserID : ConsigneeUserId; invoice.Freight = Convert.ToInt32(dataRow.ItemArray[8].ToString().Split('.')[0]); invoice.Insurance = Convert.ToInt32(dataRow.ItemArray[9].ToString().Split('.')[0]); invoice.PackingAndForwadingCharges = Convert.ToInt32(dataRow.ItemArray[10].ToString().Split('.')[0]); invoice.InvoiceType = 1; invoice.FinYear_ID = invoiceObject.GetCurrentFinYear(); string getIsinter = GstnExit == null ? "" : GstnExit.GSTNNo; string strStatecode = getIsinter.Substring(0, 2); string Statecod = GstnExit == null ? "" : GstnExit.StateCode; if (strStatecode == Statecod) { invoice.IsInter = false; } else { invoice.IsInter = true; } invoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); invoice.Status = true; EnumConstants.InvoiceSpecialCondition value = (EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), dataRow.ItemArray[6].ToString()); invoice.InvoiceSpecialCondition = (byte)value; } //CDNR else if (sheetCode == 3) { var RecieverGSTIN = dataRow.Field <string>("Column0"); var GstnExit = unitOfWork.AspnetRepository.Filter(w => w.GSTNNo == RecieverGSTIN).FirstOrDefault(); invoice.InvoiceNo = dataRow.ItemArray[1].ToString().Contains('.') ? dataRow.ItemArray[1].ToString().Split('.')[0] : dataRow.ItemArray[1].ToString(); invoice.InvoiceDate = dataRow.Field <DateTime>("Column4"); invoice.InvoiceMonth = (byte)invoice.InvoiceDate.Value.Month; invoice.SellerUserID = FindUserId(SupplierGSTIN); invoice.ReceiverUserID = FindUserId(dataRow.Field <string>("Column0")); invoice.OrderDate = dataRow.Field <DateTime>("Column2").Date; invoice.Freight = Convert.ToInt32(dataRow.ItemArray[14].ToString().Split('.')[0]); invoice.Insurance = Convert.ToInt32(dataRow.ItemArray[15].ToString().Split('.')[0]); invoice.PackingAndForwadingCharges = Convert.ToInt32(dataRow.ItemArray[16].ToString().Split('.')[0]); invoice.FinYear_ID = invoiceObject.GetCurrentFinYear(); string getIsinter = GstnExit == null ? "" : GstnExit.GSTNNo; string strStatecode = getIsinter.Substring(0, 2); string Statecod = GstnExit == null ? "" : GstnExit.StateCode; if (strStatecode == Statecod) { invoice.IsInter = false; } else { invoice.IsInter = true; } invoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); invoice.Status = true; } //CDNUR else if (sheetCode == 4) { var RecieverGSTIN = dataRow.ItemArray[19].ToString(); var GstnExit = unitOfWork.AspnetRepository.Filter(w => w.GSTNNo == RecieverGSTIN).FirstOrDefault(); invoice.InvoiceNo = dataRow.ItemArray[4].ToString().Contains('.') ? dataRow.ItemArray[4].ToString().Split('.')[0] : dataRow.ItemArray[4].ToString(); invoice.InvoiceDate = dataRow.Field <DateTime>("Column5"); invoice.InvoiceMonth = (byte)invoice.InvoiceDate.Value.Month; invoice.SellerUserID = FindUserId(SupplierGSTIN); invoice.ReceiverUserID = FindUserId(dataRow.ItemArray[19].ToString()); invoice.OrderDate = dataRow.Field <DateTime>("Column2").Date; invoice.Freight = Convert.ToInt32(dataRow.ItemArray[14].ToString().Split('.')[0]); invoice.Insurance = Convert.ToInt32(dataRow.ItemArray[15].ToString().Split('.')[0]); invoice.PackingAndForwadingCharges = Convert.ToInt32(dataRow.ItemArray[16].ToString().Split('.')[0]); invoice.FinYear_ID = invoiceObject.GetCurrentFinYear(); string getIsinter = GstnExit == null ? "" : GstnExit.GSTNNo; string strStatecode = getIsinter.Substring(0, 2); string Statecod = GstnExit == null ? "" : GstnExit.StateCode; if (strStatecode == Statecod) { invoice.IsInter = false; } else { invoice.IsInter = true; } invoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); invoice.Status = true; EnumConstants.InvoiceSpecialCondition value = (EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), dataRow.ItemArray[1].ToString()); invoice.InvoiceSpecialCondition = (byte)value; } //EXP else if (sheetCode == 5) { var RecieverGSTIN = dataRow.ItemArray[8].ToString().Contains('.') ? dataRow.ItemArray[8].ToString().Split('.')[0] : dataRow.ItemArray[8].ToString(); var GstnExit = unitOfWork.AspnetRepository.Filter(w => w.GSTNNo == RecieverGSTIN).FirstOrDefault(); invoice.InvoiceNo = dataRow.ItemArray[1].ToString().Contains('.') ? dataRow.ItemArray[1].ToString().Split('.')[0] : dataRow.ItemArray[1].ToString(); invoice.InvoiceDate = dataRow.Field <DateTime>("Column2"); invoice.InvoiceMonth = (byte)invoice.InvoiceDate.Value.Month; invoice.SellerUserID = FindUserId(SupplierGSTIN); invoice.ReceiverUserID = FindUserId(RecieverGSTIN); invoice.OrderDate = dataRow.Field <DateTime>("Column2").Date; //invoice.VendorID = //invoice.Freight = Convert.ToInt32(dataRow.ItemArray[14].ToString().Split('.')[0]); //invoice.Insurance = Convert.ToInt32(dataRow.ItemArray[15].ToString().Split('.')[0]); //invoice.PackingAndForwadingCharges = Convert.ToInt32(dataRow.ItemArray[16].ToString().Split('.')[0]); ////invoice. = //invoice.ElectronicReferenceNoDate = invoice.InvoiceType = 0; invoice.FinYear_ID = invoiceObject.GetCurrentFinYear(); string getIsinter = GstnExit == null ? "" : GstnExit.GSTNNo; string strStatecode = getIsinter.Substring(0, 2); string Statecod = GstnExit == null ? "" : GstnExit.StateCode; if (strStatecode == Statecod) { invoice.IsInter = false; } else { invoice.IsInter = true; } invoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); // invoice.TaxBenefitingState = invoice.Status = true; EnumConstants.InvoiceSpecialCondition value = (EnumConstants.InvoiceSpecialCondition)Enum.Parse(typeof(EnumConstants.InvoiceSpecialCondition), dataRow.ItemArray[1].ToString()); invoice.InvoiceSpecialCondition = (byte)value; } invoice.CreatedBy = UserId; invoice.CreatedDate = DateTime.Now; unitOfWork.InvoiceRepository.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); }
protected void lkbUpdateInvoice_Click(object sender, EventArgs e) { try { // GridView gv = (GridView)fvInvoice.FindControl("gvItems"); List <GST_TRN_INVOICE_DATA> items = GetGVData(); //var it = Invoice; if (Invoice != null) { //Seller seller = new Seller(); GST_TRN_INVOICE inv = new GST_TRN_INVOICE(); inv.InvoiceDate = DateTime.Now; inv.InvoiceMonth = Convert.ToByte(DateTime.Now.Month); var CurrentSrlNo = unitOfWork.InvoiceRepository.Filter(f => f.SellerUserID == Invoice.AspNetUser.Id).Count() + 1; inv.InvoiceNo = InvoiceOperation.InvoiceNo(Invoice.AspNetUser, Invoice.FinYear_ID.ToString(), CurrentSrlNo.ToString()); inv.SellerUserID = Invoice.SellerUserID; inv.ReceiverUserID = Invoice.ReceiverUserID; inv.ConsigneeUserID = Invoice.ConsigneeUserID; inv.OrderDate = Invoice.OrderDate; inv.VendorID = Invoice.VendorID; inv.TransShipment_ID = Invoice.TransShipment_ID; inv.Freight = Invoice.Freight; inv.Insurance = Invoice.Insurance; inv.PackingAndForwadingCharges = Invoice.PackingAndForwadingCharges; inv.ElectronicReferenceNo = Invoice.ElectronicReferenceNo; inv.ElectronicReferenceNoDate = Invoice.ElectronicReferenceNoDate; inv.InvoiceType = Invoice.InvoiceType; inv.FinYear_ID = Invoice.FinYear_ID; inv.IsInter = Invoice.IsInter; inv.ReceiverFinYear_ID = Invoice.ReceiverFinYear_ID; inv.ParentInvoiceID = Invoice.InvoiceID; inv.TaxBenefitingState = Invoice.AspNetUser2.StateCode; inv.Status = true; // var invoicePeriod=unitOfWork.FinYearRepository.Find(f=>f.Fin_ID== Invoice.FinYear_ID).Finyear_Format; // GST_TRN_INVOICE updateInvoice = new GST_TRN_INVOICE(); inv.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Fresh); inv.InvoiceSpecialCondition = Invoice.InvoiceSpecialCondition; inv.CreatedDate = DateTime.Now; inv.UpdatedDate = DateTime.Now; inv.CreatedBy = Common.LoggedInUserID(); inv.UpdatedBy = Common.LoggedInUserID(); var invoiceCreate = unitOfWork.InvoiceRepository.Create(inv); unitOfWork.Save(); //Update old invoice status that is A or M---------------Start------------- if (Invoice.InvoiceMonth == (byte)DateTime.Now.Month) { var oldInvoice = unitOfWork.InvoiceRepository.Find(f => f.InvoiceID == Invoice.InvoiceID); oldInvoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Amended); // Invoice.InvoiceID = updateInvoice.InvoiceID; var invoiceUpdate = unitOfWork.InvoiceRepository.Update(oldInvoice); unitOfWork.Save(); } else { var oldInvoice = unitOfWork.InvoiceRepository.Find(f => f.InvoiceID == Invoice.InvoiceID); oldInvoice.InvoiceStatus = Convert.ToByte(EnumConstants.InvoiceStatus.Modified); // updateInvoice.InvoiceID = updateInvoice.InvoiceID; var invoiceUpdate = unitOfWork.InvoiceRepository.Update(oldInvoice); unitOfWork.Save(); } //-------------End-------- // bool isInter =InvoiceOperation.GetConsumptionDestinationOfGoodsOrServices(Invoice.AspNetUser.StateCode, Invoice.AspNetUser2.StateCode, Invoice.AspNetUser1.StateCode); bool isInter = Invoice.IsInter.Value; bool isStateExampted = unitOfWork.StateRepository.Find(f => f.StateCode == Invoice.AspNetUser2.StateCode).IsExempted.Value; bool isExport = (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Export || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.SEZDeveloper || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.SEZUnit || Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.DeemedExport); bool isJobwork = (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.JobWork); bool isImport = (Invoice.InvoiceSpecialCondition == (byte)EnumConstants.InvoiceSpecialCondition.Import); var stateData = unitOfWork.StateRepository.Find(c => c.StateCode == Invoice.AspNetUser.StateCode); var isUTState = stateData.UT.Value; var isExempted = stateData.IsExempted.Value; var invLineItem = from invo in items select new GST_TRN_INVOICE_DATA { InvoiceID = invoiceCreate.InvoiceID, LineID = invo.LineID, // GST_MST_ITEM = invo.Item, Item_ID = invo.GST_MST_ITEM.Item_ID, Qty = invo.Qty, Rate = invo.Rate, TotalAmount = invo.TotalAmount, Discount = invo.Discount, TaxableAmount = invo.TaxableAmount, IGSTRate = isJobwork ? 0 : (isUTState ? 0 : (isInter ? 0 : (isExport ? invo.GST_MST_ITEM.IGST : (isImport ? invo.GST_MST_ITEM.IGST : 0)))), IGSTAmt = isJobwork ? 0 : (isUTState ? 0 : (isInter ? 0 : (isExport ? Calculate.CalculateIGSTLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.IGST.Value) : (isImport ? Calculate.CalculateIGSTLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.IGST.Value) : 0)))), CGSTRate = isJobwork ? 0 : (isUTState ? 0 : (isInter ? (isExport ? 0 : invo.GST_MST_ITEM.CGST) : 0)), CGSTAmt = isJobwork ? 0 : (isUTState ? 0 : (isInter ? (isExport ? 0 : Calculate.CalculateCGSTLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.CGST.Value)) : 0)), SGSTRate = isJobwork ? 0 : (isUTState ? 0 : (isInter ? 0 : (isExport ? 0 : invo.GST_MST_ITEM.SGST))), SGSTAmt = isJobwork ? 0 : (isUTState ? 0 : (isInter ? 0 : (isExport ? 0 : Calculate.CalculateSGSTLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.SGST.Value)))), UGSTRate = isJobwork ? 0 : (isExport ? 0 : (isUTState ? invo.GST_MST_ITEM.UGST.Value : 0)), UGSTAmt = isJobwork ? 0 : (isExport ? 0 : (isUTState ? Calculate.CalculateUGSTLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.UGST.Value) : 0)), CessRate = isJobwork ? 0 : invo.GST_MST_ITEM.CESS, CessAmt = isJobwork ? 0 : Calculate.CalculateCESSLineIDWise(invo.TaxableAmount.HasValue ? invo.TaxableAmount.Value : 0, invo.GST_MST_ITEM.CESS.Value) //TotalAmountWithTax = invo.TaxableAmount + IGSTAmt, }; foreach (GST_TRN_INVOICE_DATA item in invLineItem) { item.TotalAmountWithTax = item.TaxableAmount + item.IGSTAmt + item.CGSTAmt + item.SGSTAmt + item.UGSTAmt + item.CessAmt; unitOfWork.InvoiceDataRepository.Create(item); } unitOfWork.Save(); gvInvoice_Items.DataSource = null; gvInvoice_Items.DataBind(); lkbUpdateInvoice.Visible = false; Invoice = new GST_TRN_INVOICE(); this.Master.SuccessMessage = "Data updated successfully."; //uc_sucess.Visible = true; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "viewInvoiceModelSucessMessage", "$('#viewInvoiceModelSucessMessage').modal();", true); } } catch (Exception ex) { } }
private void BindInvoice(GST_TRN_INVOICE invoice) { gvInvoice_Edit.DataSource = invoice.GST_TRN_INVOICE_DATA; gvInvoice_Edit.DataBind(); }