private List <OrderDetailsViewManager> GetOrdersFromDBManager()
{
List <OrderDetailsView> list = GetOrdersFromDB();
List <OrderDetailsViewManager> listManager = new List <OrderDetailsViewManager>();
for (int i = 0; i < list.Count; i++)
{
OrderDetailsViewManager lm = (OrderDetailsViewManager)list[i];
listManager.Add(lm);
}
return(listManager);
}
private bool EqualsOrders(OrderDetailsViewManager order, OrdersTbl ordert)
{
bool equal = true;
equal = equal && order.Discount == ordert.discount;
equal = equal && order.FromDate == ordert.FromDate;
equal = equal && order.ToDate == ordert.ToDate;
equal = equal && order.ManagerComments == ordert.ManagerComments;
equal = equal && order.OrderStatus == ordert.OrderStatus;
equal = equal && order.Price == ordert.Price;
equal = equal && order.ShiftNumberFrom == ordert.ShiftNumberFrom;
equal = equal && order.ShiftNumberTo == ordert.ShiftNumberTo;
// equal = equal && order.mDogs.Count == ordert.DogsInOrder.Count;
foreach (DogsInOrderView dog in order.mDogs)
{
var dogt = context.Set <DogsInOrder>().Find(order.OrderNumber, dog.DogNumber);
equal = equal && dog.DogTraining == dogt.DogTraining;
equal = equal && dog.HomeFood == dogt.HomeFood;
equal = equal && dog.Status == dogt.Status;
}
return(equal);
}
//כל הכלבים בכל ההזמנות בתאריך והמשמרת המבוקשים
public List <DogInRoomDetailsView> GetDogsNoSetting(DateTime date, int shift)
{
List <DogInRoomDetailsView> dogsInRoom = new List <DogInRoomDetailsView>();
using (Entities context = new Entities())
{
int rooms = context.RoomsTbl.Count();
//כל הכלבים המשובצים לחדרים בתאריכים המבןקשים
for (int i = 1; i <= rooms; i++)
{
dogsInRoom.AddRange(GetDogsInRoom(i, date, shift));
}
OrderService orderService = new OrderService();
//כל ההזמנות
List <OrderDetailsViewManager> listOrders = orderService.GetAllOrdersAndDogsManager();
// כל ההזמנות בתאריך והמשמרת המבוקשים
List <OrderDetailsViewManager> listOrderInDates = listOrders.Where(
p => (p.OrderStatus == 12 || p.OrderStatus == 15) &&
(p.FromDate <date && p.ToDate> date) ||
(p.FromDate == date && p.ShiftNumberFrom <= shift) ||
(p.ToDate == date && p.ShiftNumberTo >= shift)
).ToList();
List <DogsInOrderView> dogsInOrders = new List <DogsInOrderView>();
//כל הכלבים בכל ההזמנות בתאריך והמשמרת המבוקשים
for (int i = 0; i < listOrderInDates.Count; i++)
{
dogsInOrders.AddRange(orderService.GetDogsForOrder(listOrderInDates[i].OrderNumber));
}
List <DogInRoomDetailsView> outOfRoomsList = new List <DogInRoomDetailsView>();
foreach (DogsInOrderView dogInOrder in dogsInOrders)
{
if (isExist(dogInOrder.DogNumber, dogsInRoom) == -1) //כלב בהזמנה ולא משובץ בחדר
{
DogInRoomDetailsView dogOutOfRoom = new DogInRoomDetailsView();
dogOutOfRoom.DogComments = dogInOrder.DogComments;
dogOutOfRoom.DogBirthDate = dogInOrder.DogBirthDate;
dogOutOfRoom.DogDig = dogInOrder.DogDig;
// dogOutOfRoom.DogFood=dogInOrder.
dogOutOfRoom.DogFriendlyWith = dogInOrder.DogFriendlyWith;
dogOutOfRoom.DogGender = dogInOrder.DogGender;
dogOutOfRoom.DogImage = dogInOrder.DogImage;
dogOutOfRoom.DogJump = dogInOrder.DogJump;
dogOutOfRoom.DogName = dogInOrder.DogName;
dogOutOfRoom.DogNeuter = dogInOrder.DogNeuter;
dogOutOfRoom.DogNumber = dogInOrder.DogNumber;
dogOutOfRoom.DogorderNumber = dogInOrder.OrderNumber;
dogOutOfRoom.DogRabiesVaccine = dogInOrder.DogRabiesVaccine;
dogOutOfRoom.DogShvav = dogInOrder.DogShvav;
dogOutOfRoom.DogStatus = dogInOrder.DogStatus;
dogOutOfRoom.DogTraining = dogInOrder.DogTraining;
dogOutOfRoom.DogType = dogInOrder.DogType;
dogOutOfRoom.DogUserID = dogInOrder.DogUserID;
dogOutOfRoom.OrderNumber = dogInOrder.OrderNumber;
OrderDetailsViewManager orderDetailsViewManager = listOrderInDates.Find(o => o.OrderNumber == dogOutOfRoom.OrderNumber);
dogOutOfRoom.DogUserID = orderDetailsViewManager.Userid;
dogOutOfRoom.FromDateInPension = orderDetailsViewManager.FromDate;
dogOutOfRoom.ToDateInPension = orderDetailsViewManager.ToDate;
dogOutOfRoom.ToDateInRoom = orderDetailsViewManager.ToDate;
dogOutOfRoom.RoomShiftTo = orderDetailsViewManager.ShiftNumberTo;
dogOutOfRoom.UserFirstName = orderDetailsViewManager.userFirstName;
dogOutOfRoom.UserLastName = orderDetailsViewManager.userLastName;
var user = context.UsersTbl.Find(dogOutOfRoom.DogUserID);
dogOutOfRoom.UserPhone1 = user.UserPhone1;
dogOutOfRoom.UserPhone2 = user.UserPhone2;
var vet = context.veterinarTbl.Find(user.UserVeterinarId);
dogOutOfRoom.VeterinarName = vet.VeterinarName;
dogOutOfRoom.VeterinarPhone1 = vet.VeterinarPhone1;
dogOutOfRoom.RoomNumberDB = 0;
outOfRoomsList.Add(dogOutOfRoom);
}
}
return(outOfRoomsList);
}
}
