public static void Insert(Khachhang kh)
{
if(conn.State == ConnectionState.Open) conn.Close();
conn.Open();
SqlCommand sc = new SqlCommand("Khachhang_ProcInsert", conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add(new SqlParameter("@Tenkhachhang", kh.Tenkhachhang));
sc.Parameters.Add(new SqlParameter("@Ngaysinh", kh.Ngaysinh));
sc.Parameters.Add(new SqlParameter("@Gioitinh", kh.Gioitinh));
sc.Parameters.Add(new SqlParameter("@Sodienthoai", kh.Sodienthoai));
sc.Parameters.Add(new SqlParameter("@Diachi", kh.Diachi));
sc.ExecuteNonQuery();
conn.Close();
}
public static int GetKhachhangID(Khachhang kh)
{
int ID = 0;
if (conn.State == ConnectionState.Open) conn.Close();
conn.Open();
SqlCommand sc = new SqlCommand("Khachhang_ProcGetKhachhangID", conn);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add(new SqlParameter("@Tenkhachhang", kh.Tenkhachhang));
sc.Parameters.Add(new SqlParameter("@Gioitinh", kh.Gioitinh));
sc.Parameters.Add(new SqlParameter("@Sodienthoai", kh.Sodienthoai));
sc.Parameters.Add(new SqlParameter("@Diachi", kh.Diachi));
SqlDataReader reader = sc.ExecuteReader();
while (reader.Read())
{
ID = int.Parse(reader["KhachhangID"].ToString());
}
reader.Close();
conn.Close();
return ID;
}
private void button2_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show("Bạn muốn chọn "+textBox2.Text+" làm khách hàng thân thiết?","Thông báo",MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (dialog == DialogResult.OK)
{
Khachhang kh = new Khachhang();
kh.Tenkhachhang = textBox2.Text;
kh.Gioitinh = radioButton1.Checked;
kh.Ngaysinh = dateTimePicker1.Value.Date;
kh.Sodienthoai = maskedTextBox1.Text;
kh.Diachi = textBox4.Text;
KhachhangController.Insert(kh);
MessageBox.Show("Thêm thành công!");
textBox1.Text = KhachhangController.GetKhachhangID(kh).ToString();
}
}
