public double catculateCreditSale(String date) { InvoiceModel inv = new InvoiceModel(); dynamic invoices = inv.where (inv, "is_credit = '1' and date ='" + date + "'"); double total = 0.0; if (invoices.Count > 0) { foreach (var invoice in invoices) { PaymentModel pay = new PaymentModel(); dynamic payments = pay.where (pay, "invoice_id ='" + invoice.id + "'"); if (payments.Count > 0) { double paymentAmount = 0.0; foreach (var payment in payments) { paymentAmount += payment.amount; } total += (invoice.net_total - paymentAmount); } else { total += invoice.net_total; } } } return(total); }
private void dateTimePickerSearchInvoice_ValueChanged(object sender, EventArgs e) { String searchValue = dateTimePickerSearchInvoice.Value.ToString("yyyy-MM-dd"); InvoiceModel inv = new InvoiceModel(); dynamic invoices = inv.where (inv, " date ='" + searchValue + "'"); loadInvoiceData(invoices); }
public void loadSales(string date) { clear_amount(); paymentList.Rows.Clear(); InvoiceModel inv = new InvoiceModel(); dynamic invoices = inv.where (inv, "till_id = '" + DepartmentSettings.TillId + "' and date ='" + date + "'"); if (invoices.Count > 0) { string invoiceIds = null; foreach (var invoice in invoices) { invoiceIds += "," + invoice.id; } string Ids = invoiceIds.Substring(1); PaymentModel pay = new PaymentModel(); dynamic payments = pay.where (pay, "invoice_id in(" + Ids + ")"); if (payments.Count > 0) { foreach (var payment in payments) { totalPayment += payment.amount; String type = payment.payment_method; switch (type) { case "Cash": totalCashPayment += payment.amount; break; case "Mobile": mobilePayment += payment.amount; break; case "Card": totalCardPayment += payment.amount; break; case "Debit": debitPayment += payment.amount; break; default: break; } paymentList.Rows.Add(payment.id, payment.payment_method, payment.invoice_id, Math.Round(payment.amount, 2), payment.transaction_token, payment.date); } } double total = totalPayment + catculateCreditSale(date); totalLabel.Text = "" + Math.Round(total, 2); cardLabel.Text = "" + Math.Round(totalCardPayment, 2); mobileLabel.Text = "" + Math.Round(mobilePayment, 2); debitLabel.Text = "" + Math.Round(debitPayment, 2); cashSaleLabel.Text = "" + Math.Round(totalCashPayment, 2); labelCreditSale.Text = "" + catculateCreditSale(date); } }
private void textBoxSearchInvoice_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Return) { string number = textBoxSearchInvoice.Text; InvoiceModel inv = new InvoiceModel(); dynamic invoices = inv.where (inv, "lower(number) like '%" + number.ToLower() + "%'"); loadInvoiceData(invoices); } }
public void loadSales() { string date = DateTime.Now.ToString("yyyy-MM-dd"); InvoiceModel inv = new InvoiceModel(); dynamic invoices = inv.where (inv, "till_id = '" + DepartmentSettings.TillId + "' and date ='" + date + "'"); if (invoices.Count > 0) { string invoiceIds = null; foreach (var invoice in invoices) { invoiceIds += "," + invoice.id; } string Ids = invoiceIds.Substring(1); PaymentModel pay = new PaymentModel(); dynamic payments = pay.where (pay, "invoice_id in(" + Ids + ")"); if (payments.Count > 0) { foreach (var payment in payments) { totalPayment += payment.amount; String type = payment.payment_method; switch (type) { case "Cash": totalCashPayment += payment.amount; break; case "Mobile": mobilePayment += payment.amount; break; case "Card": totalCardPayment += payment.amount; break; case "Debit": debitPayment += payment.amount; break; default: break; } } } totalLabel.Text = "" + Math.Round(totalPayment, 2); cardLabel.Text = "" + Math.Round(totalCardPayment, 2); mobileLabel.Text = "" + Math.Round(mobilePayment, 2); debitLabel.Text = "" + Math.Round(debitPayment, 2); cashSaleLabel.Text = "" + Math.Round(totalCashPayment, 2); cashSale.Text = "" + Math.Round(totalCashPayment, 2); } }
private void search_invoice_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Return) { string number = search_invoice.Text; InvoiceModel inv = new InvoiceModel(); dynamic invoices = inv.where (inv, "lower(number) like '%" + number.ToLower() + "%'"); if (invoices.Count > 0) { foreach (dynamic invoice in invoices) { invoiceList.Rows.Add(invoice.id, invoice.number, invoice.customer_id, invoice.date, invoice.net_total); } invoiceList.Rows[0].Selected = true; invoiceList.Focus(); } else { MessageDialog.ShowAlert("Invoice not found"); } } }