public RoomController(RoomBookingContext context)
{
_context = context;
if (_context.Rooms.Count() == 0)
{
_context.Rooms.Add(new Room
{
Location = "A302",
Floor = 3,
Size = 6,
Type = RoomType.Group
});
_context.SaveChanges();
}
}
public ActionResult Login(LoginModel model)
{
RoomBookingContext a = new RoomBookingContext();
var result = a.Users.SqlQuery($"SELECT * FROM dbo.Users WHERE Login = '******' AND Password = '******'").ToList();
//var login = new SqlParameter("@login", model.Login);
//var pass = new SqlParameter("@pass", model.Password);
//var result = a.Users.SqlQuery($"SELECT * FROM dbo.Users WHERE Login = @login AND Password = @pass", login, pass).ToList();
if (result.Count != 0)
{
FormsAuthentication.SetAuthCookie(result.FirstOrDefault().Login, true);
return(RedirectToAction("Index", "Home"));
}
return(View(model));
}
public ReservationController(RoomBookingContext context)
{
_context = context;
}
public RoomService(RoomBookingContext _context)
{
context = _context;
}
public RoomBookingRepository()
{
db = new RoomBookingContext();
}
public RoomBookingAuthRepository()
{
db = new RoomBookingContext();
md5 = new MD5HashCalculating();
}
public AccountController(RoomBookingContext bokingDBContext)
{
_bokingDBContext = bokingDBContext;
}
public EFGenericRepository()
{
_context = new RoomBookingContext();
}
public RoomsController(RoomBookingContext bokingDBContext)
{
_bokingDBContext = bokingDBContext;
}