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