public int Update(PhieuDatPhongVO phieuDatPhongVO)
{
try
{
return(phieuDatPhongDAO.Update(phieuDatPhongVO));
}
catch (Exception e)
{
throw e;
}
}
public int Insert(PhieuDatPhongVO phieuDatPhongVO)
{
try
{
return(phieuDatPhongDAO.Insert(phieuDatPhongVO));
}
catch (Exception e)
{
throw e;
}
}
public int Insert(PhieuDatPhongVO phieudatphongVO)
{
try
{
String query = "INSERT INTO PHIEU_DAT_PHONG VALUES(@MA_KHACH_HANG,@MA_DOAN_KHACH,@TIEN_COC,@DA_GIAI_QUYET)";
SqlParameter[] sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@MA_KHACH_HANG", phieudatphongVO.MA_KHACH_HANG);
sqlParameters[1] = new SqlParameter("@MA_DOAN_KHACH", phieudatphongVO.MA_DOAN_KHACH);
sqlParameters[2] = new SqlParameter("@TIEN_COC", phieudatphongVO.TIEN_COC);
sqlParameters[3] = new SqlParameter("@DA_GIAI_QUYET", phieudatphongVO.DA_GIAI_QUYET);
return(Program.DBConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
public int Update(PhieuDatPhongVO phieudatphongVO)
{
try
{
String query = "UPDATE PHIEU_DAT_PHONG SET MA_KHACH_HANG=@MA_KHACH_HANG,MA_DOAN_KHACH=@MA_DOAN_KHACH,TIEN_COC=@TIEN_COC,DA_GIAI_QUYET=@DA_GIAI_QUYET WHERE MA_PHIEU=@MA_PHIEU";
SqlParameter[] sqlParameters = new SqlParameter[5];
sqlParameters[0] = new SqlParameter("@MA_PHIEU", phieudatphongVO.MA_PHIEU);
sqlParameters[1] = new SqlParameter("@MA_KHACH_HANG", phieudatphongVO.MA_KHACH_HANG);
sqlParameters[2] = new SqlParameter("@MA_DOAN_KHACH", phieudatphongVO.MA_DOAN_KHACH);
sqlParameters[3] = new SqlParameter("@TIEN_COC", phieudatphongVO.TIEN_COC);
sqlParameters[4] = new SqlParameter("@DA_GIAI_QUYET", phieudatphongVO.DA_GIAI_QUYET);
return(Program.DBConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
