/// <summary>
/// Creates a new instance of the CT_DON_DAT_HANG class and populates it with data from the specified SqlDataReader.
/// </summary>
private CTDONDATHANG_DTO MakeCTDONDATHANG_DTO(SqlDataReader dataReader)
{
CTDONDATHANG_DTO CtDonDatHang = new CTDONDATHANG_DTO();
CtDonDatHang.MaDonDatHang = SqlClientUtility.GetInt32(dataReader, "MA_DON_DAT_HANG", 0);
CtDonDatHang.MaXe = SqlClientUtility.GetInt32(dataReader, "MA_XE", 0);
CtDonDatHang.MaMau = SqlClientUtility.GetString(dataReader, "MA_MAU", String.Empty);
CtDonDatHang.SoLuong = SqlClientUtility.GetInt32(dataReader, "SO_LUONG", 0);
CtDonDatHang.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
return(CtDonDatHang);
}
/// <summary>
/// Selects all records from the CT_DON_DAT_HANG table.
/// </summary>
public List <CTDONDATHANG_DTO> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_CtDonDatHang_SelectAll"))
{
List <CTDONDATHANG_DTO> CtDonDatHangList = new List <CTDONDATHANG_DTO>();
while (dataReader.Read())
{
CTDONDATHANG_DTO CtDonDatHang = MakeCTDONDATHANG_DTO(dataReader);
CtDonDatHangList.Add(CtDonDatHang);
}
return(CtDonDatHangList);
}
}
/// <summary>
/// Updates a record in the CT_DON_DAT_HANG table.
/// </summary>
public void Update(CTDONDATHANG_DTO CtDonDatHang)
{
ValidationUtility.ValidateArgument("CtDonDatHang", CtDonDatHang);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_DON_DAT_HANG", CtDonDatHang.MaDonDatHang),
new SqlParameter("@MA_XE", CtDonDatHang.MaXe),
new SqlParameter("@MA_MAU", CtDonDatHang.MaMau),
new SqlParameter("@SO_LUONG", CtDonDatHang.SoLuong),
new SqlParameter("@TONG_TIEN", CtDonDatHang.TongTien)
};
SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_CtDonDatHang_Update", parameters);
}
/// <summary>
/// Selects all records from the CT_DON_DAT_HANG table by a foreign key.
/// </summary>
public List <CTDONDATHANG_DTO> SelectAllByMaXe(int MaXe)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_XE", MaXe)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_CtDonDatHangSelectAllByMaXe", parameters))
{
List <CTDONDATHANG_DTO> CtDonDatHangList = new List <CTDONDATHANG_DTO>();
while (dataReader.Read())
{
CTDONDATHANG_DTO CtDonDatHang = MakeCTDONDATHANG_DTO(dataReader);
CtDonDatHangList.Add(CtDonDatHang);
}
return(CtDonDatHangList);
}
}
/// <summary>
/// Updates a record in the CT_DON_DAT_HANG table.
/// </summary>
public void Update(CTDONDATHANG_DTO CtDonDatHang)
{
ValidationUtility.ValidateArgument("CtDonDatHang", CtDonDatHang);
new CTDONDATHANG_DAO().Update(CtDonDatHang);
}