private void DeleteVend_Click(object sender, EventArgs e) { try { string b = this.VendorList.SelectedRows[0].Cells[0].Value.ToString(); DialogResult dialogResult = MessageBox.Show("Are you you want to delete " + VendorName.Text + "?", "Delete?", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { foreach (DataGridViewRow row in this.VendorList.SelectedRows) { //Logical delete in database dbConnect.Update("Update tblVendor set boolVendIsDel = true where strVendCode = '" + row.Cells[0].Value.ToString() + "';"); } AddVend.Visible = true; button3.Visible = false; CancelVend.Visible = false; VendorName.Clear(); //to generate new code and refresh vendors after this.VendorCode.Text = codeGenerator.generateCodeParent("tblVendor", "strVendCode", "Vendor"); //refresh VendorList refreshVendors(); } else if (dialogResult == DialogResult.No) { } } catch (ArgumentOutOfRangeException) { MessageBox.Show("No selected item"); } }
private void AddVend_Click(object sender, EventArgs e) { string txtVendCode = VendorCode.Text; string txtVendName = VendorName.Text; if (VendorName.Text != "") { //search if existing if (!isExisting(txtVendName, VendorList)) { dbConnect.Insert("insert into tblVendor values('" + txtVendCode + "','" + txtVendName + "',false);"); } //Generate new Vendor Code this.VendorCode.Text = codeGenerator.generateCodeParent("tblVendor", "strVendCode", "Vendor"); //refresh VendorList refreshVendors(); VendorName.Clear(); this.Close(); } else { MessageBox.Show("Input a Vendor name"); } }
private void Delete_Click(object sender, EventArgs e) { try { Connect connectObj = new Connect(); con = connectObj.connect(); SqlCommand cmd = new SqlCommand("DELETE FROM VENDOR WHERE VID = @vid", con); cmd.Parameters.AddWithValue("@vid", VendorID.Text); int i = cmd.ExecuteNonQuery(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Customer Deletion Successful!"); } else { MessageBox.Show("Customer Deletion Failed"); } con.Close(); //Clear the fields VendorID.Clear(); VendorName.Clear(); } catch (Exception ex) { MessageBox.Show("Vendor Not found"); } }
private void clear_Click(object sender, EventArgs e) { VendorName.Clear(); VendorAddress.Clear(); PhoneNumber.Clear(); email.Clear(); VendorID.Clear(); }
private void clear_Click(object sender, EventArgs e) { VendorName.Clear(); VendorAddress.Clear(); VendorPhoneNo.Clear(); Email.Clear(); VendorID.Clear(); VendorName2.Clear(); }
private void submit_Click(object sender, EventArgs e) { if (VendorName.Text == "" || VendorAddress.Text == "" || PhoneNO.Text == "" || Email.Text == "" || VendorID.Text == "") { MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (PhoneNO.Text.Length != 10) { MessageBox.Show("Enter valid Phone number", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { Connect connectObj = new Connect(); con = connectObj.connect(); SqlCommand cmd = new SqlCommand("Insert into VENDOR (vid,vname,address,phone_number,email) values(@id,@vname,@address,@phno,@email);", con); cmd.Parameters.AddWithValue("@id", VendorID.Text); cmd.Parameters.AddWithValue("@vname", VendorName.Text); cmd.Parameters.AddWithValue("@phno", Convert.ToInt64(PhoneNO.Text)); cmd.Parameters.AddWithValue("@address", VendorAddress.Text); cmd.Parameters.AddWithValue("@email", Email.Text); int i = cmd.ExecuteNonQuery(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Vendor Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Vendor Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); //Clear all the fields. VendorName.Clear(); VendorAddress.Clear(); PhoneNO.Clear(); Email.Clear(); VendorID.Clear(); } catch (Exception ex) { MessageBox.Show("Failed!! Try with Different ID!!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (con != null) { con.Close(); } } }
private void CancelVend_Click(object sender, EventArgs e) { AddVend.Visible = true; DeleteVend.Visible = true; button3.Visible = false; CancelVend.Visible = false; VendorName.Clear(); //to generate new code and refresh vendors after this.VendorCode.Text = codeGenerator.generateCodeParent("tblVendor", "strVendCode", "Vendor"); refreshVendors(); }
private void Cancel_Click(object sender, RoutedEventArgs e) { VendorName.Clear(); BillNo.Clear(); OrderNo.Clear(); BillDate.Clear(); DueDate.Clear(); SubTotal.Clear(); Adjustment.Clear(); Total.Clear(); CustNotes.Clear(); TermAndCondns.Clear(); }
private void update_Click(object sender, EventArgs e) { if (VendorName.Text == "" || VendorAddress.Text == "" || PhoneNumber.Text == "" || email.Text == "" || VendorID.Text == "") { MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { Connect connectObj = new Connect(); con = connectObj.connect(); SqlCommand cmd = new SqlCommand("UPDATE VENDOR SET vname = @vname,address = @address,phone_number = @phno,email = @email WHERE vid = @id;", con); cmd.Parameters.AddWithValue("@id", VendorID.Text); cmd.Parameters.AddWithValue("@vname", VendorName.Text); cmd.Parameters.AddWithValue("@phno", Convert.ToInt64(PhoneNumber.Text)); cmd.Parameters.AddWithValue("@address", VendorAddress.Text); cmd.Parameters.AddWithValue("@email", email.Text); int i = cmd.ExecuteNonQuery(); //If count is equal to 1, than show frmMain form if (i != 0) { MessageBox.Show("Vendor Updation Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Vendor Updation Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } con.Close(); } catch (Exception ex) { MessageBox.Show("Vendor not found", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (con != null) { con.Close(); } } VendorName.Clear(); VendorAddress.Clear(); PhoneNumber.Clear(); email.Clear(); VendorID.Clear(); }
private void Cancel_Click(object sender, RoutedEventArgs e) { VendorName.Clear(); PurchaseOrderNo.Clear(); ReferenceNo.Clear(); Date.Clear(); DeliveryDate.Clear(); SubTotal.Clear(); Adjustment.Clear(); Total.Clear(); CustNotes.Clear(); TermAndCondns.Clear(); RadioOrg.IsChecked = true; }
private void button3_Click(object sender, EventArgs e) { if (!isExisting(VendorName.Text, VendorList)) { dbConnect.Update("update tblVendor set strVendName = '" + VendorName.Text + "' where strVendCode = '" + VendorCode.Text + "';"); MessageBox.Show("Update Successful!"); this.VendorCode.Text = codeGenerator.generateCodeParent("tblVendor", "strVendCode", "Vendor"); AddVend.Visible = true; button3.Visible = false; CancelVend.Visible = false; VendorName.Clear(); //to generate new code and refresh vendors after this.VendorCode.Text = codeGenerator.generateCodeParent("tblVendor", "strVendCode", "Vendor"); refreshVendors(); } //Generate new Vendor Code }