/// <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); }
/// <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_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 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); }
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_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_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 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); }
/// <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 Sac_Charity class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sac_Charity MakeSac_Charity(SqlDataReader dataReader) { Sac_Charity sac_Charity = new Sac_Charity(); sac_Charity.CharityID = SqlClientUtility.GetInt32(dataReader, "CharityID", 0); sac_Charity.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0); sac_Charity.ShortName = SqlClientUtility.GetString(dataReader, "ShortName", String.Empty); sac_Charity.CharityDescription = SqlClientUtility.GetString(dataReader, "CharityDescription", String.Empty); sac_Charity.CharityTypeID = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0); sac_Charity.RegistrationNumber = SqlClientUtility.GetString(dataReader, "RegistrationNumber", String.Empty); sac_Charity.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false); sac_Charity.ButtonPosition = SqlClientUtility.GetByte(dataReader, "ButtonPosition", 0x00); sac_Charity.Logo = SqlClientUtility.GetBytes(dataReader, "Logo", new byte[0]); return(sac_Charity); }
/// <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 sol_Agencies class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_Agencie MakeSol_Agencie(SqlDataReader dataReader) { Sol_Agencie sol_Agencie = new Sol_Agencie(); sol_Agencie.AgencyID = SqlClientUtility.GetInt32(dataReader, "AgencyID", 0); sol_Agencie.Name = SqlClientUtility.GetString(dataReader, "Name", String.Empty); sol_Agencie.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); sol_Agencie.Address1 = SqlClientUtility.GetString(dataReader, "Address1", String.Empty); sol_Agencie.Address2 = SqlClientUtility.GetString(dataReader, "Address2", String.Empty); sol_Agencie.City = SqlClientUtility.GetString(dataReader, "City", String.Empty); sol_Agencie.Province = SqlClientUtility.GetString(dataReader, "Province", String.Empty); sol_Agencie.Country = SqlClientUtility.GetString(dataReader, "Country", String.Empty); sol_Agencie.PostalCode = SqlClientUtility.GetString(dataReader, "PostalCode", String.Empty); sol_Agencie.VendorID = SqlClientUtility.GetString(dataReader, "VendorID", String.Empty); sol_Agencie.AutoGenerateTagNumber = SqlClientUtility.GetBoolean(dataReader, "AutoGenerateTagNumber", false); sol_Agencie.AutoGenerateRBillNumber = SqlClientUtility.GetBoolean(dataReader, "AutoGenerateRBillNumber", false); return(sol_Agencie); }
/// <summary> /// Selects a single record from the Qds_Drop table. /// </summary> public virtual bool IsReady(int dropID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DropID", dropID) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_Drop_IsReady", parameters)) { if (dataReader.Read()) { return(SqlClientUtility.GetBoolean(dataReader, "Ready", false)); } else { return(false); } } }
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 KHACH_HANG class and populates it with data from the specified SqlDataReader. /// </summary> private KHACHHANG_DTO MakeKHACHHANG_DTO(SqlDataReader dataReader) { KHACHHANG_DTO KhachHang = new KHACHHANG_DTO(); KhachHang.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0); KhachHang.HoTen = SqlClientUtility.GetString(dataReader, "HO_TEN", String.Empty); KhachHang.Phai = SqlClientUtility.GetBoolean(dataReader, "PHAI", false); if (KhachHang.Phai) { KhachHang.PhaiChu = "Nam"; } else { KhachHang.PhaiChu = "Nữ"; } KhachHang.DiaChi = SqlClientUtility.GetString(dataReader, "DIA_CHI", String.Empty); KhachHang.DienThoai = SqlClientUtility.GetString(dataReader, "DIEN_THOAI", String.Empty); KhachHang.Cmnd = SqlClientUtility.GetString(dataReader, "CMND", String.Empty); KhachHang.LoaiKhachHang = SqlClientUtility.GetBoolean(dataReader, "LOAI_KHACH_HANG", false); return(KhachHang); }
/// <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_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); }