public static Language Get(int id)
{
using (var context = new MimosaEntities())
{
return context.Languages.First(x => x.Id == id);
}
}
public static List<Language> GetListAll()
{
using (var context = new MimosaEntities())
{
return context.Languages.OrderBy(x => x.Id).ToList();
}
}
public static List<LocaleStringResource> GetListAll()
{
using (var context = new MimosaEntities())
{
return context.LocaleStringResources.OrderBy(x => x.ResourceName).ToList();
}
}
public static List<District> GetDistricts()
{
using (var context = new MimosaEntities())
{
return context.Districts.AsNoTracking().OrderBy(x => x.DistrictCode).ToList();
}
}
public static List<RoomType> GetRoomTypeList()
{
using (var context = new MimosaEntities())
{
return context.RoomTypes.AsNoTracking().ToList();
}
}
public static LocaleStringResource Get(int id)
{
using (var context = new MimosaEntities())
{
return context.LocaleStringResources.Include(x => x.Language).First(x => x.Id == id);
}
}
public static List<Image> GetListImageRoom(int[] roomIdList)
{
using (var context = new MimosaEntities())
{
return context.Images.Where(x => roomIdList.Contains(x.ItemId)).AsNoTracking().ToList();
}
}
public static List<Image> GetListImageRoomDetails(int roomId)
{
using (var context = new MimosaEntities())
{
var serviceRoomId =
context.RoomServices.Where(x => x.RoomId == roomId)
.AsNoTracking()
.Select(x => x.ServiceId)
.ToArray();
var equipmentRoomId =
context.RoomEquipments.Where(x => x.RoomId == roomId)
.AsNoTracking()
.Select(x => x.EquipmentId)
.ToArray();
var query = context.Images.Where(x => x.ItemId == roomId && x.ImageTypeId == 3);
query = query.Union(context.Images.Where(x => serviceRoomId.Contains(x.ItemId) && x.ImageTypeId == 5));
query = query.Union(context.Images.Where(x => equipmentRoomId.Contains(x.ItemId) && x.ImageTypeId == 4));
return query.AsNoTracking().ToList();
}
}
public static void BookRoom(Customer customer, ContactInformation contact, int roomId, DateTime startDate, DateTime endDate, int[] service, int[] equipment)
{
using (var context = new MimosaEntities())
{
decimal totalPrice = 0;
var room = context.Rooms.FirstOrDefault(x => x.RoomId == roomId);
if (contact != null)
{
context.ContactInformations.Add(contact);
context.SaveChanges();
}
if (room != null)
{
var bookRoom = new Booking
{
DateCreated = DateTime.Now,
DateUpdated = DateTime.Now,
CreatedBy = string.Format("{0} {1}", customer.FirstName, customer.LastName),
UpdatedBy = string.Format("{0} {1}", customer.FirstName, customer.LastName),
RoomId = roomId,
BookDate = DateTime.Now,
CustomerId = customer.CustomerId,
BookingStatusId = 1,
RoomPrice = room.BasePrice,
Description = "",
ContractDateStart = startDate,
ContractDateEnd = endDate
};
if (service != null)
{
foreach (var id in service)
{
var itemService = context.RoomServices.FirstOrDefault(x => x.ServiceId == id);
if (itemService != null)
{
totalPrice += itemService.Price ?? 0;
bookRoom.BookingRoomServices.Add(
new BookingRoomService
{
RoomServiceId = itemService.RoomServiceId,
DateCreated = DateTime.Now,
DateUpdated = DateTime.Now,
Price = itemService.Price,
CreatedBy = string.Format("{0} {1}", customer.FirstName, customer.LastName),
UpdatedBy = string.Format("{0} {1}", customer.FirstName, customer.LastName)
});
}
}
}
if (equipment != null)
{
foreach (var id in equipment)
{
var itemEquipment = context.RoomEquipments.FirstOrDefault(x => x.EquipmentId == id);
if (itemEquipment != null)
{
totalPrice += itemEquipment.Price ?? 0;
bookRoom.BookingRoomEquipments.Add(
new BookingRoomEquipment
{
RoomEquipmentId = itemEquipment.RoomEquipmentId,
DateCreated = DateTime.Now,
DateUpdated = DateTime.Now,
Price = itemEquipment.Price,
CreatedBy = string.Format("{0} {1}", customer.FirstName, customer.LastName),
UpdatedBy = string.Format("{0} {1}", customer.FirstName, customer.LastName)
});
}
}
}
if (contact != null)
{
customer.ContactInformationId = contact.ContactInformationId;
}
customer.OrganisationID = room.Site.OrganisationID;
bookRoom.TotalPrice = totalPrice;
customer.Bookings.Add(bookRoom);
context.Customers.Add(customer);
context.SaveChanges();
}
}
}
public static Tuple<int?, int?, int?> GetStatistic()
{
int? count1 = 0;
int? count2 = 0;
int? count3 = 0;
using (var context = new MimosaEntities())
{
var item = context.VisitorOfDays.FirstOrDefault(
x => x.Day == DateTime.Now.Day && x.Month == DateTime.Now.Month && x.Year == DateTime.Now.Year);
if (item != null)
{
count1 = item.Count;
}
var firstDayOfWeek = FirstDayOfWeekUtility.GetFirstDayOfWeek(DateTime.Now);
var lastDayOfWeek = firstDayOfWeek.AddDays(7);
count2 =
context.VisitorOfDays.Where(
x => x.DateTime >= firstDayOfWeek && x.DateTime <= lastDayOfWeek).Sum(x => x.Count);
var day = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month);
var lastDateMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, day);
var firstDateMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
count3 =
context.VisitorOfDays.Where(
x => x.DateTime >= firstDateMonth && x.DateTime <= lastDateMonth).Sum(x => x.Count);
}
return new Tuple<int?, int?, int?>(count1, count2, count3);
}
public static Room RoomDetails(int roomId)
{
using (var context = new MimosaEntities())
{
return
context.Rooms.Include(x => x.RoomServices.Select(c => c.Service))
.Include(x => x.RoomEquipments.Select(c => c.Equipment))
.Include(x => x.RoomStatus)
.Include(x => x.Site.ContactInformation)
.AsNoTracking()
.FirstOrDefault(x => x.RoomId == roomId);
}
}
public static List<Room> ListRoom(int? area, int? money, int? roomType, string district, int pageIndex, int pageSize,
out int totalRecords)
{
using (var context = new MimosaEntities())
{
IQueryable<Room> query = context.Rooms;
if (area.HasValue)
{
if (area == (int)Area.Less10MeterSquare)
{
query = query.Where(x => x.MeterSquare < 10);
}
else if (area == (int)Area.MeterSquar10And20)
{
query = query.Where(x => x.MeterSquare >= 10 && x.MeterSquare <= 20);
}
else if (area == (int)Area.MeterSquar20And30)
{
query = query.Where(x => x.MeterSquare >= 20 && x.MeterSquare <= 30);
}
else if (area == (int)Area.Than30MeterSquare)
{
query = query.Where(x => x.MeterSquare >= 30);
}
}
if (money.HasValue)
{
if (money == (int)Money.Less3Million)
{
query = query.Where(x => x.BasePrice < 3000000);
}
else if (money == (int)Money.Million3And5)
{
query = query.Where(x => x.BasePrice >= 3000000 && x.BasePrice <= 5000000);
}
else if (money == (int)Money.Than5Million)
{
query = query.Where(x => x.BasePrice > 5000000);
}
}
if(!string.IsNullOrWhiteSpace(district))
{
query = query.Where(x => x.Site.ContactInformation.District.Equals(district));
}
if (roomType.HasValue)
{
query = query.Where(x => x.RoomTypeId == roomType.Value);
}
totalRecords = query.Count();
return query.OrderByDescending(x => x.RoomId).Skip(pageSize * (pageIndex - 1)).Take(pageSize).Include(x => x.RoomStatus).AsNoTracking().ToList();
}
}
public static void InsertCustomer()
{
var date = DateTime.Now;
using (var context = new MimosaEntities())
{
var item =
context.VisitorOfDays.FirstOrDefault(
x => x.Day == date.Day && x.Month == date.Month && x.Year == date.Year);
if (item == null)
{
context.VisitorOfDays.Add(new VisitorOfDay { Count = 1, DateTime = date, Day = date.Day, Month = date.Month, Year = date.Year });
}
else
{
item.Count++;
}
context.SaveChanges();
}
}