/// <summary>
/// Selects all records from the sol_Control table.
/// </summary>
public virtual List <Sol_Control> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_Control_SelectAll"))
{
List <Sol_Control> sol_ControlList = new List <Sol_Control>();
while (dataReader.Read())
{
Sol_Control sol_Control = MakeSol_Control(dataReader);
sol_ControlList.Add(sol_Control);
}
return(sol_ControlList);
}
}
/// <summary>
/// Saves a record to the sol_Control table.
/// </summary>
public virtual void Insert(Sol_Control sol_Control)
{
ValidationUtility.ValidateArgument("sol_Control", sol_Control);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ControlID", sol_Control.ControlID),
new SqlParameter("@BusinessName", sol_Control.BusinessName),
new SqlParameter("@LegalName", sol_Control.LegalName),
new SqlParameter("@StoreNumber", sol_Control.StoreNumber),
new SqlParameter("@Address", sol_Control.Address),
new SqlParameter("@City", sol_Control.City),
new SqlParameter("@State", sol_Control.State),
new SqlParameter("@Country", sol_Control.Country),
new SqlParameter("@PhoneNumber", sol_Control.PhoneNumber),
new SqlParameter("@BusinessHoursFrom", sol_Control.BusinessHoursFrom),
new SqlParameter("@BusinessHoursTo", sol_Control.BusinessHoursTo),
new SqlParameter("@IdFiscal1Name", sol_Control.IdFiscal1Name),
new SqlParameter("@IdFiscal1Value", sol_Control.IdFiscal1Value),
new SqlParameter("@IdFiscal2Name", sol_Control.IdFiscal2Name),
new SqlParameter("@IdFiscal2Value", sol_Control.IdFiscal2Value),
new SqlParameter("@WorkStationID", sol_Control.WorkStationID),
new SqlParameter("@CustomerScreenMessageID", sol_Control.CustomerScreenMessageID),
new SqlParameter("@FrontStationMessageID", sol_Control.FrontStationMessageID),
new SqlParameter("@CashierRoutineMessageID", sol_Control.CashierRoutineMessageID),
new SqlParameter("@ReturnStationMessageID", sol_Control.ReturnStationMessageID),
new SqlParameter("@CashierStationMessageID", sol_Control.CashierStationMessageID),
new SqlParameter("@ShippingStationMessageID", sol_Control.ShippingStationMessageID),
new SqlParameter("@ReceiptMessageID", sol_Control.ReceiptMessageID),
new SqlParameter("@SMTPServer", sol_Control.SMTPServer),
new SqlParameter("@SMTPPort", sol_Control.SMTPPort),
new SqlParameter("@EmailAccount", sol_Control.EmailAccount),
new SqlParameter("@EmailPassword", sol_Control.EmailPassword),
new SqlParameter("@HistoryYears", sol_Control.HistoryYears),
new SqlParameter("@FiscalYearInitialMonth", sol_Control.FiscalYearInitialMonth),
new SqlParameter("@NumericKeyPadOn", sol_Control.NumericKeyPadOn),
new SqlParameter("@NumericKeyPadPosition", sol_Control.NumericKeyPadPosition),
new SqlParameter("@ReturnButtonExtra", sol_Control.ReturnButtonExtra),
new SqlParameter("@Tax1Name", sol_Control.Tax1Name),
new SqlParameter("@Tax1Rate", sol_Control.Tax1Rate),
new SqlParameter("@Tax2Name", sol_Control.Tax2Name),
new SqlParameter("@Tax2Rate", sol_Control.Tax2Rate),
new SqlParameter("@DatabaseVersion", sol_Control.DatabaseVersion),
new SqlParameter("@Status", sol_Control.Status),
new SqlParameter("@EmployeesListRefresh", sol_Control.EmployeesListRefresh),
new SqlParameter("@WebBrowserUrl", sol_Control.WebBrowserUrl),
new SqlParameter("@AutoGenerateTagNumber", sol_Control.AutoGenerateTagNumber),
new SqlParameter("@AutoGenerateRBillNumber", sol_Control.AutoGenerateRBillNumber),
new SqlParameter("@DefaultAgencyID", sol_Control.DefaultAgencyID),
new SqlParameter("@ChitTicketComplete", sol_Control.ChitTicketComplete),
new SqlParameter("@ChitTicketIncludeBarcode", sol_Control.ChitTicketIncludeBarcode),
new SqlParameter("@CashOutPrintingOverride", sol_Control.CashOutPrintingOverride),
new SqlParameter("@WhiteBagID", sol_Control.WhiteBagID),
new SqlParameter("@BlueBagID", sol_Control.BlueBagID),
new SqlParameter("@OneWayBagID", sol_Control.OneWayBagID),
new SqlParameter("@ABCRCPalletsID", sol_Control.ABCRCPalletsID),
new SqlParameter("@CustomerScreenMonitor", sol_Control.CustomerScreenMonitor),
new SqlParameter("@CategoryButtonsPanelBgColor", sol_Control.CategoryButtonsPanelBgColor),
new SqlParameter("@CategoryButtonsSnapToGrid", sol_Control.CategoryButtonsSnapToGrid),
new SqlParameter("@BusinessHoursFromTue", sol_Control.BusinessHoursFromTue),
new SqlParameter("@BusinessHoursToTue", sol_Control.BusinessHoursToTue),
new SqlParameter("@BusinessHoursFromWed", sol_Control.BusinessHoursFromWed),
new SqlParameter("@BusinessHoursToWed", sol_Control.BusinessHoursToWed),
new SqlParameter("@BusinessHoursFromThu", sol_Control.BusinessHoursFromThu),
new SqlParameter("@BusinessHoursToThu", sol_Control.BusinessHoursToThu),
new SqlParameter("@BusinessHoursFromFri", sol_Control.BusinessHoursFromFri),
new SqlParameter("@BusinessHoursToFri", sol_Control.BusinessHoursToFri),
new SqlParameter("@BusinessHoursFromSat", sol_Control.BusinessHoursFromSat),
new SqlParameter("@BusinessHoursToSat", sol_Control.BusinessHoursToSat),
new SqlParameter("@BusinessHoursFromSun", sol_Control.BusinessHoursFromSun),
new SqlParameter("@BusinessHoursToSun", sol_Control.BusinessHoursToSun),
new SqlParameter("@ReturnsMaxQuantity", sol_Control.ReturnsMaxQuantity),
new SqlParameter("@WebBrowserUpdateHistoryUrl", sol_Control.WebBrowserUpdateHistoryUrl),
new SqlParameter("@CashierMaxAmount", sol_Control.CashierMaxAmount),
new SqlParameter("@ComputerRole", sol_Control.ComputerRole),
new SqlParameter("@SqlServerDate", sol_Control.SqlServerDate),
new SqlParameter("@VendorID", sol_Control.VendorID),
new SqlParameter("@DefaultPlantID", sol_Control.DefaultPlantID),
new SqlParameter("@DefaultCarrierID", sol_Control.DefaultCarrierID),
new SqlParameter("@ABCRCUserName", sol_Control.ABCRCUserName),
new SqlParameter("@ABCRCPassword", sol_Control.ABCRCPassword),
new SqlParameter("@ReceiptAmountBarcode", sol_Control.ReceiptAmountBarcode),
new SqlParameter("@IncludeSecurityCode", sol_Control.IncludeSecurityCode),
new SqlParameter("@RBillNumberBarcode", sol_Control.RBillNumberBarcode),
new SqlParameter("@SacCashTrayID", sol_Control.SacCashTrayID)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_Control_Insert", parameters);
}
/// <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);
}
