public void Dispose() { using (MPContext context = new MPContext()) { context.Dispose(); } }
public ActionResult SubmitOrder(OrderModel order) { if (ModelState.IsValid) { using (MPContext dbContext = new MPContext()) { var currentUserId = User.Identity.GetUserId(); var currentCustomer = dbContext.Customer.Include("OrderList").FirstOrDefault(cust => cust.UserId == currentUserId); var newOrder = order.GetOrderInfo(dbContext); dbContext.Order.Add(newOrder); if (currentCustomer == null) { Customer newCustomer = new Customer(); newCustomer.UserId = currentUserId; newCustomer.Title = User.Identity.Name; newCustomer.OrderList.Add(newOrder); dbContext.Customer.Add(newCustomer); } else { currentCustomer.OrderList.Add(newOrder); } dbContext.SaveChanges(); } return(RedirectToAction("Index", "Orders")); } return(View("GoOrder", order)); }
public JsonResult AddMessage(Message message, int offerId, int?threadId) { var result = new { message = string.Empty }; using (var ctx = new MPContext()) { if (threadId == null) { var curOffer = ctx.Offer.First(offer => offer.Id == offerId); Thread newThread = new Thread(); newThread.CreatedDateTime = DateTime.Now; newThread.AuthorId = message.AuthorId; newThread.RecepientId = message.RecepientId; newThread.Offer = curOffer; ctx.Thread.Add(newThread); ctx.SaveChanges(); message.Thread = newThread; } message.CreatedDateTime = DateTime.Now; ctx.Message.Add(message); ctx.SaveChanges(); result = new { message = "Success" }; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ShowMyOrders() { var myOrdersModel = new OrderWithOffersListModel(); var orderToPush = new OrderWithOffers(); using (MPContext dbContext = new MPContext()) { var currentUserId = User.Identity.GetUserId(); var currentCustomer = dbContext.Customer.Include("OrderList").FirstOrDefault(cust => cust.UserId == currentUserId); if (currentCustomer != null) { foreach (var order in currentCustomer.OrderList) { var offers = dbContext.Offer.Include("Order").Where(offer => offer.Order.Id == order.Id); orderToPush.Id = order.Id; orderToPush.ServiceType = order.ServiceType; orderToPush.Title = order.Title; orderToPush.SourceAddress = order.SourceAddress; orderToPush.DestinationAddress = order.DestinationAddress; orderToPush.OrderDueDateTime = order.OrderDueDateTime; orderToPush.OrderCost = order.OrderCost; orderToPush.OrderCurrency = order.OrderCurrency; orderToPush.Offers = offers.ToList(); myOrdersModel.Orders.Add(orderToPush); } } return(View("MyOrders", myOrdersModel)); } }
public Order GetOrderInfo(MPContext mpContext) { Order newOrder = new Order(); newOrder.Title = orderTitle; newOrder.Description = orderDescription; newOrder.OrderDateTime = orderDateTime; newOrder.OrderDueDateTime = orderDueDateTime; //ServiceCathegory selectedCathegory = mpContext.ServiceCathegory.Single(c => c.Id == cathegoryId); ServiceType selectedType = mpContext.ServiceType.First(c => c.Id == typeId); //mpContext.ServiceType.Attach(selectedType); newOrder.ServiceType = selectedType; newOrder.SourceAddress = sourceAddress; newOrder.DestinationAddress = destinationAddress; newOrder.ContactTitle = contactTitle; newOrder.ContactEmail = contactEmail; newOrder.ContactPhoneNumber = contactPhoneNumber; newOrder.OrderCost = orderCost; Currency selectedCurrency = mpContext.Currency.Single(c => c.Id == currencyId); //mpContext.Currency.Attach(selectedCurrency); newOrder.OrderCurrency = selectedCurrency; return(newOrder); }
// GET: Orders public ActionResult Index() { var orderList = new OrderListModel(); using (MPContext dbContext = new MPContext()) { //IQueryable<Order> query = dbContext.Order.Include("ServiceType"); foreach (var order in dbContext.Order.Include("ServiceType").Include("OrderCurrency")) { orderList.Orders.Add(order); } } return(View(orderList)); }
public ActionResult OfferAcceptanceForm(int offerId) { ViewBag.ordersDone = 0; var curOfferModel = new OfferModel(); using (MPContext dbContext = new MPContext()) { var curOffer = dbContext.Offer.Include("Executor").First(offer => offer.Id == offerId); curOfferModel.executor.Title = curOffer.Executor.Title; curOfferModel.description = curOffer.Description; curOfferModel.executor.Rating = curOffer.Executor.Rating; } return(View("OfferAcceptanceForm", curOfferModel)); }
public ActionResult GoOrder(FormCollection form) { var orderTitle = form["orderTitle"].ToString(); OrderModel newOrder = new OrderModel(); newOrder.orderTitle = orderTitle; using (var ctx = new MPContext()) { var query = from cathegory in ctx.ServiceCathegory orderby cathegory.Id select cathegory; foreach (var item in query) { var cathegoryId = item.Id; var cathegoryTitle = item.Title; ServiceCathegory newCat = new ServiceCathegory(cathegoryId, cathegoryTitle); newOrder.orderCathegoryList.Add(newCat); } var typeQuery = from type in ctx.ServiceType orderby type.Title select type; foreach (var typeItem in typeQuery) { ServiceType newType = new ServiceType(typeItem.Id, typeItem.Title, typeItem.ServiceCathegory); newOrder.orderTypeList.Add(newType); } var currencyQuery = from currency in ctx.Currency orderby currency.Title select currency; foreach (var currencyItem in currencyQuery) { Currency newCurrency = new Currency(currencyItem.Id, currencyItem.Title); newOrder.currencyList.Add(newCurrency); } } return(View(newOrder)); }
public ActionResult AcceptOffer(int offerId) { using (MPContext dbContext = new MPContext()) { var curOffer = dbContext.Offer.Include("Executor").First(offer => offer.Id == offerId); OfferTracking newOfferTracking = new OfferTracking(); newOfferTracking.Offer = curOffer; newOfferTracking.Created = DateTime.Now; newOfferTracking.Status = new OfferStatus("Accepted"); dbContext.OfferTracking.Add(newOfferTracking); dbContext.SaveChanges(); } return(RedirectToAction("ShowMyOrders", "Orders")); }
// GET: Messages public ActionResult Index() { ThreadModel myThreads = new ThreadModel(); using (var ctx = new MPContext()) { var currentUserId = User.Identity.GetUserId(); var threadList = from th in ctx.Thread orderby th.CreatedDateTime descending where th.AuthorId == currentUserId || th.RecepientId == currentUserId select th; foreach (Thread thread in threadList) { ThreadEntity newThread = new ThreadEntity(); var executorVal = (from executor in ctx.Executor where executor.UserId == currentUserId select executor).FirstOrDefault(); var customerVal = (from customer in ctx.Customer where customer.UserId == currentUserId select customer).FirstOrDefault(); var userTitle = executorVal != null ? executorVal.Title : customerVal.Title; var lastMessage = (from message in ctx.Message orderby message.CreatedDateTime descending where message.Thread.Id == thread.Id select message).FirstOrDefault(); newThread.AuthorTitle = userTitle; newThread.LastMessageDateTime = lastMessage.CreatedDateTime; newThread.LastMessageText = lastMessage.MessageText; myThreads.ThreadList.Add(newThread); } } return(View("ThreadList", myThreads)); }
public ActionResult TakeOrder(int Id, FormCollection form) { var curOrderModel = new OrderModel(); using (MPContext dbContext = new MPContext()) { var currentUserId = User.Identity.GetUserId(); var curOrder = dbContext.Order.Include("ServiceType").Include("ServiceType.ServiceCathegory").Include("OrderCurrency").First(order => order.Id == Id); var curExecutor = dbContext.Executor.FirstOrDefault(ex => ex.UserId == currentUserId); var newCreatedStatus = dbContext.OfferStatus.FirstOrDefault(s => s.Title == "Created"); string descriptionText = form["description"]; Offer newOffer = new Offer(); newOffer.Order = curOrder; newOffer.Description = descriptionText; newOffer.Executor = curExecutor; dbContext.Offer.Add(newOffer); dbContext.SaveChanges(); OfferTracking newCreatedTracking = new OfferTracking(); newCreatedTracking.Status = newCreatedStatus; newCreatedTracking.Created = DateTime.Now; newCreatedTracking.Offer = newOffer; dbContext.OfferTracking.Add(newCreatedTracking); dbContext.SaveChanges(); //curOrderModel.cathegoryId = curOrder.ServiceType.ServiceCathegory.Id; //curOrderModel.cathegoryTitle = curOrder.ServiceType.ServiceCathegory.Title; //curOrderModel.orderTitle = curOrder.Title;//curOrderModel.sourceAddress = curOrder.SourceAddress; //curOrderModel.destinationAddress = curOrder.DestinationAddress; //curOrderModel.orderDueDateTime = curOrder.OrderDueDateTime; //curOrderModel.orderCost = curOrder.OrderCost; //curOrderModel.orderCurrency = curOrder.OrderCurrency; } return(View("Order", curOrderModel)); }
public ActionResult ShowOrder(int Id) { var curOrderModel = new OrderModel(); using (MPContext dbContext = new MPContext()) { var curOrder = dbContext.Order.Include("ServiceType").Include("ServiceType.ServiceCathegory").Include("OrderCurrency").First(order => order.Id == Id); curOrderModel.orderId = curOrder.Id; curOrderModel.cathegoryId = curOrder.ServiceType.ServiceCathegory.Id; curOrderModel.cathegoryTitle = curOrder.ServiceType.ServiceCathegory.Title; curOrderModel.orderTitle = curOrder.Title; curOrderModel.sourceAddress = curOrder.SourceAddress; curOrderModel.destinationAddress = curOrder.DestinationAddress; curOrderModel.orderDueDateTime = curOrder.OrderDueDateTime; curOrderModel.orderCost = curOrder.OrderCost; curOrderModel.orderCurrency = curOrder.OrderCurrency; } return(View("Order", curOrderModel)); }
public JsonResult GetMessages(int threadId) { var result = new LinkedList <object>(); using (var ctx = new MPContext()) { List <Message> messages = ctx.Message.Where(m => m.Thread.Id == threadId).OrderBy(m => m.CreatedDateTime).ToList(); foreach (var message in messages) { result.AddLast(new { Username = message.AuthorId, PostDateTime = message.CreatedDateTime.ToString("dd MMMM yyyy hh:mm"), MessageBody = message.MessageText, ThreadId = message.Thread.Id }); } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Conversation(string executorId, int offerId) { ThreadEntity currentThread; using (var ctx = new MPContext()) { var currentUserId = User.Identity.GetUserId(); var currentUserName = User.Identity.Name; var executorVal = (from executor in ctx.Executor where executor.UserId == currentUserId select executor).FirstOrDefault(); var customerVal = (from customer in ctx.Customer where customer.UserId == currentUserId select customer).FirstOrDefault(); var userId = executorVal != null ? executorVal.Id : customerVal.Id; currentThread = new ThreadEntity(ctx, executorId, offerId, userId, currentUserName); } return(View("Conversation", currentThread)); }
public ActionResult Index() { using (var ctx = new MPContext()) { var cust = new Customer(); cust.Title = "New customer"; //ctx.Customer.Add(cust); //ctx.SaveChanges(); //// Display all Blogs from the database //var query = from b in ctx.Customer // orderby b.Title // select b; //Console.WriteLine("All blogs in the database:"); //foreach (var item in query) //{ // var test = item.Title; //} } return(View()); }
public ActionResult OffersByOrder(int orderId) { var curOfferListModel = new OfferListModel(); using (MPContext dbContext = new MPContext()) { var curOrder = dbContext.Order.Include("ServiceType") .Include("ServiceType.ServiceCathegory") .Include("OrderCurrency") .First(order => order.Id == orderId); curOfferListModel.order = curOrder; var offerList = dbContext.Offer.Include("Executor").Where(offer => offer.Order.Id == orderId); foreach (var offer in offerList) { OfferModel mOffer = new OfferModel(); mOffer.Id = offer.Id; mOffer.executor = offer.Executor; mOffer.description = offer.Description; var tracking = dbContext.OfferTracking.Include("Status").Where(o => o.Offer.Id == offer.Id).OrderByDescending(o => o.Id); var offerStatus = tracking.FirstOrDefault(); if (offerStatus != null) { mOffer.offerStatus = offerStatus.Status.Title; curOfferListModel.offers.Add(mOffer); } } } return(View("OffersByOrder", curOfferListModel)); }
public Cleanup(MPContext ctx) { context = ctx; }
public MainRepository(MPContext _context) { context = _context; }
public Converter(MPContext ctx, IConfiguration cfg) { context = ctx; config = cfg; analyzer = new MP.Core.Analysis(context, config); }
public Analysis(MPContext ctx, IConfiguration cfg) { context = ctx; config = cfg; }
public App(IConfiguration config, MPContext ctx) { _config = config; _context = ctx; }
public Product_Repository(MPContext _context) { context = _context; }
public UnitOfWork(MPContext _db) { db = _db; }