public static void CustomerUpdate(CustomerCL a)
{
try
{
string cm = "Update Customers set LastName = @LastName,FirstName = @FirstName,CompanyName = @CompanyName, Phone=@Phone,Address=@Address,Discount=@Discount " + "where CustomerID = " + a.CustomerID;
SqlCommand cmd = new SqlCommand(cm, con);
cmd.Parameters.AddWithValue("@LastName", a.Lastname);
cmd.Parameters.AddWithValue("@FirstName", a.Firstname);
cmd.Parameters.AddWithValue("@CompanyName", a.Companyname);
cmd.Parameters.AddWithValue("@Phone", a.Phone);
cmd.Parameters.AddWithValue("@Address", a.Address);
cmd.Parameters.AddWithValue("@Discount", a.Discount);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
public static void insertCustomer(CustomerCL a)
{
try
{
SqlCommand cmd = new SqlCommand("SET IDENTITY_INSERT Customers ON Insert into Customers" +
"(CustomerID,LastName,FirstName,CompanyName,Phone,Address,Discount) " +
"values(@CustomerID,@LastName,@FirstName,@CompanyName,@Phone,@Address,@Discount)", con);
cmd.Parameters.AddWithValue("@CustomerID", a.CustomerID);
cmd.Parameters.AddWithValue("@LastName", a.Lastname);
cmd.Parameters.AddWithValue("@FirstName", a.Firstname);
cmd.Parameters.AddWithValue("@CompanyName", a.Companyname);
cmd.Parameters.AddWithValue("@Phone", a.Phone);
cmd.Parameters.AddWithValue("@Address", a.Address);
cmd.Parameters.AddWithValue("@Discount", a.Discount);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
private void button1_Click(object sender, EventArgs e)
{
if(button1.Text == "Add") {
int a = SelectDA.GetMax("CustomerID", "Customers")+1;
ClearTextBox();
EnableTextBox(true);
dataGridView1.DataSource = null;
textBox1.Enabled = false;
textBox1.Text = a.ToString();
button1.Text = "Save";
button2.Enabled = false;
button3.Enabled = false;
} else {
if(textBox2.Text == ""||textBox3.Text=="") {
MessageBox.Show("First name and last name must be fill");
} else {
CustomerCL cus = new CustomerCL();
try {
cus.Discount = int.Parse(textBox8.Text);
cus.CustomerID = int.Parse(textBox1.Text.Trim());
cus.Lastname = textBox2.Text;
cus.Firstname = textBox3.Text;
cus.Companyname = textBox4.Text;
cus.Phone = textBox6.Text;
cus.Address = textBox5.Text;
InsertDA.insertCustomer(cus);
ClearTextBox();
EnableTextBox(false);
button1.Text = "Add";
button2.Enabled = true;
button3.Enabled = true;
showData("");
} catch(Exception ex) {
MessageBox.Show("Discount must be filled");
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if(button2.Text == "Edit") {
EnableTextBox(true);
textBox1.Enabled = false;
button2.Text = "Save";
button1.Enabled = false;
button3.Enabled = false;
} else {
if(textBox2.Text == "" || textBox3.Text == "") {
MessageBox.Show("First name and last name must be fill");
} else {
CustomerCL cus = new CustomerCL();
try {
cus.Discount = int.Parse(textBox8.Text);
cus.CustomerID = int.Parse(textBox1.Text.Trim());
cus.Lastname = textBox2.Text;
cus.Firstname = textBox3.Text;
cus.Companyname = textBox4.Text;
cus.Phone = textBox6.Text;
cus.Address = textBox5.Text;
UpdateDA.CustomerUpdate(cus);
ClearTextBox();
EnableTextBox(false);
button2.Text = "Edit";
button1.Enabled = true;
button3.Enabled = true;
showData("");
} catch(Exception ex) {
MessageBox.Show("Discount must be filled");
}
}
}
}
