//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");
}
