//Método para achar por id public virtual TEntity FindById(int id) { using (DataContex d = new DataContex()) { return(d.Set <TEntity>().Find(id)); } }
public bool HasLogin(string login) { using (DataContex d = new DataContex()) { return(d.Usuario.Count(u => u.Login.Equals(login)) > 0); } }
public static ApplicationRoleManager Create(IdentityFactoryOptions <ApplicationRoleManager> options, IOwinContext context) { DataContex db = context.Get <DataContex>(); ApplicationRoleManager manager = new ApplicationRoleManager(new RoleStore <ApplicationRole>(db)); return(manager); }
//Método de inserção public virtual void Insert(TEntity obj) { using (DataContex d = new DataContex()) { d.Entry(obj).State = EntityState.Added; d.SaveChanges(); } }
//Método de Exclusão public virtual void Delete(TEntity obj) { using (DataContex d = new DataContex()) { d.Entry(obj).State = EntityState.Deleted; d.SaveChanges(); } }
public static IList <Turma> Listar() { using (var db = new DataContex()) { return(db.Set <Turma>() .ToList()); } }
// GET: Products/Create public ActionResult Create() { using (var db = new DataContex()) { ViewBag.Categories = db.Categories.ToList(); return(View()); } }
public static Usuario BuscarPorId(int Id) { using (var db = new DataContex()) { return(db.Set <Usuario>() .Include("Pessoa") .FirstOrDefault(x => x.Id == Id)); } }
public ActionResult Create() { using (var db = new DataContex()) { var viewModel = new ProductViewModel(); Supply(viewModel, db); return(View(viewModel)); } }
public AuthorizationService(string connectionString) { _db = new DataContex(connectionString); _UserManager = new ApplicationUserManager(new UserStore <ApplicationUser>(_db)); _RoleManager = new ApplicationRoleManager(new RoleStore <ApplicationRole>(_db)); _signInManager = new ApplicationSignInManager(_UserManager, null); }
public static Sala BuscarPorId(int Id) { using (var db = new DataContex()) { return(db.Set <Sala>() .Include("Predio") .Where(x => x.Id == Id) .FirstOrDefault()); } }
public static IList <Sala> Listar() { using (var db = new DataContex()) { return(db.Set <Sala>() .Include("Recursos") .Include("Predio") .ToList()); } }
public Usuario Find(string login, string senha) { using (DataContex d = new DataContex()) { //SQL -> select * from Usuario // where Login = @Login and Senha = @Senha return(d.Usuario .FirstOrDefault(u => u.Login.Equals(login) && (u.Senha.Equals(senha)))); } }
public static Turma BuscarId(int Id) { using (var db = new DataContex()) { return(db.Set <Turma>() .Include("Disciplina") .Include("Professor") .FirstOrDefault(x => x.Id == Id)); } }
public static IList <Professor> Listar() { using (var db = new DataContex()) { return(db.Set <Professor>() .Include("Turmas") .Include("Turmas.Disciplina") .ToList()); } }
private void Supply(ProductViewModel viewModel, DataContex db) { viewModel.Categories = db.Categories .Select(c => new SelectListItem() { Text = c.Name, Value = c.Id.ToString() }) .ToList(); }
public static void Horarios() { using (var db = new DataContex()) { HorarioAula lHorarioAula = new HorarioAula(); lHorarioAula.DiaSemana = EDiaSemana.SegundaFeira; lHorarioAula.HoraInicio = new DateTime(2015, 11, 10, 16, 30, 0); lHorarioAula.HoraFim = new DateTime(2015, 11, 10, 18, 30, 0); HorarioAula lHorarioAula2 = new HorarioAula(); lHorarioAula.DiaSemana = EDiaSemana.SegundaFeira; lHorarioAula.HoraInicio = new DateTime(2015, 11, 10, 14, 30, 0); lHorarioAula.HoraFim = new DateTime(2015, 11, 10, 16, 30, 0); HorarioAula lHorarioAula3 = new HorarioAula(); lHorarioAula.DiaSemana = EDiaSemana.SegundaFeira; lHorarioAula.HoraInicio = new DateTime(2015, 11, 10, 10, 30, 0); lHorarioAula.HoraFim = new DateTime(2015, 11, 10, 12, 30, 0); HorarioAula lHorarioAula4 = new HorarioAula(); lHorarioAula.DiaSemana = EDiaSemana.SegundaFeira; lHorarioAula.HoraInicio = new DateTime(2015, 11, 10, 8, 30, 0); lHorarioAula.HoraFim = new DateTime(2015, 11, 10, 10, 30, 0); db.Set <HorarioAula>().Add(lHorarioAula); db.Set <HorarioAula>().Add(lHorarioAula2); db.Set <HorarioAula>().Add(lHorarioAula3); db.Set <HorarioAula>().Add(lHorarioAula4); try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } } }
// GET: Products public ActionResult Index() { using (var db = new DataContex()) { return(View(db.Products .Where(p => p.Id > 2) .OrderBy(p => p.Name) .ThenBy(p => p.Id) .Skip(1) .Take(2) .ToList())); } }
public static RegisterUser ChangeValues(Table table, DataContex dataContext) { var obj = dataContext.RegisterUser; foreach (var row in table.Rows) { foreach (var item in row) { PropertyInfo pi = obj.GetType().GetProperty(item.Key); pi.SetValue(obj, item.Value); } } return(obj); }
public ActionResult Create(Product product) {/*powinno sie dodawac w kazdej akcji*/ if (ModelState.IsValid == false) { return(View()); } using (var db = new DataContex()) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } //_products.Add(product); }
// GET: Products1 public ActionResult Index() { using (var db = new DataContex()) { var viewModels = db.Products.Select(p => new ProductViewModel { Id = p.Id, Name = p.Name, Price = p.Price, Category = p.Category.Name }).ToList(); return(View(viewModels)); } }
public static Usuario VerificarCrendeciais(string Email, string Password) { try { using (var db = new DataContex()) { return(db.Set <Usuario>().FirstOrDefault(x => x.Email == Email && x.Senha == Password)); } } catch (Exception) { throw; } }
public static IList <SolicitacaoReservaSala> Listar() { using (var db = new DataContex()) { return(db.Set <SolicitacaoReservaSala>() .Include("HorarioAula") .Include("Sala") .Include("Sala.Predio") .Include("Turma") .Include("Turma.Disciplina") .Include("Turma.Professor") .Include("Solicitante") .ToList()); } }
public ActionResult Create(ProductViewModel viewModel) { using (var db = new DataContex()) { if (ModelState.IsValid == false) { Supply(viewModel, db); return(View(viewModel)); } var product = new Product() { Name = viewModel.Name, Price = viewModel.Price, CategoryId = viewModel.CategoryId }; db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } }
public static void IncluirSolicitacao(Sala pSala, int UsuarioId, int HorarioId, DateTime dtInicio, DateTime dtFim, int TurmaId) { using (var db = new DataContex()) { SolicitacaoReservaSala lSolicitacao = new SolicitacaoReservaSala(); lSolicitacao.Sala = pSala; lSolicitacao.PeriodoInicial = dtInicio; lSolicitacao.PeriodoFim = dtFim; lSolicitacao.Solicitante = UsuarioBLL.BuscarPorId(UsuarioId); lSolicitacao.StatusSolicitacao = EStatusSolicitacaoReserva.Aguardando; lSolicitacao.HorarioAula = HorarioAulaBLL.BuscarPorId(HorarioId); lSolicitacao.Turma = TurmaBLL.BuscarId(TurmaId); db.Set <SolicitacaoReservaSala>().Add(lSolicitacao); try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } } }
public ActionResult Login(User model, string returnUrl) { if (ModelState.IsValid) { using (DataContex db = new DataContex()) { string username = model.userName; string password = model.password; bool userValid = db.Users.Any(user => user.userName == username && user.password == password); if (userValid) { FormsAuthentication.SetAuthCookie(username, false); return(Redirect(returnUrl)); } ModelState.AddModelError("CredentialError", "Nieprawidłowe hasło lub nazwa użytkownika"); } } return(View(model)); }
public AdminController() { _contex = new DataContex(); }
public DoctorController() { _contex = new DataContex(); }
public WeatherForecastController(DataContex context) { _context = context; }
public HooksUser(DataContex dataContex) { this.dataContex = dataContex; this.faker = new Faker("en"); }