private void AddItemButton_Click(object sender, EventArgs e)
{
AccountsRecievableDao DAO = new AccountsRecievableDao();
int ProductId = DAO.InsertItem(txtProductCode.Text, txtBrand.Text, Convert.ToDecimal(txtUnitPrice.Text));
//if(DAO.ItemExist())
MessageBox.Show("Product inserted into DB: " + ProductId);
}
private void SaveInvoiceFunction()
{
string ErrorMessage = "";
ErrorMessage = ValidateInvoice();
if (ErrorMessage.Length > 0)
{
MessageBox.Show("Incomplete / Invalid Invoice Details: \n" + ErrorMessage);
}
else
{
AccountsRecievableDao DAO = new AccountsRecievableDao();
if (!DAO.CustomerExist(txtCustomerName.Text))
{
CustomerId = DAO.InsertCustomer(
txtCustomerName.Text.ToString().Trim(),
txtAddress.Text.ToString().Trim(),
Convert.ToInt32(txtContactNumber.Text.ToString().Trim())
);
}
else
{
var CustomerDetails = new Dictionary<string, object>();
CustomerDetails["ADDRESS"] = txtAddress.Text;
CustomerDetails["CONTACT_NO"] = txtContactNumber.Text;
DAO.UpdateQuery(Constants.TableNames.CUSTOMER, CustomerDetails, "CUSTOMER_ID", CustomerId.ToString());
}
if (!DAO.PersonnelExist(txtSalesRepresentative.Text))
{
PersonnelId = DAO.InsertPersonnel(
txtSalesRepresentative.Text.ToString().Trim(),
txtBranch.Text.ToString().Trim()
);
}
else
{
var PersonnelDetails = new Dictionary<string, object>();
PersonnelDetails["BRANCH"] = txtBranch.Text;
DAO.UpdateQuery(Constants.TableNames.PERSONNEL, PersonnelDetails, "PERSONNEL_ID", PersonnelId.ToString());
}
//update invoice
var InvoiceDetails = new Dictionary<string, object>();
InvoiceDetails["ENTRY_DATE"] = pkrEntryDate.Value;
InvoiceDetails["INVOICE_DATE"] = pkrInvoiceDate.Value;
InvoiceDetails["PAYMENT_TERMS"] = txtPaymentTerms.Value;
InvoiceDetails["RECEIVABLE_STATUS"] = GetRecievableStatusCode(ddlRecievableStatus.SelectedItem.ToString());
InvoiceDetails["DISCOUNT"] = txtInvoiceDiscount.Text;
InvoiceDetails["DUE_DATE"] = pkrInvoiceDate.Value.AddDays(int.Parse(txtPaymentTerms.Value.ToString()));
InvoiceDetails["REMARKS"] = txtRemarks.Text;
InvoiceDetails["AMOUNT"] = txtInvoiceTotal.Text.Replace(",","");
InvoiceDetails["PERSONNEL_ID"] = PersonnelId;
InvoiceDetails["CUSTOMER_ID"] = CustomerId;
InvoiceDetails["DATE_UPDATED"] = DateTime.Now;
InvoiceDetails["UPDATED_BY"] = DAO.GetUserId(UserId);
DAO.UpdateQuery(Constants.TableNames.RECEIVABLES, InvoiceDetails, "INVOICE_NO", txtInvoiceNumber.Text);
//update transactions
DAO.ExecuteSQL("DELETE FROM " + Constants.TableNames.TRANSACTIONS + " WHERE INVOICE_ID = '" +InvoiceId.ToString()+ "'");
int InvoiceDiscount = 0;
int ProductId = 0;
int InvoiceItemDiscount = 0;
int.TryParse(txtInvoiceDiscount.Text, out InvoiceDiscount);
foreach (DataGridViewRow Row in InvoiceItems.Rows)
{
InvoiceDiscount = 0;
if (Row.Cells[Constants.RowColumnCodeForAddInvoice.DISCOUNT].Value != null)
{
int.TryParse(Row.Cells[Constants.RowColumnCodeForAddInvoice.DISCOUNT].Value.ToString().Trim(), out InvoiceDiscount);
}
if (Row.Cells[1].Value != null)
{
if (!DAO.ItemExist(Row.Cells[Constants.RowColumnCodeForAddInvoice.ITEM_CODE].Value.ToString().Trim(), Convert.ToDecimal(Row.Cells[Constants.RowColumnCodeForAddInvoice.PRICE].Value.ToString().Trim())))
{
ProductId = DAO.InsertItem(Row.Cells[Constants.RowColumnCodeForAddInvoice.ITEM_CODE].Value.ToString().Trim(),
Row.Cells[Constants.RowColumnCodeForAddInvoice.BRAND].Value.ToString().Trim(),
Convert.ToDecimal(Row.Cells[Constants.RowColumnCodeForAddInvoice.PRICE].Value.ToString().Trim()));
}
else
{
ProductId = Convert.ToInt32(DAO.SelectQuery("SELECT PRODUCT_ID FROM " + Constants.TableNames.PRODUCT + " WHERE PRODUCT_CODE ='" + Row.Cells[Constants.RowColumnCodeForAddInvoice.ITEM_CODE].Value.ToString().Trim() + "'").Rows[0][0].ToString());
}
DAO.InsertTransaction(InvoiceId, ProductId, Convert.ToInt32(Row.Cells[Constants.RowColumnCodeForAddInvoice.QUANTITY].Value.ToString().Trim()), InvoiceDiscount);
}
}
MessageBox.Show(this, "Invoice Saved.", "Success", MessageBoxButtons.OK);
this.Close();
}
}