public void UpdateDebitNote(DebitNoteForm debitNote) { try { using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities()) { DebitNote obj = entities.DebitNotes.Where(e => e.DN_No == debitNote.DebitNote.DebitNo ).SingleOrDefault(); if (obj != null) { if (!string.IsNullOrEmpty(debitNote.DebitNote.SupplierCreditNoteAmount)) { debitNote.DebitNote.SCNAmount = Convert.ToDecimal(debitNote.DebitNote.SupplierCreditNoteAmount); } obj.Sup_CN_No = debitNote.DebitNote.SupplierCreditNoteNo; obj.Sup_CN_Date = debitNote.DebitNote.SupplierCreditNoteDate; obj.Sup_CN_Amount = debitNote.DebitNote.SCNAmount; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public void UpdateDebitNote(DebitNoteForm debitNote) { try { IDebitNoteDAL debitNoteDAL = new DebitNoteDAL(); debitNoteDAL.UpdateDebitNote(debitNote); } catch (Exception ex) { throw ex; } }
public void CollectMoneyFromSupplier(object param) { MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { Mouse.OverrideCursor = Cursors.Wait; PQErrors = string.Empty; DebitNoteForm PQForm = GetDataIntoModel(); if (PQForm != null) { dnRepository.UpdateDebitNote(PQForm); } if (param != null) { SharedValues.NewClick = param.ToString(); } SharedValues.ScreenCheckName = "Refund to Supplier"; SharedValues.ViewName = "Refund From Supplier"; var accessitem = listitem.AddToList(); if (accessitem == true) { SharedValues.getValue = "RefundFromSupplierTab"; SharedValues.CollectCommand = Convert.ToString(this.SelectedSupplierID); var tabview = ServiceLocator.Current.GetInstance <CashBankTabView>(); var tabregion = this.regionManager.Regions[RegionNames.MenuBarRegion]; tabregion.Add(tabview); if (tabregion != null) { tabregion.Activate(tabview); } var mainview = ServiceLocator.Current.GetInstance <RefundFromSupplierView>(); var mainregion = this.regionManager.Regions[RegionNames.MainRegion]; mainregion.Add(mainview); if (mainregion != null) { mainregion.Activate(mainview); } eventAggregator.GetEvent <TabVisibilityEvent>().Publish(true); eventAggregator.GetEvent <TitleChangedEvent>().Publish("Refund From Supplier Form"); } else { MessageBox.Show("You do not have access to this screen. Please contact your Administrator.\n" + "@ Simple Accounting Software Pte Ltd"); } Mouse.OverrideCursor = null; } }
public void GetDebitNote(object param) { if (param != null) { DebitNoteForm pqf = dnRepository.GetDebitNoteDetails(Convert.ToString(param)); this.ID = pqf.DebitNote.ID; this.DebitNo = pqf.DebitNote.DebitNo; this.DebitDate = pqf.DebitNote.DebitDate; this.SupplierCreditNoteNo = pqf.DebitNote.SupplierCreditNoteNo; this.SupplierCreditNoteDate = pqf.DebitNote.SupplierCreditNoteDate; this.SupplierCreditNoteAmount = pqf.DebitNote.SupplierCreditNoteAmount; this.SelectedSupplierID = pqf.DebitNote.SupplierID; this.PurchaseInvoiceID = pqf.DebitNote.PurchaseInvoiceID; this.PurchaseInvoiceNo = pqf.DebitNote.PurchaseInvoiceNo; this.TermsAndConditions = pqf.DebitNote.TermsAndConditions; this.TotalBeforeTax = pqf.DebitNote.TotalBeforeTax; this.TotalTax = pqf.DebitNote.TotalTax; this.TotalAfterTax = pqf.DebitNote.TotalAfterTax; this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); this.Status = pqf.DebitNote.Status; this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.InvoiceDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PINo); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces); pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%"; pqEntity.PQQty = item.PIQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = Math.Round((decimal)item.PIDiscount, 2); // PQDEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.PIAmount; PQDetailsEntity.Add(pqEntity); } } }
public DebitNoteForm GetDataIntoModel() { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); DebitNoteForm PQForm = new DebitNoteForm(); PQForm.InvoiceDetails = new List <PurchaseInvoiceDetailEntity>(); DebitNoteEntity model = new DebitNoteEntity(); model.DebitNo = this.DebitNo; model.DebitDate = this.DebitDate; model.TotalBeforeTax = this.TotalBeforeTax; model.TotalTax = this.TotalTax; model.TotalAfterTax = this.TotalAfterTax; model.SupplierCreditNoteNo = this.SupplierCreditNoteNo; model.SupplierCreditNoteDate = DateTime.ParseExact(this.SupplierCreditNoteDateStr, oData.DateFormat, null); model.SupplierCreditNoteAmount = this.SupplierCreditNoteAmount; model.SupplierID = this.SelectedSupplierID; model.TermsAndConditions = this.TermsAndConditions; PQForm.DebitNote = model; foreach (var item in PQDetailsEntity) { PurchaseInvoiceDetailEntity pqEntity = new PurchaseInvoiceDetailEntity(); pqEntity.PINo = Convert.ToString(item.SelectedPSID); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.PIQty = item.PQQty; pqEntity.PIPrice = item.PQPrice; pqEntity.PIDiscount = item.PQDiscount; pqEntity.GSTRate = item.GSTRate; pqEntity.GSTRateStr = Convert.ToString(item.GSTRate) + "%"; pqEntity.PIAmount = item.PQAmount; if (item.SelectedPSID != null && Convert.ToInt32(item.SelectedPSID) > 0) { PQForm.InvoiceDetails.Add(pqEntity); } } return(PQForm); }
/// <summary> /// This method is used to save and edit pq /// </summary> /// <param name="param"></param> public void UpdateDebitNote(object param) { MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { Mouse.OverrideCursor = Cursors.Wait; PQErrors = string.Empty; DebitNoteForm PQForm = GetDataIntoModel(); if (PQForm != null) { dnRepository.UpdateDebitNote(PQForm); } Mouse.OverrideCursor = null; } }
public void CollectMoneyFromSupplier(object param) { MessageBoxResult result = System.Windows.MessageBox.Show("Do you want to save changes?", "Save Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { Mouse.OverrideCursor = Cursors.Wait; PQErrors = string.Empty; DebitNoteForm PQForm = GetDataIntoModel(); if (PQForm != null) { dnRepository.UpdateDebitNote(PQForm); } if (param != null) { SharedValues.NewClick = param.ToString(); } SharedValues.getValue = "RefundFromSupplierTab"; SharedValues.CollectCommand = Convert.ToString(this.SelectedSupplierID); var tabview = ServiceLocator.Current.GetInstance <SDN.Common.View.CashAndBankTabView>(); var tabregion = this.regionManager.Regions[RegionNames.MenuBarRegion]; tabregion.Add(tabview); if (tabregion != null) { tabregion.Activate(tabview); } var mainview = ServiceLocator.Current.GetInstance <RefundFromSupplierView>(); var mainregion = this.regionManager.Regions[RegionNames.MainRegion]; mainregion.Add(mainview); if (mainregion != null) { mainregion.Activate(mainview); } eventAggregator.GetEvent <TabVisibilityEvent>().Publish(true); eventAggregator.GetEvent <TitleChangedEvent>().Publish("Refund From Supplier Form"); Mouse.OverrideCursor = null; } }
public DebitNoteForm GetDataIntoModel() { DebitNoteForm PQForm = new DebitNoteForm(); PQForm.InvoiceDetails = new List <PurchaseInvoiceDetailEntity>(); DebitNoteEntity model = new DebitNoteEntity(); model.DebitNo = this.DebitNo; model.DebitDate = this.DebitDate; model.TotalBeforeTax = this.TotalBeforeTax; model.TotalTax = this.TotalTax; model.TotalAfterTax = this.TotalAfterTax; model.SupplierCreditNoteNo = this.SupplierCreditNoteNo; model.SupplierCreditNoteDate = this.SupplierCreditNoteDate; model.SupplierCreditNoteAmount = this.SupplierCreditNoteAmount; model.SupplierID = this.SelectedSupplierID; model.TermsAndConditions = this.TermsAndConditions; PQForm.DebitNote = model; foreach (var item in PQDetailsEntity) { PurchaseInvoiceDetailEntity pqEntity = new PurchaseInvoiceDetailEntity(); pqEntity.PINo = Convert.ToString(item.SelectedPSID); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.PIQty = item.PQQty; pqEntity.PIPrice = item.PQPrice; pqEntity.PIDiscount = Math.Round((decimal)item.PQDiscount, 2); pqEntity.GSTRate = item.GSTRate; pqEntity.GSTRateStr = Convert.ToString(item.GSTRate) + "%"; pqEntity.PIAmount = item.PQAmount; if (item.SelectedPSID != null && Convert.ToInt32(item.SelectedPSID) > 0) { PQForm.InvoiceDetails.Add(pqEntity); } } return(PQForm); }
public void GetDebitNote(object param) { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); if (param != null) { DebitNoteForm pqf = dnRepository.GetDebitNoteDetails(Convert.ToString(param)); this.ID = pqf.DebitNote.ID; this.DebitNo = pqf.DebitNote.DebitNo; this.DebitDate = pqf.DebitNote.DebitDate; this.SupplierCreditNoteNo = pqf.DebitNote.SupplierCreditNoteNo; if (SupplierCreditNoteDate == null) { this.SupplierCreditNoteDate = pqf.DebitNote.SupplierCreditNoteDate; } else { DateTime DateinStr = (DateTime)pqf.DebitNote.SupplierCreditNoteDate; this.SupplierCreditNoteDateStr = DateinStr.ToString(oData.DateFormat); } this.SupplierCreditNoteAmount = pqf.DebitNote.SupplierCreditNoteAmount; this.SelectedSupplierID = pqf.DebitNote.SupplierID; this.PurchaseInvoiceID = pqf.DebitNote.PurchaseInvoiceID; this.PurchaseInvoiceNo = pqf.DebitNote.PurchaseInvoiceNo; this.TermsAndConditions = pqf.DebitNote.TermsAndConditions; this.TotalBeforeTax = Convert.ToDecimal(pqf.DebitNote.TotalBeforeTax); this.TotalTax = Convert.ToDecimal(pqf.DebitNote.TotalTax); this.TotalAfterTax = Convert.ToDecimal(pqf.DebitNote.TotalAfterTax); this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); this.Status = pqf.DebitNote.Status; if (this.Status == 1) { RubberStampDN = true; } else { RubberStampDN = false; } this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.InvoiceDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PINo); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces); pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%"; pqEntity.PQQty = item.PIQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = item.PIDiscount; // PQDEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.PIAmount; PQDetailsEntity.Add(pqEntity); } } }
private void UserControl_LoadedDebitNote(object sender, RoutedEventArgs e) { //var a = _viewModel.PrintSalesQuotation(); DebitNoteForm sqf = _ViewModel.PrintDebitNote(); // System.Drawing.Image newImage = byteArrayToImage(sqf.Quotation.CompanyLogo); // System.Drawing.Image x = (Bitmap)((new ImageConverter()).ConvertFrom(sqf.Quotation.CompanyLogo)); //this is for table grid DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("PandSCode", typeof(string))); dt.Columns.Add(new DataColumn("PandSName", typeof(string))); dt.Columns.Add(new DataColumn("PIQty", typeof(string))); dt.Columns.Add(new DataColumn("Price", typeof(string))); dt.Columns.Add(new DataColumn("PIDiscount", typeof(string))); dt.Columns.Add(new DataColumn("PIAmount", typeof(string))); dt.Columns.Add(new DataColumn("GSTRate", typeof(string))); //ReportingDataset ds = new ReportingDataset(); foreach (var item in sqf.InvoiceDetails) { DataRow dr = dt.NewRow(); dr["PandSCode"] = item.PandSCode; dr["PandSName"] = item.PandSName; dr["PIQty"] = item.PIQty; dr["Price"] = item.Price.ToString(); dr["PIDiscount"] = item.PIDiscount; dr["PIAmount"] = item.PIAmount.ToString(); dr["GSTRate"] = item.GSTRate.ToString(); dt.Rows.Add(dr); } ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "DebitNoteDataSet"; // Name of the DataSet we set in .rdlc reportDataSource.Value = dt; // company details /*****Define column*****/ DataTable dt1 = new DataTable(); dt1.Columns.Add(new DataColumn("CompanyName", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyLogo", typeof(byte[]))); dt1.Columns.Add(new DataColumn("CompanyRegNumber", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyGstNumber", typeof(string))); dt1.Columns.Add(new DataColumn("Telephone", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyFax", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyEmail", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyBillToAddressLine1", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyBillToAddressLine2", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyBillToCity", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyBillToState", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyBillToCountary", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyBillToPostCode", typeof(string))); /*****End column*****/ /*****data part*******/ DataRow dr1 = dt1.NewRow(); dr1["CompanyName"] = sqf.DebitNote.CompanyName; dr1["CompanyLogo"] = sqf.DebitNote.CompanyLogo; dr1["CompanyRegNumber"] = sqf.DebitNote.CompanyRegNumber; dr1["CompanyGstNumber"] = sqf.DebitNote.CompanyGstNumber; dr1["Telephone"] = sqf.DebitNote.Telephone; dr1["CompanyFax"] = sqf.DebitNote.CompanyFax; dr1["CompanyEmail"] = sqf.DebitNote.CompanyEmail; dr1["CompanyBillToAddressLine1"] = sqf.DebitNote.CompanyBillToAddressLine1; dr1["CompanyBillToAddressLine2"] = sqf.DebitNote.CompanyBillToAddressLine2; dr1["CompanyBillToCity"] = sqf.DebitNote.CompanyBillToCity; dr1["CompanyBillToState"] = sqf.DebitNote.CompanyBillToState; dr1["CompanyBillToCountary"] = sqf.DebitNote.CompanyBillToCountary; dr1["CompanyBillToPostCode"] = sqf.DebitNote.CompanyBillToPostCode; dt1.Rows.Add(dr1); /*****data part*******/ ReportDataSource reportDataSource1 = new ReportDataSource(); reportDataSource1.Name = "CompanyDetailDataSet"; // Name of the DataSet we set in .rdlc reportDataSource1.Value = dt1; // end of company details //Customer Details /****column defn**/ DataTable dt2 = new DataTable(); dt2.Columns.Add(new DataColumn("SupplierName", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierBillToLine1", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierBillToLine2", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierBillToCity", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierBillToState", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierBillToCountary", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierBillToPostCode", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierTelephone", typeof(string))); dt2.Columns.Add(new DataColumn("TermsAndConditions", typeof(string))); dt2.Columns.Add(new DataColumn("TotalBeforeTax", typeof(string))); dt2.Columns.Add(new DataColumn("TotalTax", typeof(string))); dt2.Columns.Add(new DataColumn("TotalAfterTax", typeof(string))); dt2.Columns.Add(new DataColumn("DebitNo", typeof(string))); dt2.Columns.Add(new DataColumn("DebitDate", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierCreditNoteNo", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierCreditNoteDate", typeof(string))); dt2.Columns.Add(new DataColumn("SupplierCreditNoteAmount", typeof(string))); /****end column defn**/ /**data****/ DataRow dr2 = dt2.NewRow(); dr2["SupplierName"] = sqf.DebitNote.SupplierName; dr2["SupplierBillToLine1"] = sqf.DebitNote.SupplierBillToLine1; dr2["SupplierBillToLine2"] = sqf.DebitNote.SupplierBillToLine2; dr2["SupplierBillToCity"] = sqf.DebitNote.SupplierBillToCity; dr2["SupplierBillToState"] = sqf.DebitNote.SupplierBillToState; dr2["SupplierBillToCountary"] = sqf.DebitNote.SupplierBillToCountary; dr2["SupplierBillToPostCode"] = sqf.DebitNote.SupplierBillToPostCode; dr2["SupplierTelephone"] = sqf.DebitNote.SupplierTelephone; dr2["TermsAndConditions"] = sqf.DebitNote.TermsAndConditions; dr2["TotalBeforeTax"] = sqf.DebitNote.TotalAfterTax; dr2["TotalTax"] = sqf.DebitNote.TotalTax.ToString(); dr2["TotalAfterTax"] = sqf.DebitNote.TotalAfterTax.ToString(); dr2["DebitNo"] = sqf.DebitNote.DebitNo; dr2["DebitDate"] = sqf.DebitNote.DebitDate; dr2["SupplierCreditNoteNo"] = sqf.DebitNote.SupplierCreditNoteNo; dr2["SupplierCreditNoteDate"] = sqf.DebitNote.SupplierCreditNoteDate; dr2["SupplierCreditNoteAmount"] = sqf.DebitNote.SupplierCreditNoteAmount; /**end data****/ dt2.Rows.Add(dr2); ReportDataSource reportDataSource2 = new ReportDataSource(); reportDataSource2.Name = "DebitNoteUniqueRecordDataSet"; // Name of the DataSet we set in .rdlc reportDataSource2.Value = dt2; //End Customer Details //option DataTable dt3 = new DataTable(); dt3.Columns.Add(new DataColumn("CurrencyCode", typeof(string))); DataRow dr3 = dt3.NewRow(); dr3["CurrencyCode"] = sqf.DebitNote.CurrencyCode; dt3.Rows.Add(dr3); ReportDataSource reportDataSource3 = new ReportDataSource(); reportDataSource3.Name = "OptionDataSet"; // Name of the DataSet we set in .rdlc reportDataSource3.Value = dt3; //end options string exefolder = System.Windows.Forms.Application.StartupPath; string reportPath = System.IO.Path.Combine(exefolder, @"DebitNote.rdlc"); reportViewer4.LocalReport.ReportPath = reportPath; //D:\DayUser\src\SAS - NEW\Client\SASClient\Reports\ReportsRdlc reportViewer4.LocalReport.DataSources.Clear(); reportViewer4.LocalReport.DataSources.Add(reportDataSource); reportViewer4.LocalReport.DataSources.Add(reportDataSource1); reportViewer4.LocalReport.DataSources.Add(reportDataSource2); reportViewer4.LocalReport.DataSources.Add(reportDataSource3); reportViewer4.RefreshReport(); // this.reportViewer1.Width = 75; }
/// <summary> /// This method is used to get Purchase Invoice details /// </summary> /// <param name="pqId"></param> /// <returns></returns> public DebitNoteForm GetDebitNoteDetails(string dnNo) { DebitNoteForm pqf = new DebitNoteForm(); try { using (SDNPurchasingDBEntities entities = new SDNPurchasingDBEntities()) { var pq = (from pqs in entities.PurchaseInvoices join dn in entities.DebitNotes on pqs.ID equals dn.PI_Id where dn.DN_No == dnNo && (pqs.IsDeleted == false || pqs.IsDeleted == null) select new DebitNoteEntity { ID = dn.ID, SupplierCreditNoteNo = dn.Sup_CN_No, SupplierCreditNoteDate = dn.Sup_CN_Date, SCNAmount = dn.Sup_CN_Amount, SupplierID = pqs.Sup_Id, DebitNo = dn.DN_No, DebitDate = dn.DN_Date, TermsAndConditions = dn.DN_Reason, TotalBeforeTax = pqs.PI_Tot_bef_Tax, TotalTax = pqs.PI_GST_Amt, TotalAfterTax = pqs.PI_Tot_aft_Tax, ExcIncGST = pqs.Exc_Inc_GST, PurchaseInvoiceNo = pqs.PI_No, PurchaseInvoiceID = pqs.ID, Status = dn.DN_Status }).SingleOrDefault(); if (pq != null) { pq.SupplierCreditNoteAmount = Convert.ToString(pq.SCNAmount); pqf.DebitNote = pq; } var pqd = (from pqds in entities.PurchaseInvoiceDetails where pqds.PI_ID == pq.PurchaseInvoiceID select new PurchaseInvoiceDetailEntity { ID = pqds.ID, PIID = pqds.PI_ID, PINo = pqds.PI_No, PandSCode = pqds.PandS_Code, PandSName = pqds.PandS_Name, PIQty = pqds.PI_Qty, Price = pqds.PI_Price, PIDiscount = pqds.PI_Discount, PIAmount = pqds.PI_Amount, GSTRate = pqds.GST_Rate }).ToList <PurchaseInvoiceDetailEntity>(); if (pqd != null) { pqf.InvoiceDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }
public DebitNoteForm GetPrintDebitNote(string pqNo) { DebitNoteForm pqf = new DebitNoteForm(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var pq = (from pqs in entities.PurchaseInvoices join dn in entities.DebitNotes on pqs.ID equals dn.PI_Id join S in entities.Suppliers on dn.Sup_Id equals S.ID where dn.DN_No == pqNo && (pqs.IsDeleted == false || pqs.IsDeleted == null) select new DebitNoteEntity { ID = dn.ID, SupplierCreditNoteNo = dn.Sup_CN_No, SupplierCreditNoteDate = dn.Sup_CN_Date, SCNAmount = dn.Sup_CN_Amount, SupplierID = pqs.Sup_Id, SupplierName = S.Sup_Name, SupplierBillToLine1 = S.Sup_Bill_to_line1, SupplierBillToLine2 = S.Sup_Bill_to_line2, SupplierBillToCity = S.Sup_Bill_to_city, SupplierBillToState = S.Sup_Bill_to_state, SupplierBillToCountary = S.Sup_Bill_to_country, SupplierBillToPostCode = S.Sup_Bill_to_post_code, SupplierTelephone = S.Sup_Telephone, DebitNo = dn.DN_No, DebitDate = dn.DN_Date, TermsAndConditions = dn.DN_Reason, TotalBeforeTax = pqs.PI_Tot_bef_Tax, TotalTax = pqs.PI_GST_Amt, TotalAfterTax = pqs.PI_Tot_aft_Tax, ExcIncGST = pqs.Exc_Inc_GST, PurchaseInvoiceNo = pqs.PI_No, PurchaseInvoiceID = pqs.ID, Status = dn.DN_Status }).SingleOrDefault(); if (pq != null) { pq.SupplierCreditNoteAmount = Convert.ToString(pq.SCNAmount); pqf.DebitNote = pq; } //company details binding data var company = (from com in entities.CompanyDetails where (com.IsDeleted == false || com.IsDeleted == null) select new DebitNoteEntity { CompanyName = com.Comp_Name, CompanyLogo = com.Comp_Logo, CompanyRegNumber = com.Comp_Reg_No, CompanyGstNumber = com.Comp_GST_Reg_No, CompanyBillToAddressLine1 = com.Comp_Bill_to_line1, CompanyBillToAddressLine2 = com.Comp_Bill_to_line2, CompanyBillToCity = com.Comp_Bill_to_city, CompanyBillToState = com.Comp_Bill_to_state, CompanyBillToCountary = com.Comp_Bill_to_country, CompanyBillToPostCode = com.Comp_Bill_to_post_code, CompanyEmail = com.Comp_Email, CompanyFax = com.Comp_Fax }).SingleOrDefault(); pqf.DebitNote.CompanyName = company.CompanyName; pqf.DebitNote.CompanyLogo = company.CompanyLogo; pqf.DebitNote.CompanyRegNumber = company.CompanyRegNumber; pqf.DebitNote.CompanyGstNumber = company.CompanyGstNumber; pqf.DebitNote.CompanyBillToAddressLine1 = company.CompanyBillToAddressLine1; pqf.DebitNote.CompanyBillToAddressLine2 = company.CompanyBillToAddressLine2; pqf.DebitNote.CompanyBillToCity = company.CompanyBillToCity; pqf.DebitNote.CompanyBillToState = company.CompanyBillToState; pqf.DebitNote.CompanyBillToCountary = company.CompanyBillToCountary; pqf.DebitNote.CompanyBillToPostCode = company.CompanyBillToPostCode; pqf.DebitNote.CompanyEmail = company.CompanyEmail; pqf.DebitNote.CompanyFax = company.CompanyFax; //end of company details binding //option details var optiondata = (from option in entities.Options select new DebitNoteEntity { CurrencyCode = option.Currency_Code }).SingleOrDefault(); pqf.DebitNote.CurrencyCode = optiondata.CurrencyCode; //end options details var pqd = (from pqds in entities.PurchaseInvoiceDetails where pqds.PI_ID == pq.PurchaseInvoiceID select new PurchaseInvoiceDetailEntity { ID = pqds.ID, PIID = pqds.PI_ID, PINo = pqds.PI_No, PandSCode = pqds.PandS_Code, PandSName = pqds.PandS_Name, PIQty = pqds.PI_Qty, Price = pqds.PI_Price, PIDiscount = pqds.PI_Discount, PIAmount = pqds.PI_Amount, GSTRate = pqds.GST_Rate }).ToList <PurchaseInvoiceDetailEntity>(); if (pqd != null) { pqf.InvoiceDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }