/// <summary>
/// Add a new KhachHang_DichVu within KhachHang_DichVu database table
/// </summary>
/// <param name="obj">KhachHang_DichVu</param>
/// <returns>key of table</returns>
public int Add(KhachHang_DichVu obj)
{
DbParameter parameterItemID = Data.CreateParameter("MaKhachHang_DichVu", obj.MaKhachHang_DichVu);
parameterItemID.Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(Data.ConnectionString, CommandType.StoredProcedure,"sproc_KhachHang_DichVu_Add"
,parameterItemID
,Data.CreateParameter("MaKhachHang", obj.MaKhachHang)
,Data.CreateParameter("MaDichVu", obj.MaDichVu)
,Data.CreateParameter("MaNguon", obj.MaNguon)
,Data.CreateParameter("GiaTriHopDong", obj.GiaTriHopDong)
,Data.CreateParameter("SoHopDong", obj.SoHopDong)
,Data.CreateParameter("TomTatHopDong", obj.TomTatHopDong)
,Data.CreateParameter("NgayThanhLyHD", obj.NgayThanhLyHD)
,Data.CreateParameter("NgayBatDauDichVu", obj.NgayBatDauDichVu)
,Data.CreateParameter("NgayKetThucDichVu", obj.NgayKetThucDichVu)
);
return 0;
}
/// <summary>
/// Add a new KhachHang_DichVu within KhachHang_DichVu database table
/// </summary>
/// <param name="obj_khachhang_dichvu">KhachHang_DichVu</param>
/// <returns>key of table</returns>
public int Add(KhachHang_DichVu obj_khachhang_dichvu)
{
ServerCache.Remove("KhachHang_DichVu", true);
return objKhachHang_DichVuDA.Add(obj_khachhang_dichvu);
}
/// <summary>
/// updates the specified KhachHang_DichVu
/// </summary>
/// <param name="obj_khachhang_dichvu">KhachHang_DichVu</param>
/// <returns></returns>
public void Update(KhachHang_DichVu obj_khachhang_dichvu)
{
ServerCache.Remove("KhachHang_DichVu", true);
objKhachHang_DichVuDA.Update(obj_khachhang_dichvu);
}
/// <summary>
/// updates the specified KhachHang_DichVu
/// </summary>
/// <param name="obj">KhachHang_DichVu</param>
/// <returns></returns>
public void Update(KhachHang_DichVu obj)
{
SqlHelper.ExecuteNonQuery(Data.ConnectionString, CommandType.StoredProcedure,"sproc_KhachHang_DichVu_Update"
,Data.CreateParameter("MaKhachHang_DichVu", obj.MaKhachHang_DichVu)
,Data.CreateParameter("MaKhachHang", obj.MaKhachHang)
,Data.CreateParameter("MaDichVu", obj.MaDichVu)
,Data.CreateParameter("MaNguon", obj.MaNguon)
,Data.CreateParameter("GiaTriHopDong", obj.GiaTriHopDong)
,Data.CreateParameter("SoHopDong", obj.SoHopDong)
,Data.CreateParameter("TomTatHopDong", obj.TomTatHopDong)
,Data.CreateParameter("NgayThanhLyHD", obj.NgayThanhLyHD)
,Data.CreateParameter("NgayBatDauDichVu", obj.NgayBatDauDichVu)
,Data.CreateParameter("NgayKetThucDichVu", obj.NgayKetThucDichVu)
);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public KhachHang_DichVu Populate(IDataReader myReader)
{
KhachHang_DichVu obj = new KhachHang_DichVu();
obj.MaKhachHang_DichVu = (int) myReader["MaKhachHang_DichVu"];
obj.MaKhachHang = (int) myReader["MaKhachHang"];
obj.MaDichVu = (Byte) myReader["MaDichVu"];
obj.MaNguon = (int) myReader["MaNguon"];
obj.GiaTriHopDong = (decimal) myReader["GiaTriHopDong"];
obj.SoHopDong = (string) myReader["SoHopDong"];
obj.TomTatHopDong = (string) myReader["TomTatHopDong"];
obj.NgayThanhLyHD = (DateTime) myReader["NgayThanhLyHD"];
obj.NgayBatDauDichVu = (DateTime) myReader["NgayBatDauDichVu"];
obj.NgayKetThucDichVu = (DateTime) myReader["NgayKetThucDichVu"];
return obj;
}
