public void InsertNewProduct()
{
sqlCommandAB brandSql = new sqlCommandAB();
DataTable dt = brandSql.QueryDT("SELECT * FROM Product");
DataRow dr = dt.NewRow();
try { dr["categoryName"] = selectCat.SelectedItem.ToString(); }
catch (NullReferenceException) {
MessageBox.Show("Please Select a category first.");
}
dr["brandID"] = brandID;
dr["pCode"] = tb_itemBarCode.Text.ToString();
dr["pName"] = tb_itemName.Text.ToString();
try
{
dr["pCostPrice"] = Convert.ToDecimal(tb_itemStockPrice.Text);
dr["pSellingPrice"] = Convert.ToDecimal(tb_itemSellingPrice.Text);
dr["pReorderQty"] = Convert.ToInt32(ReorderPoint.Value);
dr["pQty"] = Convert.ToInt32(qty.Value);
}
catch (FormatException) {
MessageBox.Show("Check your input values");
}
dr["pDescription"] = tb_itemDescription.Text.ToString();
// dr["pImage"] = imageString;
dt.Rows.Add(dr);
brandSql.UpDate(dt);
}
public void InserPayment()
{
// MessageBox.Show((string)oNumberTB.Text + " " + (string)custNumberTB.Text + " " + Convert.ToDouble(orderAmount) + " " + Convert.ToInt32(orderQty) + " " +
// Convert.ToDouble(amountPaidTB.Text) + " " + (string)paymentCB.Text);
sqlCommandAB brandSql = new sqlCommandAB();
DataTable dt = brandSql.QueryDT("SELECT * FROM Payment");
DataRow dr = dt.NewRow();
dr["Order_Number"] = (string)oNumberTB.Text;
dr["staff_Number"] = (string)custNumberTB.Text;
dr["Customer_Number"] = (string)custNumberTB.Text;
dr["OrderAmount"] = Convert.ToDouble(orderAmount);
if (change > 0)
{
dr["pChange"] = Convert.ToDouble(change);
}
dr["OrderQuantity"] = Convert.ToInt32(orderQty);
try
{
dr["pAmount"] = Convert.ToDouble(amountPaidTB.Text);
}
catch (Exception) {
dr["pAmount"] = 0;
}
dr["pType"] = (string)paymentCB.Text;
dt.Rows.Add(dr);
brandSql.UpDate(dt);
}
public void insertUser()
{
sqlCommandAB iu = new sqlCommandAB();
DataTable dt = iu.QueryDT("SELECT * FROM loginLog");
DataRow dr = dt.NewRow();
dr["staff_Number"] = sNumber;
dr["staff_Name"] = sName;
dt.Rows.Add(dr);
iu.UpDate(dt);
}
public void InserNewCategory()
{
sqlCommandAB brandSql = new sqlCommandAB();
DataTable dt = brandSql.QueryDT("SELECT * FROM Category");
DataRow dr = dt.NewRow();
dr["categoryName"] = CategoryNameTB.Text;
dr["categoryDescription"] = Category_DescriptionTB.Text;
dt.Rows.Add(dr);
brandSql.UpDate(dt);
}
public void InsertNewBrand()
{
sqlCommandAB brandSql = new sqlCommandAB();
DataTable dt = brandSql.QueryDT("SELECT * FROM Brand");
DataRow dr = dt.NewRow();
dr["categoryName"] = selectCat.SelectedItem.ToString();
dr["brandName"] = brandNameTB.Text;
dr["brandDescription"] = brandDescriptionTB.Text;
dt.Rows.Add(dr);
brandSql.UpDate(dt);
}
private void insertSale()
{
sqlCommandAB saleQuery = new sqlCommandAB();
DataTable dt = saleQuery.QueryDT("SELECT * FROM sale");
DataRow dr = dt.NewRow();
dr["invoiceNumber"] = "Abrahale Kiros";
dr["qty"] = (counter + 1);
dr["total_profit"] = totalProfit;
dr["amountDue"] = pAmount;
dr["amountPayed"] = paidAmount;
dr["total_cost"] = totalCost;
dr["change"] = (paidAmount - pAmount);
dr["tithe"] = (double)totalProfit * 0.10;
dt.Rows.Add(dr);
saleQuery.UpDate(dt);
}
public void InserNewCustomer(Staff customer)
{
sqlCommandAB brandSql = new sqlCommandAB();
DataTable dt = brandSql.QueryDT("SELECT * FROM Staff");
DataRow dr = dt.NewRow();
dr["staff_Number"] = customer.staffNumber;
dr["staff_Name"] = customer.name;
dr["staff_Surname"] = customer.surname;
dr["staff_IDNumber"] = customer.IDnumber;
dr["staff_Gender"] = customer.gender;
dr["staff_Cell"] = customer.cell;
dr["staff_Email"] = customer.email;
dr["staff_Type"] = customer.type;
dr["staff_Username"] = customer.username;
dr["staff_Password"] = customer.password;
dr["staff_Remarks"] = customer.remarks;
dt.Rows.Add(dr);
brandSql.UpDate(dt);
}
public void InserNewCustomer(Customer customer)
{
sqlCommandAB brandSql = new sqlCommandAB();
DataTable dt = brandSql.QueryDT("SELECT * FROM Customer");
DataRow dr = dt.NewRow();
dr["Customer_Number"] = customer.username;
dr["Customer_Name"] = customer.name;
dr["Customer_Surname"] = customer.surname;
dr["Customer_IDNumber"] = customer.IDnumber;
dr["Customer_Gender"] = customer.gender;
dr["Customer_Cell"] = customer.cell;
dr["Customer_Tel"] = customer.tel;
dr["Customer_Email"] = customer.email;
dr["Customer_Address"] = customer.address;
dr["Customer_CreditLimit"] = customer.creditLimit;
dr["Customer_CreditBalance"] = customer.creditBalance;
dr["Customer_Password"] = customer.password;
dt.Rows.Add(dr);
brandSql.UpDate(dt);
}
private void buttonFinalizeOrder_Click(object sender, EventArgs e)
{
if (cart2.Rows.Count > 0)
{
DataTable orders = posSql.QueryDT("Select * FROM Orders");
DataRow orderRow = orders.NewRow();
orderRow["Order_Number"] = currentOrderNum.ToString();
if (custNumberTB.Text.ToString() != "")
{
orderRow["Customer_Number"] = custNumberTB.Text.ToString();
orderRow["staff_Number"] = Main.staffNumber.ToString();
double orderAmount = 0;
double orderQuantity = 0;
for (int i = 0; i < cart2.Rows.Count; i++)
{
try
{
orderAmount += Double.Parse(cart2.Rows[i]["pTotalAmount"].ToString());
orderQuantity += Double.Parse(cart2.Rows[i]["pQuantity"].ToString());
}
catch (Exception)
{
MessageBox.Show("Failed to compute Order amount and quantity.\nPlease make sure that InvoiceNumber input is correct.");
}
}
orderRow["OrderAmount"] = orderAmount.ToString();
orderRow["OrderQuantity"] = orderQuantity.ToString();
orderRow["OrderStatus"] = "Pending";
orders.Rows.Add(orderRow);
posSql.UpDate(orders);
if (sqlCommandAB.message == null)
{
MessageBox.Show("Order saved successfully.");
}
else
{
MessageBox.Show("Failed to save Order!");
MessageBox.Show(sqlCommandAB.message);
}
DataTable dt = posSql.QueryDT("Select * FROM OrderItem");
for (int i = 0; i < cart2.Rows.Count; i++)
{
DataRow row = dt.NewRow();
// string r =dt.Rows[0]["Order_Number"].ToString();
row["Order_Number"] = cart2.Rows[i]["Order_Number"].ToString();
row["pName"] = cart2.Rows[i]["pName"].ToString();
row["pCode"] = cart2.Rows[i]["pCode"].ToString();
row["pSellingPrice"] = cart2.Rows[i]["pSellingPrice"].ToString();
row["pQuantity"] = cart2.Rows[i]["pQuantity"].ToString();
row["pTotalAmount"] = cart2.Rows[i]["pTotalAmount"].ToString();
//if (cart2.Rows[i]["pDiscount"].ToString() != "")
//{
// row["pDiscount"] = cart2.Rows[i]["pDiscount"].ToString();
//}
//row["pVAT"] = cart2.Rows[i]["pVAT"].ToString();
dt.Rows.Add(row);
}
posSql.UpDate(dt);
if (sqlCommandAB.message == null)
{
dataGridView2.Rows.Clear();
DataTable dataOrders = posSql.QueryDT("Select Order_Number, staff_Number,OrderAmount, OrderQuantity, OrderStatus, OrderDate FROM Orders WHERE Customer_Number='" + custNumberTB.Text.ToString() + "'AND (OrderStatus ='Pending'OR OrderStatus='Installment')");
int len = dataOrders.Rows.Count;
String[] items = new String[len];
String[] row;
for (int i = 0; i < len; i++)
{
row = new String[] { (string)dataOrders.Rows[i]["Order_Number"], (string)dataOrders.Rows[i]["staff_Number"], dataOrders.Rows[i]["OrderAmount"].ToString(), dataOrders.Rows[i]["OrderQuantity"].ToString(), (string)dataOrders.Rows[i]["OrderStatus"], dataOrders.Rows[i]["OrderDate"].ToString() };
dataGridView2.Rows.Add(row);
}
// conn.updateQuery(query);
// dataGridView2.DataSource = conn.getData();
ClearAll();
}
else
{
MessageBox.Show("Failed to save Cart!");
}
}
else
{
MessageBox.Show("Customer number is missing. Please select the customer.");
}
}
else
{
MessageBox.Show("Can't save an empty cart!");
}
}
