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 CT_PhieuThue Read(SqlDataReader reader)
{
var ctpt = new CT_PhieuThue()
{
ID = reader.GetString(iID),
MaPhieuThue = reader.GetString(iMaPhieuThue),
MaKhachHang = reader.GetString(iMaKhachHang)
};
return(ctpt);
}
public static bool DeleteCT_PhieuThue(CT_PhieuThue ctpt)
{
var cm = CreateCommand();
cm.CommandText = @"Exec delete_row_CT_PhieuThue @ID";
cm.Parameters.Add(new SqlParameter("@ID", ctpt.ID));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static bool UpdateCT_PhieuThue(CT_PhieuThue ctpt)
{
var cm = CreateCommand();
cm.CommandText = @"Exec update_row_CT_PhieuThue @ID, @MPT, @MKH";
cm.Parameters.Add(new SqlParameter("@ID", ctpt.ID));
cm.Parameters.Add(new SqlParameter("@MPT", ctpt.MaPhieuThue));
cm.Parameters.Add(new SqlParameter("@MKH", ctpt.MaKhachHang));
int rs = cm.ExecuteNonQuery();
cn.Close();
return(rs > 0);
}
public static List <CT_PhieuThue> DSCT_PhieuThue()
{
var lctpt = new List <CT_PhieuThue>();
var cm = CreateCommand();
cm.CommandText = @"SELECT * FROM CT_PHIEUTHUE";
var reader = cm.ExecuteReader();
while (reader.Read())
{
lctpt.Add(CT_PhieuThue.Read(reader));
}
cn.Close();
return(lctpt);
}
