/// <summary> /// Updates a record in the MAU_XE table. /// </summary> public void Update(MAUXE_DTO MauXe) { ValidationUtility.ValidateArgument("MauXe", MauXe); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@MA_XE", MauXe.MaXe), new SqlParameter("@MA_MAU", MauXe.MaMau), new SqlParameter("@SO_LUONG", MauXe.SoLuong) }; SqlClientUtility.ExecuteNonQuery(m_ConnectionString, CommandType.StoredProcedure, "PROC_MauXe_Update", parameters); }
/// <summary> /// Selects all records from the MAU_XE table. /// </summary> public List <MAUXE_DTO> SelectAll() { using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_MauXe_SelectAll")) { List <MAUXE_DTO> MauXeList = new List <MAUXE_DTO>(); while (dataReader.Read()) { MAUXE_DTO MauXe = MakeMAUXE_DTO(dataReader); MauXeList.Add(MauXe); } return(MauXeList); } }
/// <summary> /// Selects all records from the MAU_XE table by a foreign key. /// </summary> public List <MAUXE_DTO> SelectAllByMaXe(int MaXe) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@MA_XE", MaXe) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_MauXe_SelectAllByMa_Xe", parameters)) { List <MAUXE_DTO> MauXeList = new List <MAUXE_DTO>(); while (dataReader.Read()) { MAUXE_DTO MauXe = MakeMAUXE_DTO(dataReader); MauXeList.Add(MauXe); } return(MauXeList); } }
/// <summary> /// Updates a record in the MAU_XE table. /// </summary> public void Update(MAUXE_DTO MauXe) { ValidationUtility.ValidateArgument("MauXe", MauXe); new MAUXE_DAO().Update(MauXe); }