/// <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_Customers class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Customer MakeSol_Customer(SqlDataReader dataReader) { Sol_Customer sol_Customer = new Sol_Customer(); sol_Customer.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0); sol_Customer.CustomerCode = SqlClientUtility.GetString(dataReader, "CustomerCode", String.Empty); sol_Customer.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sol_Customer.Contact = SqlClientUtility.GetString(dataReader, "Contact", String.Empty); sol_Customer.Address1 = SqlClientUtility.GetString(dataReader, "Address1", String.Empty); sol_Customer.Address2 = SqlClientUtility.GetString(dataReader, "Address2", String.Empty); sol_Customer.City = SqlClientUtility.GetString(dataReader, "City", String.Empty); sol_Customer.Province = SqlClientUtility.GetString(dataReader, "Province", String.Empty); sol_Customer.Country = SqlClientUtility.GetString(dataReader, "Country", String.Empty); sol_Customer.PostalCode = SqlClientUtility.GetString(dataReader, "PostalCode", String.Empty); sol_Customer.Email = SqlClientUtility.GetString(dataReader, "Email", String.Empty); sol_Customer.LoweredEmail = SqlClientUtility.GetString(dataReader, "LoweredEmail", String.Empty); sol_Customer.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false); sol_Customer.PhoneNumber = SqlClientUtility.GetString(dataReader, "PhoneNumber", String.Empty); sol_Customer.Notes = SqlClientUtility.GetString(dataReader, "Notes", String.Empty); sol_Customer.Password = SqlClientUtility.GetString(dataReader, "Password", String.Empty); sol_Customer.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty); sol_Customer.CardNumber = SqlClientUtility.GetString(dataReader, "CardNumber", String.Empty); sol_Customer.CardTypeID = SqlClientUtility.GetInt32(dataReader, "CardTypeID", 0); sol_Customer.SolumCustomer = SqlClientUtility.GetBoolean(dataReader, "SolumCustomer", false); sol_Customer.QuickDropCustomer = SqlClientUtility.GetBoolean(dataReader, "QuickDropCustomer", false); //sol_Customer.IsNew = SqlClientUtility.GetBoolean(dataReader, "IsNew", false); return(sol_Customer); }
/// <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); }
/// <summary> /// Creates a new instance of the sol_CategoryButtons class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_CategoryButton MakeSol_CategoryButton(SqlDataReader dataReader) { Sol_CategoryButton sol_CategoryButton = new Sol_CategoryButton(); sol_CategoryButton.CategoryButtonID = SqlClientUtility.GetInt32(dataReader, "CategoryButtonID", 0); sol_CategoryButton.WorkStationID = SqlClientUtility.GetInt32(dataReader, "WorkStationID", 0); sol_CategoryButton.ControlType = SqlClientUtility.GetByte(dataReader, "ControlType", 0x00); sol_CategoryButton.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); sol_CategoryButton.DefaultQuantity = SqlClientUtility.GetInt32(dataReader, "DefaultQuantity", 0); sol_CategoryButton.CategoryID = SqlClientUtility.GetInt32(dataReader, "CategoryID", 0); sol_CategoryButton.LocationX = SqlClientUtility.GetInt32(dataReader, "LocationX", 0); sol_CategoryButton.LocationY = SqlClientUtility.GetInt32(dataReader, "LocationY", 0); sol_CategoryButton.Width = SqlClientUtility.GetInt32(dataReader, "Width", 0); sol_CategoryButton.Height = SqlClientUtility.GetInt32(dataReader, "Height", 0); sol_CategoryButton.Font = SqlClientUtility.GetString(dataReader, "Font", String.Empty); sol_CategoryButton.FontStyle = SqlClientUtility.GetString(dataReader, "FontStyle", String.Empty); sol_CategoryButton.ForeColor = SqlClientUtility.GetString(dataReader, "ForeColor", String.Empty); sol_CategoryButton.BackColor = SqlClientUtility.GetString(dataReader, "BackColor", String.Empty); sol_CategoryButton.ImageIndex = SqlClientUtility.GetInt32(dataReader, "ImageIndex", 0); sol_CategoryButton.ImagePath = SqlClientUtility.GetString(dataReader, "ImagePath", String.Empty); sol_CategoryButton.SubContainerMaxCount = SqlClientUtility.GetInt32(dataReader, "SubContainerMaxCount", 0); sol_CategoryButton.SubContainerCounter = SqlClientUtility.GetInt32(dataReader, "SubContainerCounter", 0); sol_CategoryButton.ImageSize = SqlClientUtility.GetByte(dataReader, "ImageSize", 0x00); sol_CategoryButton.SubContainerCountDown = SqlClientUtility.GetBoolean(dataReader, "SubContainerCountDown", false); sol_CategoryButton.MaxCountPerLine = SqlClientUtility.GetInt32(dataReader, "MaxCountPerLine", 0); try { sol_CategoryButton.ForeColorArgb = SqlClientUtility.GetInt32(dataReader, "ForeColorArgb", 0); sol_CategoryButton.BackColorArgb = SqlClientUtility.GetInt32(dataReader, "BackColorArgb", 0); } catch { } return(sol_CategoryButton); }
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 Qds_CardType class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Qds_CardType MakeQds_CardType(SqlDataReader dataReader) { Qds_CardType qds_CardType = new Qds_CardType(); qds_CardType.CardTypeID = SqlClientUtility.GetInt32(dataReader, "CardTypeID", 0); qds_CardType.CardType = SqlClientUtility.GetString(dataReader, "CardType", String.Empty); return(qds_CardType); }
/// <summary> /// Creates a new instance of the Vir_StagingMethod class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Vir_StagingMethod MakeVir_StagingMethod(SqlDataReader dataReader) { Vir_StagingMethod vir_StagingMethod = new Vir_StagingMethod(); vir_StagingMethod.StagingMethodID = SqlClientUtility.GetInt32(dataReader, "StagingMethodID", 0); vir_StagingMethod.StagingMethodName = SqlClientUtility.GetString(dataReader, "StagingMethodName", String.Empty); return(vir_StagingMethod); }
/// <summary> /// Creates a new instance of the Sol_WS_ItemTypes class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_WS_ItemType MakeSol_WS_ItemType(SqlDataReader dataReader) { Sol_WS_ItemType sol_WS_ItemType = new Sol_WS_ItemType(); sol_WS_ItemType.ItemTypeID = SqlClientUtility.GetInt32(dataReader, "ItemTypeID", 0); sol_WS_ItemType.ItemType = SqlClientUtility.GetString(dataReader, "ItemType", String.Empty); return(sol_WS_ItemType); }
/// <summary> /// Creates a new instance of the Qds_PaymentMethod class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Qds_PaymentMethod MakeQds_PaymentMethod(SqlDataReader dataReader) { Qds_PaymentMethod qds_PaymentMethod = new Qds_PaymentMethod(); qds_PaymentMethod.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0); qds_PaymentMethod.PaymentMethod = SqlClientUtility.GetString(dataReader, "PaymentMethod", String.Empty); return(qds_PaymentMethod); }
/// <summary> /// Creates a new instance of the Sol_OrderCardLink class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_OrderCardLink MakeSol_OrderCardLink(SqlDataReader dataReader) { Sol_OrderCardLink sol_OrderCardLink = new Sol_OrderCardLink(); sol_OrderCardLink.CardNumber = SqlClientUtility.GetString(dataReader, "CardNumber", String.Empty); sol_OrderCardLink.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0); return(sol_OrderCardLink); }
/// <summary> /// Creates a new instance of the Sac_LogType class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_LogType MakeSac_LogType(SqlDataReader dataReader) { Sac_LogType sac_LogType = new Sac_LogType(); sac_LogType.LogTypeID = SqlClientUtility.GetInt32(dataReader, "LogTypeID", 0); sac_LogType.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); return(sac_LogType); }
/// <summary> /// Creates a new instance of the Sac_CharityType class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_CharityType MakeSac_CharityType(SqlDataReader dataReader) { Sac_CharityType sac_CharityType = new Sac_CharityType(); sac_CharityType.CharityTypeID = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0); sac_CharityType.CharityType = SqlClientUtility.GetString(dataReader, "CharityType", String.Empty); return(sac_CharityType); }
/// <summary> /// Creates a new instance of the Vir_Conveyor class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Vir_Conveyor MakeVir_Conveyor(SqlDataReader dataReader) { Vir_Conveyor vir_Conveyor = new Vir_Conveyor(); vir_Conveyor.ConveyorID = SqlClientUtility.GetInt32(dataReader, "ConveyorID", 0); vir_Conveyor.ConveyorDescription = SqlClientUtility.GetString(dataReader, "ConveyorDescription", String.Empty); return(vir_Conveyor); }
/// <summary> /// Creates a new instance of the LOAI_NHAN_VIEN class and populates it with data from the specified SqlDataReader. /// </summary> private LOAINHANVIEN_DTO MakeLOAINHANVIEN_DTO(SqlDataReader dataReader) { LOAINHANVIEN_DTO LoaiNhanVien = new LOAINHANVIEN_DTO(); LoaiNhanVien.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); LoaiNhanVien.TenLoaiNhanVien = SqlClientUtility.GetString(dataReader, "TEN_LOAI_NHAN_VIEN", String.Empty); return(LoaiNhanVien); }
/// <summary> /// Creates a new instance of the MAU class and populates it with data from the specified SqlDataReader. /// </summary> private MAU_DTO MakeMAU_DTO(SqlDataReader dataReader) { MAU_DTO Mau = new MAU_DTO(); Mau.Ma = SqlClientUtility.GetString(dataReader, "MA", String.Empty); Mau.Mau = SqlClientUtility.GetString(dataReader, "MAU", String.Empty); return(Mau); }
/// <summary> /// Creates a new instance of the Sol_WS_Carriers class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_WS_Carrier MakeSol_WS_Carrier(SqlDataReader dataReader) { Sol_WS_Carrier sol_WS_Carrier = new Sol_WS_Carrier(); sol_WS_Carrier.CarrierID = SqlClientUtility.GetInt32(dataReader, "CarrierID", 0); sol_WS_Carrier.Carrier = SqlClientUtility.GetString(dataReader, "Carrier", String.Empty); return(sol_WS_Carrier); }
/// <summary> /// Creates a new instance of the HANG_SAN_XUAT class and populates it with data from the specified SqlDataReader. /// </summary> private HANGSANXUAT_DTO MakeHANGSANXUAT_DTO(SqlDataReader dataReader) { HANGSANXUAT_DTO HangSanXuat = new HANGSANXUAT_DTO(); HangSanXuat.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); HangSanXuat.TenHangXe = SqlClientUtility.GetString(dataReader, "TEN_HANG_XE", String.Empty); return(HangSanXuat); }
/// <summary> /// Creates a new instance of the sol_ContainerTypes class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_ContainerType MakeSol_ContainerType(SqlDataReader dataReader) { Sol_ContainerType sol_ContainerType = new Sol_ContainerType(); sol_ContainerType.ContainerTypeID = SqlClientUtility.GetInt32(dataReader, "ContainerTypeID", 0); sol_ContainerType.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); return(sol_ContainerType); }
/// <summary> /// Creates a new instance of the Sol_WS_Plants class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_WS_Plant MakeSol_WS_Plant(SqlDataReader dataReader) { Sol_WS_Plant sol_WS_Plant = new Sol_WS_Plant(); sol_WS_Plant.PlantID = SqlClientUtility.GetInt32(dataReader, "PlantID", 0); sol_WS_Plant.Plant = SqlClientUtility.GetString(dataReader, "Plant", String.Empty); return(sol_WS_Plant); }
/// <summary> /// Creates a new instance of the LOAI_XE class and populates it with data from the specified SqlDataReader. /// </summary> private LOAIXE_DTO MakeLOAIXE_DTO(SqlDataReader dataReader) { LOAIXE_DTO LoaiXe = new LOAIXE_DTO(); LoaiXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); LoaiXe.TenLoaiXe = SqlClientUtility.GetString(dataReader, "TEN_LOAI_XE", String.Empty); LoaiXe.GhiChu = SqlClientUtility.GetString(dataReader, "GHI_CHU", String.Empty); return(LoaiXe); }
/// <summary> /// Creates a new instance of the Qds_PaymentMethodAvailableByDepot class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Qds_PaymentMethodAvailableByDepot MakeQds_PaymentMethodAvailableByDepot(SqlDataReader dataReader) { Qds_PaymentMethodAvailableByDepot qds_PaymentMethodAvailableByDepot = new Qds_PaymentMethodAvailableByDepot(); qds_PaymentMethodAvailableByDepot.DepotID = SqlClientUtility.GetString(dataReader, "DepotID", String.Empty); qds_PaymentMethodAvailableByDepot.PaymentMethodID = SqlClientUtility.GetInt32(dataReader, "PaymentMethodID", 0); qds_PaymentMethodAvailableByDepot.DepotDefault = SqlClientUtility.GetBoolean(dataReader, "DepotDefault", false); return(qds_PaymentMethodAvailableByDepot); }
/// <summary> /// Creates a new instance of the Sol_Settings class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Setting MakeSol_Setting(SqlDataReader dataReader) { Sol_Setting sol_Setting = new Sol_Setting(); sol_Setting.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sol_Setting.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); sol_Setting.SetValue = SqlClientUtility.GetObject(dataReader, "SetValue", new object()); return(sol_Setting); }
/// <summary> /// Creates a new instance of the sol_Messages class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Message MakeSol_Message(SqlDataReader dataReader) { Sol_Message sol_Message = new Sol_Message(); sol_Message.MessageID = SqlClientUtility.GetInt32(dataReader, "MessageID", 0); sol_Message.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sol_Message.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); return(sol_Message); }
/// <summary> /// Creates a new instance of the KIEU_XE class and populates it with data from the specified SqlDataReader. /// </summary> private KIEUXE_DTO MakeKIEUXE_DTO(SqlDataReader dataReader) { KIEUXE_DTO KieuXe = new KIEUXE_DTO(); KieuXe.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); KieuXe.MaLoaiXe = SqlClientUtility.GetInt32(dataReader, "MA_LOAI_XE", 0); KieuXe.TenKieuXe = SqlClientUtility.GetString(dataReader, "TEN_KIEU_XE", String.Empty); return(KieuXe); }
/// <summary> /// Creates a new instance of the Sol_BinCount class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_BinCount MakeSol_BinCount(SqlDataReader dataReader) { Sol_BinCount sol_BinCount = new Sol_BinCount(); sol_BinCount.ClientID = SqlClientUtility.GetString(dataReader, "ClientID", String.Empty); sol_BinCount.CategoryButtonID = SqlClientUtility.GetInt32(dataReader, "CategoryButtonID", 0); sol_BinCount.CurrentCount = SqlClientUtility.GetInt32(dataReader, "CurrentCount", 0); return(sol_BinCount); }
/// <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 Sac_Settings class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_Setting MakeSac_Setting(SqlDataReader dataReader) { Sac_Setting sac_Setting = new Sac_Setting(); sac_Setting.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sac_Setting.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); sac_Setting.SetValue = SqlClientUtility.GetBytes(dataReader, "SetValue", new byte[0]); return(sac_Setting); }
/// <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_WS_ErrorCodes class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_WS_ErrorCode MakeSol_WS_ErrorCode(SqlDataReader dataReader) { Sol_WS_ErrorCode sol_WS_ErrorCode = new Sol_WS_ErrorCode(); sol_WS_ErrorCode.ErrorNumber = SqlClientUtility.GetInt32(dataReader, "ErrorNumber", 0); sol_WS_ErrorCode.ErrorDescription = SqlClientUtility.GetString(dataReader, "ErrorDescription", String.Empty); sol_WS_ErrorCode.MessageToClient = SqlClientUtility.GetBoolean(dataReader, "MessageToClient", false); sol_WS_ErrorCode.Notes = SqlClientUtility.GetString(dataReader, "Notes", String.Empty); return(sol_WS_ErrorCode); }