public override void edit_button_Click(object sender, EventArgs e) { if (name_textBox.Text == "" || phone_textBox.Text == "" || address_textBox.Text == "" || password_textBox.Text == "" || username_textBox.Text == "" || roles_comboBox.SelectedIndex == -1) { CodingSourceClass.ShowMsg("Please select a record to edit.", "Error"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); } else { CodingSourceClass.enable(left_panel); edit = true; //editing option enabled add_button.Enabled = false; //can't add delete_button.Enabled = false; //can't delete view_button.Enabled = false; //can't view save_button.Enabled = true; //can save after editing } }
public static int insert_update_delete(string proc, Hashtable ht) { int res = 0; try { SqlConnection sql_con = new SqlConnection(CodingSourceClass.connection()); SqlCommand cmd = new SqlCommand(proc, sql_con); cmd.CommandType = CommandType.StoredProcedure; foreach (DictionaryEntry item in ht) { cmd.Parameters.AddWithValue(item.Key.ToString(), item.Value); } sql_con.Open(); //returns an integer which indicates how many rows have been affected res = cmd.ExecuteNonQuery(); sql_con.Close(); } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); } return(res); }
private void sales_invoice_comboBox_payments_SelectedIndexChanged(object sender, EventArgs e) { try { if (sales_invoice_comboBox_payments.SelectedIndex != -1) { Hashtable ht = new Hashtable(); ht.Add("@custID", Convert.ToInt32(customer_comboBox_payments.SelectedValue.ToString())); ht.Add("@salesinvoiceID", Convert.ToInt64(sales_invoice_comboBox_payments.SelectedValue.ToString())); double[] arr = SQL_TASKS.SaleInvoiceAmounts("st_getSALESINVOICEAMOUNT", ht); total_amount_textBox_payments.Text = arr[0].ToString(); amount_paid_textBox_payments.Text = arr[1].ToString(); remaining_amount_textBox_payments.Text = arr[2].ToString(); } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }
private void SALES_RETURN_Load(object sender, EventArgs e) { try { CodingSourceClass.disable_reset(left_panel); edit_button.Enabled = false; delete_button.Enabled = false; LoadSalesReturn(); SQL_TASKS.LoadList("st_getSHOPS", shop_comboBox_salesreturn, "ID", "Name"); base.delete_button.Text = "CANNOT DELETE"; base.delete_button.Enabled = false; base.edit_button.Text = "CANNOT EDIT"; base.edit_button.Enabled = false; } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }
//to be fixed //overloaded version: public static void load_roles_like(DataGridView dv, DataGridViewColumn RoleGV, string data) { SqlConnection sql_con = new SqlConnection(CodingSourceClass.connection()); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "st_getROLESlike"; cmd.Parameters.AddWithValue("@data", data); cmd.Connection = sql_con; cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter sqladp = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sqladp.Fill(dt); RoleGV.DataPropertyName = dt.Columns["Role"].ToString(); dv.DataSource = dt; } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); } }
public override void edit_button_Click(object sender, EventArgs e) { if (roles_textBox.Text == "" || roles_textBox.Enabled == true) { CodingSourceClass.ShowMsg("Please select a record to edit.", "Error"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); } else { CodingSourceClass.enable(left_panel); edit = true; add_button.Enabled = false; //can't add delete_button.Enabled = false; //can't delete view_button.Enabled = false; //can't view save_button.Enabled = true; } }
public override void edit_button_Click(object sender, EventArgs e) { try { if (shops_comboBox_customers.SelectedIndex == -1) { throw new Exception("Please select a record to edit."); } else { CodingSourceClass.enable(left_panel); edit = true; //editing option enabled add_button.Enabled = false; //can't add delete_button.Enabled = false; //can't delete view_button.Enabled = false; //can't view save_button.Enabled = true; //can save after editing } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }
private void PAYMENT_Load(object sender, EventArgs e) { try { edit_button.Enabled = false; LoadPayments(); SQL_TASKS.LoadList("st_getSHOPS", shop_comboBox_payments, "ID", "Name"); cheque_no_textBox.Visible = false; cheque_no_label.Visible = false; bank_and_branch_label.Visible = false; bank_and_branch_textBox.Visible = false; clearing_date_label.Visible = false; clearing_date_dateTimePicker.Visible = false; base.edit_button.Text = "CANNOT EDIT"; CodingSourceClass.disable_reset(left_panel); } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }
private void send_code_button_Click(object sender, EventArgs e) { if (email_address_textBox.Text == "") { CodingSourceClass.ShowMsg("Please enter email address.", "error"); } else { try { Random r = new Random(); x = r.Next(1, 1000000); //Generating 6-digit verification code SmtpClient cl = new SmtpClient("smtp.gmail.com"); cl.Port = 587; cl.Credentials = new System.Net.NetworkCredential("*****@*****.**", "syedkamranali90."); cl.EnableSsl = true; MailMessage mail = new MailMessage("*****@*****.**", email_address_textBox.Text, "VERIFICATION CODE", "Your confirmation code is " + x.ToString() + "."); cl.Send(mail); MessageBox.Show("A code is sent to " + email_address_textBox.Text + ".Enter code to verify it.", "CODE SENT...", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "error"); } } }
public static void LoadList(string proc, ComboBox cb, string valueMember, string displayMember) { try { cb.Items.Clear(); SqlConnection sql = new SqlConnection(CodingSourceClass.connection()); SqlCommand cmd = new SqlCommand(proc, sql); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); cb.DisplayMember = displayMember; cb.ValueMember = valueMember; cb.DataSource = dt; cb.SelectedIndex = -1; } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); } }
public static void load_data(string proc, DataGridView dv, ListBox lb) { try { SqlConnection sql_con = new SqlConnection(CodingSourceClass.connection()); SqlCommand command = new SqlCommand(proc, sql_con); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(command); DataTable dat = new DataTable(); adapter.Fill(dat); for (int i = 0; i < lb.Items.Count; i++) { string colName1 = ((DataGridViewColumn)lb.Items[i]).Name; dv.Columns[colName1].DataPropertyName = dat.Columns[i].ToString(); } dv.DataSource = dat; } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); } }
public override void view_button_Click(object sender, EventArgs e) { enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); LoadVendors(); }
public override void add_button_Click_1(object sender, EventArgs e) { CodingSourceClass.enable(left_panel); edit = false; //can't edit at the time of adding view_button.Enabled = false; //can't view delete_button.Enabled = false; //can't delete }
private void customers_Load(object sender, EventArgs e) { SQL_TASKS.LoadList("st_getSHOPS", shops_comboBox_customers, "ID", "Name"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); LoadCustomers(); }
private void USERS_Load(object sender, EventArgs e) { LoadUsers(); SQL_TASKS.LoadList("st_getROLESdata", roles_comboBox, "ID", "Role"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); }
private void ROLES_Load(object sender, EventArgs e) { LoadRoles(); SQL_TASKS.TotalRecords("getTOTALROLES", total_roles_label); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); //add,delete,update..... }
public override void add_button_Click_1(object sender, EventArgs e) { CodingSourceClass.enable(left_panel); edit = false; view_button.Enabled = false; delete_button.Enabled = false; }
public override void view_button_Click(object sender, EventArgs e) { CodingSourceClass.disable_reset(left_panel); LoadRoles(); CodingSourceClass.disable_reset(left_panel); SQL_TASKS.TotalRecords("getTOTALROLES", total_roles_label); }
private void users_dataGridView_CellClick_1(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { add_button.Enabled = false; if (edit == true) //updating member { save_button.Enabled = true; } else if (edit == false) //adding member { save_button.Enabled = false; } DataGridViewRow row = users_dataGridView.Rows[e.RowIndex]; userID = Convert.ToInt32(row.Cells[0].Value.ToString()); name_textBox.Text = row.Cells[1].Value.ToString(); username_textBox.Text = row.Cells[2].Value.ToString(); password_textBox.Text = row.Cells[3].Value.ToString(); phone_textBox.Text = row.Cells[4].Value.ToString(); address_textBox.Text = row.Cells[5].Value.ToString(); roles_comboBox.SelectedValue = row.Cells[6].Value; CodingSourceClass.disable(left_panel); delete_button.Enabled = true; edit_button.Enabled = true; save_button.Enabled = false; cancel_button.Enabled = true; view_button.Enabled = true; } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); } }
private void save_new_details_button_change_Click(object sender, EventArgs e) { try { if (new_password_textBox_change.Text != "" && admin_radioButton.Checked == true && other_radioButton.Checked == false) { Hashtable ht = new Hashtable(); ht.Add("@username", usernameGLOBAL); ht.Add("@password", new_password_textBox_change.Text); if (SQL_TASKS.insert_update_delete("st_updateAdminPASSWORD", ht) > 0) { CodingSourceClass.ShowMsg("Password changed successfully.", "Success"); clear(); sq.Close(); } else { throw new Exception("An error occured."); } } else if (new_password_textBox_change.Text != "" && admin_radioButton.Checked == false && other_radioButton.Checked == true) { Hashtable ht = new Hashtable(); ht.Add("@username", usernameGLOBAL); ht.Add("@password", new_password_textBox_change.Text); if (SQL_TASKS.insert_update_delete("st_updateUSERPASSWORD", ht) > 0) { CodingSourceClass.ShowMsg("Password changed successfully.", "Success"); clear(); sq.Close(); } else { throw new Exception("An error occured."); } } else { throw new Exception("Please fill all required fields properly."); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); sq.Close(); } }
public override void delete_button_Click(object sender, EventArgs e) { try { if (roles_textBox.Text != "" && roles_textBox.Enabled == false) { Hashtable ht = new Hashtable(); DialogResult dr = MessageBox.Show("Are you sure? ", "Question.....", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { //key , value ht.Add("@id", roleID); if (SQL_TASKS.insert_update_delete("st_deleteROLES", ht) > 0) { MainClass.CodingSourceClass.ShowMsg(roles_textBox.Text + " deleted successfully from the system.", "Success"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); LoadRoles(); SQL_TASKS.TotalRecords("getTOTALROLES", total_roles_label); } else { CodingSourceClass.ShowMsg("Unable to delete.", "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } } } else { CodingSourceClass.ShowMsg("Select a record to delete.", "Error"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }
private void save_settings_button_Click(object sender, EventArgs e) { try { bool windowsAuth; if (integrated_checkBox_settings.Checked) { if (server_name_textBox_settings.Text != "" && database_textBox_settings.Text != "") { windowsAuth = true; CodingSourceClass.createFile("\\bms_connect", windowsAuth, server_name_textBox_settings.Text, database_textBox_settings.Text); login log = new login(); CodingSourceClass.ShowWindow(log, this, MDI.ActiveForm); } else { CodingSourceClass.ShowMsg("Please fill all required fields", "Error"); } } else { if (server_name_textBox_settings.Text != "" && database_textBox_settings.Text != "" && username_textBox_settings.Text != "" && password_textBox_settings.Text != "") { windowsAuth = false; bool result = CodingSourceClass.createFile("\\bms_connect", windowsAuth, server_name_textBox_settings.Text, database_textBox_settings.Text, username_textBox_settings.Text, password_textBox_settings.Text); if (result == true) { login log = new login(); CodingSourceClass.ShowWindow(log, this, MDI.ActiveForm); LoginCodeClass.set_logged(true); } } else { LoginCodeClass.set_logged(false); CodingSourceClass.ShowMsg("Please fill all required fields", "Error"); } } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); } }
private void shops_Load(object sender, EventArgs e) { SQL_TASKS.LoadList("st_getVENDORSdata", vendors_comboBox_shops, "ID", "Vendor Name"); SQL_TASKS.LoadList("st_getUSERSwrtMANAGERS", managers_comboBox_shops, "ID", "Name"); CodingSourceClass.enable_reset(left_panel); enable_crud_buttons(); LoadShops(); }
private void verify_code_button_Click(object sender, EventArgs e) { if (x.ToString() == verification_code_textBox.Text) { disabled_new_details_label.Text = "ENABLED"; disable_control_panel.Enabled = true; } else { CodingSourceClass.ShowMsg("Incorrect code.", "error"); } }
private void logoutToolStripMenuItem1_Click(object sender, EventArgs e) { if (LoginCodeClass.get_logged() == true) { login lg = new login(); CodingSourceClass.ShowWindow(lg, MDI.ActiveForm); } else { CodingSourceClass.ShowMsg("Already logged out!", "Error"); } }
private void roles_button_Click(object sender, EventArgs e) { if (LoginCodeClass.isAdmin == true) { ROLES rl = new ROLES(); CodingSourceClass.ShowWindow(rl, MDI.ActiveForm); } else { CodingSourceClass.ShowMsg("You do not have permission to view roles.", "Error"); } }
private void users_button_Click(object sender, EventArgs e) { if (LoginCodeClass.isAdmin == true) { USERS us = new USERS(); CodingSourceClass.ShowWindow(us, MDI.ActiveForm); } else { CodingSourceClass.ShowMsg("You do not have permission to view users.", "Error"); } }
private void customers_dataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex != -1) { add_button.Enabled = false; if (edit == true) //updating member { save_button.Enabled = true; } else if (edit == false) //adding member { save_button.Enabled = false; } DataGridViewRow row = customers_dataGridView.Rows[e.RowIndex]; customerID = Convert.ToInt32(row.Cells[0].Value.ToString()); customer_name_textBox.Text = row.Cells["CustomernameGV"].Value.ToString(); shops_comboBox_customers.SelectedValue = Convert.ToInt32(row.Cells["ShopIDGV"].Value.ToString()); email_textBox_customers.Text = row.Cells["CustomeremailGV"].Value.ToString(); phone_textBox_customers.Text = row.Cells["CustomerphoneGV"].Value.ToString(); CodingSourceClass.disable(left_panel); delete_button.Enabled = true; edit_button.Enabled = true; save_button.Enabled = false; cancel_button.Enabled = true; view_button.Enabled = true; } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }
public static bool getlogindetails(string proc, Hashtable ht) { bool check = false; try { SqlConnection sql_con = new SqlConnection(MainClass.CodingSourceClass.connection()); SqlCommand cmd = new SqlCommand(proc, sql_con); cmd.CommandType = CommandType.StoredProcedure; foreach (DictionaryEntry item in ht) { cmd.Parameters.AddWithValue(item.Key.ToString(), item.Value); } sql_con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { check = true; while (dr.Read()) { USERID = Convert.ToInt32(dr[0].ToString()); NAME = dr[1].ToString(); ROLEID = Convert.ToInt32(dr[2].ToString()); ROLE = dr[3].ToString(); } } else { check = false; CodingSourceClass.ShowMsg("Invalid username or password", "Error"); } sql_con.Close(); } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); } return(check); }
public override void delete_button_Click(object sender, EventArgs e) { try { if (true) { Hashtable ht = new Hashtable(); DialogResult dr = MessageBox.Show("Are you sure? ", "Question.....", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { ht.Add("@payid", paymentID); if (SQL_TASKS.insert_update_delete("st_deletePAYMENTS", ht) > 0) { CodingSourceClass.ShowMsg("Record deleted successfully from the system.", "Success"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); LoadPayments(); } else { CodingSourceClass.ShowMsg("Unable to delete.An error occured.", "Error"); enable_crud_buttons(); CodingSourceClass.disable_reset(left_panel); } } } else { throw new Exception("Select a record to delete."); } } catch (Exception ex) { CodingSourceClass.ShowMsg(ex.Message, "Error"); CodingSourceClass.disable_reset(left_panel); enable_crud_buttons(); } }