private void btnTao_Click(object sender, EventArgs e)
{
if (dgvKH.Rows[0].DataBoundItem as KhachHang == null)
{
MessageBox.Show("Phiếu thuê không thể không có khách hàng");
}
else
{
var pt = new PhieuThue();
pt.ID = GetPTID();
pt.NgayBatDau = DateTime.Now;
pt.MaPhong = cbMaPhong.SelectedValue.ToString().Trim();
DataUtil.ThemPhieuThue(pt);
foreach (DataGridViewRow row in dgvKH.Rows)
{
var kh = row.DataBoundItem as KhachHang;
if (kh != null)
{
var ct = new CT_PhieuThue();
ct.ID = GetCTPTID();
ct.MaKhachHang = kh.ID;
ct.MaPhieuThue = pt.ID;
DataUtil.ThemCT_PhieuThue(ct);
}
}
}
}
public static PhieuThue Read(SqlDataReader reader)
{
var pt = new PhieuThue()
{
ID = reader.GetString(iID),
MaPhong = reader.GetString(iMaPhong),
NgayBatDau = reader.GetDateTime(iNgayBatDau)
};
return(pt);
}
public static bool DeletePhieuThue(PhieuThue pt)
{
var cm = CreateCommand();
cm.CommandText = @"Exec delete_row_PhieuThue @ID";
cm.Parameters.Add(new SqlParameter("@ID", pt.ID));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static bool UpdatePhieuThue(PhieuThue pt)
{
var cm = CreateCommand();
cm.CommandText = @"Exec update_row_PhieuThue @ID, @MP, @NBD";
cm.Parameters.Add(new SqlParameter("@ID", pt.ID));
cm.Parameters.Add(new SqlParameter("@MP", pt.MaPhong));
cm.Parameters.Add(new SqlParameter("@NBD", pt.NgayBatDau));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static List <PhieuThue> DSPhieuThue()
{
var lpt = new List <PhieuThue>();
var cm = CreateCommand();
cm.CommandText = @"SELECT * FROM PHIEUTHUE";
var reader = cm.ExecuteReader();
while (reader.Read())
{
lpt.Add(PhieuThue.Read(reader));
}
cn.Close();
return(lpt);
}
