public DataTable GetmmmBUS(LichSuEntities l)
{
DataTable dt = null;
dt = nvmDAO.Getmmm(l);
return(dt);
}
public DataTable GetBUS(LichSuEntities add)
{
DataTable dt = null;
dt = nvmDAO.GetTT(add);
return(dt);
}
public DataTable ThemLSBUS(LichSuEntities ttkt)
{
DataTable dt = null;
dt = nvmDAO.ThemLS(ttkt);
return(dt);
}
public DataTable Getmmm(LichSuEntities l)
{
string sql = "select * from LichSu where Ten ='" + l.Ten + "'";
return(getDataTable(sql));
}
public DataTable Getm(LichSuEntities l)
{
string sql = "select * from LichSu where ID='" + l.ID + "' and Ten ='" + (l.Ten) + "'";
return(getDataTable(sql));
}
public DataTable GetTT(LichSuEntities ttkt)
{
string sql = "select * from LichSu";
return(getDataTable(sql));
}
public DataTable ThemLS(LichSuEntities add)
{
string sql = "insert into LichSu ('ID','Ten','NgaySinh','GioiTinh','Cmnd','NgayCap','NoiCap','NgayVao','Sdt') values ('" + add.ID + "','" + add.Ten + "','" + add.NgaySinh + "','" + add.GioiTinh + "','" + add.CMND + "','" + add.NgayCap + "','" + add.NoiCap + "','" + add.NgayVao + "','" + add.Sdt + "')";
return(getDataTable(sql));
}
private void button1_Click(object sender, EventArgs e)
{
ThongTinKhachThueEntities c = new ThongTinKhachThueEntities();
LichSuEntities d = new LichSuEntities();
PhongEntities ee = new PhongEntities();
if (textBox1.Text == "")
{
MessageBox.Show("Xin nhặp tên");
textBox1.Focus();
}
else
{
if (checkBox1.Checked || checkBox2.Checked == true)
{
if (textBox11.Text == "")
{
MessageBox.Show("Xin nhặp CMND");
textBox11.Focus();
}
else
{
if (comboBox3.Text == "")
{
MessageBox.Show("Xin chọn nơi cấp");
comboBox3.Focus();
}
else
{
if (textBox10.Text == "")
{
MessageBox.Show("Xin nhặp SĐT");
textBox10.Focus();
}
else
{
c.Ten = textBox1.Text;
c.NgaySinh = dateTimePicker1.Text;
if (checkBox1.Checked == true)
{
c.GioiTinh = true;
}
else
{
c.GioiTinh = false;
}
if (checkBox2.Checked == true)
{
c.GioiTinh = false;
}
else
{
c.GioiTinh = true;
}
c.CMND = Convert.ToInt32(textBox11.Text);
c.NgayCap = Convert.ToString(dateTimePicker4.Text);
c.NoiCap = comboBox3.Text;
c.NgayVao = Convert.ToString(dateTimePicker5.Text);
c.Sdt = Convert.ToInt32(textBox10.Text);
c.ID = Convert.ToInt32(ID);
d.Ten = textBox1.Text;
d.NgaySinh = Convert.ToString(dateTimePicker1.Text);
if (checkBox1.Checked == true)
{
d.GioiTinh = true;
}
else
{
d.GioiTinh = false;
}
if (checkBox2.Checked == true)
{
d.GioiTinh = false;
}
else
{
d.GioiTinh = true;
}
d.CMND = Convert.ToInt32(textBox11.Text);
d.NgayCap = dateTimePicker4.Text;
d.NoiCap = comboBox3.Text;
d.NgayVao = Convert.ToString(dateTimePicker5.Text);
d.Sdt = Convert.ToInt32(textBox10.Text);
d.ID = Convert.ToInt32(ID);
ee.HienTrang = mm;
ee.Id = Convert.ToInt32(ID);
ThongTinKhachThueBUS cbus = new ThongTinKhachThueBUS();
DataTable dt = cbus.GetTKBUS(c);
LichSuBUS a = new LichSuBUS();
DataTable s = a.ThemLSBUS(d);
PhongBUS t = new PhongBUS();
DataTable tt = t.GetUpdate(ee);
MessageBox.Show("Thuê " + label3.Text + " thành công.");
home.doimau(b);
Close();
}
}
}
}
else
{
MessageBox.Show("Hãy chọn giới tính");
}
}
}
