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");
}
}
}