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!"); } }