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;
}
