public int Update(PhieuThuKhachHangVO phieuthukhachhangVO)
{
try
{
return(phieuThuKhachHangDAO.Update(phieuthukhachhangVO));
}
catch (SqlException e)
{
throw e;
}
}
public int Insert(PhieuThuKhachHangVO phieuthukhachhangVO)
{
try
{
return(phieuThuKhachHangDAO.Insert(phieuthukhachhangVO));
}
catch (Exception e)
{
throw e;
}
}
private PhieuThuKhachHangVO GetPhieuThuKhachHangVO()
{
PhieuThuKhachHangVO phieuVO = new PhieuThuKhachHangVO();
phieuVO.SO_PHIEU = int.Parse(txt_SoPhieu.Text.Substring(2));
phieuVO.MA_CA_TRUC = int.Parse(cbo_Catruc.SelectedValue.ToString().Substring(2));
phieuVO.MA_PHIEU = int.Parse(cbo_PhieuThue.SelectedValue.ToString().Substring(1));
phieuVO.NGAY_PHIEU = date_NgayPhieu.DateTime;
if (txt_Sotien.Text == "")
{
txt_Sotien.Text = "0";
}
phieuVO.SO_TIEN = Double.Parse(txt_Sotien.Text.ToString());
phieuVO.NOI_DUNG_THU = txt_NoiDungThu.Text;
phieuVO.HINH_THUC_THU = txt_HinhThucThu.Text;
return(phieuVO);
}
public int Update(PhieuThuKhachHangVO phieuThuKhachHangVO)
{
try
{
String query = "UPDATE PHIEU_THU_KHACH_HANG SET MA_PHIEU=@MA_PHIEU,MA_CA_TRUC=@MA_CA_TRUC,NGAY_PHIEU=@NGAY_PHIEU,SO_TIEN=@SO_TIEN,NOI_DUNG_THU=@NOI_DUNG_THU,HINH_THUC_THU=@HINH_THUC_THU WHERE SO_PHIEU=@SO_PHIEU";
SqlParameter[] sqlParameters = new SqlParameter[7];
sqlParameters[0] = new SqlParameter("@SO_PHIEU", phieuThuKhachHangVO.SO_PHIEU);
sqlParameters[1] = new SqlParameter("@MA_PHIEU", phieuThuKhachHangVO.MA_PHIEU);
sqlParameters[2] = new SqlParameter("@MA_CA_TRUC", phieuThuKhachHangVO.MA_CA_TRUC);
sqlParameters[3] = new SqlParameter("@NGAY_PHIEU", phieuThuKhachHangVO.NGAY_PHIEU);
sqlParameters[4] = new SqlParameter("@SO_TIEN", phieuThuKhachHangVO.SO_TIEN);
sqlParameters[5] = new SqlParameter("@NOI_DUNG_THU", phieuThuKhachHangVO.NOI_DUNG_THU);
sqlParameters[6] = new SqlParameter("@HINH_THUC_THU", phieuThuKhachHangVO.HINH_THUC_THU);
return(Program.DBConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
public int Insert(PhieuThuKhachHangVO phieuThuKhachHangVO)
{
try
{
String query = "INSERT INTO PHIEU_THU_KHACH_HANG VALUES(@MA_CA_TRUC,@MA_PHIEU,@NGAY_PHIEU,@SO_TIEN,@NOI_DUNG_THU,@HINH_THUC_THU)";
SqlParameter[] sqlParameters = new SqlParameter[6];
sqlParameters[0] = new SqlParameter("@MA_PHIEU", phieuThuKhachHangVO.MA_PHIEU);
sqlParameters[1] = new SqlParameter("@MA_CA_TRUC", phieuThuKhachHangVO.MA_CA_TRUC);
sqlParameters[2] = new SqlParameter("@NGAY_PHIEU", phieuThuKhachHangVO.NGAY_PHIEU);
sqlParameters[3] = new SqlParameter("@SO_TIEN", phieuThuKhachHangVO.SO_TIEN);
sqlParameters[4] = new SqlParameter("@NOI_DUNG_THU", phieuThuKhachHangVO.NOI_DUNG_THU);
sqlParameters[5] = new SqlParameter("@HINH_THUC_THU", phieuThuKhachHangVO.HINH_THUC_THU);
return(Program.DBConnection.ExecuteNonQuery(query, sqlParameters));
}
catch (Exception e)
{
throw e;
}
}
