/// <summary>
/// Creates a new instance of the sol_Shipment class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Shipment MakeSol_Shipment(SqlDataReader dataReader)
{
Sol_Shipment sol_Shipment = new Sol_Shipment();
sol_Shipment.ShipmentID = SqlClientUtility.GetInt32(dataReader, "ShipmentID", 0);
sol_Shipment.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_Shipment.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
sol_Shipment.RBillNumber = SqlClientUtility.GetString(dataReader, "RBillNumber", String.Empty);
sol_Shipment.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_Shipment.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0);
sol_Shipment.AgencyName = SqlClientUtility.GetString(dataReader, "AgencyName", String.Empty);
sol_Shipment.AgencyAddress1 = SqlClientUtility.GetString(dataReader, "AgencyAddress1", String.Empty);
sol_Shipment.AgencyAddress2 = SqlClientUtility.GetString(dataReader, "AgencyAddress2", String.Empty);
sol_Shipment.AgencyCity = SqlClientUtility.GetString(dataReader, "AgencyCity", String.Empty);
sol_Shipment.AgencyProvince = SqlClientUtility.GetString(dataReader, "AgencyProvince", String.Empty);
sol_Shipment.AgencyCountry = SqlClientUtility.GetString(dataReader, "AgencyCountry", String.Empty);
sol_Shipment.AgencyPostalCode = SqlClientUtility.GetString(dataReader, "AgencyPostalCode", String.Empty);
sol_Shipment.Status = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
sol_Shipment.CarrierID = SqlClientUtility.GetInt32(dataReader, "CarrierID", 0);
sol_Shipment.PlantID = SqlClientUtility.GetInt32(dataReader, "PlantID", 0);
sol_Shipment.TrailerNumber = SqlClientUtility.GetString(dataReader, "TrailerNumber", String.Empty);
sol_Shipment.ProBillNumber = SqlClientUtility.GetString(dataReader, "ProBillNumber", String.Empty);
sol_Shipment.ShippedDate = SqlClientUtility.GetDateTime(dataReader, "ShippedDate", new DateTime(0));
sol_Shipment.SealNumber = SqlClientUtility.GetString(dataReader, "SealNumber", String.Empty);
sol_Shipment.LoadReference = SqlClientUtility.GetString(dataReader, "LoadReference", String.Empty);
sol_Shipment.ERBillTransmitted = SqlClientUtility.GetBoolean(dataReader, "eRBillTransmitted", false);
return(sol_Shipment);
}
/// <summary>
/// Creates a new instance of the sol_CashTrays class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_CashTray MakeSol_CashTray(SqlDataReader dataReader)
{
Sol_CashTray sol_CashTray = new Sol_CashTray();
sol_CashTray.CashTrayID = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0);
sol_CashTray.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sol_CashTray.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
sol_CashTray.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_CashTray.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
return(sol_CashTray);
}
/// <summary>
/// Creates a new instance of the Sol_EmployeesLog class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_EmployeesLog MakeSol_EmployeesLog(SqlDataReader dataReader)
{
Sol_EmployeesLog sol_EmployeesLog = new Sol_EmployeesLog();
sol_EmployeesLog.LogId = SqlClientUtility.GetInt64(dataReader, "LogId", 0);
sol_EmployeesLog.UserId = SqlClientUtility.GetGuid(dataReader, "UserId", Guid.Empty);
sol_EmployeesLog.PunchInTime = SqlClientUtility.GetDateTime(dataReader, "PunchInTime", new DateTime(0));
sol_EmployeesLog.PunchOutTime = SqlClientUtility.GetDateTime(dataReader, "PunchOutTime", new DateTime(0));
sol_EmployeesLog.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
sol_EmployeesLog.Approved = SqlClientUtility.GetBoolean(dataReader, "Approved", false);
sol_EmployeesLog.Modified = SqlClientUtility.GetBoolean(dataReader, "Modified", false);
return(sol_EmployeesLog);
}
/// <summary>
/// Creates a new instance of the sol_Entries class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Entrie MakeSol_Entrie(SqlDataReader dataReader)
{
Sol_Entrie sol_Entrie = new Sol_Entrie();
sol_Entrie.EntryID = SqlClientUtility.GetInt32(dataReader, "EntryID", 0);
sol_Entrie.EntryType = SqlClientUtility.GetString(dataReader, "EntryType", String.Empty);
sol_Entrie.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_Entrie.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
sol_Entrie.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_Entrie.CashTrayID = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0);
sol_Entrie.ExpenseTypeID = SqlClientUtility.GetInt32(dataReader, "ExpenseTypeID", 0);
sol_Entrie.Amount = SqlClientUtility.GetDecimal(dataReader, "Amount", Decimal.Zero);
sol_Entrie.DiscrepancyAmount = SqlClientUtility.GetDecimal(dataReader, "DiscrepancyAmount", Decimal.Zero);
return(sol_Entrie);
}
///// <summary>
///// Selects all records from the Sol_Employees table (lookup).
///// </summary>
//public virtual List<Sol_Employee> SelectAllLookup()
//{
// using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_Employees_SelectAllLookup"))
// {
// List<Sol_Employee> sol_EmployeeList = new List<Sol_Employee>();
// while (dataReader.Read())
// {
// Sol_Employee sol_Employee = MakeSol_Employee(dataReader);
// sol_EmployeeList.Add(sol_Employee);
// }
// return sol_EmployeeList;
// }
//}
//Aditional Stored Procedures
/// <summary>
/// Selects all records from the Sol_Employees table (lookup).
/// </summary>
public virtual List <Sol_EmployeeLookup> SelectAllLookup()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_Employees_SelectAllLookup"))
{
List <Sol_EmployeeLookup> sol_EmployeeLookupList = new List <Sol_EmployeeLookup>();
while (dataReader.Read())
{
Sol_EmployeeLookup sol_EmployeeLookup = new Sol_EmployeeLookup();
sol_EmployeeLookup.UserId = SqlClientUtility.GetGuid(dataReader, "UserId", Guid.Empty);
sol_EmployeeLookup.FullName = SqlClientUtility.GetString(dataReader, "FullName", String.Empty);
sol_EmployeeLookupList.Add(sol_EmployeeLookup);
}
return(sol_EmployeeLookupList);
}
}
/// <summary>
/// Creates a new instance of the Sol_SupplyInventory class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_SupplyInventory MakeSol_SupplyInventory(SqlDataReader dataReader)
{
Sol_SupplyInventory sol_SupplyInventory = new Sol_SupplyInventory();
sol_SupplyInventory.SupplyInventoryID = SqlClientUtility.GetInt32(dataReader, "SupplyInventoryID", 0);
sol_SupplyInventory.SupplyInventoryType = SqlClientUtility.GetString(dataReader, "SupplyInventoryType", String.Empty);
sol_SupplyInventory.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_SupplyInventory.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_SupplyInventory.DateOrdered = SqlClientUtility.GetDateTime(dataReader, "DateOrdered", new DateTime(0));
sol_SupplyInventory.ProductID = SqlClientUtility.GetInt32(dataReader, "ProductID", 0);
sol_SupplyInventory.ContainerID = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0);
sol_SupplyInventory.Quantity = SqlClientUtility.GetInt32(dataReader, "Quantity", 0);
sol_SupplyInventory.ShipmentID = SqlClientUtility.GetInt32(dataReader, "ShipmentID", 0);
sol_SupplyInventory.ReferenceNumber = SqlClientUtility.GetString(dataReader, "ReferenceNumber", String.Empty);
return(sol_SupplyInventory);
}
/// <summary>
/// Creates a new instance of the Sol_Employees class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Employee MakeSol_Employee(SqlDataReader dataReader)
{
Sol_Employee sol_Employee = new Sol_Employee();
sol_Employee.UserId = SqlClientUtility.GetGuid(dataReader, "UserId", Guid.Empty);
sol_Employee.FirstName = SqlClientUtility.GetString(dataReader, "FirstName", String.Empty);
sol_Employee.LastName = SqlClientUtility.GetString(dataReader, "LastName", String.Empty);
sol_Employee.MiddleName = SqlClientUtility.GetString(dataReader, "MiddleName", String.Empty);
sol_Employee.BirthDate = SqlClientUtility.GetDateTime(dataReader, "BirthDate", new DateTime(0));
sol_Employee.HireDate = SqlClientUtility.GetDateTime(dataReader, "HireDate", new DateTime(0));
sol_Employee.EmployeeNotes = SqlClientUtility.GetString(dataReader, "EmployeeNotes", String.Empty);
sol_Employee.SIN = SqlClientUtility.GetString(dataReader, "SIN", String.Empty);
sol_Employee.Gender = SqlClientUtility.GetByte(dataReader, "Gender", 0x00);
sol_Employee.EmployeeNumber = SqlClientUtility.GetString(dataReader, "EmployeeNumber", String.Empty);
sol_Employee.PayrollNumber = SqlClientUtility.GetString(dataReader, "PayrollNumber", String.Empty);
sol_Employee.CompensationAmount = SqlClientUtility.GetDecimal(dataReader, "CompensationAmount", Decimal.Zero);
sol_Employee.CompensationType = SqlClientUtility.GetByte(dataReader, "CompensationType", 0x00);
return(sol_Employee);
}
/// <summary>
/// Creates a new instance of the sol_Stage class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Stage MakeSol_Stage(SqlDataReader dataReader)
{
Sol_Stage sol_Stage = new Sol_Stage();
sol_Stage.StageID = SqlClientUtility.GetInt32(dataReader, "StageID", 0);
sol_Stage.ShipmentID = SqlClientUtility.GetInt32(dataReader, "ShipmentID", 0);
sol_Stage.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_Stage.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
sol_Stage.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_Stage.TagNumber = SqlClientUtility.GetString(dataReader, "TagNumber", String.Empty);
sol_Stage.ContainerID = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0);
sol_Stage.ContainerDescription = SqlClientUtility.GetString(dataReader, "ContainerDescription", String.Empty);
sol_Stage.ProductID = SqlClientUtility.GetInt32(dataReader, "ProductID", 0);
sol_Stage.ProductName = SqlClientUtility.GetString(dataReader, "ProductName", String.Empty);
sol_Stage.Dozen = SqlClientUtility.GetInt32(dataReader, "Dozen", 0);
sol_Stage.Quantity = SqlClientUtility.GetInt32(dataReader, "Quantity", 0);
sol_Stage.Price = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero);
sol_Stage.Remarks = SqlClientUtility.GetString(dataReader, "Remarks", String.Empty);
sol_Stage.Status = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
sol_Stage.DateClosed = SqlClientUtility.GetDateTime(dataReader, "DateClosed", new DateTime(0));
return(sol_Stage);
}
/// <summary>
/// Creates a new instance of the sol_Orders class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Order MakeSol_Order(SqlDataReader dataReader)
{
Sol_Order sol_Order = new Sol_Order();
sol_Order.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0);
sol_Order.OrderType = SqlClientUtility.GetString(dataReader, "OrderType", String.Empty);
sol_Order.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
sol_Order.ComputerName = SqlClientUtility.GetString(dataReader, "ComputerName", String.Empty);
sol_Order.UserID = SqlClientUtility.GetGuid(dataReader, "UserID", Guid.Empty);
sol_Order.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
sol_Order.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_Order.CashTrayID = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0);
sol_Order.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
sol_Order.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
sol_Order.Address1 = SqlClientUtility.GetString(dataReader, "Address1", String.Empty);
sol_Order.Address2 = SqlClientUtility.GetString(dataReader, "Address2", String.Empty);
sol_Order.City = SqlClientUtility.GetString(dataReader, "City", String.Empty);
sol_Order.Province = SqlClientUtility.GetString(dataReader, "Province", String.Empty);
sol_Order.Country = SqlClientUtility.GetString(dataReader, "Country", String.Empty);
sol_Order.PostalCode = SqlClientUtility.GetString(dataReader, "PostalCode", String.Empty);
sol_Order.TotalAmount = SqlClientUtility.GetDecimal(dataReader, "TotalAmount", Decimal.Zero);
sol_Order.DateClosed = SqlClientUtility.GetDateTime(dataReader, "DateClosed", new DateTime(0));
sol_Order.DatePaid = SqlClientUtility.GetDateTime(dataReader, "DatePaid", new DateTime(0));
sol_Order.FeeID = SqlClientUtility.GetInt32(dataReader, "FeeID", 0);
sol_Order.FeeAmount = SqlClientUtility.GetDecimal(dataReader, "FeeAmount", Decimal.Zero);
sol_Order.Tax1Amount = SqlClientUtility.GetDecimal(dataReader, "Tax1Amount", Decimal.Zero);
sol_Order.Tax2Amount = SqlClientUtility.GetDecimal(dataReader, "Tax2Amount", Decimal.Zero);
sol_Order.Status = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
sol_Order.Reference = SqlClientUtility.GetString(dataReader, "Reference", String.Empty);
sol_Order.PaymentTypeID = SqlClientUtility.GetByte(dataReader, "PaymentTypeID", 0x00);
sol_Order.SecurityCode = SqlClientUtility.GetString(dataReader, "SecurityCode", String.Empty);
sol_Order.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
//sol_Order.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);
return(sol_Order);
}