/// <summary>
/// Creates a new instance of the Sol_WS_ErrorCodes class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_WS_ErrorCode MakeSol_WS_ErrorCode(SqlDataReader dataReader)
{
Sol_WS_ErrorCode sol_WS_ErrorCode = new Sol_WS_ErrorCode();
sol_WS_ErrorCode.ErrorNumber = SqlClientUtility.GetInt32(dataReader, "ErrorNumber", 0);
sol_WS_ErrorCode.ErrorDescription = SqlClientUtility.GetString(dataReader, "ErrorDescription", String.Empty);
sol_WS_ErrorCode.MessageToClient = SqlClientUtility.GetBoolean(dataReader, "MessageToClient", false);
sol_WS_ErrorCode.Notes = SqlClientUtility.GetString(dataReader, "Notes", String.Empty);
return(sol_WS_ErrorCode);
}
/// <summary>
/// Updates a record in the Sol_WS_ErrorCodes table.
/// </summary>
public virtual void Update(Sol_WS_ErrorCode sol_WS_ErrorCode)
{
ValidationUtility.ValidateArgument("sol_WS_ErrorCode", sol_WS_ErrorCode);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ErrorNumber", sol_WS_ErrorCode.ErrorNumber),
new SqlParameter("@ErrorDescription", sol_WS_ErrorCode.ErrorDescription),
new SqlParameter("@MessageToClient", sol_WS_ErrorCode.MessageToClient),
new SqlParameter("@Notes", sol_WS_ErrorCode.Notes)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ErrorCodes_Update", parameters);
}
/// <summary>
/// Selects all records from the Sol_WS_ErrorCodes table.
/// </summary>
public virtual List <Sol_WS_ErrorCode> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ErrorCodes_SelectAll"))
{
List <Sol_WS_ErrorCode> sol_WS_ErrorCodeList = new List <Sol_WS_ErrorCode>();
while (dataReader.Read())
{
Sol_WS_ErrorCode sol_WS_ErrorCode = MakeSol_WS_ErrorCode(dataReader);
sol_WS_ErrorCodeList.Add(sol_WS_ErrorCode);
}
return(sol_WS_ErrorCodeList);
}
}
