public ActionResult Update(int id) { var clientOrder = new ClientOrderViewModel() { ClientOrders = _context.TableClientOrders.Include(c => c.Items).Include(d => d.Clients).SingleOrDefault(c => c.id == id), Client = _context.TableClients.ToList(), Item = _context.TableItems.ToList() }; if (clientOrder == null) { return(HttpNotFound()); } return(View("ClientOrderForm", clientOrder)); }
public ActionResult AddOrder() { var clients = _context.TableClients.ToList(); var items = _context.TableItems.ToList(); var viewModel = new ClientOrderViewModel { ClientOrders = new ClientOrders { date = DateTime.Now }, Client = clients, Item = items }; return(View("ClientOrderForm", viewModel)); }
public ActionResult Create() { ClientOrderViewModel comodel = new ClientOrderViewModel(); ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName"); ViewBag.ClientID = new SelectList(db.Clients, "ClientID", "Name"); ViewBag.EventSubTypeID = new SelectList(db.EventSubTypes, "EventSubTypeID", "EventSubTypeName"); ViewBag.EventTypeID = new SelectList(db.EventTypes, "EventTypeID", "EventTypeName"); ViewBag.VenueID = new SelectList(db.Venues, "VenueID", "VenueName"); ViewBag.ServiceID = new SelectList(db.Services, "ServiceID", "ServiceName"); ViewBag.ServiceProviderID = new SelectList(db.ServiceProviders, "ServiceProviderID", "ServiceProviderName"); ViewBag.pgCategory = new SelectList("1", "1", "1"); ViewBag.DecorationTypeID = new SelectList(db.DecorationTypes, "DecorationTypeID", "Name"); ViewBag.DecorationImageID = new SelectList(db.DecorationImages, "DecorationImageID", "Image"); return(View(comodel)); }
public ActionResult IndexByID() { var context = new IdentityDbContext(); var users = context.Users.ToList(); var user = User.Identity.Name; var Usercontact = users.Where(m => m.UserName == user).Single(); var contact = Usercontact.PhoneNumber; var clID = db.Clients.Where(c => c.Phone == contact).Select(i => i.ClientID).FirstOrDefault(); List <ClientOrderViewModel> covm = new List <ClientOrderViewModel>(); var clientOrderDetails = (from co in db.ClientOrders join cl in db.Clients on co.ClientID equals cl.ClientID join ep in db.EventsPhotographies on co.ClientOrderID equals ep.ClientOrderID join city in db.Cities on co.CityID equals city.CityID join et in db.EventTypes on co.EventTypeID equals et.EventTypeID join est in db.EventSubTypes on co.EventSubTypeID equals est.EventSubTypeID join vn in db.Venues on co.VenueID equals vn.VenueID where cl.ClientID == clID select new { co.ClientOrderID, cl.ClientID, cl.Name, city.CityName, et.EventTypeName, est.EventSubTypeName, co.EventName, co.EventStartDate, co.EventEndDate, co.NoOfGuest, vn.VenueName, co.SpecialInstruction }).ToList(); foreach (var item in clientOrderDetails) { ClientOrderViewModel cvm = new ClientOrderViewModel(); cvm.ClientOrderID = item.ClientOrderID; cvm.Name = item.Name; cvm.CityName = item.CityName; cvm.EventTypeName = item.EventTypeName; cvm.EventSubTypeName = item.EventSubTypeName; cvm.EventName = item.EventName; cvm.EventStartDate = item.EventStartDate; cvm.EventEndDate = item.EventEndDate; cvm.NoOfGuest = item.NoOfGuest; cvm.VenueName = item.VenueName; cvm.SpecialInstruction = item.SpecialInstruction; covm.Add(cvm); } return(View(covm)); }
public IActionResult MakeOrder(ClientOrderViewModel request) { if (request.order.CheckOutDate != null && request.order.CheckInDate >= request.order.CheckOutDate) { ModelState.AddModelError("", "CheckInDate can't be more or equal than CheckOutDate"); } if (!ModelState.IsValid) { return(View(request.order)); } ClientDTO client = mapper.Map <ClientDTO>(request.client); ActiveOrderDTO order = mapper.Map <ActiveOrderDTO>(request.order); clientOrderService.AddClientActiveOrder(order, client); return(View("~/Views/Home/Index.cshtml")); }
public ActionResult Save(ClientOrders clientOrders) { var itemInDb = _context.TableItems.Single(c => c.id == clientOrders.ItemsId); if (!ModelState.IsValid) { var clientOrder = new ClientOrderViewModel() { ClientOrders = clientOrders, Client = _context.TableClients.ToList(), Item = _context.TableItems.ToList() }; return(View("ClientOrderForm", clientOrder)); } var clientInDb = _context.TableClients.Single(c => c.id == clientOrders.ClientsId); if (clientOrders.id == 0) { clientOrders.bill = clientOrders.quantity * itemInDb.sellingPrice; _context.TableClientOrders.Add(clientOrders); } else { var clientOrderInDb = _context.TableClientOrders.Single(c => c.id == clientOrders.id); itemInDb.quantity = itemInDb.quantity + clientOrderInDb.quantity; clientOrderInDb.ClientsId = clientOrders.ClientsId; clientOrderInDb.ItemsId = clientOrders.ItemsId; clientOrderInDb.quantity = clientOrders.quantity; clientOrderInDb.date = clientOrders.date; clientOrderInDb.status = clientOrders.status; clientOrderInDb.bill = clientOrders.quantity * itemInDb.sellingPrice; } if (clientOrders.status.Equals("2")) { clientInDb.balance = clientInDb.balance - clientOrders.bill; } if (!clientOrders.status.Equals("3")) { itemInDb.quantity = itemInDb.quantity - clientOrders.quantity; } _context.SaveChanges(); return(RedirectToAction("Index", "ClientOrders")); }
public IActionResult PostOrder(ClientOrderViewModel request) { if (request is null || request.Client is null || request.Order is null) { return(BadRequest()); } if (request.Order.CheckOutDate != null && request.Order.CheckInDate >= request.Order.CheckOutDate) { ModelState.AddModelError("", "CheckInDate can't be more or equal than CheckOutDate"); } if (!ModelState.IsValid) { return(BadRequest()); } ClientDTO client = mapper.Map <ClientDTO>(request.Client); ActiveOrderDTO order = mapper.Map <ActiveOrderDTO>(request.Order); clientOrderService.AddClientActiveOrder(order, client); return(Ok()); }
public ActionResult Index() { List <ClientOrderViewModel> covm = new List <ClientOrderViewModel>(); var clientOrderDetails = (from co in db.ClientOrders join cl in db.Clients on co.ClientID equals cl.ClientID join ep in db.EventsPhotographies on co.ClientOrderID equals ep.ClientOrderID join city in db.Cities on co.CityID equals city.CityID join et in db.EventTypes on co.EventTypeID equals et.EventTypeID join est in db.EventSubTypes on co.EventSubTypeID equals est.EventSubTypeID join vn in db.Venues on co.VenueID equals vn.VenueID select new { co.ClientOrderID, cl.ClientID, cl.Name, city.CityName, et.EventTypeName, est.EventSubTypeName, co.EventName, co.EventStartDate, co.EventEndDate, co.NoOfGuest, vn.VenueName, co.SpecialInstruction }).ToList(); foreach (var item in clientOrderDetails) { ClientOrderViewModel cvm = new ClientOrderViewModel(); cvm.ClientOrderID = item.ClientOrderID; cvm.Name = item.Name; cvm.CityName = item.CityName; cvm.EventTypeName = item.EventTypeName; cvm.EventSubTypeName = item.EventSubTypeName; cvm.EventName = item.EventName; cvm.EventStartDate = item.EventStartDate; cvm.EventEndDate = item.EventEndDate; cvm.NoOfGuest = item.NoOfGuest; cvm.VenueName = item.VenueName; cvm.SpecialInstruction = item.SpecialInstruction; covm.Add(cvm); } return(View(covm)); }
public ClientOrder() { clientOrderViewModel = new ClientOrderViewModel(); DataContext = clientOrderViewModel; this.InitializeComponent(); }
public JsonResult Create(ClientOrderViewModel vm) { ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName"); ViewBag.ClientID = new SelectList(db.Clients, "ClientID", "Name"); ViewBag.EventSubTypeID = new SelectList(db.EventSubTypes, "EventSubTypeID", "EventSubTypeName"); ViewBag.EventTypeID = new SelectList(db.EventTypes, "EventTypeID", "EventTypeName"); ViewBag.VenueID = new SelectList(db.Venues, "VenueID", "VenueName"); ViewBag.ServiceID = new SelectList(db.Services, "ServiceID", "ServiceName"); ViewBag.ServiceProviderID = new SelectList(db.ServiceProviders, "ServiceProviderID", "ServiceProviderName"); bool status = false; if (ModelState.IsValid) { EventServices evs = new EventServices(); ClientOrder co = new ClientOrder(); co.ClientID = vm.ClientID; co.CityID = vm.CityID; co.EventTypeID = vm.EventTypeID; co.EventSubTypeID = vm.EventSubTypeID; co.EventName = vm.EventName; co.EventStartDate = vm.EventStartDate; co.EventEndDate = vm.EventEndDate; co.NoOfGuest = vm.NoOfGuest; if (vm.VenueID != 0) { co.VenueID = Convert.ToInt32(vm.VenueID); } co.SpecialInstruction = vm.SpecialInstruction; co.Date = DateTime.Now.Date; db.ClientOrders.Add(co); db.SaveChanges(); int latestCoId = co.ClientOrderID; if (vm.VenueID != 0) { evs.ClientOrderID = latestCoId; evs.ServiceID = 9; evs.Price = Convert.ToDouble(db.Venues.Where(e => e.VenueID == vm.VenueID).Select(rent => rent.Rent).FirstOrDefault()); db.EventServicess.Add(evs); db.SaveChanges(); } EventSchedule es = new EventSchedule(); es.EventName = vm.EventName; es.EventStartDate = vm.EventStartDate; es.EventEndDate = vm.EventEndDate; es.VenueID = Convert.ToInt32(vm.VenueID); db.EventSchedules.Add(es); db.SaveChanges(); if (vm.PgCategory != null) { EventsPhotography ep = new EventsPhotography(); ep.Category = Convert.ToInt32(vm.PgCategory); ep.NumberOfTeam = Convert.ToInt32(vm.PgNumberOfTeam); ep.Price = Convert.ToDouble(vm.PgPrice); ep.ClientOrderID = latestCoId; db.EventsPhotographies.Add(ep); db.SaveChanges(); evs.ClientOrderID = latestCoId; evs.ServiceID = 7; evs.Price = Convert.ToDouble(vm.PgPrice); db.EventServicess.Add(evs); db.SaveChanges(); } if (vm.EventsDecorations != null) { foreach (var item in vm.EventsDecorations) { EventsDecoration evDec = new EventsDecoration(); evDec.ClientOrderID = latestCoId; evDec.DecorationTypeID = item.DecorationTypeID; if (item.DecorationImageID != null) { evDec.DecorationImageID = item.DecorationImageID; } if (item.CustomImage != null) { evDec.CustomImage = item.CustomImage; } evDec.Price = item.Price; db.EventsDecorations.Add(evDec); } evs.ClientOrderID = latestCoId; evs.ServiceID = 6; evs.Price = Convert.ToDouble(vm.TotalDecCost); db.SaveChanges(); } if (vm.EventsCaterings != null) { foreach (var item in vm.EventsCaterings) { EventsCatering ecate = new EventsCatering(); ecate.ClientOrderID = latestCoId; ecate.MealType = item.MealType; ecate.FoodItems = item.FoodItems; ecate.PerPersonCost = item.PerPersonCost; ecate.TotalCost = item.PerPersonCost * vm.NoOfGuest; db.EventsCaterings.Add(ecate); } evs.ClientOrderID = latestCoId; evs.ServiceID = 5; evs.Price = Convert.ToDouble(vm.TotalCateCost * vm.NoOfGuest); db.SaveChanges(); } if (vm.EventServicess != null) { foreach (var i in vm.EventServicess) { EventServices eser = new EventServices(); eser.ClientOrderID = latestCoId; eser.ServiceID = i.ServiceID; eser.Price = i.Price; db.EventServicess.Add(eser); } db.SaveChanges(); } var subTotal = db.EventServicess.Where(e => e.ClientOrderID == latestCoId).Sum(s => s.Price); if (subTotal != 0) { EventBill ebill = new EventBill(); ebill.ClientOrderID = latestCoId; ebill.SubTotalAmount = Convert.ToDouble(subTotal); ebill.MadeBy = User.Identity.GetUserName(); ebill.vat = vm.Vat; ebill.Discount = Convert.ToInt32(vm.Discount); db.EventBills.Add(ebill); db.SaveChanges(); EventPayment epay = new EventPayment(); epay.ClientOrderID = latestCoId; epay.Total = vm.NetTotal; epay.PaidAmount = 0; db.EventPayments.Add(epay); db.SaveChanges(); } status = true; } else { status = false; } var errors = ModelState.Values.SelectMany(v => v.Errors); return(Json(status, JsonRequestBehavior.AllowGet)); }
public ActionResult DetailsForClient(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { ClientOrderViewModel cvm = new ClientOrderViewModel(); var clientOrderDetails = (from co in db.ClientOrders join cl in db.Clients on co.ClientID equals cl.ClientID join ep in db.EventsPhotographies on co.ClientOrderID equals ep.ClientOrderID join city in db.Cities on co.CityID equals city.CityID join et in db.EventTypes on co.EventTypeID equals et.EventTypeID join est in db.EventSubTypes on co.EventSubTypeID equals est.EventSubTypeID join vn in db.Venues on co.VenueID equals vn.VenueID where co.ClientOrderID == id select new { co.ClientOrderID, cl.Name, city.CityName, et.EventTypeName, est.EventSubTypeName, co.EventName, co.EventStartDate, co.EventEndDate, co.NoOfGuest, vn.VenueName, co.SpecialInstruction, ep.EventsPhotographyID, ep.Category, ep.NumberOfTeam, ep.Price }).FirstOrDefault(); var eventCate = db.EventsCaterings.Where(i => i.ClientOrderID == id).ToList(); var eventDec = db.EventsDecorations.Where(i => i.ClientOrderID == id).ToList(); //var eventDec = (from ed in db.EventsDecorations // join de in db.DecorationTypes // on ed.DecorationTypeID equals de.DecorationTypeID // join di in db.DecorationImages // on ed.DecorationImageID equals di.DecorationImageID // where ed.ClientOrderID == id // select ed).ToList(); var EventOtherSer = db.EventServicess.Where(i => i.ClientOrderID == id).ToList(); cvm.ClientOrderID = clientOrderDetails.ClientOrderID; cvm.FirstName = clientOrderDetails.Name; cvm.CityName = clientOrderDetails.CityName; cvm.EventTypeName = clientOrderDetails.EventTypeName; cvm.EventSubTypeName = clientOrderDetails.EventSubTypeName; cvm.EventName = clientOrderDetails.EventName; cvm.EventStartDate = clientOrderDetails.EventStartDate; cvm.EventEndDate = clientOrderDetails.EventEndDate; cvm.NoOfGuest = clientOrderDetails.NoOfGuest; cvm.VenueName = clientOrderDetails.VenueName; cvm.SpecialInstruction = clientOrderDetails.SpecialInstruction; if (eventCate != null) { cvm.EventsCaterings = eventCate; } if (eventDec != null) { cvm.EventsDecorations = eventDec; } if (EventOtherSer != null) { cvm.EventServicess = EventOtherSer; } return(PartialView(cvm)); }; }