/// <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);
}
protected virtual LocationRuleView MakeLocationRuleView(SqlDataReader dataReader)
{
LocationRuleView locationRule = new LocationRuleView();
// Table columns
locationRule.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
locationRule.Code = SqlClientUtility.GetString(dataReader, "Code", String.Empty);
locationRule.LocationID = SqlClientUtility.GetInt32(dataReader, "LocationID", 0);
locationRule.RuleID = SqlClientUtility.GetInt32(dataReader, "RuleID", 0);
locationRule.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
locationRule.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
locationRule.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
locationRule.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
locationRule.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
locationRule.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
locationRule.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
// Extended columns from view
locationRule.MapLatitude = SqlClientUtility.GetDecimal(dataReader, "MapLatitude", 0);
locationRule.MapLongitude = SqlClientUtility.GetDecimal(dataReader, "MapLongitude", 0);
locationRule.RadiusK = SqlClientUtility.GetDecimal(dataReader, "RadiusK", 0);
locationRule.WarnK = SqlClientUtility.GetDecimal(dataReader, "WarnK", 0);
locationRule.Direction = SqlClientUtility.GetInt32(dataReader, "Direction", 0);
locationRule.Message = SqlClientUtility.GetString(dataReader, "Message", String.Empty);
locationRule.LocationName = SqlClientUtility.GetString(dataReader, "LocationName", String.Empty);
locationRule.LocationType = SqlClientUtility.GetInt32(dataReader, "LocationType", 0);
locationRule.Polygon = SqlClientUtility.GetString(dataReader, "Polygon", String.Empty);
return(locationRule);
}
/// <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>
/// Creates a new instance of the sol_QueryDate class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_QueryDate MakeSol_QueryDate(SqlDataReader dataReader)
{
Sol_QueryDate sol_QueryDate = new Sol_QueryDate();
sol_QueryDate.DateFrom = SqlClientUtility.GetDateTime(dataReader, "DateFrom", new DateTime(0));
sol_QueryDate.DateTo = SqlClientUtility.GetDateTime(dataReader, "DateTo", new DateTime(0));
sol_QueryDate.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
return(sol_QueryDate);
}
/// <summary>
/// Creates a new instance of the DON_DAT_HANG class and populates it with data from the specified SqlDataReader.
/// </summary>
private DONDATHANG_DTO MakeDONDATHANG_DTO(SqlDataReader dataReader)
{
DONDATHANG_DTO DonDatHang = new DONDATHANG_DTO();
DonDatHang.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
DonDatHang.NgayDat = SqlClientUtility.GetDateTime(dataReader, "NGAY_DAT", DateTime.Now);
DonDatHang.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
DonDatHang.TongSoLuong = SqlClientUtility.GetInt32(dataReader, "TONG_SO_LUONG", 0);
return(DonDatHang);
}
/// <summary>
/// Creates a new instance of the PHIEU_NHAP_XE class and populates it with data from the specified SqlDataReader.
/// </summary>
private PHIEUNHAPXE_DTO MakePHIEUNHAPXE_DTO(SqlDataReader dataReader)
{
PHIEUNHAPXE_DTO PhieuNhapXe = new PHIEUNHAPXE_DTO();
PhieuNhapXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
PhieuNhapXe.MaDonDatHang = SqlClientUtility.GetInt32(dataReader, "MA_DON_DAT_HANG", 0);
PhieuNhapXe.NgayNhap = SqlClientUtility.GetDateTime(dataReader, "NGAY_NHAP", DateTime.Now);
PhieuNhapXe.TongSoLuong = SqlClientUtility.GetInt32(dataReader, "TONG_SO_LUONG", 0);
return(PhieuNhapXe);
}
/// <summary>
/// Creates a new instance of the PHIEU_XUAT_XE class and populates it with data from the specified SqlDataReader.
/// </summary>
private PHIEUXUATXE_DTO MakePHIEUXUATXE_DTO(SqlDataReader dataReader)
{
PHIEUXUATXE_DTO PhieuXuatXe = new PHIEUXUATXE_DTO();
PhieuXuatXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
PhieuXuatXe.NgayXuat = SqlClientUtility.GetDateTime(dataReader, "NGAY_XUAT", DateTime.Now);
PhieuXuatXe.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
PhieuXuatXe.TongSoLuong = SqlClientUtility.GetInt32(dataReader, "TONG_SO_LUONG", 0);
return(PhieuXuatXe);
}
/// <summary>
/// Creates a new instance of the BIEN_NHAN class and populates it with data from the specified SqlDataReader.
/// </summary>
private BIENNHAN_DTO MakeBIENNHAN_DTO(SqlDataReader dataReader)
{
BIENNHAN_DTO BienNhan = new BIENNHAN_DTO();
BienNhan.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
BienNhan.MaHoaDon = SqlClientUtility.GetInt32(dataReader, "MA_HOA_DON", 0);
BienNhan.NgayThanhToan = SqlClientUtility.GetDateTime(dataReader, "NGAY_THANH_TOAN", DateTime.Now);
BienNhan.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
BienNhan.SoTien = SqlClientUtility.GetDecimal(dataReader, "SO_TIEN", Decimal.Zero);
return(BienNhan);
}
/// <summary>
/// Creates a new instance of the Sol_OrderCardLog class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_OrderCardLog MakeSol_OrderCardLog(SqlDataReader dataReader)
{
Sol_OrderCardLog sol_OrderCardLog = new Sol_OrderCardLog();
sol_OrderCardLog.LogID = SqlClientUtility.GetInt32(dataReader, "LogID", 0);
sol_OrderCardLog.CardNumber = SqlClientUtility.GetString(dataReader, "CardNumber", String.Empty);
sol_OrderCardLog.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0);
sol_OrderCardLog.DateAdded = SqlClientUtility.GetDateTime(dataReader, "DateAdded", new DateTime(0));
sol_OrderCardLog.DatePaid = SqlClientUtility.GetDateTime(dataReader, "DatePaid", new DateTime(0));
return(sol_OrderCardLog);
}
/// <summary>
/// Creates a new instance of the PHIEU_DAT_XE class and populates it with data from the specified SqlDataReader.
/// </summary>
private PHIEUDATXE_DTO MakePHIEUDATXE_DTO(SqlDataReader dataReader)
{
PHIEUDATXE_DTO PhieuDatXe = new PHIEUDATXE_DTO();
PhieuDatXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
PhieuDatXe.MaKhachHang = SqlClientUtility.GetInt32(dataReader, "MA_KHACH_HANG", 0);
PhieuDatXe.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
PhieuDatXe.NgayDat = SqlClientUtility.GetDateTime(dataReader, "NGAY_DAT", DateTime.Now);
PhieuDatXe.NgayHenLay = SqlClientUtility.GetDateTime(dataReader, "NGAY_HEN_LAY", DateTime.Now);
PhieuDatXe.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
PhieuDatXe.TienTraTruoc = SqlClientUtility.GetDecimal(dataReader, "TIEN_TRA_TRUOC", Decimal.Zero);
return(PhieuDatXe);
}
/// <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 HOA_DON class and populates it with data from the specified SqlDataReader.
/// </summary>
private HOADON_DTO MakeHOADON_DTO(SqlDataReader dataReader)
{
HOADON_DTO HoaDon = new HOADON_DTO();
HoaDon.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
HoaDon.MaKhachHang = SqlClientUtility.GetInt32(dataReader, "MA_KHACH_HANG", 0);
HoaDon.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
HoaDon.NgayLap = SqlClientUtility.GetDateTime(dataReader, "NGAY_LAP", DateTime.Now);
HoaDon.KieuThanhToan = SqlClientUtility.GetBoolean(dataReader, "KIEU_THANH_TOAN", false);
HoaDon.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
HoaDon.TienTraMoiDot = SqlClientUtility.GetDecimal(dataReader, "TIEN_TRA_MOI_DOT", Decimal.Zero);
HoaDon.SoLanTra = SqlClientUtility.GetInt32(dataReader, "SO_LAN_TRA", 0);
return(HoaDon);
}
/// <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>
/// 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 LocationRule class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual LocationRule MakeLocationRule(SqlDataReader dataReader)
{
LocationRule locationRule = new LocationRule();
locationRule.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
locationRule.Code = SqlClientUtility.GetString(dataReader, "Code", String.Empty);
locationRule.LocationID = SqlClientUtility.GetInt32(dataReader, "LocationID", 0);
locationRule.RuleID = SqlClientUtility.GetInt32(dataReader, "RuleID", 0);
locationRule.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
locationRule.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
locationRule.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
locationRule.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
locationRule.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
locationRule.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
locationRule.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
return(locationRule);
}
/// <summary>
/// Creates a new instance of the NHAN_VIEN class and populates it with data from the specified SqlDataReader.
/// </summary>
private NHANVIEN_DTO MakeNHANVIEN_DTO(SqlDataReader dataReader)
{
NHANVIEN_DTO NhanVien = new NHANVIEN_DTO();
NhanVien.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
NhanVien.HoTen = SqlClientUtility.GetString(dataReader, "HO_TEN", String.Empty);
NhanVien.MaLoaiNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_LOAI_NHAN_VIEN", 0);
NhanVien.TenLoaiNhanVien = SqlClientUtility.GetString(dataReader, "TEN_LOAI_NHAN_VIEN", string.Empty);
NhanVien.Username = SqlClientUtility.GetString(dataReader, "USERNAME", String.Empty);
NhanVien.UserPassword = SqlClientUtility.GetString(dataReader, "USER_PASSWORD", String.Empty);
NhanVien.Phai = SqlClientUtility.GetBoolean(dataReader, "PHAI", false);
NhanVien.NgaySinh = SqlClientUtility.GetDateTime(dataReader, "NGAY_SINH", DateTime.Now);
NhanVien.DiaChi = SqlClientUtility.GetString(dataReader, "DIA_CHI", String.Empty);
NhanVien.DienThoai = SqlClientUtility.GetString(dataReader, "DIEN_THOAI", String.Empty);
NhanVien.Cmnd = SqlClientUtility.GetString(dataReader, "CMND", String.Empty);
return(NhanVien);
}
/// <summary>
/// Creates a new instance of the Qds_Bag class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_Bag MakeQds_Bag(SqlDataReader dataReader)
{
Qds_Bag qds_Bag = new Qds_Bag();
qds_Bag.BagID = SqlClientUtility.GetInt32(dataReader, "BagID", 0);
qds_Bag.DropID = SqlClientUtility.GetInt32(dataReader, "DropID", 0);
qds_Bag.BagEstimateUnderLitre = SqlClientUtility.GetInt32(dataReader, "BagEstimateUnderLitre", 0);
qds_Bag.BagEstimateOverLitre = SqlClientUtility.GetInt32(dataReader, "BagEstimateOverLitre", 0);
qds_Bag.DateEntered = SqlClientUtility.GetDateTime(dataReader, "DateEntered", DateTime.Now);
qds_Bag.DateAccepted = SqlClientUtility.GetDateTime(dataReader, "DateAccepted", DateTime.Now);
qds_Bag.DateCounted = SqlClientUtility.GetDateTime(dataReader, "DateCounted", DateTime.Now);
qds_Bag.DatePaid = SqlClientUtility.GetDateTime(dataReader, "DatePaid", DateTime.Now);
qds_Bag.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty);
qds_Bag.DatePrinted = SqlClientUtility.GetDateTime(dataReader, "DatePrinted", DateTime.Now);
//qds_Bag.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);
return(qds_Bag);
}
/// <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);
}
protected virtual QtiRowView MakeQtiRowView(SqlDataReader dataReader)
{
QtiRowView qtiRow = new QtiRowView();
// Table columns
qtiRow.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
qtiRow.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
qtiRow.TimesheetID = SqlClientUtility.GetInt32(dataReader, "TimesheetID", 0);
qtiRow.TimeFrom = SqlClientUtility.GetDateTime(dataReader, "TimeFrom", DateTime.Now);
qtiRow.TimeTo = SqlClientUtility.GetDateTime(dataReader, "TimeTo", DateTime.Now);
qtiRow.BreakHours = SqlClientUtility.GetDecimal(dataReader, "BreakHours", Decimal.Zero);
qtiRow.Hours = SqlClientUtility.GetDecimal(dataReader, "Hours", Decimal.Zero);
qtiRow.Activity = SqlClientUtility.GetString(dataReader, "Activity", String.Empty);
qtiRow.OvernightStay = SqlClientUtility.GetBoolean(dataReader, "OvernightStay", false);
qtiRow.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
qtiRow.ProjectPersonID = SqlClientUtility.GetInt32(dataReader, "ProjectPersonID", 0);
qtiRow.ExpensesAmount = SqlClientUtility.GetDecimal(dataReader, "ExpensesAmount", Decimal.Zero);
qtiRow.Mileage = SqlClientUtility.GetDecimal(dataReader, "Mileage", Decimal.Zero);
qtiRow.FromLocationID = SqlClientUtility.GetInt32(dataReader, "FromLocationID", 0);
qtiRow.ToLocationID = SqlClientUtility.GetInt32(dataReader, "ToLocationID", 0);
qtiRow.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
qtiRow.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
qtiRow.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
qtiRow.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
qtiRow.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
qtiRow.ExpensesDetails = SqlClientUtility.GetString(dataReader, "ExpensesDetails", String.Empty);
// Extended columns from view
qtiRow.ProjectCode = SqlClientUtility.GetString(dataReader, "ProjectCode", String.Empty);
qtiRow.ProjectName = SqlClientUtility.GetString(dataReader, "ProjectName", String.Empty);
qtiRow.CustomerCode = SqlClientUtility.GetString(dataReader, "CustomerCode", String.Empty);
qtiRow.CustomerName = SqlClientUtility.GetString(dataReader, "CustomerName", String.Empty);
qtiRow.FromLocationName = SqlClientUtility.GetString(dataReader, "FromLocationName", String.Empty);
qtiRow.ToLocationName = SqlClientUtility.GetString(dataReader, "ToLocationName", String.Empty);
qtiRow.MaxDailyHours = SqlClientUtility.GetDecimal(dataReader, "MaxDailyHours", Decimal.Zero);
qtiRow.ProjectFullName = (qtiRow.ProjectCode.Length > 0 ? qtiRow.ProjectCode + " - " : String.Empty) + qtiRow.ProjectName;
qtiRow.CustomerFullName = (qtiRow.CustomerCode.Length > 0 ? qtiRow.CustomerCode + " - " : String.Empty) + qtiRow.CustomerName;
return(qtiRow);
}
/// <summary>
/// Creates a new instance of the sol_Payments class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Payment MakeSol_Payment(SqlDataReader dataReader)
{
Sol_Payment sol_Payment = new Sol_Payment();
sol_Payment.PaymentID = SqlClientUtility.GetInt32(dataReader, "PaymentID", 0);
sol_Payment.PaymentAmount = SqlClientUtility.GetFloat(dataReader, "PaymentAmount", 0.0F);
sol_Payment.Date = SqlClientUtility.GetDateTime(dataReader, "date", new DateTime(0));
sol_Payment.UserID = SqlClientUtility.GetInt32(dataReader, "UserID", 0);
sol_Payment.UserName = SqlClientUtility.GetString(dataReader, "UserName", String.Empty);
sol_Payment.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
sol_Payment.ChequeNumber = SqlClientUtility.GetString(dataReader, "ChequeNumber", String.Empty);
sol_Payment.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
sol_Payment.Address1 = SqlClientUtility.GetString(dataReader, "Address1", String.Empty);
sol_Payment.Address2 = SqlClientUtility.GetString(dataReader, "Address2", String.Empty);
sol_Payment.City = SqlClientUtility.GetString(dataReader, "City", String.Empty);
sol_Payment.Province = SqlClientUtility.GetString(dataReader, "Province", String.Empty);
sol_Payment.Country = SqlClientUtility.GetString(dataReader, "Country", String.Empty);
sol_Payment.PostalCode = SqlClientUtility.GetString(dataReader, "PostalCode", String.Empty);
return(sol_Payment);
}
/// <summary>
/// Creates a new instance of the Rule class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Rule MakeRule(SqlDataReader dataReader)
{
Rule rule = new Rule();
rule.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
rule.Code = SqlClientUtility.GetString(dataReader, "Code", String.Empty);
rule.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
rule.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
rule.RadiusK = SqlClientUtility.GetDecimal(dataReader, "RadiusK", Decimal.Zero);
rule.WarnK = SqlClientUtility.GetDecimal(dataReader, "WarnK", Decimal.Zero);
rule.Direction = SqlClientUtility.GetInt32(dataReader, "Direction", 0);
rule.Message = SqlClientUtility.GetString(dataReader, "Message", String.Empty);
rule.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
rule.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
rule.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
rule.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
rule.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
rule.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
return(rule);
}
/// <summary>
/// Creates a new instance of the sol_OrdersDetail class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_OrdersDetail MakeSol_OrdersDetail(SqlDataReader dataReader)
{
Sol_OrdersDetail sol_OrdersDetail = new Sol_OrdersDetail();
sol_OrdersDetail.DetailID = SqlClientUtility.GetInt32(dataReader, "DetailID", 0);
sol_OrdersDetail.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0);
sol_OrdersDetail.OrderType = SqlClientUtility.GetString(dataReader, "OrderType", String.Empty);
sol_OrdersDetail.Date = SqlClientUtility.GetDateTime(dataReader, "Date", new DateTime(0));
sol_OrdersDetail.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0);
sol_OrdersDetail.ProductID = SqlClientUtility.GetInt32(dataReader, "ProductID", 0);
sol_OrdersDetail.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty);
sol_OrdersDetail.Quantity = SqlClientUtility.GetInt32(dataReader, "Quantity", 0);
sol_OrdersDetail.Price = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero);
sol_OrdersDetail.Amount = SqlClientUtility.GetDecimal(dataReader, "Amount", Decimal.Zero);
sol_OrdersDetail.Status = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
sol_OrdersDetail.CategoryButtonID = SqlClientUtility.GetInt32(dataReader, "CategoryButtonID", 0);
sol_OrdersDetail.BagID = SqlClientUtility.GetInt32(dataReader, "BagID", 0);
//sol_OrdersDetail.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false);
sol_OrdersDetail.ConveyorID = SqlClientUtility.GetInt32(dataReader, "ConveyorID", 0);
sol_OrdersDetail.StageID = SqlClientUtility.GetInt32(dataReader, "StageID", 0);
return(sol_OrdersDetail);
}
/// <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 Location class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Location MakeLocation(SqlDataReader dataReader)
{
Location location = new Location();
location.ID = SqlClientUtility.GetInt32(dataReader, "ID", 0);
location.Code = SqlClientUtility.GetString(dataReader, "Code", String.Empty);
location.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty);
location.MapLatitude = SqlClientUtility.GetDecimal(dataReader, "MapLatitude", Decimal.Zero);
location.MapLongitude = SqlClientUtility.GetDecimal(dataReader, "MapLongitude", Decimal.Zero);
location.IsApproved = SqlClientUtility.GetBoolean(dataReader, "IsApproved", false);
location.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
location.AuthorComments = SqlClientUtility.GetString(dataReader, "AuthorComments", String.Empty);
location.ApproverComments = SqlClientUtility.GetString(dataReader, "ApproverComments", String.Empty);
location.Comments = SqlClientUtility.GetString(dataReader, "Comments", String.Empty);
location.LocationType = SqlClientUtility.GetInt32(dataReader, "LocationType", 0);
location.Polygon = SqlClientUtility.GetString(dataReader, "Polygon", String.Empty);
location.InternalComment = SqlClientUtility.GetString(dataReader, "InternalComment", String.Empty);
location.CreatedBy = SqlClientUtility.GetString(dataReader, "CreatedBy", String.Empty);
location.CreatedOn = SqlClientUtility.GetDateTime(dataReader, "CreatedOn", DateTime.Now);
location.AuditActionBy = SqlClientUtility.GetString(dataReader, "AuditActionBy", String.Empty);
location.AuditActionOn = SqlClientUtility.GetDateTime(dataReader, "AuditActionOn", DateTime.Now);
return(location);
}
/// <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);
}
/// <summary>
/// Creates a new instance of the sol_Control class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sol_Control MakeSol_Control(SqlDataReader dataReader)
{
Sol_Control sol_Control = new Sol_Control();
sol_Control.ControlID = SqlClientUtility.GetInt32(dataReader, "ControlID", 0);
sol_Control.BusinessName = SqlClientUtility.GetString(dataReader, "BusinessName", String.Empty);
sol_Control.LegalName = SqlClientUtility.GetString(dataReader, "LegalName", String.Empty);
sol_Control.StoreNumber = SqlClientUtility.GetInt32(dataReader, "StoreNumber", 0);
sol_Control.Address = SqlClientUtility.GetString(dataReader, "Address", String.Empty);
sol_Control.City = SqlClientUtility.GetString(dataReader, "City", String.Empty);
sol_Control.State = SqlClientUtility.GetString(dataReader, "State", String.Empty);
sol_Control.Country = SqlClientUtility.GetString(dataReader, "Country", String.Empty);
sol_Control.PhoneNumber = SqlClientUtility.GetString(dataReader, "PhoneNumber", String.Empty);
sol_Control.BusinessHoursFrom = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFrom", new DateTime(0));
sol_Control.BusinessHoursTo = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursTo", new DateTime(0));
sol_Control.IdFiscal1Name = SqlClientUtility.GetString(dataReader, "IdFiscal1Name", String.Empty);
sol_Control.IdFiscal1Value = SqlClientUtility.GetString(dataReader, "IdFiscal1Value", String.Empty);
sol_Control.IdFiscal2Name = SqlClientUtility.GetString(dataReader, "IdFiscal2Name", String.Empty);
sol_Control.IdFiscal2Value = SqlClientUtility.GetString(dataReader, "IdFiscal2Value", String.Empty);
sol_Control.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0);
sol_Control.CustomerScreenMessageID = SqlClientUtility.GetInt32(dataReader, "CustomerScreenMessageID", 0);
sol_Control.FrontStationMessageID = SqlClientUtility.GetInt32(dataReader, "FrontStationMessageID", 0);
sol_Control.CashierRoutineMessageID = SqlClientUtility.GetInt32(dataReader, "CashierRoutineMessageID", 0);
sol_Control.ReturnStationMessageID = SqlClientUtility.GetInt32(dataReader, "ReturnStationMessageID", 0);
sol_Control.CashierStationMessageID = SqlClientUtility.GetInt32(dataReader, "CashierStationMessageID", 0);
sol_Control.ShippingStationMessageID = SqlClientUtility.GetInt32(dataReader, "ShippingStationMessageID", 0);
sol_Control.ReceiptMessageID = SqlClientUtility.GetInt32(dataReader, "ReceiptMessageID", 0);
sol_Control.SMTPServer = SqlClientUtility.GetString(dataReader, "SMTPServer", String.Empty);
sol_Control.SMTPPort = SqlClientUtility.GetInt32(dataReader, "SMTPPort", 0);
sol_Control.EmailAccount = SqlClientUtility.GetString(dataReader, "EmailAccount", String.Empty);
sol_Control.EmailPassword = SqlClientUtility.GetString(dataReader, "EmailPassword", String.Empty);
sol_Control.HistoryYears = SqlClientUtility.GetByte(dataReader, "HistoryYears", 0x00);
sol_Control.FiscalYearInitialMonth = SqlClientUtility.GetByte(dataReader, "FiscalYearInitialMonth", 0x00);
sol_Control.NumericKeyPadOn = SqlClientUtility.GetBoolean(dataReader, "NumericKeyPadOn", false);
sol_Control.NumericKeyPadPosition = SqlClientUtility.GetByte(dataReader, "NumericKeyPadPosition", 0x00);
sol_Control.ReturnButtonExtra = SqlClientUtility.GetByte(dataReader, "ReturnButtonExtra", 0x00);
sol_Control.Tax1Name = SqlClientUtility.GetString(dataReader, "Tax1Name", String.Empty);
sol_Control.Tax1Rate = SqlClientUtility.GetDecimal(dataReader, "Tax1Rate", Decimal.Zero);
sol_Control.Tax2Name = SqlClientUtility.GetString(dataReader, "Tax2Name", String.Empty);
sol_Control.Tax2Rate = SqlClientUtility.GetDecimal(dataReader, "Tax2Rate", Decimal.Zero);
sol_Control.DatabaseVersion = SqlClientUtility.GetDecimal(dataReader, "DatabaseVersion", Decimal.Zero);
sol_Control.Status = SqlClientUtility.GetString(dataReader, "Status", String.Empty);
sol_Control.EmployeesListRefresh = SqlClientUtility.GetInt32(dataReader, "EmployeesListRefresh", 0);
sol_Control.WebBrowserUrl = SqlClientUtility.GetString(dataReader, "WebBrowserUrl", String.Empty);
sol_Control.AutoGenerateTagNumber = SqlClientUtility.GetBoolean(dataReader, "AutoGenerateTagNumber", false);
sol_Control.AutoGenerateRBillNumber = SqlClientUtility.GetBoolean(dataReader, "AutoGenerateRBillNumber", false);
sol_Control.DefaultAgencyID = SqlClientUtility.GetInt32(dataReader, "DefaultAgencyID", 0);
sol_Control.ChitTicketComplete = SqlClientUtility.GetByte(dataReader, "ChitTicketComplete", 0x00);
sol_Control.ChitTicketIncludeBarcode = SqlClientUtility.GetBoolean(dataReader, "ChitTicketIncludeBarcode", false);
sol_Control.CashOutPrintingOverride = SqlClientUtility.GetBoolean(dataReader, "CashOutPrintingOverride", false);
sol_Control.WhiteBagID = SqlClientUtility.GetInt32(dataReader, "WhiteBagID", 0);
sol_Control.BlueBagID = SqlClientUtility.GetInt32(dataReader, "BlueBagID", 0);
sol_Control.OneWayBagID = SqlClientUtility.GetInt32(dataReader, "OneWayBagID", 0);
sol_Control.ABCRCPalletsID = SqlClientUtility.GetInt32(dataReader, "ABCRCPalletsID", 0);
sol_Control.CustomerScreenMonitor = SqlClientUtility.GetByte(dataReader, "CustomerScreenMonitor", 0x00);
sol_Control.CategoryButtonsPanelBgColor = SqlClientUtility.GetInt32(dataReader, "CategoryButtonsPanelBgColor", 0);
sol_Control.CategoryButtonsSnapToGrid = SqlClientUtility.GetBoolean(dataReader, "CategoryButtonsSnapToGrid", false);
sol_Control.BusinessHoursFromTue = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromTue", new DateTime(0));
sol_Control.BusinessHoursToTue = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToTue", new DateTime(0));
sol_Control.BusinessHoursFromWed = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromWed", new DateTime(0));
sol_Control.BusinessHoursToWed = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToWed", new DateTime(0));
sol_Control.BusinessHoursFromThu = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromThu", new DateTime(0));
sol_Control.BusinessHoursToThu = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToThu", new DateTime(0));
sol_Control.BusinessHoursFromFri = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromFri", new DateTime(0));
sol_Control.BusinessHoursToFri = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToFri", new DateTime(0));
sol_Control.BusinessHoursFromSat = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromSat", new DateTime(0));
sol_Control.BusinessHoursToSat = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToSat", new DateTime(0));
sol_Control.BusinessHoursFromSun = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursFromSun", new DateTime(0));
sol_Control.BusinessHoursToSun = SqlClientUtility.GetDateTime(dataReader, "BusinessHoursToSun", new DateTime(0));
sol_Control.ReturnsMaxQuantity = SqlClientUtility.GetInt32(dataReader, "ReturnsMaxQuantity", 0);
sol_Control.WebBrowserUpdateHistoryUrl = SqlClientUtility.GetString(dataReader, "WebBrowserUpdateHistoryUrl", String.Empty);
sol_Control.CashierMaxAmount = SqlClientUtility.GetDecimal(dataReader, "CashierMaxAmount", Decimal.Zero);
sol_Control.ComputerRole = SqlClientUtility.GetByte(dataReader, "ComputerRole", 0x00);
sol_Control.SqlServerDate = SqlClientUtility.GetBoolean(dataReader, "SqlServerDate", false);
sol_Control.VendorID = SqlClientUtility.GetInt32(dataReader, "VendorID", 0);
sol_Control.DefaultPlantID = SqlClientUtility.GetInt32(dataReader, "DefaultPlantID", 0);
sol_Control.DefaultCarrierID = SqlClientUtility.GetInt32(dataReader, "DefaultCarrierID", 0);
sol_Control.ABCRCUserName = SqlClientUtility.GetString(dataReader, "ABCRCUserName", String.Empty);
sol_Control.ABCRCPassword = SqlClientUtility.GetString(dataReader, "ABCRCPassword", String.Empty);
sol_Control.ReceiptAmountBarcode = SqlClientUtility.GetBoolean(dataReader, "ReceiptAmountBarcode", false);
sol_Control.IncludeSecurityCode = SqlClientUtility.GetBoolean(dataReader, "IncludeSecurityCode", false);
sol_Control.RBillNumberBarcode = SqlClientUtility.GetBoolean(dataReader, "RBillNumberBarcode", false);
sol_Control.SacCashTrayID = SqlClientUtility.GetInt32(dataReader, "SacCashTrayID", 0);
return(sol_Control);
}