/// <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); }