/// <summary>
/// Updates a record in the Sac_Log table.
/// </summary>
public virtual void Update(Sac_Log sac_Log)
{
ValidationUtility.ValidateArgument("sac_Log", sac_Log);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@LogID", sac_Log.LogID),
new SqlParameter("@EntryType", sac_Log.EntryType),
new SqlParameter("@OrderNumber", sac_Log.OrderNumber),
new SqlParameter("@OrderAmount", sac_Log.OrderAmount),
new SqlParameter("@Description", sac_Log.Description),
new SqlParameter("@Quantityof50", sac_Log.Quantityof50),
new SqlParameter("@Quantityof20", sac_Log.Quantityof20),
new SqlParameter("@Quantityof10", sac_Log.Quantityof10),
new SqlParameter("@Quantityof5", sac_Log.Quantityof5),
new SqlParameter("@QuantityofToonie", sac_Log.QuantityofToonie),
new SqlParameter("@QuantityofLoonie", sac_Log.QuantityofLoonie),
new SqlParameter("@QuantityofQuarter", sac_Log.QuantityofQuarter),
new SqlParameter("@QuantityofDime", sac_Log.QuantityofDime),
new SqlParameter("@QuantityofNickel", sac_Log.QuantityofNickel),
new SqlParameter("@TotalValue", sac_Log.TotalValue),
new SqlParameter("@Remaining50", sac_Log.Remaining50),
new SqlParameter("@Remaining20", sac_Log.Remaining20),
new SqlParameter("@Remaining10", sac_Log.Remaining10),
new SqlParameter("@Remaining5", sac_Log.Remaining5),
new SqlParameter("@RemainingToonie", sac_Log.RemainingToonie),
new SqlParameter("@RemainingLoonie", sac_Log.RemainingLoonie),
new SqlParameter("@RemainingQuarter", sac_Log.RemainingQuarter),
new SqlParameter("@RemainingDime", sac_Log.RemainingDime),
new SqlParameter("@RemainingNickel", sac_Log.RemainingNickel),
new SqlParameter("@TimeStamp", sac_Log.TimeStamp)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sac_Log_Update", parameters);
}
/// <summary>
/// Creates a new instance of the Sac_Log class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_Log MakeSac_Log(SqlDataReader dataReader)
{
Sac_Log sac_Log = new Sac_Log();
sac_Log.LogID = SqlClientUtility.GetInt32(dataReader, "LogID", 0);
sac_Log.EntryType = SqlClientUtility.GetInt32(dataReader, "EntryType", 0);
sac_Log.OrderNumber = SqlClientUtility.GetInt32(dataReader, "OrderNumber", 0);
sac_Log.OrderAmount = SqlClientUtility.GetDecimal(dataReader, "OrderAmount", Decimal.Zero);
sac_Log.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sac_Log.Quantityof50 = SqlClientUtility.GetInt32(dataReader, "Quantityof50", 0);
sac_Log.Quantityof20 = SqlClientUtility.GetInt32(dataReader, "Quantityof20", 0);
sac_Log.Quantityof10 = SqlClientUtility.GetInt32(dataReader, "Quantityof10", 0);
sac_Log.Quantityof5 = SqlClientUtility.GetInt32(dataReader, "Quantityof5", 0);
sac_Log.QuantityofToonie = SqlClientUtility.GetInt32(dataReader, "QuantityofToonie", 0);
sac_Log.QuantityofLoonie = SqlClientUtility.GetInt32(dataReader, "QuantityofLoonie", 0);
sac_Log.QuantityofQuarter = SqlClientUtility.GetInt32(dataReader, "QuantityofQuarter", 0);
sac_Log.QuantityofDime = SqlClientUtility.GetInt32(dataReader, "QuantityofDime", 0);
sac_Log.QuantityofNickel = SqlClientUtility.GetInt32(dataReader, "QuantityofNickel", 0);
sac_Log.TotalValue = SqlClientUtility.GetDecimal(dataReader, "TotalValue", Decimal.Zero);
sac_Log.Remaining50 = SqlClientUtility.GetInt32(dataReader, "Remaining50", 0);
sac_Log.Remaining20 = SqlClientUtility.GetInt32(dataReader, "Remaining20", 0);
sac_Log.Remaining10 = SqlClientUtility.GetInt32(dataReader, "Remaining10", 0);
sac_Log.Remaining5 = SqlClientUtility.GetInt32(dataReader, "Remaining5", 0);
sac_Log.RemainingToonie = SqlClientUtility.GetInt32(dataReader, "RemainingToonie", 0);
sac_Log.RemainingLoonie = SqlClientUtility.GetInt32(dataReader, "RemainingLoonie", 0);
sac_Log.RemainingQuarter = SqlClientUtility.GetInt32(dataReader, "RemainingQuarter", 0);
sac_Log.RemainingDime = SqlClientUtility.GetInt32(dataReader, "RemainingDime", 0);
sac_Log.RemainingNickel = SqlClientUtility.GetInt32(dataReader, "RemainingNickel", 0);
sac_Log.TimeStamp = SqlClientUtility.GetDateTime(dataReader, "TimeStamp", new DateTime(0));
return(sac_Log);
}
/// <summary>
/// Selects all records from the Sac_Log table.
/// </summary>
public virtual List <Sac_Log> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sac_Log_SelectAll"))
{
List <Sac_Log> sac_LogList = new List <Sac_Log>();
while (dataReader.Read())
{
Sac_Log sac_Log = MakeSac_Log(dataReader);
sac_LogList.Add(sac_Log);
}
return(sac_LogList);
}
}
/// <summary>
/// Selects all records from the Sac_Log table by a foreign key.
/// </summary>
public virtual List <Sac_Log> _SelectAllByEntryType(int entryType)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@EntryType", entryType)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sac_Log_SelectAllByEntryType", parameters))
{
List <Sac_Log> sac_LogList = new List <Sac_Log>();
while (dataReader.Read())
{
Sac_Log sac_Log = MakeSac_Log(dataReader);
sac_LogList.Add(sac_Log);
}
return(sac_LogList);
}
}
