private void ShowAllDetails() { try { PurchaseOrderDB pdb = new PurchaseOrderDB(); poheader poh = pdb.getFilteredPurchaseOrderHeaderlist(docID, tempno, tempdate).FirstOrDefault(); if (poh != null) { txtDocID.Text = poh.DocumentID; //txtTrackingNo.Text = poh.TrackingNo.ToString(); //dtTrackingDate.Value = poh.TrackingDate; txtDevileryPeriod.Text = poh.DeliveryPeriod.ToString(); cmbCustomer.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbCustomer, poh.CustomerID); txtPONo.Text = poh.PONo.ToString(); dtPODate.Value = poh.PODate; cmbCurrency.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbCurrency, poh.CurrencyID); cmbPaymentMode.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbPaymentMode, poh.ModeOfPayment); cmbFreightTerms.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbFreightTerms, poh.FreightTerms); cmbTaxterms.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbTaxterms, poh.TaxTerms); cmbTransportationMode.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbTransportationMode, poh.TransportationMode); txtValidityperiod.Text = poh.validityPeriod.ToString(); txtFreightCharge.Text = poh.FreightCharge.ToString(); txtpaymentTerms.Text = getPaymentTermsExplained(poh.PaymentTerms); txtproductValue.Text = poh.ProductValueINR.ToString(); txtTaxvalue.Text = poh.TaxAmountINR.ToString(); txtPOvalue.Text = poh.POValueINR.ToString(); } poheader popd = new poheader(); popd.DocumentID = docID; popd.TemporaryNo = tempno; popd.TemporaryDate = tempdate; List <podetail> pod = PurchaseOrderDB.getPurchaseOrderDetails(popd); grdPRDetail.Rows.Clear(); int i = 0; double count = 0; foreach (podetail po in pod) { grdPRDetail.Rows.Add(); grdPRDetail.Rows[i].Cells["LineNo"].Value = grdPRDetail.Rows.Count; grdPRDetail.Rows[i].Cells["Item"].Value = po.StockItemID; grdPRDetail.Rows[i].Cells["ItemDesc"].Value = po.StockItemName; grdPRDetail.Rows[i].Cells["TaxCode"].Value = po.TaxCode; grdPRDetail.Rows[i].Cells["Quantity"].Value = po.Quantity; grdPRDetail.Rows[i].Cells["Price"].Value = po.Price; grdPRDetail.Rows[i].Cells["Tax"].Value = po.Tax; double valu = po.Price * po.Quantity + po.Tax; grdPRDetail.Rows[i].Cells["Value"].Value = valu; count += valu; i++; } txtTotalValue.Text = count.ToString(); } catch (Exception ex) { MessageBox.Show("Error in POOut"); } }
private void ShowAllDetails() { if (docID == "POPRODUCTINWARD" || docID == "POPRODUCTINWARD") { try { POPIHeaderDB popihdb = new POPIHeaderDB(); popiheader vd = popihdb.getPOPIHeader(tempno, tempdate, docID).FirstOrDefault(); if (vd != null) { txtDocID.Text = vd.DocumentID; txtTrackingNo.Text = vd.TrackingNo.ToString(); dtTrackingDate.Value = vd.TrackingDate; txtrefno.Text = vd.ReferenceNo; cmbCustomer.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbCustomer, vd.CustomerID); txtPONo.Text = vd.CustomerPONO; dtPODate.Value = vd.CustomerPODate; dtDeliveryDate.Value = vd.DeliveryDate; cmbOfficeID.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbOfficeID, vd.OfficeID); cmbProjectID.SelectedIndex = cmbProjectID.FindString(vd.ProjectID); cmbPaymentMode.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbPaymentMode, vd.PaymentMode); cmbFreightTerms.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbFreightTerms, vd.FreightTerms); cmbCurrency.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbCurrency, vd.CurrencyID); txtFreightCharge.Text = vd.FreightCharge.ToString(); dtValidateDate.Value = vd.ValidityDate; txtpaymentTerms.Text = getPaymentTermsExplained(vd.PaymentTerms); txtproductValue.Text = vd.ProductValueINR.ToString(); txtTaxvalue.Text = vd.TaxAmountINR.ToString(); txtPOvalue.Text = vd.POValueINR.ToString(); } popiheader popih = new popiheader(); popih.DocumentID = docID; popih.TemporaryNo = tempno; popih.TemporaryDate = tempdate; List <popidetail> POPIDetail = POPIHeaderDB.getPOPIDetail(popih); grdPRDetail.Rows.Clear(); int i = 0; double count = 0; foreach (popidetail pop in POPIDetail) { grdPRDetail.Rows.Add(); grdPRDetail.Rows[i].Cells["LineNo"].Value = grdPRDetail.Rows.Count; grdPRDetail.Rows[i].Cells["Item"].Value = pop.StockItemID; grdPRDetail.Rows[i].Cells["ItemDesc"].Value = pop.StockItemName; grdPRDetail.Rows[i].Cells["TaxCode"].Value = pop.TaxCode; grdPRDetail.Rows[i].Cells["Quantity"].Value = pop.Quantity; grdPRDetail.Rows[i].Cells["Price"].Value = pop.Price; grdPRDetail.Rows[i].Cells["Tax"].Value = pop.Tax; double valu = pop.Price * pop.Quantity + pop.Tax; grdPRDetail.Rows[i].Cells["Value"].Value = valu; count += valu; i++; } txtTotalValue.Text = count.ToString(); } catch (Exception ex) { MessageBox.Show("Error in POInward"); } } else if (docID == "PURCHASEORDER") { try { PurchaseOrderDB pdb = new PurchaseOrderDB(); poheader poh = pdb.getFilteredPurchaseOrderHeaderlist(docID, tempno, tempdate).FirstOrDefault(); if (poh != null) { txtDocID.Text = poh.DocumentID; //txtTrackingNo.Text = poh.TrackingNo.ToString(); //dtTrackingDate.Value = poh.TrackingDate; //txtrefno.Text = poh.ReferenceNo; cmbCustomer.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbCustomer, poh.CustomerID); //txtPONo.Text = poh.CustomerPONO; //dtPODate.Value = poh.CustomerPODate; //dtDeliveryDate.Value = poh.DeliveryDate; //cmbOfficeID.SelectedIndex = Structures.ComboFUnctions.getComboIndex(cmbOfficeID, poh.OfficeID); //cmbProjectID.SelectedIndex = cmbProjectID.FindString(poh.ProjectID); //dtValidateDate.Value = poh.ValidityDate; txtpaymentTerms.Text = getPaymentTermsExplained(poh.PaymentTerms); txtproductValue.Text = poh.ProductValueINR.ToString(); txtTaxvalue.Text = poh.TaxAmountINR.ToString(); txtPOvalue.Text = poh.POValueINR.ToString(); } poheader popd = new poheader(); popd.DocumentID = docID; popd.TemporaryNo = tempno; popd.TemporaryDate = tempdate; List <podetail> pod = PurchaseOrderDB.getPurchaseOrderDetails(popd); grdPRDetail.Rows.Clear(); int i = 0; double count = 0; foreach (podetail po in pod) { grdPRDetail.Rows.Add(); grdPRDetail.Rows[i].Cells["LineNo"].Value = grdPRDetail.Rows.Count; grdPRDetail.Rows[i].Cells["Item"].Value = po.StockItemID; grdPRDetail.Rows[i].Cells["ItemDesc"].Value = po.StockItemName; grdPRDetail.Rows[i].Cells["TaxCode"].Value = po.TaxCode; grdPRDetail.Rows[i].Cells["Quantity"].Value = po.Quantity; grdPRDetail.Rows[i].Cells["Price"].Value = po.Price; grdPRDetail.Rows[i].Cells["Tax"].Value = po.Tax; double valu = po.Price * po.Quantity + po.Tax; grdPRDetail.Rows[i].Cells["Value"].Value = valu; count += valu; i++; } txtTotalValue.Text = count.ToString(); } catch (Exception ex) { MessageBox.Show("Error in POOut"); } } else if (docID == "WORKORDER") { try { } catch (Exception ex) { MessageBox.Show("Error in WorkOrder"); } } else if (docID == "POGENERAL") { try { } catch (Exception ex) { MessageBox.Show("Error in POgeneral"); } } else if (docID == "POINVOICEIN" || docID == "WOINVOICEIN" || docID == "POGENERALINVOICEIN") { try { } catch (Exception ex) { MessageBox.Show("Error in InvoiceIn"); } } else if (docID == "PRODUCTINVOICEOUT" || docID == "SERVICEINVOICEOUT") { try { } catch (Exception ex) { MessageBox.Show("Error in InvoiceOut"); } } }