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
}
