int IPurchaseQuotationRepository.AddUpdateQuotation(PurchaseQuotationForm quotationData) { IPurchaseQuotationBL pqBL = new PurchaseQuotationBL(); int i = pqBL.AddUpdateQuotation(quotationData); return(i); }
public PurchaseQuotationForm GetDataIntoModel() { PurchaseQuotationForm PQForm = new PurchaseQuotationForm(); PQForm.QuotationDetails = new List <PurchaseQuotationDetailEntity>(); PurchaseQuotationEntity model = new PurchaseQuotationEntity(); model.QuotationNo = this.QuotationNo; model.QuotationDate = this.QuotationDate; model.TotalBeforeTax = this.TotalBeforeTax; model.TotalTax = this.TotalTax; model.TotalAfterTax = this.TotalAfterTax; model.ValidForDays = this.ValidForDays; model.SupplierID = this.SelectedSupplierID; model.TermsAndConditions = this.TermsAndConditions; if (ExcludingTax == true) { model.ExcIncGST = false; } else { model.ExcIncGST = true; } PQForm.Quotation = model; foreach (var item in PQDetailsEntity) { PurchaseQuotationDetailEntity pqEntity = new PurchaseQuotationDetailEntity(); pqEntity.PQNo = Convert.ToString(item.SelectedPSID); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.PQQty = item.PQQty; pqEntity.PQPrice = item.PQPrice; pqEntity.PQDiscount = item.PQDiscount; pqEntity.GSTRate = item.GSTRate; pqEntity.GSTRateStr = Convert.ToString(item.GSTRate) + "%"; pqEntity.PQAmount = item.PQAmount; if (item.SelectedPSID != null && Convert.ToInt32(item.SelectedPSID) > 0) { PQForm.QuotationDetails.Add(pqEntity); } } return(PQForm); }
public void ConvertToPurchaseInvoice(object param) { Mouse.OverrideCursor = Cursors.Wait; if (this.PQ_Conv_to_PI == false || this.PQ_Conv_to_PI == null) { PurchaseQuotationForm PQForm = GetDataIntoModel(); int i = pqRepository.ConvertToPurchaseInvoice(PQForm); if (i > 0) { this.PQ_Conv_to_PI = true; AllFieldsReadonly = true; AllFieldsEnabled = false; SupplierEnabled = false; } } else { PQErrors = "Already converted to Purchase Invoice"; } Mouse.OverrideCursor = null; }
/// <summary> /// This method is used to save and edit pq /// </summary> /// <param name="param"></param> public void SavePurchaseQuotation(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; string msg = ValidatePurchaseQuotation(); if (msg != string.Empty) { PQErrors = msg; Mouse.OverrideCursor = null; return; } PQErrors = string.Empty; PurchaseQuotationForm PQForm = GetDataIntoModel(); int i = 0; if (IsNew == true) { i = pqRepository.AddUpdateQuotation(PQForm); } else { i = pqRepository.UpdationQuotation(PQForm); } if (i > 0) { // GetNewPQ(); IsNew = false; SupplierEnabled = false; } Mouse.OverrideCursor = null; } }
public int ConvertToPurchaseOrder(PurchaseQuotationForm pqForm) { IPurchaseQuotationDAL PQDAL = new PurchaseQuotationDAL(); return(PQDAL.ConvertToPurchaseOrder(pqForm)); }
public int UpdationQuotation(PurchaseQuotationForm quotationData) { IPurchaseQuotationDAL PQDAL = new PurchaseQuotationDAL(); return(PQDAL.UpdationQuotation(quotationData)); }
public PurchaseQuotationForm GetPrintPurchaseQuotation(string pqno) { PurchaseQuotationForm pqf = new PurchaseQuotationForm(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var pq = (from pqs in entities.PurchaseQuotations join Sup in entities.Suppliers on pqs.Sup_Id equals Sup.ID where pqs.PQ_No == pqno && (pqs.IsDeleted == false || pqs.IsDeleted == null) select new PurchaseQuotationEntity { ID = pqs.ID, SupplierID = pqs.Sup_Id, SupplierName = Sup.Sup_Name, SupplierBillAddress1 = Sup.Sup_Bill_to_line1, SupplierBillAddress2 = Sup.Sup_Bill_to_line2, SupplierBillAddressCity = Sup.Sup_Bill_to_city, SupplierBillAddressState = Sup.Sup_Bill_to_state, SupplierBillAddressCountary = Sup.Sup_Bill_to_country, SupplierBillPostCode = Sup.Sup_Bill_to_post_code, SupplierTelephone = Sup.Sup_Telephone, QuotationNo = pqs.PQ_No, QuotationDate = pqs.PQ_Date, ValidForDays = pqs.PQ_Valid_for, TermsAndConditions = pqs.PQ_TandC, TotalBeforeTax = pqs.PQ_Tot_bef_Tax, TotalTax = pqs.PQ_GST_Amt, TotalAfterTax = pqs.PQ_Tot_aft_Tax }).SingleOrDefault(); if (pq != null) { pqf.Quotation = pq; } //for comapany details var company = (from com in entities.CompanyDetails where (com.IsDeleted == false || com.IsDeleted == null) select new PurchaseQuotationEntity { CompanyName = com.Comp_Name, CompanyRegNumber = com.Comp_Reg_No, CompanyLogo = com.Comp_Logo, 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, CompanyShipToAddressLine1 = com.Comp_Ship_to_line1, CompanyShipToAddressLine2 = com.Comp_Ship_to_line2, CompanyShipToCity = com.Comp_Ship_to_city, CompanyShipToState = com.Comp_Ship_to_state, CompanyShipToCountary = com.Comp_Ship_to_country, CompanyShipToPostCode = com.Comp_Ship_to_post_code, CompanyEmail = com.Comp_Email, CompanyFax = com.Comp_Fax }).SingleOrDefault(); pqf.Quotation.CompanyName = company.CompanyName; pqf.Quotation.CompanyLogo = company.CompanyLogo; pqf.Quotation.CompanyRegNumber = company.CompanyRegNumber; pqf.Quotation.CompanyGstNumber = company.CompanyGstNumber; pqf.Quotation.CompanyBillToAddressLine1 = company.CompanyBillToAddressLine1; pqf.Quotation.CompanyBillToAddressLine2 = company.CompanyBillToAddressLine2; pqf.Quotation.CompanyBillToCity = company.CompanyBillToCity; pqf.Quotation.CompanyBillToState = company.CompanyBillToState; pqf.Quotation.CompanyBillToCountary = company.CompanyBillToCountary; pqf.Quotation.CompanyBillToPostCode = company.CompanyBillToPostCode; pqf.Quotation.CompanyShipToAddressLine1 = company.CompanyShipToAddressLine1; pqf.Quotation.CompanyShipToAddressLine2 = company.CompanyShipToAddressLine2; pqf.Quotation.CompanyShipToCity = company.CompanyShipToCity; pqf.Quotation.CompanyShipToState = company.CompanyShipToState; pqf.Quotation.CompanyShipToCountary = company.CompanyShipToCountary; pqf.Quotation.CompanyShipToPostCode = company.CompanyShipToPostCode; pqf.Quotation.CompanyEmail = company.CompanyEmail; pqf.Quotation.CompanyFax = company.CompanyFax; //end for comapany details //option details var optiondata = (from option in entities.Options select new PurchaseQuotationEntity { CurrencyCode = option.Currency_Code }).SingleOrDefault(); pqf.Quotation.CurrencyCode = optiondata.CurrencyCode; //end options details var pqd = (from pqds in entities.PurchaseQuotationDetails where pqds.PQ_ID == pq.ID select new PurchaseQuotationDetailEntity { ID = pqds.ID, PQID = pqds.PQ_ID, PQNo = pqds.PQ_No, PandSCode = pqds.PandS_Code, PandSName = pqds.PandS_Name, PQQty = pqds.PQ_Qty, Price = pqds.PQ_Price, PQDiscount = pqds.PQ_Discount, PQAmount = pqds.PQ_Amount, GSTRate = pqds.GST_Rate }).ToList <PurchaseQuotationDetailEntity>(); if (pqd != null) { pqf.QuotationDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }
/// <summary> /// This method is used to get Purchase Quotation details /// </summary> /// <param name="pqId"></param> /// <returns></returns> public PurchaseQuotationForm GetPurchaseQuotation(string pqno) { PurchaseQuotationForm pqf = new PurchaseQuotationForm(); try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { var pq = (from pqs in entities.PurchaseQuotations where pqs.PQ_No == pqno && (pqs.IsDeleted == false || pqs.IsDeleted == null) select new PurchaseQuotationEntity { ID = pqs.ID, SupplierID = pqs.Sup_Id, QuotationNo = pqs.PQ_No, QuotationDate = pqs.PQ_Date, ValidForDays = pqs.PQ_Valid_for, TermsAndConditions = pqs.PQ_TandC, TotalBeforeTax = pqs.PQ_Tot_bef_Tax, TotalTax = pqs.PQ_GST_Amt, TotalAfterTax = pqs.PQ_Tot_aft_Tax, ExcIncGST = pqs.Exc_Inc_GST, PQ_Conv_to_PI = pqs.PQ_Conv_to_PI, PQ_Conv_to_PO = pqs.PQ_Conv_to_PO }).FirstOrDefault(); if (pq != null) { pqf.Quotation = pq; } var pqd = (from pqds in entities.PurchaseQuotationDetails where pqds.PQ_ID == pq.ID select new PurchaseQuotationDetailEntity { ID = pqds.ID, PQID = pqds.PQ_ID, PQNo = pqds.PQ_No, PandSCode = pqds.PandS_Code, PandSName = pqds.PandS_Name, PQQty = pqds.PQ_Qty, Price = pqds.PQ_Price, PQDiscount = pqds.PQ_Discount, PQAmount = pqds.PQ_Amount, GSTRate = pqds.GST_Rate }).ToList <PurchaseQuotationDetailEntity>(); if (pqd != null) { pqf.QuotationDetails = pqd; } return(pqf); } } catch (Exception ex) { throw ex; } }
/// <summary> /// This method is used to convert the Purchase quotation to order /// </summary> /// <param name="quotationData"></param> /// <returns></returns> public int ConvertToPurchaseOrder(PurchaseQuotationForm quotationData) { int autoId = 0; PurchaseOrder obj = new PurchaseOrder(); //obj.ID = quotationData.Quotation.ID; obj.Sup_Id = quotationData.Quotation.SupplierID; obj.PO_Date = quotationData.Quotation.QuotationDate; obj.PO_Del_Date = DateTime.Now; obj.PO_GST_Amt = Convert.ToDecimal(quotationData.Quotation.TotalTax); obj.PO_No = "PO-" + (GetLastOrderNo() + 1); obj.PO_TandC = quotationData.Quotation.TermsAndConditions; obj.PO_Tot_aft_Tax = Convert.ToDecimal(quotationData.Quotation.TotalAfterTax); obj.PO_Tot_bef_Tax = Convert.ToDecimal(quotationData.Quotation.TotalBeforeTax); obj.PO_Status = Convert.ToByte(PO_Status.unDeposited); obj.Exc_Inc_GST = quotationData.Quotation.ExcIncGST; obj.IsDeleted = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { if (entities.PurchaseOrders.AsNoTracking().FirstOrDefault(x => x.ID == quotationData.Quotation.ID) == null) { //obj.CreatedBy = quotationData.PQModel.CreatedBy; obj.CreatedDate = DateTime.Now; entities.PurchaseOrders.Add(obj); entities.SaveChanges(); autoId = obj.ID; } else { // obj.ModifiedBy = quotationData.PQModel.ModifiedBy; obj.ModifiedDate = DateTime.Now; entities.Entry(obj).State = EntityState.Modified; autoId = entities.SaveChanges(); } if (autoId > 0) { PurchaseOrderDetail PQDetails; if (quotationData.QuotationDetails != null) { foreach (PurchaseQuotationDetailEntity PQDetailEntity in quotationData.QuotationDetails) { PQDetails = new PurchaseOrderDetail(); PQDetails.PO_ID = autoId; PQDetails.PO_No = PQDetailEntity.PQNo; PQDetails.PandS_Code = PQDetailEntity.PandSCode; PQDetails.PandS_Name = PQDetailEntity.PandSName; PQDetails.PO_Amount = PQDetailEntity.PQAmount; PQDetails.PO_Discount = PQDetailEntity.PQDiscount; PQDetails.PO_No = PQDetailEntity.PQNo; PQDetails.PO_Price = Convert.ToDecimal(PQDetailEntity.PQPrice); PQDetails.PO_Qty = PQDetailEntity.PQQty; PQDetails.GST_Code = PQDetailEntity.GSTCode; PQDetails.GST_Rate = PQDetailEntity.GSTRate; if (entities.PurchaseOrderDetails.AsNoTracking().FirstOrDefault(x => x.ID == PQDetailEntity.ID) == null) { entities.PurchaseOrderDetails.Add(PQDetails); entities.SaveChanges(); } else { entities.Entry(PQDetails).State = EntityState.Modified; entities.SaveChanges(); } } } PurchaseQuotation objQ = entities.PurchaseQuotations.Where(e => e.PQ_No == quotationData.Quotation.QuotationNo ).SingleOrDefault(); if (objQ != null) { objQ.PQ_Conv_to_PO = true; objQ.Conv_to_No = obj.PO_No; objQ.ModifiedDate = DateTime.Now; entities.SaveChanges(); } } } return(autoId); } catch (Exception ex) { throw ex; } }
/// <summary> /// This method is used to add or edit purchase quotation /// </summary> /// <param name="quotationData"></param> /// <returns></returns> public int AddUpdateQuotation(PurchaseQuotationForm quotationData) { int autoId = 0; //Add purchase quotation PurchaseQuotation obj = new PurchaseQuotation(); obj.ID = quotationData.Quotation.ID; obj.Sup_Id = quotationData.Quotation.SupplierID; obj.PQ_Conv_to_PO = quotationData.Quotation.PQ_Conv_to_PO; obj.PQ_Conv_to_PI = quotationData.Quotation.PQ_Conv_to_PI; //obj.PQ_Date = quotationData.Quotation.QuotationDate; obj.PQ_Date = quotationData.Quotation.QuotationDate; obj.PQ_GST_Amt = Convert.ToDecimal(quotationData.Quotation.TotalTax); obj.PQ_No = quotationData.Quotation.QuotationNo; obj.PQ_TandC = quotationData.Quotation.TermsAndConditions; obj.PQ_Tot_aft_Tax = Convert.ToDecimal(quotationData.Quotation.TotalAfterTax); obj.PQ_Tot_bef_Tax = Convert.ToDecimal(quotationData.Quotation.TotalBeforeTax); obj.PQ_Valid_for = quotationData.Quotation.ValidForDays; obj.Exc_Inc_GST = quotationData.Quotation.ExcIncGST; obj.IsDeleted = false; try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { if (entities.PurchaseQuotations.AsNoTracking().FirstOrDefault(x => x.ID == quotationData.Quotation.ID) == null) { //obj.CreatedBy = quotationData.PQModel.CreatedBy; obj.CreatedDate = DateTime.Now; entities.PurchaseQuotations.Add(obj); entities.SaveChanges(); autoId = obj.ID; } else { // obj.ModifiedBy = quotationData.PQModel.ModifiedBy; obj.ModifiedDate = DateTime.Now; entities.Entry(obj).State = EntityState.Modified; autoId = entities.SaveChanges(); } if (autoId > 0) { PurchaseQuotationDetail PQDetails; if (quotationData.QuotationDetails != null) { foreach (PurchaseQuotationDetailEntity PQDetailEntity in quotationData.QuotationDetails) { PQDetails = new PurchaseQuotationDetail(); PQDetails.PQ_ID = autoId; PQDetails.PQ_No = PQDetailEntity.PQNo; PQDetails.PandS_Code = PQDetailEntity.PandSCode; PQDetails.PandS_Name = PQDetailEntity.PandSName; PQDetails.PQ_Amount = PQDetailEntity.PQAmount; PQDetails.PQ_Discount = PQDetailEntity.PQDiscount; PQDetails.PQ_No = PQDetailEntity.PQNo; PQDetails.PQ_Price = Convert.ToDecimal(PQDetailEntity.PQPrice); PQDetails.PQ_Qty = PQDetailEntity.PQQty; PQDetails.GST_Code = PQDetailEntity.GSTCode; PQDetails.GST_Rate = PQDetailEntity.GSTRate; if (entities.PurchaseQuotationDetails.AsNoTracking().FirstOrDefault(x => x.ID == PQDetailEntity.ID) == null) { entities.PurchaseQuotationDetails.Add(PQDetails); entities.SaveChanges(); } else { entities.Entry(PQDetails).State = EntityState.Modified; entities.SaveChanges(); } } } } } return(autoId); } catch (Exception ex) { throw ex; } }
public int ConvertToPurchaseInvoice(PurchaseQuotationForm quotationData) { IPurchaseQuotationBL pqBL = new PurchaseQuotationBL(); return(pqBL.ConvertToPurchaseInvoice(quotationData)); }
public int ConvertToPurchaseOrder(PurchaseQuotationForm pqForm) { IPurchaseQuotationBL pqBL = new PurchaseQuotationBL(); return(pqBL.ConvertToPurchaseOrder(pqForm)); }
public int UpdationQuotation(PurchaseQuotationForm quotationData) { IPurchaseQuotationBL pqBL = new PurchaseQuotationBL(); return(pqBL.UpdationQuotation(quotationData)); }
public int ConvertToPurchaseInvoice(PurchaseQuotationForm quotationData) { IPurchaseQuotationDAL PQDAL = new PurchaseQuotationDAL(); return(PQDAL.ConvertToPurchaseInvoice(quotationData)); }
public int UpdationQuotation(PurchaseQuotationForm quotationData) { try { using (SASEntitiesEDM entities = new SASEntitiesEDM()) { PurchaseQuotation obj = entities.PurchaseQuotations.Where(e => e.PQ_No == quotationData.Quotation.QuotationNo ).SingleOrDefault(); if (obj != null) { //obj.ID = quotationData.Quotation.ID; obj.Sup_Id = quotationData.Quotation.SupplierID; // obj.PQ_Conv_to_PO = quotationData.Quotation.PQ_Conv_to_PO; // obj.PQ_Conv_to_PI = quotationData.Quotation.PQ_Conv_to_PI; obj.PQ_Date = Convert.ToDateTime(quotationData.Quotation.QuotationDateStr); obj.PQ_GST_Amt = Convert.ToDecimal(quotationData.Quotation.TotalTax); obj.PQ_No = quotationData.Quotation.QuotationNo; obj.PQ_TandC = quotationData.Quotation.TermsAndConditions; obj.PQ_Tot_aft_Tax = Convert.ToDecimal(quotationData.Quotation.TotalAfterTax); obj.PQ_Tot_bef_Tax = Convert.ToDecimal(quotationData.Quotation.TotalBeforeTax); obj.PQ_Valid_for = quotationData.Quotation.ValidForDays; obj.Exc_Inc_GST = quotationData.Quotation.ExcIncGST; obj.ModifiedDate = DateTime.Now; entities.SaveChanges(); } var objPurchase = entities.PurchaseQuotationDetails.Where (e => e.PQ_ID == obj.ID).ToList(); if (objPurchase != null) { foreach (var item in objPurchase) { entities.PurchaseQuotationDetails.Remove(item); entities.SaveChanges(); } } PurchaseQuotationDetail PQDetails; if (quotationData.QuotationDetails != null) { foreach (PurchaseQuotationDetailEntity PQDetailEntity in quotationData.QuotationDetails) { PQDetails = new PurchaseQuotationDetail(); PQDetails.PQ_ID = obj.ID; PQDetails.PQ_No = PQDetailEntity.PQNo; PQDetails.PandS_Code = PQDetailEntity.PandSCode; PQDetails.PandS_Name = PQDetailEntity.PandSName; PQDetails.PQ_Amount = PQDetailEntity.PQAmount; PQDetails.PQ_Discount = PQDetailEntity.PQDiscount; PQDetails.PQ_No = PQDetailEntity.PQNo; PQDetails.PQ_Price = Convert.ToDecimal(PQDetailEntity.PQPrice); PQDetails.PQ_Qty = PQDetailEntity.PQQty; PQDetails.GST_Code = PQDetailEntity.GSTCode; PQDetails.GST_Rate = PQDetailEntity.GSTRate; entities.PurchaseQuotationDetails.Add(PQDetails); entities.SaveChanges(); } } return(obj.ID); } } catch (Exception ex) { throw ex; } }
private void UserControl_LoadedPurchaseQuotation(object sender, RoutedEventArgs e) { //var a = _viewModel.PrintSalesQuotation(); PurchaseQuotationForm sqf = _viewModelSales.PrintPurchaseQuotation(); //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("Qty", typeof(string))); dt.Columns.Add(new DataColumn("Price", typeof(string))); dt.Columns.Add(new DataColumn("Discount", typeof(string))); dt.Columns.Add(new DataColumn("Amount", typeof(string))); dt.Columns.Add(new DataColumn("Rate", typeof(string))); //ReportingDataset ds = new ReportingDataset(); foreach (var item in sqf.QuotationDetails) { DataRow dr = dt.NewRow(); dr["PandSCode"] = item.PandSCode; dr["PandSName"] = item.PandSName; dr["Qty"] = item.PQQty; dr["Price"] = item.Price.ToString(); dr["Discount"] = item.PQDiscount; dr["Amount"] = item.PQAmount.ToString(); dr["Rate"] = item.GSTRate.ToString(); dt.Rows.Add(dr); } ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "PurchaseQuotationDetailsDataSet"; // Name of the DataSet we set in .rdlc reportDataSource.Value = dt; // end of product grid code DataTable dt4 = new DataTable(); //for other than table dt4.Columns.Add(new DataColumn("TAndCondition", typeof(string))); dt4.Columns.Add(new DataColumn("TotalBeforeTaxStr", typeof(string))); dt4.Columns.Add(new DataColumn("TotalTax", typeof(string))); dt4.Columns.Add(new DataColumn("TotalAfterTaxStr", typeof(string))); dt4.Columns.Add(new DataColumn("PQNo", typeof(string))); dt4.Columns.Add(new DataColumn("PQDate", typeof(string))); dt4.Columns.Add(new DataColumn("ValidForDays", typeof(int))); DataRow dr4 = dt4.NewRow(); dr4["TAndCondition"] = sqf.Quotation.TermsAndConditions; dr4["TotalBeforeTaxStr"] = sqf.Quotation.TotalAfterTax; dr4["TotalTax"] = sqf.Quotation.TotalTax.ToString(); dr4["TotalAfterTaxStr"] = sqf.Quotation.TotalAfterTax.ToString(); dr4["PQNo"] = sqf.Quotation.QuotationNo; dr4["PQDate"] = sqf.Quotation.QuotationDate.Date.ToString("dd/M/yyyy"); dr4["ValidForDays"] = sqf.Quotation.ValidForDays; dt4.Rows.Add(dr4); ReportDataSource reportDataSource4 = new ReportDataSource(); reportDataSource4.Name = "PurchaseQuotationUniqueRecordDetailsDataSet"; // Name of the DataSet we set in .rdlc reportDataSource4.Value = dt4; // 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))); dt1.Columns.Add(new DataColumn("CompanyShipToPostCode", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyShipToLine1", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyShipToLine2", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyShipToCity", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyShipToState", typeof(string))); dt1.Columns.Add(new DataColumn("CompanyShipToCountary", typeof(string))); /*****End column*****/ /*****data part*******/ DataRow dr1 = dt1.NewRow(); dr1["CompanyName"] = sqf.Quotation.CompanyName; dr1["CompanyLogo"] = sqf.Quotation.CompanyLogo; dr1["CompanyRegNumber"] = sqf.Quotation.CompanyRegNumber; dr1["CompanyGstNumber"] = sqf.Quotation.CompanyGstNumber; dr1["Telephone"] = sqf.Quotation.Telephone; dr1["CompanyFax"] = sqf.Quotation.CompanyFax; dr1["CompanyEmail"] = sqf.Quotation.CompanyEmail; dr1["CompanyBillToAddressLine1"] = sqf.Quotation.CompanyBillToAddressLine1; dr1["CompanyBillToAddressLine2"] = sqf.Quotation.CompanyBillToAddressLine2; dr1["CompanyBillToCity"] = sqf.Quotation.CompanyBillToCity; dr1["CompanyBillToState"] = sqf.Quotation.CompanyBillToState; dr1["CompanyBillToCountary"] = sqf.Quotation.CompanyBillToCountary; dr1["CompanyBillToPostCode"] = sqf.Quotation.CompanyBillToPostCode; dr1["CompanyShipToLine1"] = sqf.Quotation.CompanyShipToAddressLine1; dr1["CompanyShipToLine2"] = sqf.Quotation.CompanyShipToAddressLine2; dr1["CompanyShipToCity"] = sqf.Quotation.CompanyShipToCity; dr1["CompanyShipToState"] = sqf.Quotation.CompanyShipToState; dr1["CompanyShipToCountary"] = sqf.Quotation.CompanyShipToCountary; dr1["CompanyShipToPostCode"] = sqf.Quotation.CompanyShipToPostCode; dt1.Rows.Add(dr1); /*****data part*******/ ReportDataSource reportDataSource1 = new ReportDataSource(); reportDataSource1.Name = "CompanyDetailsDataSet"; // 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))); /****end column defn**/ /**data****/ DataRow dr2 = dt2.NewRow(); dr2["SupplierName"] = sqf.Quotation.SupplierName; dr2["SupplierBillToLine1"] = sqf.Quotation.SupplierBillAddress1; dr2["SupplierBillToLine2"] = sqf.Quotation.SupplierBillAddress2; dr2["SupplierBillToCity"] = sqf.Quotation.SupplierBillAddressCity; dr2["SupplierBillToState"] = sqf.Quotation.SupplierBillAddressState; dr2["SupplierBillToCountary"] = sqf.Quotation.SupplierBillAddressCountary; dr2["SupplierBillToPostCode"] = sqf.Quotation.SupplierBillPostCode; dr2["SupplierTelephone"] = sqf.Quotation.SupplierTelephone; /**end data****/ dt2.Rows.Add(dr2); ReportDataSource reportDataSource2 = new ReportDataSource(); reportDataSource2.Name = "SupplierDetailsDataSet"; // 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.Quotation.CurrencyCode; dt3.Rows.Add(dr3); ReportDataSource reportDataSource3 = new ReportDataSource(); reportDataSource3.Name = "OptionsDetailsDataSet"; // 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, @"PurchaseQuotation.rdlc"); reportViewer9.LocalReport.ReportPath = reportPath; //D:\DayUser\src\SAS - NEW\Client\SASClient\Reports\ReportsRdlc reportViewer9.LocalReport.DataSources.Clear(); reportViewer9.LocalReport.DataSources.Add(reportDataSource); reportViewer9.LocalReport.DataSources.Add(reportDataSource1); reportViewer9.LocalReport.DataSources.Add(reportDataSource2); reportViewer9.LocalReport.DataSources.Add(reportDataSource3); reportViewer9.LocalReport.DataSources.Add(reportDataSource4); reportViewer9.RefreshReport(); // this.reportViewer1.Width = 75; }
public void GetPurchaseQuotation(string pqNo) { // Mouse.OverrideCursor = Cursors.Wait; PurchaseQuotationForm pqf = pqRepository.GetPurchaseQuotation(pqNo); this.ID = pqf.Quotation.ID; this.QuotationNo = pqf.Quotation.QuotationNo; this.QuotationDate = pqf.Quotation.QuotationDate; this.ValidForDays = pqf.Quotation.ValidForDays; this.SelectedSupplierID = pqf.Quotation.SupplierID; //if (this.SelectedSupplierID > 0) //{ // GetSupplierDetails(); //} this.TermsAndConditions = pqf.Quotation.TermsAndConditions; this.TotalBeforeTax = pqf.Quotation.TotalBeforeTax; this.TotalTax = pqf.Quotation.TotalTax; this.TotalAfterTax = pqf.Quotation.TotalAfterTax; this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); if (pqf.Quotation.ExcIncGST == true) { ExcludingTax = false; IncludingTax = true; // PQDEntity.GSTRate = 0; } else { ExcludingTax = true; IncludingTax = false; // PQDEntity.GSTRate = TaxRate; } this.PQ_Conv_to_PO = pqf.Quotation.PQ_Conv_to_PO; this.PQ_Conv_to_PI = pqf.Quotation.PQ_Conv_to_PI; if (PQ_Conv_to_PO == true || PQ_Conv_to_PI == true) { AllFieldsReadonly = true; AllFieldsEnabled = false; } else { AllFieldsReadonly = false; AllFieldsEnabled = true; LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList(); ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive != "Y").ToObservable(); } SupplierEnabled = false; this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.QuotationDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PQNo); 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.PQQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = item.PQDiscount; // PQDEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.PQAmount; PQDetailsEntity.Add(pqEntity); } }