/// <summary> /// Selects a single record from the sol_Entries table. /// </summary> public virtual decimal GetValueOfFloat(int cashTrayID, int closingEntryID) { /* * @CashTrayID int, --not required when providing Closing EntryID * @ClosingEntryID int = NULL --optional if you want to know the calculated value of a previous close * */ SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CashTrayID", cashTrayID), new SqlParameter("@ClosingEntryID", closingEntryID) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_Entries_GetValueOfFloat", parameters)) { if (dataReader.Read()) { return(SqlClientUtility.GetDecimal(dataReader, "CurrentFloat", Decimal.Zero)); } else { return(0m); } } }
/// <summary> /// Selects a single record from the sol_Orders table. /// </summary> public virtual void CheckIntegrity( int orderID, string orderType, ref decimal @TotalAmount, ref decimal @DetailTotalAmount ) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@OrderID", orderID), new SqlParameter("@OrderType", orderType) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_Orders_CheckIntegrity", parameters)) { if (dataReader.Read()) { @TotalAmount = SqlClientUtility.GetDecimal(dataReader, "TotalAmount", Decimal.Zero); @DetailTotalAmount = SqlClientUtility.GetDecimal(dataReader, "DetailTotalAmount", Decimal.Zero); //return MakeSol_Order(dataReader); } else { @TotalAmount = Decimal.Zero; @DetailTotalAmount = Decimal.Zero; //return null; } } }
/// <summary> /// Creates a new instance of the sol_Products class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Product MakeSol_Product(SqlDataReader dataReader) { Sol_Product sol_Product = new Sol_Product(); sol_Product.ProductID = SqlClientUtility.GetInt32(dataReader, "ProductID", 0); sol_Product.ProName = SqlClientUtility.GetString(dataReader, "ProName", String.Empty); sol_Product.ProDescription = SqlClientUtility.GetString(dataReader, "ProDescription", String.Empty); sol_Product.ProShortDescription = SqlClientUtility.GetString(dataReader, "ProShortDescription", String.Empty); sol_Product.ProImage = SqlClientUtility.GetBytes(dataReader, "ProImage", new byte[0]); sol_Product.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0); sol_Product.MenuOrder = SqlClientUtility.GetInt32(dataReader, "MenuOrder", 0); sol_Product.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false); sol_Product.Price = SqlClientUtility.GetDecimal(dataReader, "Price", Decimal.Zero); sol_Product.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0); sol_Product.RefundAmount = SqlClientUtility.GetDecimal(dataReader, "RefundAmount", Decimal.Zero); sol_Product.HandlingCommissionAmount = SqlClientUtility.GetDecimal(dataReader, "HandlingCommissionAmount", Decimal.Zero); sol_Product.CommissionUnit = SqlClientUtility.GetInt32(dataReader, "CommissionUnit", 0); sol_Product.VafAmount = SqlClientUtility.GetDecimal(dataReader, "VafAmount", Decimal.Zero); sol_Product.FeeUnit = SqlClientUtility.GetInt32(dataReader, "FeeUnit", 0); sol_Product.ContainerID = SqlClientUtility.GetInt32(dataReader, "ContainerID", 0); sol_Product.StandardDozenID = SqlClientUtility.GetInt32(dataReader, "StandardDozenID", 0); sol_Product.UPC = SqlClientUtility.GetString(dataReader, "UPC", String.Empty); sol_Product.ProductCode = SqlClientUtility.GetString(dataReader, "ProductCode", String.Empty); sol_Product.TypeId = SqlClientUtility.GetByte(dataReader, "TypeId", 0x00); sol_Product.Tax1Exempt = SqlClientUtility.GetBoolean(dataReader, "Tax1Exempt", false); sol_Product.Tax2Exempt = SqlClientUtility.GetBoolean(dataReader, "Tax2Exempt", false); sol_Product.MasterProductID = SqlClientUtility.GetInt32(dataReader, "MasterProductID", 0); sol_Product.Weight = SqlClientUtility.GetDecimal(dataReader, "Weight", Decimal.Zero); sol_Product.Volume = SqlClientUtility.GetDecimal(dataReader, "Volume", Decimal.Zero); sol_Product.TargetQuantity = SqlClientUtility.GetInt32(dataReader, "TargetQuantity", 0); return(sol_Product); }
/// <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); }
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_ClientNames class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_ClientName MakeSac_ClientName(SqlDataReader dataReader) { Sac_ClientName sac_ClientName = new Sac_ClientName(); sac_ClientName.ClientID = SqlClientUtility.GetString(dataReader, "ClientID", String.Empty); sac_ClientName.CashTrayID = SqlClientUtility.GetInt32(dataReader, "CashTrayID", 0); sac_ClientName.CoinAmountInventory = SqlClientUtility.GetDecimal(dataReader, "CoinAmountInventory", Decimal.Zero); return(sac_ClientName); }
/// <summary> /// Creates a new instance of the sol_Fees class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Fee MakeSol_Fee(SqlDataReader dataReader) { Sol_Fee sol_Fee = new Sol_Fee(); sol_Fee.FeeID = SqlClientUtility.GetInt32(dataReader, "FeeID", 0); sol_Fee.FeeDescription = SqlClientUtility.GetString(dataReader, "FeeDescription", String.Empty); sol_Fee.FeeAmount = SqlClientUtility.GetDecimal(dataReader, "FeeAmount", Decimal.Zero); sol_Fee.Percentage = SqlClientUtility.GetBoolean(dataReader, "Percentage", false); return(sol_Fee); }
/// <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 Sac_Money class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_Money MakeSac_Money(SqlDataReader dataReader) { Sac_Money sac_Money = new Sac_Money(); sac_Money.MoneyID = SqlClientUtility.GetInt32(dataReader, "MoneyID", 0); sac_Money.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sac_Money.TypeID = SqlClientUtility.GetByte(dataReader, "TypeID", 0x00); sac_Money.DollarValue = SqlClientUtility.GetDecimal(dataReader, "DollarValue", Decimal.Zero); sac_Money.CountryCode = SqlClientUtility.GetString(dataReader, "CountryCode", String.Empty); return(sac_Money); }
/// <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 CT_DON_DAT_HANG class and populates it with data from the specified SqlDataReader. /// </summary> private CTDONDATHANG_DTO MakeCTDONDATHANG_DTO(SqlDataReader dataReader) { CTDONDATHANG_DTO CtDonDatHang = new CTDONDATHANG_DTO(); CtDonDatHang.MaDonDatHang = SqlClientUtility.GetInt32(dataReader, "MA_DON_DAT_HANG", 0); CtDonDatHang.MaXe = SqlClientUtility.GetInt32(dataReader, "MA_XE", 0); CtDonDatHang.MaMau = SqlClientUtility.GetString(dataReader, "MA_MAU", String.Empty); CtDonDatHang.SoLuong = SqlClientUtility.GetInt32(dataReader, "SO_LUONG", 0); CtDonDatHang.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero); return(CtDonDatHang); }
/// <summary> /// Creates a new instance of the CHI_TIET_HOA_DON class and populates it with data from the specified SqlDataReader. /// </summary> private CHITIETHOADON_DTO MakeCHITIETHOADON_DTO(SqlDataReader dataReader) { CHITIETHOADON_DTO ChiTietHoaDon = new CHITIETHOADON_DTO(); ChiTietHoaDon.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); ChiTietHoaDon.MaHoaDon = SqlClientUtility.GetInt32(dataReader, "MA_HOA_DON", 0); ChiTietHoaDon.MaXe = SqlClientUtility.GetInt32(dataReader, "MA_XE", 0); ChiTietHoaDon.MaMau = SqlClientUtility.GetString(dataReader, "MA_MAU", String.Empty); ChiTietHoaDon.SoLuong = SqlClientUtility.GetInt32(dataReader, "SO_LUONG", 0); ChiTietHoaDon.ThanhTien = SqlClientUtility.GetDecimal(dataReader, "THANH_TIEN", Decimal.Zero); return(ChiTietHoaDon); }
/// <summary> /// Creates a new instance of the Sol_Categories class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Category MakeSol_Category(SqlDataReader dataReader) { Sol_Category Sol_Category = new Sol_Category(); Sol_Category.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0); Sol_Category.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); Sol_Category.RefundAmount = SqlClientUtility.GetDecimal(dataReader, "RefundAmount", Decimal.Zero); Sol_Category.SubContainerQuantity = SqlClientUtility.GetInt32(dataReader, "SubContainerQuantity", 0); Sol_Category.StagingMethodID = SqlClientUtility.GetInt32(dataReader, "StagingMethodID", 0); Sol_Category.StagingProductID = SqlClientUtility.GetInt32(dataReader, "StagingProductID", 0); return(Sol_Category); }
/// <summary> /// Creates a new instance of the CHI_TIET_PHIEU_DAT_XE class and populates it with data from the specified SqlDataReader. /// </summary> private CHITIETPHIEUDATXE_DTO MakeCHITIETPHIEUDATXE_DTO(SqlDataReader dataReader) { CHITIETPHIEUDATXE_DTO ChiTietPhieuDatXe = new CHITIETPHIEUDATXE_DTO(); ChiTietPhieuDatXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); ChiTietPhieuDatXe.MaPhieuDat = SqlClientUtility.GetInt32(dataReader, "MA_PHIEU_DAT", 0); ChiTietPhieuDatXe.MaXe = SqlClientUtility.GetInt32(dataReader, "MA_XE", 0); ChiTietPhieuDatXe.MaMau = SqlClientUtility.GetString(dataReader, "MA_MAU", String.Empty); ChiTietPhieuDatXe.SoLuong = SqlClientUtility.GetInt32(dataReader, "SO_LUONG", 0); ChiTietPhieuDatXe.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero); return(ChiTietPhieuDatXe); }
/// <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_CashDenominations class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_CashDenomination MakeSol_CashDenomination(SqlDataReader dataReader) { Sol_CashDenomination sol_CashDenomination = new Sol_CashDenomination(); sol_CashDenomination.CashID = SqlClientUtility.GetInt32(dataReader, "CashID", 0); sol_CashDenomination.CashType = SqlClientUtility.GetByte(dataReader, "CashType", 0x00); sol_CashDenomination.CashValue = SqlClientUtility.GetDecimal(dataReader, "CashValue", Decimal.Zero); sol_CashDenomination.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); sol_CashDenomination.OrderValue = SqlClientUtility.GetInt16(dataReader, "OrderValue", 0); sol_CashDenomination.CashItemValue = SqlClientUtility.GetDecimal(dataReader, "CashItemValue", Decimal.Zero); sol_CashDenomination.Quantity = SqlClientUtility.GetInt32(dataReader, "Quantity", 0); sol_CashDenomination.MoneyID = SqlClientUtility.GetInt32(dataReader, "MoneyID", 0); return(sol_CashDenomination); }
/// <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> /// Selects a single record from the sol_Entries table. /// </summary> public virtual decimal GetLastClosingValue(int cashTrayID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CashTrayID", cashTrayID) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_Entries_GetLastClosingValue", parameters)) { if (dataReader.Read()) { return(SqlClientUtility.GetDecimal(dataReader, "Amount", Decimal.Zero)); } else { return(0m); //} } } }
/// <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> /// Get customer balance /// </summary> public virtual decimal GetCustomerBalance(int customerID, string dateTo) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CustomerID", customerID), new SqlParameter("@DateTo", dateTo) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_Customers_Balance", parameters)) { if (dataReader.Read()) { return(SqlClientUtility.GetDecimal(dataReader, "Balance", Decimal.Zero)); } else { return(0m); } } }
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 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 XE class and populates it with data from the specified SqlDataReader. /// </summary> private XE_DTO MakeXE_DTO(SqlDataReader dataReader) { XE_DTO Xe = new XE_DTO(); Xe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); Xe.TenXe = SqlClientUtility.GetString(dataReader, "TEN_XE", String.Empty); Xe.MaKieuXe = SqlClientUtility.GetInt32(dataReader, "MA_KIEU_XE", 0); Xe.MaHangXe = SqlClientUtility.GetInt32(dataReader, "MA_HANG_XE", 0); Xe.TenHangXe = SqlClientUtility.GetString(dataReader, "TEN_HANG_XE", String.Empty); Xe.DoiXe = SqlClientUtility.GetInt32(dataReader, "DOI_XE", 0); Xe.TenKieuXe = SqlClientUtility.GetString(dataReader, "TEN_KIEU_XE", String.Empty); Xe.ChiSoNhienLieu = SqlClientUtility.GetDecimal(dataReader, "CHI_SO_NHIEN_LIEU", Decimal.Zero); Xe.MaxSpeed = SqlClientUtility.GetInt32(dataReader, "MAX_SPEED", 0); Xe.LoaiDiaHinh = SqlClientUtility.GetString(dataReader, "LOAI_DIA_HINH", String.Empty); Xe.SoChoNgoi = SqlClientUtility.GetInt32(dataReader, "SO_CHO_NGOI", 0); Xe.GiaTienBan = SqlClientUtility.GetDecimal(dataReader, "GIA_TIEN_BAN", Decimal.Zero); Xe.GiaTienMua = SqlClientUtility.GetDecimal(dataReader, "GIA_TIEN_MUA", Decimal.Zero); Xe.SoLuong = SqlClientUtility.GetInt32(dataReader, "SO_LUONG", 0); return(Xe); }
/// <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_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 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); }