private void btnInsert_Click(object sender, EventArgs e) { decimal paymentDue = 0; if (decimal.TryParse(tbPaymentDue.Text, out paymentDue)) { if (calDueDate.Value != null) { if (ddlPO.SelectedValue != null) { if (BLSupplierInvoice.insertSupplierInvoice(APCContext, tbSupplierOriInvoiceNo.Text, paymentDue, calDueDate.Value, BLPO.GetPOById(APCContext, int.Parse(ddlPO.SelectedValue.ToString())))) { MessageBox.Show("SupplierInvoice Successfully Added"); } else { MessageBox.Show("Please check your input"); } } else { MessageBox.Show("Please select the associated PO Number"); } } else { MessageBox.Show("Please specify Due Date"); } } else { MessageBox.Show("Please specify correct amount of Payment Due"); } }
public List <SupplierInvoice> searchById(int id) { if (id != 0) { List <SupplierInvoice> supplierInvoiceList = BLSupplierInvoice.GetSupplierInvoiceListById(APCContext, id); if (supplierInvoiceList != null) { tbId.Text = supplierInvoiceList[0].Id.ToString(); tbSupplierOriInvoiceNo.Text = supplierInvoiceList[0].SupplierOriNo; tbPaymentDue.Text = supplierInvoiceList[0].PaymentDue.ToString(); calDueDate.Value = DateTime.Parse(supplierInvoiceList[0].DueDate.ToString()); ddlPO.SelectedValue = int.Parse(supplierInvoiceList[0].PO.Id.ToString()); return(supplierInvoiceList); } else { MessageBox.Show("SupplierInvoice Id not found"); } } else { MessageBox.Show("SupplierInvoice Id not found"); } return(null); }
private void btnSearch_Click(object sender, EventArgs e) { DateTime startDate = calStartDueDate.Value; DateTime endDate = calEndDueDate.Value; List <SupplierInvoice> supplierInvoiceList = BLSupplierInvoice.GetSupplierInvoiceByDate(APCContext, startDate, endDate, cbPaid.Checked); dgPaymentToSupplier.DataSource = convertListToDataTable(supplierInvoiceList); }
private void btnSearchBySupplierOriInvoiceNo_Click(object sender, EventArgs e) { if (tbSearchSupplierOriNo.Text.Trim() != "") { List <SupplierInvoice> supplierInvoiceList = BLSupplierInvoice.GetSupplierInvoiceBySupplierOriNo(APCContext, tbSearchSupplierOriNo.Text); dgSupplierInvoice.DataSource = convertListToDataTable(supplierInvoiceList); } else { MessageBox.Show("SupplierInvoice Name not found"); } }
private decimal calculateBalance(bool invoiced, bool paid, bool all) { decimal total = 0; DataTable dt = BLSupplierInvoice.GetSUMSupplierInvoiceDueDatePOInvoicedAndPaid(DateTime.Today.AddDays(14), invoiced, paid, all); if (dt.Rows.Count > 0) { if (decimal.TryParse(dt.Rows[0][0].ToString(), out total)) { return(total); } } return(0); }
private void PaymentToSupplierForm_Load(object sender, EventArgs e) { lblTodaysDate.Text = DateTime.Today.ToShortDateString(); lblPurchaseNotInvoiced.Text = calculateBalance(false, false, false).ToString(); lblArconInvoiceNotPaid.Text = calculateBalance(true, false, false).ToString(); lblPaymentDueForSupplier.Text = calculateBalance(false, false, true).ToString(); APCContext = new APCEntities(); cbPaid.Enabled = false; cbInvoiced.Enabled = false; cbALL.Checked = true; DataTable dt = BLSupplierInvoice.GetSupplierInvoiceDueDatePOInvoicedAndPaid(DateTime.Today.AddDays(14), cbInvoiced.Checked, cbPaid.Checked, cbALL.Checked); dgReminderSupplierPayment.DataSource = dt; }
public void setId(int SupplierInvoiceId, APCEntities APCContext1) { APCContext = APCContext1; DataTable dtSupplierInvoice = BLSupplierInvoice.GetSupplierInvoiceById(SupplierInvoiceId); if (dtSupplierInvoice.Rows.Count > 0) { DataRow supplierInvoiceRow = dtSupplierInvoice.Rows[0]; int supplierInvoiceId = int.Parse(supplierInvoiceRow["Id"].ToString()); tbSupplierInvoiceId.Text = supplierInvoiceRow["Id"].ToString(); tbSupplierInvoiceOriginalNo.Text = supplierInvoiceRow["SupplierOriNo"].ToString(); tbPONo.Text = supplierInvoiceRow["POId"].ToString(); tbPaymentDue.Text = ((decimal.Parse(supplierInvoiceRow["PaymentDue"].ToString())) - TotalPaid(supplierInvoiceId)).ToString("N"); } }
private void btnUpdate_Click(object sender, EventArgs e) { int id = 0; int.TryParse(tbId.Text, out id); if (id != 0) { SupplierInvoice currentSupplierInvoice = BLSupplierInvoice.GetSupplierInvoiceById(APCContext, id); if (currentSupplierInvoice != null) { decimal paymentDue = 0; if (decimal.TryParse(tbPaymentDue.Text, out paymentDue)) { if (calDueDate.Value != null) { if (ddlPO.SelectedValue != null) { currentSupplierInvoice.SupplierOriNo = tbSupplierOriInvoiceNo.Text; currentSupplierInvoice.PaymentDue = paymentDue; currentSupplierInvoice.DueDate = calDueDate.Value; currentSupplierInvoice.PO = BLPO.GetPOById(APCContext, int.Parse(ddlPO.SelectedValue.ToString())); APCContext.SaveChanges(); MessageBox.Show("SupplierInvoice Details Successfully Updated"); } else { MessageBox.Show("Please select the associated PO Number"); } } else { MessageBox.Show("Please specify a correct due date"); } } else { MessageBox.Show("Please specify correct amount of Payment Due"); } } else { MessageBox.Show("SupplierInvoice Id not found"); } } else { MessageBox.Show("SupplierInvoice Id not found"); } }
private void btnSubmit_Click(object sender, EventArgs e) { SupplierInvoice supplierInvoice = BLSupplierInvoice.GetSupplierInvoiceListById(APCContext,int.Parse(tbSupplierInvoiceId.Text)).First(); BLPaymentToSupplier.insertPaymentToSupplier(APCContext, supplierInvoice, decimal.Parse(tbPaymentAmount.Text), calPaidDate.Value); //check if payment has been made full - if yes then can mark as paid. if (supplierInvoice.PaymentDue <= TotalPaid(supplierInvoice.Id)) { supplierInvoice.Paid = true; supplierInvoice.PaidDate = DateTime.Now; APCContext.SaveChanges(); } MessageBox.Show("Payment has been recorded"); }
private void btnDelete_Click(object sender, EventArgs e) { int id = 0; int.TryParse(tbId.Text, out id); if (id != 0) { SupplierInvoice currentSupplierInvoice = BLSupplierInvoice.GetSupplierInvoiceById(APCContext, id); if (currentSupplierInvoice != null) { APCContext.DeleteObject(currentSupplierInvoice); APCContext.SaveChanges(); MessageBox.Show("Delete Successfully"); } else { MessageBox.Show("SupplierInvoice Id not found"); } } else { MessageBox.Show("SupplierInvoice Id not found"); } }
private void btnSearch_Click(object sender, EventArgs e) { DataTable dt = BLSupplierInvoice.GetSupplierInvoiceDueDatePOInvoicedAndPaid(DateTime.Today.AddDays(14), cbInvoiced.Checked, cbPaid.Checked, cbALL.Checked); dgReminderSupplierPayment.DataSource = dt; }