public void loadCustomers()
{
try
{
dgCustomerList.Rows.Clear();
dgCustomerList.Columns.Clear();
dgCustomerList.Columns.Add("id", "Номер");
dgCustomerList.Columns.Add("fio", "ФИО");
dgCustomerList.Columns.Add("address", "Адрес");
dgCustomerList.Columns.Add("phone", "Телефон");
var customersList = CustomersBusinessLayer.GetAllCustomersList();
foreach (var customer in customersList)
{
dgCustomerList.Rows.Add(customer.IDCUS, customer.FIO, customer.Address, customer.PhoneNumber);
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void сохранитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (validate())
{
//if (this.typeQuery == "add") {
// string text = "INSERT INTO Customers (FIO, DateOfBirth, PassportNo, DateOfIssue, Authority, Address, PhoneNumber) VALUES (@fio, @birth, @passNum, @dateOfl, @auth, @adress, @phone)";
// saveCustomer(text);
//}
//else if (this.typeQuery == "edit"){
// string text = "UPDATE Customers SET FIO = @fio, DateOfBirth = @birth, PassportNo = @passNum, DateOfIssue = @dateOfl, Authority = @auth, Address = @adress, PhoneNumber = @phone WHERE IDCUS = " + this.id;
// saveCustomer(text);
//}
CustomersBusinessLayer.AddOrUpdateCustomer(tbAddress.Text, tbAuthority.Text, Convert.ToDateTime(dtDateOfBirth.Text),
Convert.ToDateTime(dtDateOfIssue.Text), tbFIO.Text,
tbPassportNo.Text, Convert.ToInt32(tbPhoneNumber.Text));
this.Close();
}
else
{
MessageBox.Show("Заполните все поля!");
}
}
