public EditDienNuoc(DienNuocDAL dinc)
{
InitializeComponent();
maCanHo_suaDienNuoc.Text = dinc.maCanHo;
eChiSoCu_suaDienNuoc.Text = dinc.eChiSoCu.ToString();
eChiSoMoi_suaDienNuoc.Text = dinc.eChiSoMoi.ToString();
wChiSoCu_suaDienNuoc.Text = dinc.wChiSoCu.ToString();
wChiSoCMoi_suaDienNuoc.Text = dinc.wChiSoMoi.ToString();
}
private void button_them_AddCanHo_MouseClick(object sender, MouseEventArgs e)
{
Regex rex_maCan = new Regex(@"^\d{6}$");
if (!rex_maCan.IsMatch(maCanHo_dinc.Text))
{
MessageBox.Show("Mã căn hộ gồm 6 kí tự.");
}
Regex rex_eChiSoCu = new Regex(@"^\d{1,4}$");
if (!rex_eChiSoCu.IsMatch(eChiSoCu_dinc.Text))
{
MessageBox.Show("Chỉ số điện cũ.?");
}
Regex rex_eChiSoMoi = new Regex(@"^\d{1,4}$");
if (!rex_eChiSoMoi.IsMatch(eChiSoMoi_dinc.Text))
{
MessageBox.Show("Chỉ số điện mới.?");
}
Regex rex_wChiSoCu = new Regex(@"^\d{1,4}$");
if (!rex_wChiSoCu.IsMatch(wChiSoCu_dinc.Text))
{
MessageBox.Show("Chỉ số nước cũ.?");
}
Regex rex_wChiSoMoi = new Regex(@"^\d{1,4}$");
if (!rex_wChiSoMoi.IsMatch(wChiSoMoi_dinc.Text))
{
MessageBox.Show("Chỉ số nước mới.?");
}
if (rex_maCan.IsMatch(maCanHo_dinc.Text) && rex_eChiSoCu.IsMatch(eChiSoCu_dinc.Text) && rex_eChiSoMoi.IsMatch(eChiSoMoi_dinc.Text) && rex_wChiSoCu.IsMatch(wChiSoCu_dinc.Text) && rex_wChiSoMoi.IsMatch(wChiSoMoi_dinc.Text))
{
DienNuocDAL dinc = new DienNuocDAL();
dinc.maCanHo = maCanHo_dinc.Text;
dinc.eChiSoCu = int.Parse(eChiSoCu_dinc.Text);
dinc.eChiSoMoi = int.Parse(eChiSoMoi_dinc.Text);
dinc.wChiSoCu = int.Parse(eChiSoCu_dinc.Text);
dinc.wChiSoMoi = int.Parse(eChiSoMoi_dinc.Text);
if (NhanVien_Controller.Instance.Add_DienNuoc(dinc) > 0)
{
MessageBox.Show("Thêm Thành công..!");
var myParent = (DienNuocKhac)this.Owner;
myParent.RefreshForm();
this.Close();
}
}
}
public int Add_DienNuoc(DienNuocDAL dienNuocDAL)
{
string query = "insert into DIENNUOC values('" + dienNuocDAL.maCanHo + "', " + dienNuocDAL.eChiSoCu + ", " + dienNuocDAL.eChiSoMoi + ", " + dienNuocDAL.wChiSoCu + "," + dienNuocDAL.wChiSoMoi + "); ";
return(DataProvider.Instance.ExcuteNonQuery(query));
}
public int Del_DienNuoc(DienNuocDAL dienNuocDAL)
{
string query = "DELETE DIENNUOC WHERE maCanHo='" + dienNuocDAL.maCanHo + "'";
return(DataProvider.Instance.ExcuteNonQuery(query));
}
public int Update_DienNuoc(DienNuocDAL dienNuocDAL)
{
string query = "UPDATE DIENNUOC SET trangThai=" + dienNuocDAL.trangThai + ", eChiSoCu=" + dienNuocDAL.eChiSoCu + ", eChiSoMoi='" + dienNuocDAL.eChiSoMoi + "', wChiSoCu=" + dienNuocDAL.wChiSoCu + ", wChiSoMoi=" + dienNuocDAL.wChiSoMoi + " where maCanHo='" + dienNuocDAL.maCanHo + "'";
return(DataProvider.Instance.ExcuteNonQuery(query));
}
