public int insertSale(ClassSales sale)
{
string query = "INSERT INTO sales VALUES ( '" + sale.orderid + "','" + sale.customerid + "','" + sale.date + "', " + sale.discount + ", " + sale.amountobepaid + ", " + sale.amountpaid + ", " + sale.creditvalue + ", " + sale.discountpercentage + ", " + sale.total + ");";
int result = clsConnection.SendQuery(query);
return(result);
}
private void txtSalesId_TextChanged(object sender, EventArgs e)
{
try {
dgvsalesview.DataSource = ClassSales.wildcardsalesdetailsSearch(txtSalesId.Text);
} catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtCusName_Leave(object sender, EventArgs e)
{
try
{
DataTable db = new DataTable();
string query = "select customerid from customer where customername ='" + txtCusName.Text + "'";
db = clsConnection.GetData(query);
string cusid = db.Rows[0][0].ToString();
dgvsalesview.DataSource = ClassSales.salesdetailsSearch2(cusid);
dgvsalesview.Columns[0].HeaderText = "Sales ID";
dgvsalesview.Columns[1].HeaderText = "Customer Name";
dgvsalesview.Columns[2].HeaderText = "Date";
dgvsalesview.Columns[3].HeaderText = "Amount to be paid";
dgvsalesview.Columns[4].HeaderText = "Amount paid";
dgvsalesview.Columns[5].HeaderText = "Balance";
dgvPaymentView.DataSource = ClassPayments.customerPaymentSearch(cusid);
dgvPaymentView.Columns[0].HeaderText = "Payment ID";
dgvPaymentView.Columns[1].HeaderText = "Customer Name";
dgvPaymentView.Columns[2].HeaderText = "Date";
dgvPaymentView.Columns[3].HeaderText = "Amount";
DataTable db1 = new DataTable();
string query2 = "select orderid from orderbill where customerid ='" + cusid + "'";
db1 = clsConnection.GetData(query2);
string ordid = db1.Rows[0][0].ToString();
dgvReturnView.DataSource = classReturns.returndetails(ordid);
dgvReturnView.Columns[0].HeaderText = "Return ID";
dgvReturnView.Columns[1].HeaderText = "Order ID";
dgvReturnView.Columns[2].HeaderText = "Item ID";
dgvReturnView.Columns[3].HeaderText = "Batch ID";
dgvReturnView.Columns[4].HeaderText = "Quantity";
dgvReturnView.Columns[5].HeaderText = "Date";
dgvReturnView.Columns[5].HeaderText = "Amount";
DataTable db2 = new DataTable();
string query1 = "select creditvalue from customer where customername ='" + txtCusName.Text + "'";
db2 = clsConnection.GetData(query1);
txtcredit.Text = db2.Rows[0][0].ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmSalesDetails_Load(object sender, EventArgs e)
{
try
{
dgvSalesdetails.DataSource = ClassSales.salesUpdatebillsearch(orderid);
dgvSalesdetails.Columns[0].HeaderText = "Item ID";
dgvSalesdetails.Columns[1].HeaderText = "Batch ID";
dgvSalesdetails.Columns[2].HeaderText = "Item Name";
dgvSalesdetails.Columns[3].HeaderText = "Quantity";
dgvSalesdetails.Columns[4].HeaderText = "Discount Items";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmSalesReport_Load(object sender, EventArgs e)
{
try
{
dgvsalesview.DataSource = ClassSales.salesdetailsSearch();
dgvsalesview.Columns[0].HeaderText = "Sales ID";
dgvsalesview.Columns[1].HeaderText = "Customer Name";
dgvsalesview.Columns[2].HeaderText = "Date";
dgvsalesview.Columns[3].HeaderText = "Amount to be paid";
dgvsalesview.Columns[4].HeaderText = "Amount paid";
dgvsalesview.Columns[5].HeaderText = "Balance";
dgvsalesview.Columns[6].HeaderText = "Discount %";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public frmSalesDetails(string oid)
{
InitializeComponent();
orderid = oid;
try
{
customernamefill();
txtOrderId.Text = orderid;
DataTable db = new DataTable();
db = ClassSales.customersearchfromSales(orderid);
txtCustomerId.Text = db.Rows[0][0].ToString();
prevcusid = db.Rows[0][0].ToString();
txtCustomerName.Text = db.Rows[0][1].ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmSales_Load(object sender, EventArgs e)
{
try
{
dgvStockView.DataSource = classBatch.getItemsAvailable();
dgvStockView.Columns[0].HeaderText = "Item ID";
dgvStockView.Columns[1].HeaderText = "Batch ID";
dgvStockView.Columns[2].HeaderText = "Item Name";
dgvStockView.Columns[3].HeaderText = "Quantity";
stockcombofill();
customernamefill();
DateTime date = DateTime.Now;
DateLbl.Text = date.ToString("MM-d-yyyy");
DataTable db = ClassSales.getTopSalesId();
string OrderId = db.Rows[0][0].ToString();
int newOrdId = Int32.Parse(OrderId) + 1;
txtOrderId.Text = newOrdId.ToString();
}
catch (SqlException sqle)
{
clsConnection.connectionclose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
table.Columns.Add("Item Id", typeof(int));
table.Columns.Add("Batch ID", typeof(string));
table.Columns.Add("Item Name", typeof(string));
table.Columns.Add("Quantity", typeof(int));
table.Columns.Add("Free items", typeof(int));
table.Columns.Add("Selling Price", typeof(float));
table.Columns.Add("Amount ", typeof(float));
table.Columns.Add("Expire Date", typeof(DateTime));
dgvBill.DataSource = table;
}
private void btnSubmit_Click(object sender, EventArgs e)
{
string oid = txtOrderId.Text;
int y = 1;
classSalesBilling bill = new classSalesBilling();
try
{
if (txtCustomerId.Text == "" || txtCusName.Text == "")
{
throw new Exception("Enter a valid customer ID");
}
if (txtTobePaid.Text == "")
{
throw new Exception("Order Items.");
}
bill.amounttobepay = float.Parse(txtTobePaid.Text);
bill.amountpay = float.Parse(txttotalAmount.Text);
y = 2;
}
catch (FormatException fex)
{
MessageBox.Show("Enter valid paying amount");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (y == 2)
{
try
{
DataTable db = classCustomers.getCustomerCreditvalueById(txtCustomerId.Text);
int check = 0;
if (checkboxItem.Checked == true)
{
check = 1;
}
var sale = new ClassSales
{
orderid = txtOrderId.Text,
customerid = txtCustomerId.Text,
date = DateLbl.Text,
discount = float.Parse(txtaAmount.Text) - bill.amounttobepay,
amountobepaid = bill.amounttobepay,
amountpaid = bill.amountpay,
creditvalue = bill.credit,
discountpercentage = float.Parse(txtDiscount.Text)
};
int insertSale = sale.insertSale(sale);
int increaseCustomerCredit = classCustomers.updateCustomerCreditValueIncrease(bill.credit.ToString(), txtCustomerId.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
for (int i = 0; i < dgvBill.Rows.Count; i++)
{
try
{
int insertOrderDetails = ClassSales.insertToOrderDetails(txtOrderId.Text, dgvBill.Rows[i].Cells[0].Value.ToString(), dgvBill.Rows[i].Cells[1].Value.ToString(), Int32.Parse(dgvBill.Rows[i].Cells[3].Value.ToString()), Int32.Parse(dgvBill.Rows[i].Cells[4].Value.ToString()), float.Parse(dgvBill.Rows[i].Cells[6].Value.ToString()));
int purchseamnt = Int32.Parse(dgvBill.Rows[i].Cells[3].Value.ToString()) + Int32.Parse(dgvBill.Rows[i].Cells[4].Value.ToString());
string query = "UPDATE item SET Qty=Qty-" + purchseamnt + " where ItemID ='" + dgvBill.Rows[i].Cells[0].Value.ToString() + "'";
clsConnection.SendQuery(query);
string query2 = "UPDATE Batch SET Quantity=Quantity-" + purchseamnt + " where BatchID ='" + dgvBill.Rows[i].Cells[1].Value.ToString() + "' and itemid='" + dgvBill.Rows[i].Cells[0].Value.ToString() + "'";
clsConnection.SendQuery(query2);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
int rowCount = dgvBill.Rows.Count;
for (int x = rowCount - 1; x >= 0; x--)
{
dgvBill.Rows.RemoveAt(x);
}
checkboxItem.Enabled = true;
btnDiscount.Enabled = true;
txtDiscount.Enabled = true;
txtDiscount.Text = "";
txtTobePaid.Text = "";
txttotalAmount.Text = "";
txtaAmount.Text = "";
txtCustomerId.Text = "";
txtCusName.Text = "";
DataTable db1 = new DataTable();
try
{
dgvStockView.DataSource = classBatch.getItemsAvailable();
string query = "select top 1 orderid from sales order by orderid desc";
DataTable db = new DataTable();
db = clsConnection.GetData(query);
string OrderId = db.Rows[0][0].ToString();
int newOrdId = Int32.Parse(OrderId) + 1;
txtOrderId.Text = newOrdId.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
frmSalesInvoice frinvoice = new frmSalesInvoice(oid);
frinvoice.ShowDialog();
}
}
