public static Int64 getCustIDwrtPhone(string phone) { Int64 custID = 0; try { SqlCommand cmd = new SqlCommand("st_getCustIdWRTPhone", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@phone", phone); MainClass.con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { custID = Convert.ToInt64(dr["CustomerID"].ToString()); CUSTOMER = dr["Name"].ToString(); ADDRESS = dr["Address"].ToString(); } } else { custID = 0; CUSTOMER = ""; ADDRESS = ""; } MainClass.con.Close(); } catch (Exception ex) { MainClass.con.Close(); MainClass.showMessage(ex.Message, "error"); } return(custID); }
public static void updateCustomer(Int64 cid, string name, string phone, string address) { try { SqlCommand cmd = new SqlCommand("st_updateCustomer", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@phone", phone); cmd.Parameters.AddWithValue("@address", address); cmd.Parameters.AddWithValue("@cID", cid); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage(name + " updated successfully into the system.", "success"); } } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to update customer.\nContact technical support", "error"); } }
public static void getUsers(DataGridView gv, DataGridViewColumn userIDgv, DataGridViewColumn nameGV, DataGridViewColumn usernameGV, DataGridViewColumn passGV, DataGridViewColumn phoneGV, DataGridViewColumn addressGV, DataGridViewColumn roleIDGV, DataGridViewColumn roleGV) { try { SqlCommand cmd = new SqlCommand("st_getUsers", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable();; da.Fill(dt); userIDgv.DataPropertyName = dt.Columns["User ID"].ToString(); nameGV.DataPropertyName = dt.Columns["User"].ToString(); usernameGV.DataPropertyName = dt.Columns["Username"].ToString(); passGV.DataPropertyName = dt.Columns["Password"].ToString(); phoneGV.DataPropertyName = dt.Columns["Phone"].ToString(); addressGV.DataPropertyName = dt.Columns["Address"].ToString(); roleIDGV.DataPropertyName = dt.Columns["Role ID"].ToString(); roleGV.DataPropertyName = dt.Columns["Role"].ToString(); gv.DataSource = dt; MainClass.sno(gv, "snoGV"); } catch (Exception ex) { MainClass.showMessage(ex.Message, " error"); } }
public static void updateMenuItem(int menuID, string name, float price, int catID, int status) { try { SqlCommand cmd = new SqlCommand("st_updateMenuItem", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@price", price); cmd.Parameters.AddWithValue("@catID", catID); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@menuID", menuID); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage("Menu Item '" + name + "' updated successfully into the system.", "success"); } } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to update the Menu Item.\nContact technical support", "error"); } }
public static void updateUsers(int userID, string name, string uname, string pass, string address, string phone, Int16 roleID) { try { SqlCommand cmd = new SqlCommand("st_updateUsers", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@username", uname); cmd.Parameters.AddWithValue("@password", pass); cmd.Parameters.AddWithValue("@address", address); cmd.Parameters.AddWithValue("@phone", phone); cmd.Parameters.AddWithValue("@roleID", roleID); cmd.Parameters.AddWithValue("@userID", userID); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage(name + " updated successfully into the system", "success"); } } catch (Exception ex) { MainClass.con.Close(); MainClass.showMessage("Unable to update the user.\nContact technical support", "error"); } }
public static void insertOrder(DateTime date, Int64 custID, Int16 orderType, Int16 floorID, Int16 tableID, float tamount, float amountPaid, float amtReturned, Int16 status) { try { SqlCommand cmd = new SqlCommand("st_insertOrder", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@date", date); cmd.Parameters.AddWithValue("@custID", custID); cmd.Parameters.AddWithValue("@orderType", orderType); cmd.Parameters.AddWithValue("@floorID", floorID); cmd.Parameters.AddWithValue("@tableID", tableID); cmd.Parameters.AddWithValue("@tAmount", tamount); cmd.Parameters.AddWithValue("@amtPaid", amountPaid); cmd.Parameters.AddWithValue("@amtReturned", amtReturned); cmd.Parameters.AddWithValue("@status", status); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage("Order placed successfully.", "success"); } } catch (Exception ex) { MainClass.con.Close(); MainClass.showMessage(ex.Message, "error"); } }
public static void deleteData(string procedure, string param, int value1 = 0, Int64 value2 = 0) { try { SqlCommand cmd = new SqlCommand(procedure, MainClass.con); cmd.CommandType = CommandType.StoredProcedure; if (value1 != 0) { cmd.Parameters.AddWithValue(param, value1); } if (value2 != 0) { cmd.Parameters.AddWithValue(param, value2); } MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage(" Data deleted successfully from the system", "success"); } } catch (Exception ex) { MainClass.con.Close(); MainClass.showMessage(ex.Message, "error"); } }
public static void loadReport(ReportDocument rd, CrystalReportViewer crv, Int16 status, string phone = null, int?tableID = null) { try { SqlCommand cmd = new SqlCommand("st_getOrderReport", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; if (phone == null) { cmd.Parameters.AddWithValue("@tableID", tableID); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@phone", DBNull.Value); } else { cmd.Parameters.AddWithValue("@phone", phone); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@tableID", DBNull.Value); } SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); rd.Load(Application.StartupPath + "\\Reports\\billReport.rpt"); rd.SetDataSource(dt); crv.ReportSource = rd; crv.RefreshReport(); } catch (Exception ex) { if (rd != null) { rd.Close(); } MainClass.showMessage(ex.Message, "error"); } }
public override void savebtn_Click(object sender, EventArgs e) { if (rolesTxt.Text == "") { rolesErrorLabel.Visible = true; } else { rolesErrorLabel.Visible = false; } if (rolesErrorLabel.Visible) { MainClass.showMessage("Fields with * are mandatory", "Error"); } else { if (edit == 0) { insertion.insertRole(rolesTxt.Text); MainClass.resetDisable(leftpanel); RetrivalData.getRoles(dataGridView1, RoleIDGV, RoleGV); } else if (edit == 1) { Updates.updateRole(rolesTxt.Text, roleID); MainClass.resetDisable(leftpanel); RetrivalData.getRoles(dataGridView1, RoleIDGV, RoleGV); } } }
private void itemDD_SelectedIndexChanged(object sender, EventArgs e) { if (itemDD.SelectedIndex != -1) { try { itemEL.Visible = false; SqlCommand cmd = new SqlCommand("st_getPriceWRTitem", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mid", Convert.ToInt32(itemDD.SelectedValue.ToString())); MainClass.con.Open(); priceTxt.Text = Math.Round(Convert.ToDouble(cmd.ExecuteScalar().ToString()), 0).ToString(); MainClass.con.Close(); DataRowView drv = itemDD.SelectedItem as DataRowView; RetrivalData.loadCategoryWRTItem(drv["Menu Name"].ToString()); } catch (Exception ex) { MainClass.showMessage(ex.Message, "error"); } } else { itemEL.Visible = true; priceTxt.Text = ""; } }
private void phoneTxt_Leave(object sender, EventArgs e) { try { if (phoneTxt.Text != "") { RetrivalData.getOrderBill(phoneTxt.Text, dataGridView1, ItemGV, QuantGV, amountGV, orderIDGV, totalAmountGV); BillLabel.Text = Math.Round(Convert.ToDouble(dataGridView1.Rows[0].Cells["totalAmountGV"].Value.ToString()), 0).ToString(); orderidTxt.Text = dataGridView1.Rows[0].Cells["orderIDGV"].Value.ToString(); } } catch (Exception) { MainClass.showMessage("No order found", "error"); } }
private void phonetxt_Leave(object sender, EventArgs e) { if (phonetxt.Text != "") { PhoneEL.Visible = false; custID = RetrivalData.getCustIDwrtPhone(phonetxt.Text); if (custID == 0) { customersWindow cw = new customersWindow(); MainClass.showWindow(cw, this, MDI.ActiveForm); } else { MainClass.showMessage(RetrivalData.CUSTOMER + "\n" + RetrivalData.ADDRESS + "\n", "success"); } } }
private void insertOrderDetails() { Int64 orderID = RetrivalData.lastOrderID(); int count = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { count += insertion.insertOrderDetails(orderID, Convert.ToInt32(row.Cells["itemIDGV"].Value.ToString()), Convert.ToInt16(row.Cells["QuantityGV"].Value.ToString())); } if (count > 0) { } else { MainClass.showMessage("An Error Occured", "error"); } }
public static void getPendingOrders(DataGridView gv, DataGridViewColumn orderIDGV, DataGridViewColumn statusGV) { try { SqlCommand cmd = new SqlCommand("st_getOrders", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); orderIDGV.DataPropertyName = dt.Columns["OrderID"].ToString(); statusGV.DataPropertyName = dt.Columns["Status"].ToString(); gv.DataSource = dt; } catch (Exception ex) { MainClass.showMessage(ex.Message, "error"); } }
public static void getCategory(DataGridView gv, DataGridViewColumn catIDGV, DataGridViewColumn catGV) { try { SqlCommand cmd = new SqlCommand("st_getCategories", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable();; da.Fill(dt); catIDGV.DataPropertyName = dt.Columns["ID"].ToString(); catGV.DataPropertyName = dt.Columns["Category"].ToString(); gv.DataSource = dt; MainClass.sno(gv, "snoGV"); } catch (Exception ex) { MainClass.showMessage(ex.Message, " error"); } }
public static void getPendingOrderdetails(Int64 orderid, DataGridView gv, DataGridViewColumn prodGV, DataGridViewColumn quantityGV) { try { SqlCommand cmd = new SqlCommand("st_getOrderDetails", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", orderid); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); prodGV.DataPropertyName = dt.Columns["Item"].ToString(); quantityGV.DataPropertyName = dt.Columns["Quantity"].ToString(); gv.DataSource = dt; } catch (Exception ex) { MainClass.showMessage(ex.Message, "error"); } }
public static bool ValidUser(string user, string pass) { bool status = false; try { SqlCommand cmd = new SqlCommand("st_getUserAuth", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@user", user); cmd.Parameters.AddWithValue("@pass", pass); MainClass.con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { if (user == dr["Username"].ToString() && pass == dr["Password"].ToString()) { USER = dr["User"].ToString(); ROLE = dr["Role"].ToString(); status = true; } else { MainClass.showMessage("Invalid username or password.", "error"); status = false; } } } else { MainClass.showMessage("Invalid username or password.", "error"); status = false; } MainClass.con.Close(); } catch (Exception ex) { MainClass.showMessage(ex.Message, "error"); } return(status); }
public static void insertCategory(string name) { try { SqlCommand cmd = new SqlCommand("st_insertCategory", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", name); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage("Category " + name + " added successfully into the system.", "success"); } } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to save the Category.\nThe table may already exist.\nContact technical support", "error"); } }
public static int insertOrderDetails(Int64 orderID, int proID, Int16 quantity) { int res = 0; try { SqlCommand cmd = new SqlCommand("st_insertOrderDetails", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", orderID); cmd.Parameters.AddWithValue("@proID", proID); cmd.Parameters.AddWithValue("@quantity", quantity); MainClass.con.Open(); res = cmd.ExecuteNonQuery(); MainClass.con.Close(); } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to save the Menu Item.\nThe table may already exist.\nContact technical support", "error"); } return(res); }
public static void getTables(DataGridView gv, DataGridViewColumn floorIDGV, DataGridViewColumn floornameGV, DataGridViewColumn tableNameGV, DataGridViewColumn tableIDGV, DataGridViewColumn chairsGV) { try { SqlCommand cmd = new SqlCommand("st_getTables", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable();; da.Fill(dt); floorIDGV.DataPropertyName = dt.Columns["Floor ID"].ToString(); floornameGV.DataPropertyName = dt.Columns["Floor"].ToString(); tableIDGV.DataPropertyName = dt.Columns["Table ID"].ToString(); chairsGV.DataPropertyName = dt.Columns["Chairs"].ToString(); tableNameGV.DataPropertyName = dt.Columns["Table Number"].ToString(); gv.DataSource = dt; MainClass.sno(gv, "snoGV"); } catch (Exception ex) { MainClass.showMessage(ex.Message, " error"); } }
public static int updateOrder(Int64 orderID, float amountPaid, float amtReturned, Int16 status) { int res = 0; try { SqlCommand cmd = new SqlCommand("st_updateOrder", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@amtPaid", amountPaid); cmd.Parameters.AddWithValue("@amtReturned", amtReturned); cmd.Parameters.AddWithValue("@status", status); cmd.Parameters.AddWithValue("@orderID", orderID); MainClass.con.Open(); res = cmd.ExecuteNonQuery(); } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to save the Order.", "error"); } return(res); }
public static void getOrderBill(int tableID, DataGridView gv, DataGridViewColumn itemGV, DataGridViewColumn quantGV, DataGridViewColumn amountGV, DataGridViewColumn orderID, DataGridViewColumn totalAmountGV) { try { SqlCommand cmd = new SqlCommand("st_getOrderSDetailsWRTtables", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tableId", tableID); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); itemGV.DataPropertyName = dt.Columns["Item"].ToString(); quantGV.DataPropertyName = dt.Columns["Quantity"].ToString(); amountGV.DataPropertyName = dt.Columns["Price"].ToString(); orderID.DataPropertyName = dt.Columns["ID"].ToString(); totalAmountGV.DataPropertyName = dt.Columns["Toatl Amount"].ToString(); gv.DataSource = dt; } catch (Exception ex) { MainClass.showMessage(ex.Message, "error"); } }
public static void updateCategory(string name, int catID) { try { SqlCommand cmd = new SqlCommand("st_updateCategory", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@id", catID); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage(name + " updated successfully into the system", "success"); } } catch (Exception ex) { MainClass.con.Close(); MainClass.showMessage(ex.Message, "Error"); } }
public static void updateOrderStatus(Int64 orderID, Int16 status) { try { SqlCommand cmd = new SqlCommand("st_updateOrderStatus", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@orderID", orderID); cmd.Parameters.AddWithValue("@status", status); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage("Order status updated.", "success"); } } catch (Exception ex) { MainClass.con.Close(); MainClass.showMessage("Unable to update ordder status.", "error"); } }
public static void updateFloors(Int16 floorID, string name, Int16 number) { try { SqlCommand cmd = new SqlCommand("st_updateFloors", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@floor", name); cmd.Parameters.AddWithValue("@floorNumber", number); cmd.Parameters.AddWithValue("@floorID", floorID); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage(name + " added successfully into the system.", "success"); } } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to updated floor.\nContact technical support", "error"); } }
public static void insertTables(int tableNumber, Int16 chairs, Int16 floorID) { try { SqlCommand cmd = new SqlCommand("st_insertTables", MainClass.con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tableNumber", tableNumber); cmd.Parameters.AddWithValue("@chairs", chairs); cmd.Parameters.AddWithValue("@floorID", floorID); MainClass.con.Open(); int res = cmd.ExecuteNonQuery(); MainClass.con.Close(); if (res > 0) { MainClass.showMessage(tableNumber + " added successfully into the system.", "success"); } } catch (Exception) { MainClass.con.Close(); MainClass.showMessage("Unable to save table.\nThe table may already exist.\nContact technical support", "error"); } }
private void savebtn_Click(object sender, EventArgs e) { if (iscb.Checked) { if (serverTxt.Text == "") { serverErrorLabel.Visible = true; } else { serverErrorLabel.Visible = false; } if (databaseTxt.Text == "") { DbErrorLabel.Visible = true; } else { DbErrorLabel.Visible = false; } if (serverErrorLabel.Visible || DbErrorLabel.Visible) { MainClass.showMessage("Fields with * are mandatory.", "error"); } else { connection = "Data Source=" + serverTxt.Text + ";Initial Catalog=" + databaseTxt.Text + ";Integrated Security=true;MultipleActiveResultSets=true"; saveConnection(); DialogResult dr = MessageBox.Show("Settings saved succesfully."); if (dr == DialogResult.OK) { LoginScreen ls = new LoginScreen(); MainClass.showWindow(ls, this, MDI.ActiveForm); } } } else { if (serverTxt.Text == "") { serverErrorLabel.Visible = true; } else { serverErrorLabel.Visible = false; } if (databaseTxt.Text == "") { DbErrorLabel.Visible = true; } else { DbErrorLabel.Visible = false; } if (userTxt.Text == "") { UserErrorLabel.Visible = true; } else { UserErrorLabel.Visible = false; } if (passTxt.Text == "") { PassErrorLabel.Visible = true; } else { PassErrorLabel.Visible = false; } if (serverErrorLabel.Visible || DbErrorLabel.Visible || UserErrorLabel.Visible || PassErrorLabel.Visible) { MainClass.showMessage("Fields with * are mandatory.", "error"); } else { connection = "Data Source=" + serverTxt.Text + ";Initial Catalog=" + databaseTxt.Text + ";User Id=" + userTxt.Text + ";Password="******";MultipleActiveResultSets=true"; saveConnection(); DialogResult dr = MessageBox.Show("Settings saved succesfully."); if (dr == DialogResult.OK) { LoginScreen ls = new LoginScreen(); MainClass.showWindow(ls, this, MDI.ActiveForm); } } } }
private void cartButton_Click(object sender, EventArgs e) { if (MainClass.checkControls(leftpanel).Count != 0) { MainClass.showMessage("Please enter all the required field", "error"); } else { bool check = false; foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells["itemIDGV"].Value.ToString() == itemDD.SelectedValue.ToString()) { check = true; break; } } DataRowView drvFloor = floorDD.SelectedItem as DataRowView; DataRowView drvTable = tableDD.SelectedItem as DataRowView; DataRowView drvItems = itemDD.SelectedItem as DataRowView; try { if (check) { MainClass.showMessage("Item added already!", "error"); } else { catID = RetrivalData.CATEGORYID; catName = RetrivalData.CATEGORYNAME; if (orderDD.SelectedIndex == 0) { totalAmount += Convert.ToSingle(priceTxt.Text) * Convert.ToSingle(numericUpDown1.Value); totalLabel.Text = totalAmount.ToString(); dataGridView1.Rows.Add(null, Convert.ToInt32(tableDD.SelectedValue.ToString()), Convert.ToInt32(floorDD.SelectedValue.ToString()), catID, catName, Convert.ToInt32(itemDD.SelectedValue.ToString()), drvItems["Menu Name"], Convert.ToSingle(priceTxt.Text), Convert.ToInt32(numericUpDown1.Text), orderDD.SelectedItem.ToString(), drvFloor["Floor"], drvTable["Table Number"], null); } else if (orderDD.SelectedIndex == 1 || orderDD.SelectedIndex == 2) { totalAmount += Convert.ToSingle(priceTxt.Text) * Convert.ToSingle(numericUpDown1.Value); totalLabel.Text = totalAmount.ToString(); dataGridView1.Rows.Add(null, null, null, catID, catName, Convert.ToInt32(itemDD.SelectedValue.ToString()), drvItems["Menu Name"], Convert.ToSingle(priceTxt.Text), Convert.ToInt32(numericUpDown1.Text), orderDD.SelectedItem.ToString(), null, null, phonetxt.Text); } } } catch (Exception) { MainClass.showMessage("Please enter all the fields.", "error"); } } MainClass.sno(dataGridView1, "snoGV"); }