/// <summary> /// Fill the Countries table from the Database basing on the AirlineCompanies data source /// </summary> private void AddCountries() { _currentDAO = CreateAppropriateDAO(); _currentDAO.DeleteAllNotRegardingForeignKeys(); List <string> countries_names = new List <string>(); foreach (var s_airline in _airlineCompaniesFromExternalSource) { s_airline.TryGetValue("country", out string s_airline_country_name); if (!countries_names.Contains(s_airline_country_name)) { countries_names.Add(s_airline_country_name); } } foreach (var s_country_name in countries_names) { Country country = new Country(); country.COUNTRY_NAME = _regex.Replace(s_country_name, string.Empty); country.COUNTRY_IDENTIFIER = Convert.ToInt64(Statics.GetUniqueKeyOriginal_BIASED(_rnd.Next(4, 9), Charset.OnlyNumber)); _currentDAO.Add(country as T); } }
public void Salvar(Log log) { try { _dao.Add(log); _dao.CommitChanges(); }catch (Exception ex) { } }
public async Task <IActionResult> Create([Bind("Codigo,Nome,Salario")] Funcionario funcionario) { if (ModelState.IsValid) { _dao.Add(funcionario); return(RedirectToAction(nameof(Index))); } return(View(funcionario)); }
private void AddOneTicket() { Ticket ticket = new Ticket(); Customer randomCustomer = _customers[_rnd.Next(_customers.Count)]; Flight randomFlight = _flights[_rnd.Next(_flights.Count)]; ticket.CUSTOMER_ID = randomCustomer.ID; ticket.FLIGHT_ID = randomFlight.ID; _currentDAO = CreateAppropriateDAO(); _currentDAO.Add(ticket as T); }
public string Cadastrar <T>(T e) where T : EntidadeDominio { string msg = ExecutarRegras(e); if (msg == "") { IDAO <T> dao = new DAO <T>(_contexto); return(dao.Add(e)); } return(msg); }
public IHttpActionResult Post(Tarefa Tarefa) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tarefa.CreatedAt = DateTime.Now; Tarefa.UpdatedAt = DateTime.Now; var added = Dao.Add(Tarefa); return(Ok(added)); }
public IHttpActionResult Post(Prioridade prioridade) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } prioridade.CreatedAt = DateTime.Now; prioridade.UpdatedAt = DateTime.Now; var added = Dao.Add(prioridade); return(Ok(added)); }
public IHttpActionResult Post(ListaDeTarefas ListaDeTarefas) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } ListaDeTarefas.CreatedAt = DateTime.Now; ListaDeTarefas.UpdatedAt = DateTime.Now; var added = Dao.Add(ListaDeTarefas); return(Ok(added)); }
public void Salvar(ExecucaoAgendamento exeAgd) { try { if (exeAgd.IdExecucaoAgendamento == 0) { _dao.Add(exeAgd); _dao.CommitChanges(); } else { _dao.Update(exeAgd, exeAgd.IdExecucaoAgendamento); } }catch (Exception ex) { throw ex; } }
public void Salvar(Arquivo arquivo) { try { if (arquivo.IdArquivo == 0) { _dao.Add(arquivo); _dao.CommitChanges(); } else { _dao.Update(arquivo, arquivo.IdArquivo); } }catch (Exception ex) { throw ex; } }
public void Salvar(Emissor emissor) { try { if (emissor.IdEmissor == 0) { _dao.Add(emissor); _dao.CommitChanges(); } else { _dao.Update(emissor); } } catch (Exception ex) { throw ex; } }
public void Salvar(Agendamento agendamento) { try { if (agendamento.IdAgendamento == 0) { _dao.Add(agendamento); _dao.CommitChanges(); } else { _dao.Update(agendamento, agendamento.IdAgendamento); } } catch (Exception ex) { throw ex; } }
public void Salvar(Subcampo subcampo) { try { if (subcampo.IdSubcampo == 0) { _dao.Add(subcampo); _dao.CommitChanges(); } else { _dao.Update(subcampo); } } catch (Exception ex) { throw ex; } }
private void AddOneFlight() { Flight flight = new Flight(); AirlineCompany randomAirline = _airlineCompanies[_rnd.Next(_airlineCompanies.Count)]; flight.AIRLINECOMPANY_ID = randomAirline.ID; flight.ORIGIN_COUNTRY_CODE = _countries[_rnd.Next(_countries.Count)].ID; flight.DESTINATION_COUNTRY_CODE = _countries[_rnd.Next(_countries.Count)].ID; var departureDateTime = Statics.GetRandomDate(DateTime.Now, DateTime.Now.AddHours(Convert.ToDouble(_rnd.Next(1, 3))).AddMinutes(Convert.ToDouble(_rnd.Next(10, 55)))); flight.DEPARTURE_TIME = departureDateTime; //flight.LANDING_TIME = Statics.GetRandomDate(flight.DEPARTURE_TIME, new DateTime(flight.DEPARTURE_TIME.Year, flight.DEPARTURE_TIME.Month, flight.DEPARTURE_TIME.Day, flight.DEPARTURE_TIME.Hour + _rnd.Next(0, 24 - flight.DEPARTURE_TIME.Hour), 0, 0)); flight.LANDING_TIME = Statics.GetRandomDate(flight.DEPARTURE_TIME, flight.DEPARTURE_TIME.AddHours(_rnd.Next(18, 20)).AddMinutes(_rnd.Next(5, 45))); flight.REMAINING_TICKETS = _rnd.Next(0, 500); _currentDAO = CreateAppropriateDAO(); _currentDAO.Add(flight as T); }
public void Salvar(TipoDado tipoDado) { try { if (tipoDado.IdTipoDado == 0) { _dao.Add(tipoDado); _dao.CommitChanges(); } else { _dao.Update(tipoDado); } } catch (Exception ex) { throw ex; } }
public void Salvar(Layout layout) { try { if (layout.IdLayout == 0) { _dao.Add(layout); _dao.CommitChanges(); } else { _dao.Update(layout); } } catch (Exception ex) { throw ex; } }
public void Salvar(Registro registro) { try { if (registro.IdRegistro == 0) { _dao.Add(registro); _dao.CommitChanges(); } else { _dao.Update(registro); } } catch (Exception ex) { throw ex; } }
public void Salvar(Informacao informacao) { try { if (informacao.idInformacao == 0) { _dao.Add(informacao); _dao.CommitChanges(); } else { _dao.Update(informacao); } } catch (Exception ex) { throw ex; } }
public void Salvar(Usuario usuario) { try { usuario.Senha = LAB5Utils.CriptografiaUtils.TripleDESEncrypt(usuario.Senha, true); if (usuario.IdUsuario == 0) { _dao.Add(usuario); _dao.CommitChanges(); } else { _dao.Update(usuario); } } catch (Exception ex) { throw ex; } }
public void Salvar(TransacaoElo transacao) { try { if (transacao.Id_TransacaoElo == 0) { _dao.Add(transacao); _dao.CommitChanges(); } else { _dao.Update(transacao); } } catch (DbUpdateException dbex) { throw dbex; } catch (Exception ex) { throw ex; } }
public void Update(Unit u) { DataObject = u; DAO <UnitDAO, Unit> .Add("SepUnitUpdate", this); }
public int Add(Unit o) { DataObject = o; return(DAO <UnitDAO, Unit> .Add("SepUnitAdd", this)); }
public int Add(Technology o) { DataObject = o; return(DAO <TechnologyDAO, Technology> .Add("DnTechnologyAdd", this)); }
public int Add(Order o) { DataObject = o; return(DAO <OrderDAO, Order> .Add("SepOrderAdd", this)); }
public int Add(Kingdom o) { DataObject = o; return(DAO <KingdomDAO, Kingdom> .Add("SepKingdomAdd", this)); }
public int Add(Event o) { DataObject = o; return(DAO <EventDAO, Event> .Add("DnEventAdd", this)); }
public int Add(User user) { DataObject = user; return(DAO <UserDAO, User> .Add("DnUserAdd", this)); }
public int Add(UnitType o) { DataObject = o; return(DAO <UnitTypeDAO, UnitType> .Add("DnUnitTypeAdd", this)); }
public int Add(Log o) { DataObject = o; return(DAO <LogDAO, Log> .Add("DnLogAdd", this)); }
public int Add(OrderType o) { DataObject = o; return(DAO <OrderTypeDAO, OrderType> .Add("SepOrderTypeAdd", this)); }