public void updateRegister(registers register)
{
List <columnsValues> columnsList = new List <columnsValues>();
columnsList.Add(createItem.ofTypeColumnsValues("reg_ActiveRegister", register.reg_ActiveRegister));
columnsList.Add(createItem.ofTypeColumnsValues("reg_ComputerName", register.reg_ComputerName));
List <valuesWhere> termsList = new List <valuesWhere>();
termsList.Add(createItem.ofTypeValuesWhere(false, "reg_RegisterNumber", register.reg_RegisterNumber.ToString(), (int)OPERATORBOOLEAN.NONE, (int)OPERATOR.EQUALITY));
createQuery.toUpdate("Registers", columnsList, termsList);
}
public void createRegister(registers register)
{
List <columnsValues> columnsList = new List <columnsValues>();
columnsList.Add(createItem.ofTypeColumnsValues("reg_RegisterNumber", register.reg_RegisterNumber));
columnsList.Add(createItem.ofTypeColumnsValues("reg_ComputerName", register.reg_ComputerName));
columnsList.Add(createItem.ofTypeColumnsValues("reg_ActiveRegister", register.reg_ActiveRegister));
columnsList.Add(createItem.ofTypeColumnsValues("reg_ModifiedBy", register.reg_ModifiedBy));
columnsList.Add(createItem.ofTypeColumnsValues("reg_ModificationDate", register.reg_ModificationDate));
columnsList.Add(createItem.ofTypeColumnsValues("reg_CreatedBy", register.reg_CreatedBy));
columnsList.Add(createItem.ofTypeColumnsValues("reg_CreationDate", register.reg_CreationDate));
createQuery.toInsert("Registers", columnsList);
}
public List <registers> getRegisters()
{
List <registers> registersList = new List <registers>();
List <valuesWhere> termsList = new List <valuesWhere>();
var data = createQuery.toSelectAll("Registers", termsList);
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow filas = data.Rows[i];
var items = new registers();
items.reg_ActiveRegister = Convert.ToBoolean(filas["reg_ActiveRegister"]);
items.reg_ComputerName = Convert.ToString(filas["reg_ComputerName"]);
items.reg_RegisterNumber = Convert.ToInt32(filas["reg_RegisterNumber"]);
registersList.Add(items);
}
return(registersList);
}
public settings getSettings()
{
settings settings = new settings();
List <string> columnsList = new List <string>();
List <valuesWhere> termsList = new List <valuesWhere>();
DataTable data = createQuery.toSelect(columnsList, "Settings", termsList);
for (int i = 0; i < data.Rows.Count; i++)
{
DataRow filas = data.Rows[i];
var items = new registers();
settings.LockAutomatically = Convert.ToBoolean(filas["LockAutomatically"]);
settings.TimeOutLock = Convert.ToInt32(filas["TimeOutLock"]);
settings.RefreshSummary = Convert.ToBoolean(filas["RefreshSummary"]);
settings.TimeRefreshSummary = Convert.ToInt32(filas["TimeRefreshSummary"]);
settings.LeaveMoneyInRegister = Convert.ToBoolean(filas["LeaveMoneyInRegister"]);
settings.DefaultPassword = Convert.ToBoolean(filas["DefaultPassword"]);
settings.DefaultPasswordValue = Convert.ToString(filas["DefaultPasswordValue"]);
settings.Logo = Convert.ToString(filas["Logo"]);
}
return(settings);
}
