/// <summary>
/// Creates a new instance of the BIEN_NHAN class and populates it with data from the specified SqlDataReader.
/// </summary>
private BIENNHAN_DTO MakeBIENNHAN_DTO(SqlDataReader dataReader)
{
BIENNHAN_DTO BienNhan = new BIENNHAN_DTO();
BienNhan.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
BienNhan.MaHoaDon = SqlClientUtility.GetInt32(dataReader, "MA_HOA_DON", 0);
BienNhan.NgayThanhToan = SqlClientUtility.GetDateTime(dataReader, "NGAY_THANH_TOAN", DateTime.Now);
BienNhan.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
BienNhan.SoTien = SqlClientUtility.GetDecimal(dataReader, "SO_TIEN", Decimal.Zero);
return(BienNhan);
}
/// <summary>
/// Saves a record to the BIEN_NHAN table.
/// </summary>
public void Insert(BIENNHAN_DTO BienNhan)
{
ValidationUtility.ValidateArgument("BienNhan", BienNhan);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_HOA_DON", BienNhan.MaHoaDon),
new SqlParameter("@NGAY_THANH_TOAN", BienNhan.NgayThanhToan),
new SqlParameter("@MA_NHAN_VIEN", BienNhan.MaNhanVien),
new SqlParameter("@SO_TIEN", BienNhan.SoTien)
};
BienNhan.Ma = (int)SqlClientUtility.ExecuteScalar(m_ConnectionString, CommandType.StoredProcedure, "PROC_BienNhan_Insert", parameters);
}
/// <summary>
/// Selects all records from the BIEN_NHAN table.
/// </summary>
public List <BIENNHAN_DTO> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_BienNhan_SelectAll"))
{
List <BIENNHAN_DTO> BienNhanList = new List <BIENNHAN_DTO>();
while (dataReader.Read())
{
BIENNHAN_DTO BienNhan = MakeBIENNHAN_DTO(dataReader);
BienNhanList.Add(BienNhan);
}
return(BienNhanList);
}
}
private void btn_LapPhieu_Click(object sender, EventArgs e)
{
if (txt_BN_SoTienTra.Text != String.Empty)
{
BIENNHAN_DTO biennhanDto = new BIENNHAN_DTO();
biennhanDto.MaHoaDon = int.Parse(txt_HD_MaHoaDon.Text);
biennhanDto.MaNhanVien = int.Parse(txt_BN_MaNV_LapBienNhan.Text);
biennhanDto.NgayThanhToan = DateTime.Today;
biennhanDto.SoTien = decimal.Parse(txt_BN_SoTienTra.Text.Trim());
new BIENNHAN_BUS().Insert(biennhanDto);
txt_BN_MaBienNhan.Text = biennhanDto.Ma.ToString();
MessageBox.Show("Đã lập xong biên nhận thanh toán đợt mới cho hóa đơn " + txt_HD_MaHoaDon.Text, "", MessageBoxButtons.OK);
btn_LapPhieu.Enabled = false;
}
}
/// <summary>
/// Selects all records from the BIEN_NHAN table by a foreign key.
/// </summary>
public List <BIENNHAN_DTO> SelectAllByMaNhanVien(int MaNhanVien)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_NHAN_VIEN", MaNhanVien)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_BienNhanSelectAllByMaNhanVien", parameters))
{
List <BIENNHAN_DTO> BienNhanList = new List <BIENNHAN_DTO>();
while (dataReader.Read())
{
BIENNHAN_DTO BienNhan = MakeBIENNHAN_DTO(dataReader);
BienNhanList.Add(BienNhan);
}
return(BienNhanList);
}
}
/// <summary>
/// Updates a record in the BIEN_NHAN table.
/// </summary>
public void Update(BIENNHAN_DTO BienNhan)
{
ValidationUtility.ValidateArgument("BienNhan", BienNhan);
new BIENNHAN_DAO().Update(BienNhan);
}
