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