private void btnNew_Click(object sender, RoutedEventArgs e)
{
crud_modal.Visibility = System.Windows.Visibility.Visible;
cntrl.terminal objTerminal = new cntrl.terminal();
app_terminal app_terminal = new app_terminal();
entity.db.app_terminal.Add(app_terminal);
app_terminalViewSource.View.MoveCurrentToLast();
objTerminal.app_terminalViewSource = app_terminalViewSource;
objTerminal.entity = entity;
crud_modal.Children.Add(objTerminal);
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
MessageBoxResult res = MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (res == MessageBoxResult.Yes)
{
app_terminal app_terminal = app_terminalViewSource.View.CurrentItem as app_terminal;
app_terminal.is_active = false;
btnSave_Click(sender, e);
}
}
catch (Exception)
{
//throw ex;
}
}
private void sync_Company()
{
DataTable dt = exeDT("SELECT * FROM EMPRESA");
DataTable dt_Branch = exeDT("SELECT * FROM SUCURSAL");
DataTable dt_Terminal = exeDT("SELECT * FROM PC");
foreach (DataRow row in dt.Rows)
{
app_company _app_company = new app_company();
_app_company.name = row["NOMCONTRIBUYENTE"].ToString();
_app_company.alias = row["NOMFANTASIA"].ToString();
if (_app_company.name != null && _app_company.alias != null)
{
_app_company.name = _app_company.alias;
}
else
{
continue;
}
_app_company.address = (row["DIRECCION"].ToString() == "") ? "Address Placeholder" : row["DIRECCION"].ToString();
_app_company.gov_code = (row["RUCCONTRIBUYENTE"].ToString() == "") ? "GovID Placeholder" : row["RUCCONTRIBUYENTE"].ToString();
dbContext.app_company.Add(_app_company);
dbContext.SaveChanges();
id_company = _app_company.id_company;
CurrentSession.Id_Company = id_company;
Dispatcher.BeginInvoke((Action)(() =>
{
entity.Properties.Settings.Default.company_ID = id_company;
entity.Properties.Settings.Default.Save();
}
));
sync_Users();
id_user = dbContext.security_user.Where(i => i.id_company == id_company).FirstOrDefault().id_user;
CurrentSession.Id_User = id_company;
foreach (DataRow row_Branch in dt_Branch.Rows)
{
app_branch _app_branch = new app_branch();
_app_branch.id_company = id_company;
_app_branch.name = row_Branch["DESSUCURSAL"].ToString();
_app_branch.code = row_Branch["SUCURSALTIMBRADO"].ToString();
_app_branch.can_invoice = (row_Branch["TIPOSUCURSAL"].ToString().Contains("Factura")) ? true : false;
_app_branch.can_stock = (row_Branch["TIPOSUCURSAL"].ToString().Contains("Stock")) ? true : false;
if (_app_branch.can_stock)
{
app_location app_location = new app_location();
app_location.is_active = true;
app_location.is_default = true;
app_location.name = "Deposito";
_app_branch.app_location.Add(app_location);
}
string id_branchString = row_Branch["CODSUCURSAL"].ToString();
foreach (DataRow row_Terminal in dt_Terminal.Select("CODSUCURSAL = " + id_branchString))
{
app_terminal app_terminal = new app_terminal();
app_terminal.is_active = true;
app_terminal.code = row_Terminal["NUMMAQUINA"].ToString();
app_terminal.name = row_Terminal["NOMBRE"].ToString();
_app_branch.app_terminal.Add(app_terminal);
}
if (_app_branch.Error == null)
{
dbContext.app_branch.Add(_app_branch);
dbContext.SaveChanges();
}
}
id_branch = dbContext.app_branch.Where(i => i.id_company == id_company).FirstOrDefault().id_branch;
id_terminal = dbContext.app_terminal.Where(i => i.id_company == id_company).FirstOrDefault().id_terminal;
Dispatcher.BeginInvoke((Action)(() =>
{
entity.Properties.Settings.Default.branch_ID = id_branch;
entity.Properties.Settings.Default.terminal_ID = id_terminal;
entity.Properties.Settings.Default.Save();
}
));
}
dt.Clear();
dt_Branch.Clear();
dt_Terminal.Clear();
}