public override void delete_button_Click(object sender, EventArgs e) { if (category_name_textBox.Text == "" || is_active_category_comboBox.SelectedIndex == -1) { MainClass.ShowMsg("Please enter a record to delete.", "error"); reset_disable(); enable_crude_buttons(); } else if (category_name_textBox.Enabled == true || is_active_category_comboBox.Enabled == true) { MainClass.ShowMsg("Please select record from the table.", "error"); reset_disable(); enable_crude_buttons(); } else if ((category_name_textBox.Enabled == false && is_active_category_comboBox.Enabled == false) && (category_name_textBox.Text != "" && is_active_category_comboBox.SelectedIndex != -1)) { try { DialogResult ans = MessageBox.Show("Are you sure you want to delete current record.", "CONFIRM?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (ans == DialogResult.Yes) { Hashtable ht = new Hashtable(); ht.Add("@id", categoryID); if (SQL_TASKS.insert_update_delete("st_deletecategories", ht) > 0) { MainClass.ShowMsg(category_name_textBox.Text + " deleted successfully.", "Success"); reset_disable(); enable_crude_buttons(); LoadCategory(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); reset_disable(); enable_crude_buttons(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); reset_disable(); sql_con.Close(); enable_crude_buttons(); } } }
private void purchaseinvoice_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (LoginCodeClass.isAdmin != true) { if (e.RowIndex != -1 && e.ColumnIndex != -1) { if (e.ColumnIndex == 6) { DataGridViewRow row = purchaseinvoice_dataGridView.Rows[e.RowIndex]; DialogResult dr = MessageBox.Show("Are you sure you want to delete?\n\nIt will affect your stock.", "PRODUCT DELETION", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { using (TransactionScope sc = new TransactionScope()) { Hashtable ht = new Hashtable(); ht.Add("@purchID", Convert.ToInt64(purchaseinvoice_comboBox.SelectedValue.ToString())); ht.Add("@userID", LoginCodeClass.USERID); ht.Add("@proID", Convert.ToInt32(row.Cells["productIDGV"].Value)); ht.Add("@quan", Convert.ToInt32(row.Cells["productquantityGV"].Value)); ht.Add("@date", DateTime.Today); SQL_TASKS.insert_update_delete("st_insertDeletedItemPI", ht); int q; object ob; ob = SQL_TASKS.getProductQuantity(Convert.ToInt32(row.Cells["productIDGV"].Value.ToString())); bool update = true; if (ob != null || Convert.ToInt32(ob) != 0) { update = true; } else { update = false; } if (update) { //update q = Convert.ToInt32(ob); q -= Convert.ToInt32(row.Cells["productquantityGV"].Value.ToString()); Hashtable ht1 = new Hashtable(); ht1.Add("@prodID", Convert.ToInt32(row.Cells["productIDGV"].Value.ToString())); ht1.Add("@quan", q); SQL_TASKS.insert_update_delete("st_updateSTOCK", ht1); Hashtable ht3 = new Hashtable(); ht3.Add("@purchaseinvoicedetailsID", Convert.ToInt64(row.Cells["purchaseinvoiceIDGV"].Value.ToString())); if (SQL_TASKS.insert_update_delete("st_deletePRODUCTSfromPURCHASEINVOICEDETAILS", ht3) > 0) { MainClass.ShowMsg("Deleted successfully.", "Success"); gross_total_price_label.Text = "0.00"; LoadPurchaseInvoiceDetails(); purchaseinvoice_comboBox.SelectedIndex = -1; } else { MainClass.ShowMsg("Unable to delete.", "Error"); gross_total_price_label.Text = "0.00"; purchaseinvoice_comboBox.SelectedIndex = -1; } sc.Complete(); } } } } } } else { throw new Exception("Admin cannot delete purchase invoice details.To delete purchase invoice details login with an user account."); } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); } }
public override void save_button_Click(object sender, EventArgs e) { if (category_name_textBox.Text == "" || is_active_category_comboBox.SelectedIndex == -1) { MainClass.ShowMsg("Please enter all required information.", "error"); reset_disable(); enable_crude_buttons(); } else { if (Convert.ToString(is_active_category_comboBox.SelectedItem) == "Yes") { stat = 1; //active } else if (Convert.ToString(is_active_category_comboBox.SelectedItem) == "No") { stat = 0; //in-active } if (edit == 0) //0 to add record { try { Hashtable ht = new Hashtable(); ht.Add("@name", category_name_textBox.Text); ht.Add("@isActive", stat); if (SQL_TASKS.insert_update_delete("st_insertcategories", ht) > 0) { MainClass.ShowMsg(category_name_textBox.Text + " added successfully to the system.", "Success"); reset_disable(); enable_crude_buttons(); LoadCategory(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); reset_disable(); enable_crude_buttons(); } LoadCategory(); enable_crude_buttons(); reset_disable(); } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "error"); reset_disable(); enable_crude_buttons(); } } else if (edit == 1) // to update record { if (Convert.ToString(is_active_category_comboBox.SelectedItem) == "Yes") { stat = 1; //active } else if (Convert.ToString(is_active_category_comboBox.SelectedItem) == "No") { stat = 0; //in-active } try { Hashtable ht = new Hashtable(); ht.Add("@id", categoryID); ht.Add("@name", category_name_textBox.Text); ht.Add("@isActive", stat); if (SQL_TASKS.insert_update_delete("st_updatecategories", ht) > 0) { MainClass.ShowMsg(category_name_textBox.Text + " updated successfully to the system.", "Success"); reset_disable(); enable_crude_buttons(); LoadCategory(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); reset_disable(); enable_crude_buttons(); } LoadCategory(); edit = 0; } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "error"); reset_disable(); enable_crude_buttons(); } } } }
public override void delete_button_Click(object sender, EventArgs e) { if (supplier_name_textBox.Text == "" || contact_person_textBox.Text == "" || phone1_textBox.Text == "" || address_textBox_suppliers.Text == "" || NTN_textBox.Text == "" || supplier_status_comboBox.SelectedIndex == -1) { MainClass.ShowMsg("Please enter a record to delete.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else if (supplier_name_textBox.Enabled == true || contact_person_textBox.Enabled == true || phone1_textBox.Enabled == true || address_textBox_suppliers.Enabled == true || NTN_textBox.Enabled == true || supplier_status_comboBox.Enabled == true) { MainClass.ShowMsg("Please select record from the table.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else if ((supplier_name_textBox.Enabled == false || contact_person_textBox.Enabled == false || phone1_textBox.Enabled == false || address_textBox_suppliers.Enabled == false || NTN_textBox.Enabled == false || supplier_status_comboBox.Enabled == false) && (supplier_name_textBox.Text != "" || contact_person_textBox.Text != "" || phone1_textBox.Text != "" || address_textBox_suppliers.Text != "" || NTN_textBox.Text != "" || supplier_status_comboBox.SelectedIndex != -1)) { try { DialogResult ans = MessageBox.Show("Are you sure you want to delete current record.", "CONFIRM?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (ans == DialogResult.Yes) { Hashtable ht = new Hashtable(); ht.Add("@supp_id", supplierID); if (SQL_TASKS.insert_update_delete("st_deleteSUPPLIERS", ht) > 0) { MainClass.ShowMsg(supplier_name_textBox.Text + " deleted successfully.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadSuppliers(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadSuppliers(); } } catch (Exception ex) { MessageBox.Show(ex.Message); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } }
public override void save_button_Click(object sender, EventArgs e) { if (product_name_textBox.Text == "" || barcode_textBox.Text == "" || dateTimePicker_expiry_products.Value < DateTime.Today || categories_comboBox.SelectedIndex == -1) { MainClass.ShowMsg("Please enter all required information.", "Error"); reset_disable(); enable_crude_buttons(); } else { if (edit == 0) //0 to add record { try { Hashtable ht = new Hashtable(); ht.Add("@productname", product_name_textBox.Text); ht.Add("@productbarcode", barcode_textBox.Text); ht.Add("@productexpirydate", dateTimePicker_expiry_products.Value); ht.Add("@productcategoryID", Convert.ToInt32(categories_comboBox.SelectedValue.ToString())); if (SQL_TASKS.insert_update_delete("st_insertPRODUCTS", ht) > 0) { MainClass.ShowMsg(product_name_textBox.Text + " added successfully to the system.", "Success"); reset_disable(); enable_crude_buttons(); LoadProducts(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); reset_disable(); enable_crude_buttons(); } LoadProducts(); enable_crude_buttons(); reset_disable(); } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); reset_disable(); enable_crude_buttons(); } } else if (edit == 1) // to update record { try { Hashtable ht = new Hashtable(); ht.Add("@productid", productID); ht.Add("@productname", product_name_textBox.Text); ht.Add("@productbarcode", barcode_textBox.Text); ht.Add("@productexpirydate", dateTimePicker_expiry_products.Value); ht.Add("@productcategoryID", Convert.ToInt32(categories_comboBox.SelectedValue.ToString())); if (SQL_TASKS.insert_update_delete("st_updatePRODUCTS", ht) > 0) { MainClass.ShowMsg(product_name_textBox.Text + " updated successfully to the system.", "Success"); reset_disable(); enable_crude_buttons(); LoadProducts(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); reset_disable(); enable_crude_buttons(); } edit = 0; } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); reset_disable(); enable_crude_buttons(); } } } }
public override void delete_button_Click(object sender, EventArgs e) { if (name_textBox.Text == "" || phone_number_textBox.Text == "" || password_textBox.Text == "" || email_textBox.Text == "") { MainClass.ShowMsg("Please enter a record to delete.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else if (name_textBox.Enabled == true || phone_number_textBox.Enabled == true || password_textBox.Enabled == true || email_textBox.Enabled == true) { MainClass.ShowMsg("Please select record from the table.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else if ((name_textBox.Enabled == false && phone_number_textBox.Enabled == false && password_textBox.Enabled == false && email_textBox.Enabled == false) && (name_textBox.Text != "" && phone_number_textBox.Text != "" && password_textBox.Text != "" && email_textBox.Text != "")) { try { DialogResult ans = MessageBox.Show("Are you sure you want to delete current record.", "CONFIRM?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (ans == DialogResult.Yes) { Hashtable ht = new Hashtable(); ht.Add("@id", USERID); if (SQL_TASKS.insert_update_delete("st_deleteusers", ht) > 0) { MainClass.ShowMsg("User deleted successfully.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadUsers(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadUsers(); } } catch (Exception ex) { MessageBox.Show(ex.Message); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } }
public override void save_button_Click(object sender, EventArgs e) { if (supplier_name_textBox.Text == "" || contact_person_textBox.Text == "" || phone1_textBox.Text == "" || address_textBox_suppliers.Text == "" || NTN_textBox.Text == "" || supplier_status_comboBox.SelectedIndex == -1) { MainClass.ShowMsg("Please enter all required information.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else { if (Convert.ToString(supplier_status_comboBox.SelectedItem) == "Active") { stat = 1; //active } else if (Convert.ToString(supplier_status_comboBox.SelectedItem) == "In-active") { stat = 0; //in-active } if (edit == false) //0 to add record { try { Hashtable ht = new Hashtable(); ht.Add("@suppliername", supplier_name_textBox.Text); ht.Add("@contactpersonname", contact_person_textBox.Text); ht.Add("@phone1", phone1_textBox.Text); ht.Add("@phone2", phone2_textBox.Text); ht.Add("@address", address_textBox_suppliers.Text); ht.Add("@ntn", NTN_textBox.Text); ht.Add("@status", stat); if (SQL_TASKS.insert_update_delete("st_insertSUPPLIERS", ht) > 0) { MainClass.ShowMsg(supplier_name_textBox.Text + " added successfully to the system.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadSuppliers(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } else if (edit == true) // to update record { if (Convert.ToString(supplier_status_comboBox.SelectedItem) == "Active") { stat = 1; //active } else if (Convert.ToString(supplier_status_comboBox.SelectedItem) == "In-active") { stat = 0; //in-active } try { Hashtable ht = new Hashtable(); ht.Add("@suppliername", supplier_name_textBox.Text); ht.Add("@contactpersonname", contact_person_textBox.Text); ht.Add("@phone1", phone1_textBox.Text); ht.Add("@phone2", phone2_textBox.Text); ht.Add("@address", address_textBox_suppliers.Text); ht.Add("@ntn", NTN_textBox.Text); ht.Add("@status", stat); ht.Add("@supp_id", supplierID); if (SQL_TASKS.insert_update_delete("st_updateSUPPLIERS", ht) > 0) { MainClass.ShowMsg(supplier_name_textBox.Text + " updated successfully.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadSuppliers(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } edit = false; loadSuppliers(); } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } } }
public override void save_button_Click(object sender, EventArgs e) { if (name_textBox.Text == "" || password_textBox.Text == "" || email_textBox.Text == "" || phone_number_label.Text == "" || status_comboBox.SelectedIndex == -1) { MainClass.ShowMsg("Please enter all required information.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else { if (Convert.ToString(status_comboBox.SelectedItem) == "Active") { stat = 1; //active } else if (Convert.ToString(status_comboBox.SelectedItem) == "In-active") { stat = 0; //in-active } if (edit == 0) //0 to add record { try { Hashtable ht = new Hashtable(); ht.Add("@name", name_textBox.Text); ht.Add("@email", email_textBox.Text); ht.Add("@password", password_textBox.Text); ht.Add("@phone", phone_number_textBox.Text); ht.Add("@status", stat); ht.Add("@role", role_textBox.Text); if (SQL_TASKS.insert_update_delete("st_insertusers", ht) > 0) { MainClass.ShowMsg("User added successfully to the system.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadUsers(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } else if (edit == 1) // to update record { if (Convert.ToString(status_comboBox.SelectedItem) == "Active") { stat = 1; //active } else if (Convert.ToString(status_comboBox.SelectedItem) == "In-active") { stat = 0; //in-active } try { if (name_textBox.Text == temp_name && phone_number_textBox.Text == temp_phone && password_textBox.Text == temp_password && email_textBox.Text == temp_mail && status_comboBox.Text == temp_status) { MainClass.ShowMsg("This record is already saved.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } Hashtable ht = new Hashtable(); ht.Add("@name", name_textBox.Text); ht.Add("@email", email_textBox.Text); ht.Add("@password", password_textBox.Text); ht.Add("@phone", phone_number_textBox.Text); ht.Add("@status", stat); ht.Add("@role", role_textBox.Text); ht.Add("@id", USERID); if (SQL_TASKS.insert_update_delete("st_updateusers", ht) > 0) { MainClass.ShowMsg("User updated successfully.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); loadUsers(); } else { MainClass.ShowMsg("Unable to save record.", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } edit = 0; loadUsers(); } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } } }
public override void save_button_Click(object sender, EventArgs e) { bool success = false; int che = 0; try { if (category_comboBox_product_pricing.SelectedIndex != -1 && product_pricing_dataGridView.Rows.Count != 0) { foreach (DataGridViewRow row in product_pricing_dataGridView.Rows) { if ((bool)row.Cells["selectGV"].FormattedValue == true) { ++che; float disc, pm, sp; disc = row.Cells["discountGV"].Value == null ? 0 : Convert.ToSingle(row.Cells["discountGV"].Value.ToString()); pm = row.Cells["profitmarginGV"].Value == null ? 0 : Convert.ToSingle(row.Cells["profitmarginGV"].Value.ToString()); Hashtable ht = new Hashtable(); ht.Add("@prodID", row.Cells["productIDGV"].Value.ToString()); ht.Add("@bp", Convert.ToSingle(row.Cells["buyingpriceGV"].Value.ToString())); if (disc == 0 && pm == 0) { sp = Convert.ToSingle(row.Cells["buyingpriceGV"].Value.ToString()); } else { sp = Convert.ToSingle(row.Cells["finalpriceGV"].Value.ToString()); } ht.Add("@sp", sp); ht.Add("@buyingdate", DateTime.Today); ht.Add("@profitper", pm); ht.Add("@discount", disc); ht.Add("@productbarcode", row.Cells["BarcodeGV"].Value.ToString()); if (SQL_TASKS.insert_update_delete("st_updatePRODUCTPRICE", ht) > 0) { success = true; } else { success = false; } } } if (success && che > 0) { MainClass.ShowMsg("Updated successfully...", "Success"); enable_crude_buttons(); che = 0; } else { throw new Exception("Unbale to update.Verify if the product is checked."); che = 0; } } else { throw new Exception("Select a product first!"); che = 0; } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); enable_crude_buttons(); che = 0; } }
public override void save_button_Click(object sender, EventArgs e) { if (purchase_dataGridView.Rows.Count == 0 || purchase_dataGridView.Rows.Count < 0) { MainClass.ShowMsg("Please enter all required information.", "error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } else { MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); try { using (TransactionScope sc = new TransactionScope()) { int compare, compareTO; here: for (int i = 0; i < purchase_dataGridView.Rows.Count; ++i) { compare = Convert.ToInt32(purchase_dataGridView.Rows[i].Cells["productIDGV"].Value); for (int j = i + 1; j < purchase_dataGridView.Rows.Count; ++j) { compareTO = Convert.ToInt32(purchase_dataGridView.Rows[j].Cells["productIDGV"].Value); if (compare == compareTO) { if (correctIT == false) { DialogResult dr = MessageBox.Show("You added a duplicate product which is not allowed.\n\nDo you want to remove that duplicate product and add its quantity?", "Duplicate product(s) encountered!", MessageBoxButtons.YesNo, MessageBoxIcon.Error); if (DialogResult.Yes == dr) { correctIT = true; goto here; } else { correctIT = false; throw new Exception("Duplicate products are not allowed!"); } } else { Int32 originalproductTOTAL, originalproductVALUE, dupliactedproductVALUE, dupliactedproductTOTAL; originalproductVALUE = Convert.ToInt32(purchase_dataGridView.Rows[i].Cells["productquantityGV"].Value); dupliactedproductVALUE = Convert.ToInt32(purchase_dataGridView.Rows[j].Cells["productquantityGV"].Value); originalproductTOTAL = Convert.ToInt32(purchase_dataGridView.Rows[i].Cells["totalGV"].Value); dupliactedproductTOTAL = Convert.ToInt32(purchase_dataGridView.Rows[j].Cells["totalGV"].Value); originalproductVALUE += dupliactedproductVALUE; originalproductTOTAL += dupliactedproductTOTAL; purchase_dataGridView.Rows[i].Cells["productquantityGV"].Value = originalproductVALUE; purchase_dataGridView.Rows[i].Cells["totalGV"].Value = originalproductTOTAL; int beforeREMOVE = purchase_dataGridView.Rows.Count; int afterREMOVE; purchase_dataGridView.Rows.Remove(purchase_dataGridView.Rows[j]); afterREMOVE = purchase_dataGridView.Rows.Count; if (afterREMOVE < beforeREMOVE) { MainClass.ShowMsg("Operation successfull.", "Success"); } else { throw new Exception("An error occured during removing duplicated products!"); } } } } } SQL_TASKS ss = new SQL_TASKS(); foreach (DataGridViewRow row in purchase_dataGridView.Rows) { //inserting purchase invoice purchaseinvoiceID_FROM_SQL_TASKS = ss.InsertPurchaseinvoice(DateTime.Today, LoginCodeClass.USERID, Convert.ToInt32(row.Cells["supplierIDGV"].Value)); //inserting purchase invoice details count += ss.insertPurchaseinvoicedetails(purchaseinvoiceID_FROM_SQL_TASKS, Convert.ToInt32(row.Cells["productIDGV"].Value.ToString()), Convert.ToInt32(row.Cells["productquantityGV"].Value.ToString()), Convert.ToSingle(row.Cells["totalGV"].Value.ToString())); SqlConnection sql_con = new SqlConnection(MainClass.connection()); SqlCommand cmd = new SqlCommand(); cmd.Connection = sql_con; cmd.CommandType = CommandType.Text; cmd.CommandText = "select pp_prodID from ProductPrice where pp_ProductBarcode='" + row.Cells["productbarcodeGV"].Value.ToString() + "' "; sql_con.Open(); object check = cmd.ExecuteScalar(); sql_con.Close(); if (check == null) //product not present { Hashtable ht1 = new Hashtable(); ht1.Add("@prodID", row.Cells["productIDGV"].Value.ToString()); ht1.Add("@bp", Convert.ToSingle(row.Cells["totalGV"].Value.ToString())); ht1.Add("@sp", DBNull.Value); ht1.Add("@buyingdate", DateTime.Today); ht1.Add("@profitper", DBNull.Value); ht1.Add("@discount", DBNull.Value); ht1.Add("@productbarcode", row.Cells["productbarcodeGV"].Value.ToString()); // inserting product price: if (SQL_TASKS.insert_update_delete("st_insertPRODUCTPRICE", ht1) > 0) { success = true; } else { success = false; } } else //product present { Hashtable ht2 = new Hashtable(); ht2.Add("@prodID", row.Cells["productIDGV"].Value.ToString()); cmd.CommandText = "select pp_buyingPrice from ProductPrice where pp_prodID='" + row.Cells["productIDGV"].Value.ToString() + "' "; sql_con.Open(); Int64 ExistingProductBuyingPrice = Convert.ToInt64(cmd.ExecuteScalar()); sql_con.Close(); Int64 finalp = Convert.ToInt64(row.Cells["totalGV"].Value) + ExistingProductBuyingPrice; Hashtable htx = new Hashtable(); htx.Add("@prodID", row.Cells["productIDGV"].Value.ToString()); htx.Add("@bp", finalp); if (SQL_TASKS.insert_update_delete("st_updatePRODUCTPRICEforPURCHASEINVOICE", htx) > 0) { success = true; } else { success = false; } } int q; object stockcount; bool DoesExist = SQL_TASKS.IfProductExist(Convert.ToInt64(row.Cells["productIDGV"].Value.ToString())); if (DoesExist) //if product does exist { //update stock stockcount = SQL_TASKS.getProductQuantityfromSTOCK(Convert.ToInt32(row.Cells["productIDGV"].Value.ToString())); q = Convert.ToInt32(stockcount); q += Convert.ToInt32(row.Cells["productquantityGV"].Value.ToString()); Hashtable hta = new Hashtable(); hta.Add("@prodID", Convert.ToInt32(row.Cells["productIDGV"].Value.ToString())); hta.Add("@quan", q); //updating stock: if (SQL_TASKS.insert_update_delete("st_updateSTOCK", hta) > 0) { success = true; } } else //if product does not exist { //insert Hashtable htb = new Hashtable(); htb.Add("@prodID", Convert.ToInt32(row.Cells["productIDGV"].Value.ToString())); htb.Add("@quan", Convert.ToInt32(row.Cells["productquantityGV"].Value.ToString())); // inserting stock: if (SQL_TASKS.insert_update_delete("st_insertSTOCK", htb) > 0) { success = true; } else { success = false; } } } if (count > 0 && success == true) { MainClass.ShowMsg("Purchase Invoice created successfully.", "Success"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); purchase_dataGridView.Rows.Clear(); gross_total_price_label.Text = ""; } else { MainClass.ShowMsg("Unable to create Purchase Invoice", "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); purchase_dataGridView.Rows.Clear(); gross_total_price_label.Text = ""; } sc.Complete(); } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); MainClass.disbale_reset(left_panel_sample2); enable_crude_buttons(); } } }
private void pay_button_Click(object sender, EventArgs e) { try { if (gross_textBox.Text != "" && discount_textBox.Text != "" && payment_Type_comboBox.SelectedIndex != -1 && change_to_give_textBox.Text != "" && amount_given_textBox.Text != "") { Hashtable ht = new Hashtable(); ht.Add("@done", LoginCodeClass.USERID); ht.Add("@date", DateTime.Now); ht.Add("@totalamt", Convert.ToSingle(gross_textBox.Text)); ht.Add("@totaldisc", Convert.ToSingle(discount_textBox.Text)); ht.Add("@givenamt", Convert.ToSingle(amount_given_textBox.Text)); ht.Add("@return", Convert.ToSingle(change_to_give_textBox.Text)); if (payment_Type_comboBox.SelectedIndex == 0) { ht.Add("@payType", 0); //0 means cash } else if (payment_Type_comboBox.SelectedIndex == 1) { ht.Add("@payType", 1);//1 means debit } else { ht.Add("@payType", 2); } //2 means credit DialogResult dr = MessageBox.Show("\n\tTotal Amount: " + gross_textBox.Text + "\n\tTotal Discount: " + discount_textBox.Text + "\n\tAmount Given: " + amount_given_textBox.Text + "\n\tAmount to return: " + change_to_give_textBox.Text + "\n\tPayment Type: " + payment_Type_comboBox.SelectedItem.ToString() + " \n\nAre you sure you want to submit current sales?", "Question...", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (DialogResult.Yes == dr) { using (TransactionScope sc = new TransactionScope()) { if (SQL_TASKS.insert_update_delete("st_insertSALES", ht) > 0) { foreach (DataGridViewRow row in sales_dataGridView.Rows) { int CurrentProductQuan = SQL_TASKS.getStockwrtProduct(Convert.ToInt32(row.Cells["ProductIDGV"].Value)); Hashtable ht1 = new Hashtable(); int x = CurrentProductQuan - Convert.ToInt32(row.Cells["ProductquantityGV"].Value); ht1.Add("@prodID", Convert.ToInt32(row.Cells["ProductIDGV"].Value)); ht1.Add("@quan", x); SQL_TASKS.insert_update_delete("st_updateSTOCK", ht1); Hashtable ht2 = new Hashtable(); ht2.Add("@saleID", SQL_TASKS.getLASTID("st_getSalesID")); ht2.Add("@prodID", Convert.ToInt64(row.Cells["productIDGV"].Value.ToString())); ht2.Add("@quantity", Convert.ToInt32(row.Cells["productquantityGV"].Value.ToString())); ht2.Add("@discount", Convert.ToSingle(row.Cells["discountGV"].Value.ToString())); ht2.Add("@sellingprice", Convert.ToSingle(row.Cells["TotalAmountGV"].Value.ToString())); SQL_TASKS.insert_update_delete("st_insertSalesDetails", ht2); } MainClass.ShowMsg("Record saved successfully.", "Success"); MainClass.disbale_reset(left_panel_sample2); sales_dataGridView.Rows.Clear(); SALES_REPORT sr = new SALES_REPORT(); sr.ShowDialog(); gross_total_price_label.Text = "0.00"; } else { throw new Exception("Unable to save record."); } sc.Complete(); } } } else { throw new Exception("Please fill all required fields."); } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); } }
//private void barcode_textBox_Validating(object sender, System.ComponentModel.CancelEventArgs e) //{ // try // { // if (barcode_textBox.Text != "") // { // if (sales_return_dataGridView.Rows.Count > 0) // { // using (TransactionScope sc = new TransactionScope()) // { // foreach (DataGridViewRow row in sales_return_dataGridView.Rows) // { // if (barcode_textBox.Text == row.Cells["BarcodeGV"].Value.ToString()) // { // DialogResult dr = MessageBox.Show("Are you sure you want to return " + row.Cells["ProductGV"].Value.ToString() + "?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); // if (dr == DialogResult.Yes) // { // //----------------------INSERTING RECORD TO REFUND TABLE------------------ // Hashtable htx = new Hashtable(); // htx.Add("@refSaleID", Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString())); // htx.Add("@refDate", DateTime.Now); // htx.Add("@refDoneBy", Convert.ToInt64(row.Cells["UserIDGV"].Value.ToString())); // htx.Add("@refProdID", Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString())); // htx.Add("@refQuantity", Convert.ToInt64(row.Cells["QuantityGV"].Value.ToString())); // htx.Add("@refAmount", Convert.ToSingle(row.Cells["ProductPriceGV"].Value.ToString())); // int x = 0; // x += SQL_TASKS.insert_update_delete("st_insertRefundReturn", htx); // if (x > 0) // { // MainClass.ShowMsg("Return and Refund Successfull", "Success"); // x = 0; // ht.Clear(); // } // else // { // throw new Exception("Something went wrong"); // } // //----------------------UPDATING STOCK------------------ // int currentQuantity = (int)SQL_TASKS.getProductQuantity(Convert.ToInt32((row.Cells["ProductIDGV"].Value.ToString()))); // int finalQuantity = currentQuantity - Convert.ToInt32(row.Cells["QuantityGV"].Value.ToString()); // Hashtable htinsetrStock = new Hashtable(); // htinsetrStock.Add("@prodID", Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString())); // htinsetrStock.Add("@quan", finalQuantity); // SQL_TASKS.insert_update_delete("st_updateSTOCK", htinsetrStock); // Int64 productID = Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString()); // float productPrice = Convert.ToSingle(row.Cells["ProductPriceGV"].Value.ToString()); // int product_quantity = Convert.ToInt32(row.Cells["QuantityGV"].Value.ToString()); // amount_refund += productPrice; // amount_to_refund_textBox.Text = Math.Round(amount_refund, 0).ToString(); // if (product_quantity == 0) // { // if (ht.ContainsKey(row.Cells["ProductIDGV"].Value)) // { // Int64 prodIDht = Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString()); // ht[prodIDht] = Convert.ToInt32(ht[prodIDht]) - 1; // } // else // { // ht.Add(row.Cells["ProductIDGV"].Value, 1); // } // sales_return_dataGridView.Rows.Remove(row); // } // else // { // row.Cells["QuantityGV"].Value = product_quantity; // row.Cells["PerProductTotalGV"].Value = Convert.ToSingle(row.Cells["PerProductTotalGV"].Value.ToString()); // if (ht.ContainsKey(row.Cells["ProductIDGV"].Value)) // { // Int64 prodIDht = Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString()); // ht[prodIDht] = Convert.ToInt32(ht[prodIDht]) + 1; // } // else // { // ht.Add(row.Cells["ProductIDGV"].Value, 1); // } // sales_return_dataGridView.Rows.Remove(row); // } // } // } // break; // } // sc.Complete(); // } // } // } // } // catch (Exception ex) // { // MainClass.ShowMsg(ex.Message, "Error"); // } //} private void return_button_Click(object sender, EventArgs e) { try { bool found = false; if (barcode_textBox.Text != "") { if (sales_return_dataGridView.Rows.Count > 0) { using (TransactionScope sc = new TransactionScope()) { foreach (DataGridViewRow row in sales_return_dataGridView.Rows) { if (barcode_textBox.Text == row.Cells["BarcodeGV"].Value.ToString()) { DialogResult dr = MessageBox.Show("Are you sure you want to return " + row.Cells["ProductGV"].Value.ToString() + "?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { //----------------------INSERTING RECORD TO REFUND TABLE------------------ Hashtable htx = new Hashtable(); htx.Add("@refSaleID", Convert.ToInt64(row.Cells["saleIDGV"].Value.ToString())); htx.Add("@refDate", DateTime.Now); htx.Add("@refDoneBy", Convert.ToInt64(row.Cells["UserIDGV"].Value.ToString())); htx.Add("@refProdID", Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString())); htx.Add("@refQuantity", Convert.ToInt64(row.Cells["QuantityGV"].Value.ToString())); htx.Add("@refAmount", Convert.ToSingle(row.Cells["ProductPriceGV"].Value.ToString())); int x = 0; x += SQL_TASKS.insert_update_delete("st_insertRefundReturn", htx); if (x > 0) { MainClass.ShowMsg("Return and Refund Successfull", "Success"); x = 0; ht.Clear(); } else { throw new Exception("Something went wrong"); } //----------------------UPDATING STOCK------------------ int currentQuantity = (int)SQL_TASKS.getProductQuantityfromSTOCK(Convert.ToInt64((row.Cells["ProductIDGV"].Value.ToString()))); int finalQuantity = currentQuantity - Convert.ToInt32(row.Cells["QuantityGV"].Value.ToString()); Hashtable htinsertStock = new Hashtable(); htinsertStock.Add("@prodID", row.Cells["ProductIDGV"].Value.ToString()); htinsertStock.Add("@quan", finalQuantity); SQL_TASKS.insert_update_delete("st_updateSTOCK", htinsertStock); Int64 productID = Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString()); float productPrice = Convert.ToSingle(row.Cells["ProductPriceGV"].Value.ToString()); int product_quantity = Convert.ToInt32(row.Cells["QuantityGV"].Value.ToString()); amount_refund += productPrice; amount_to_refund_textBox.Text = Math.Round(amount_refund, 0).ToString(); if (product_quantity == 0) { if (ht.ContainsKey(row.Cells["ProductIDGV"].Value)) { Int64 prodIDht = Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString()); ht[prodIDht] = Convert.ToInt32(ht[prodIDht]) - 1; } else { ht.Add(row.Cells["ProductIDGV"].Value, 1); } sales_return_dataGridView.Rows.Remove(row); SalesReturnReceipt srr = new SalesReturnReceipt(); srr.ShowDialog(); } else { row.Cells["QuantityGV"].Value = product_quantity; row.Cells["PerProductTotalGV"].Value = Convert.ToSingle(row.Cells["PerProductTotalGV"].Value.ToString()); if (ht.ContainsKey(row.Cells["ProductIDGV"].Value)) { Int64 prodIDht = Convert.ToInt64(row.Cells["ProductIDGV"].Value.ToString()); ht[prodIDht] = Convert.ToInt32(ht[prodIDht]) + 1; } else { ht.Add(row.Cells["ProductIDGV"].Value, 1); } sales_return_dataGridView.Rows.Remove(row); SalesReturnReceipt srr = new SalesReturnReceipt(); srr.ShowDialog(); } } found = true; } if (found) { break; } } sc.Complete(); } } } } catch (Exception ex) { MainClass.ShowMsg(ex.Message, "Error"); } }