private void btndlt_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow != null)
{
if (MessageBox.Show("Bạn Muốn Xóa Thông Tin Khách Hàng Này?", "Chú Ý !!!", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
var result = SQLProvider.Execute("DELETE FROM [dbo].[Transaction] WHERE CustomerId = @CustomerId;" +
"DELETE FROM [dbo].[Account] WHERE CustomerId = @CustomerId; " +
"DELETE FROM [dbo].[User] WHERE CustomerId = @CustomerId; " +
"DELETE FROM [dbo].[Customer] WHERE CustomerId = @CustomerId; "
, paramters: new Dictionary <string, object>
{
{ "CustomerId", dataGridView1.CurrentRow.Cells[0].Value }
});
if (result)
{
//show lên 1 cái form
MessageBox.Show("Xóa Thành Công", "Xóa", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadCustomer();
}
else
{
MessageBox.Show("Xóa Không Thành Công", "Lỗi !!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void button8_Click(object sender, EventArgs e)
{
Customer ctm = new Customer();
if (textName.Text == "")
{
MessageBox.Show("Please Enter the First Name", "Confirmation"); return;
}
if (textLName.Text == "")
{
MessageBox.Show("Please Enter the Last Name", "Confirmation"); return;
}
if (textNumber.Text == "")
{
MessageBox.Show("Please Enter the idnumber", "Confirmation"); return;
}
if (textPlace.Text == "")
{
MessageBox.Show("Please Enter the Place", "Confirmation"); return;
}
if (textAddress.Text == "")
{
MessageBox.Show("Please Enter the Adress", "Confirmation"); return;
}
if (textPhone.Text == "")
{
MessageBox.Show("Please Enter the Phone Number", "Confirmation"); return;
}
if (textPhone.Text != "")
{
try
{
int phone = int.Parse(textPhone.Text);
}
catch (Exception)
{
MessageBox.Show("the phone number must be a number", "Confirmation");
return;
}
}
if (textPhone.Text != "")
{
try
{
UInt64 phone = UInt64.Parse(textPhone.Text);
}
catch (Exception)
{
MessageBox.Show("Phone number don't contain special characters", "confirmation");
return;
}
}
string query = @"INSERT INTO Customer (FirstName, LastName, IDNumber, IDPlace, IDDate,Address,Phone) VALUES (@FirstName, @LastName, @IDNumber, @IDPlace, @IDDate,@Address,@Phone)";
if (customerrow != null)
{
query = @"UPDATE Customer SET FirstName = @FirstName, LastName = @LastName, IDNumber = @IDNumber, IDPlace = @IDPlace, IDDate = @IDDate,Address=@Address,Phone=@Phone WHERE CustomerId = @CustomerId";
}
var parameters = new Dictionary <string, object>
{
{ "FirstName", textName.Text },
{ "LastName", textLName.Text },
{ "IDNumber", textNumber.Text },
{ "IDPlace", textPlace.Text },
{ "IDDate", dateIDDate.Value },
{ "Address", textAddress.Text },
{ "Phone", textPhone.Text }
};
if (customerrow != null)
{
parameters.Add("CustomerId", (int)customerrow["CustomerId"]);
}
var result = SQLProvider.Execute(query, paramters: parameters);
if (result)
{
MessageBox.Show("Save Customer successful.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
else
{
MessageBox.Show("Save Customer failed.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}