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"); } } }