public ActionResult OrderDetail(int id, string submit)
{
var status = String.Empty;
switch (submit)
{
case "Reject":
status = StatusType.REJECTED;
break;
case "Approve":
status = StatusType.APPROVED;
break;
}
var result = OrderRepos.UpdateStatus(id, status);
TempData["Type"] = status;
if (result == SaveResult.SUCCESS)
{
TempData["Status"] = "OK";
}
else
{
TempData["Status"] = "FAIL";
}
var data = GetInforOrder(id);
return(View(data));
}
public PartialViewResult GetOrder(string sortOrder, int?page)
{
ViewBag.DateSortOrder = sortOrder == "DateSortOrder" ? "DateSortOrder_Desc" : "DateSortOrder";
ViewBag.CustomerSortOrder = sortOrder == "CustomerSortOrder" ? "CustomerSortOrder_Desc" : "CustomerSortOrder";
ViewBag.CurrentSort = sortOrder;
List <ManagementOrderViewModel> data = new List <ManagementOrderViewModel>();
//Get order
var orders = OrderRepos.GetAll();
foreach (var order in orders)
{
var total = OrderDetailRepos.TotalOrder(order.ID);
data.Add(new ManagementOrderViewModel
{
Status = order.Status,
Country = order.Customer.Country.Name,
Customer = order.Customer.Name,
OrderDate = order.OrderDate,
Id = order.ID,
Total = total
});
}
var dashboards = SortOrder(sortOrder, data);
int pageNumber = page ?? 1;
return(PartialView(dashboards.ToPagedList(pageNumber, 25)));
}
public UnitOfWork(ElectronicsStoreContext context)
{
_context = context;
ItemRepos = new ItemRepos(_context);
CustomerRepos = new CustomerRepos(_context);
OrderRepos = new OrderRepos(_context);
ImportRepos = new ImportRepos(_context);
}
public ActionResult Index(OrderViewModel order)
{
ViewBag.Error = "Error";
if (ModelState.IsValid)
{
try
{
var saveCustomer = CustomerRepos.AddCustomer(new CustomerDto()
{
Address = order.Address,
CountryId = order.CountryId,
Email = order.Email,
Name = order.Name,
Phone = order.Phone
});
var saveOrder = OrderRepos.AddOrder(new OrderDto
{
CustomerId = saveCustomer.ID,
OrderDate = DateTime.Now,
Status = StatusType.NEW,
});
//Remove first order
if (order.OrderDetail.Count > 0)
{
order.OrderDetail.RemoveAt(0);
}
if (order.OrderDetail.Count > 0)
{
foreach (var item in order.OrderDetail)
{
decimal price = ProductRepos.GetPrice(item.ProductId);
var saveOrderDetail = OrderDetailRepos.Add(new OrderDetailDto
{
OrderId = saveOrder.ID,
ProductId = 1,
Quantity = 1,
UnitPrice = price,
});
}
}
}
catch (Exception ex)
{
LogService.Error(ex.Message, ex);
return(View());
}
//Return page successfully
return(RedirectToAction("ResultOrder", new { status = true }));// View(order);
}
return(View());
}
private void UpdateCalendar()
{
Entity.Rooms selectedRoom = (Entity.Rooms)DataGrid_rooms.SelectedItem;
List <Order_entity> ordersList = Order_entity.init_Orders(db);
// достаем заказы с выбранной комнатой
OrderRepos orderRepos = new OrderRepos(db);
List <Order_entity> selectedRoomOrderList = orderRepos.GetByRoomId(selectedRoom.Id);
Calendar_.BlackoutDates.Clear();
foreach (Order_entity order in selectedRoomOrderList)
{
Calendar_.BlackoutDates.Add(
new CalendarDateRange(order.DateStart, order.DateEnd)
);
}
int a = 2;
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
private OrderViewModel GetInforOrder(int id)
{
//get customer
OrderDto order = OrderRepos.Single(id);
OrderViewModel data = new OrderViewModel();
//Information customer
data.Id = id;
data.Name = order.Customer.Name;
data.Address = order.Customer.Address;
data.Email = order.Customer.Email;
data.Phone = order.Customer.Phone;
data.CounntryName = order.Customer.Country.Name;
data.DateOrder = order.OrderDate;
data.Status = order.Status;
//Information order detail
List <OrderDetailDto> orderDetail = OrderDetailRepos.GetByOrder(id).ToList();
if (data.OrderDetail == null)
{
data.OrderDetail = new List <OrderDetailViewModel>();
}
for (int i = 0; i < orderDetail.Count(); i++)
{
var item = orderDetail[i];
data.OrderDetail.Add(new OrderDetailViewModel
{
No = i + 1,
Quality = item.Quantity,
UnitPrice = item.UnitPrice,
ProductName = item.Product.ProductName,
Total = item.Total,
});
}
return(data);
}
private void Button_delRow_click(object sender, RoutedEventArgs e)
{
Entity.Rooms room = ((FrameworkElement)sender).DataContext as Entity.Rooms;
MessageBoxResult messageBoxResult =
System.Windows.MessageBox.Show(
"Вы действительно хотите удалить комнату №" + room.Number,
"Delete Confirmation",
System.Windows.MessageBoxButton.YesNo
);
if (messageBoxResult == MessageBoxResult.Yes)
{
Console.WriteLine("clicked delete row id = " + room.Id);
// Проверяем, нет ли зависимых от это строки записей
OrderRepos orderRepo = new OrderRepos(db);
List <Order_entity> dependentOrders = orderRepo.GetByRoomId(room.Id);
if (dependentOrders.Count != 0)
{
MessageBox.Show(
"Невозможно удалить эту запись, т.к. от нее зависят " + dependentOrders.Count + " заказов");
return;
}
using (var context = new ApplicationContext())
{
var deletedCustomer = context.Rooms.Where(c => c.Id == room.Id).FirstOrDefault();
context.Rooms.Remove(deletedCustomer);
context.SaveChanges();
}
db.SaveChanges();
this.updateDataGrid();
}
}
public void InitializeRepos(bool CheckInputs = true, bool AllowCascade = false)
{
UsersRepos = new UsersRepos(cont, CheckInputs, AllowCascade);
AddressRepos = new AddressRepos(cont, CheckInputs, AllowCascade);
HouseRepos = new HouseRepos(cont, CheckInputs, AllowCascade);
StreetRepos = new StreetRepos(cont, CheckInputs, AllowCascade);
CityRepos = new CityRepos(cont, CheckInputs, AllowCascade);
OrderRepos = new OrderRepos(cont, CheckInputs, AllowCascade);
CustomerRepos = new CustomerRepos(cont, CheckInputs, AllowCascade);
CompanyRepos = new CompanyRepos(cont, CheckInputs, AllowCascade);
OrderEntryRepos = new OrderEntryRepos(cont, CheckInputs, AllowCascade);
StatusRepos = new StatusRepos(cont, CheckInputs, AllowCascade);
MeterRepos = new MeterRepos(cont, CheckInputs, AllowCascade);
MeterTypeRepos = new MeterTypeRepos(cont, CheckInputs, AllowCascade);
StavkaRepos = new StavkaRepos(cont, CheckInputs, AllowCascade);
PersonRepos = new PersonRepos(cont, CheckInputs, AllowCascade);
UserToCustomerRepos = new UserToCustomerRepos(cont, CheckInputs, AllowCascade);
Reposes = new Dictionary <Type, object>()
{
{ typeof(Address), AddressRepos },
{ typeof(House), HouseRepos },
{ typeof(Street), StreetRepos },
{ typeof(City), CityRepos },
{ typeof(Order), OrderRepos },
{ typeof(OrderEntry), OrderEntryRepos },
{ typeof(Customer), CustomerRepos },
{ typeof(Company), CompanyRepos },
{ typeof(User), UsersRepos },
{ typeof(Meter), MeterRepos },
{ typeof(MeterType), MeterTypeRepos },
{ typeof(Status), StatusRepos },
{ typeof(Person), PersonRepos },
{ typeof(Stavka), StavkaRepos },
{ typeof(UserToCustomer), UserToCustomerRepos },
};
}
public Form_createOrder(Order_entity o)
{
this.order_editing = o;
InitializeComponent();
db = new ApplicationContext();
roomTypesList = RoomTypes.init_RoomTypes(db);
roomsList = Entity.Rooms.init_Rooms(db);
clientsList = Clients.init_Clients(db);
ordersList = Order_entity.init_Orders(db);
// инициализируем комбобокс с выбором типа комнаты
ComboBox_roomType.Items.Add(emptyComboBoxItem);
foreach (RoomTypes type in roomTypesList)
{
ComboBox_roomType.Items.Add(type);
}
// Инициализируем комбобокс выбора размера комнаты значениями
Combobox_size.Items.Add(emptyComboBoxItem);
Entity.Rooms.initComboboxSize(Combobox_size);
updateDataGridRooms();
try
{
updateDataGridClients();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
using (StreamWriter writetext = new StreamWriter("_logs.txt"))
{
writetext.WriteLine(ex.Message);
writetext.WriteLine("\n");
writetext.WriteLine(ex.ToString());
}
}
DateTime now = DateTime.Now;
Calendar_.SelectionMode = CalendarSelectionMode.MultipleRange;
Calendar_.DisplayDateStart = new DateTime(
now.Year,
now.Month - 1 < 1 ? 1 : now.Month - 1,
1);
if (order_editing != null)
{
// edit mod
this.Title = "Редактирование информации о заказе";
this.Button_confirmOrder.Content = "Обновить";
this.selectedRoom = order_editing.Rooms;
// инфа о выбранном пользователе
TextBox_passport.Text = order_editing.Clients.Passport;
TextBox_firstName.Text = order_editing.Clients.FirstName;
TextBox_secondName.Text = order_editing.Clients.SecondName;
TextBox_patronymic.Text = order_editing.Clients.Patronymic;
TextBox_phone.Text = order_editing.Clients.Phone;
// достаем заказы с выбранной комнатой
OrderRepos orderRepos = new OrderRepos(db);
List <Order_entity> selectedRoomOrderList = orderRepos.GetByRoomId(order_editing.RoomsId);
// помечаем календарь крестиками
Calendar_.BlackoutDates.Clear();
Calendar_.SelectedDates.Clear();
foreach (Order_entity order in selectedRoomOrderList)
{
if (order.Id != order_editing.Id)
{
Calendar_.BlackoutDates.Add(
new CalendarDateRange(order.DateStart, order.DateEnd)
);
}
}
// помечаем на календаре выбранные дни для текущего заказа
Calendar_.SelectedDates.Clear();
for (DateTime date = order_editing.DateStart;
order_editing.DateEnd.AddDays(1).CompareTo(date) > 0;
date = date.AddDays(1.0))
{
Calendar_.SelectedDates.Add(date);
}
}
}
