public TravelHelperContext Init() { //string _connectionString = "Data Source=DESKTOP-VPF0AQ3;Initial Catalog=TravelHelperProject;Integrated Security=True"; string _connectionString = "Server=tcp:nguyencuongoc.database.windows.net,1433;Initial Catalog=TravelHelperProject;Persist Security Info=False;User ID=nguyencuongoc;Password=Abcxyz123;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; var optionsBuilder = new DbContextOptionsBuilder <TravelHelperContext>(); optionsBuilder.UseSqlServer(_connectionString); return(_travelHelperContext ?? (_travelHelperContext = new TravelHelperContext(optionsBuilder.Options))); }
public IEnumerable <Message> GetMessagesPaging(Expression <Func <Message, bool> > expression, int index = 0, int size = 5, string[] includes = null) { var skipCount = index * size; IQueryable <Message> _resetSet = null; if (includes != null && includes.Count() > 0) { var query = TravelHelperContext.Set <Message>().Include(includes.First()); foreach (string i in includes.Skip(1)) { query = query.Include(i); } _resetSet = expression != null?query.Where <Message>(expression).OrderByDescending(s => s.CreateDate).AsQueryable() : query.OrderByDescending(s => s.CreateDate).AsQueryable(); } else { _resetSet = expression != null?TravelHelperContext.Set <Message>().Where <Message>(expression).OrderByDescending(s => s.CreateDate).AsQueryable() : TravelHelperContext.Set <Message>().OrderByDescending(s => s.CreateDate).AsQueryable(); } _resetSet = index == 0 ? _resetSet.Take(size) : _resetSet.Skip(skipCount).Take(size); return(_resetSet.AsQueryable()); }
public string Post([FromBody] Reservations value) { using (TravelHelperContext dbContext = new TravelHelperContext()) { Microsoft.Data.SqlClient.SqlParameter roomIdParam = new Microsoft.Data.SqlClient.SqlParameter("@roomId", value.RoomId); Microsoft.Data.SqlClient.SqlParameter startDateParam = new Microsoft.Data.SqlClient.SqlParameter("@startDate", value.StartDate); Microsoft.Data.SqlClient.SqlParameter endDateParam = new Microsoft.Data.SqlClient.SqlParameter("@endDate", value.EndDate); int activeReservationsCount = dbContext.Reservations.FromSqlRaw("GetActiveReservationsByDates {0}, {1}, {2}", roomIdParam, startDateParam, endDateParam).ToList().Count(); int count = dbContext.Rooms.Where(room => room.Id.Equals(value.RoomId)).FirstOrDefault().Count; if (activeReservationsCount >= count) { return("Too much reservations"); } else { return("Ok"); } } }
public AddressList(TravelHelperContext travelHelperContext) { _travelHelperContext = travelHelperContext; }