public ActionResult Routes(TransportRequestModel std) { //if (ModelState.IsValid) //{ var advert = db.TransportRequests.ToList().Where(s => s.Id == std.Id).FirstOrDefault(); advert.Notes = std.Notes; //advert.Pickup_Time = std.Pickup_Time; //advert.Delivery_Time = std.Delivery_Time; advert.Status = "Paid"; db.SaveChanges(); return(RedirectToAction("Index", "Home")); //} //return View(); }
public ActionResult Rent(RentModel rent) { var items = db.Items.ToList(); List <string> selection = new List <string>(); foreach (var item in items) { selection.Add(item.Name); } ViewData["selection"] = selection; if (ModelState.IsValid) { if (Request["Items"] != null || rent.StartDate > rent.EndDate) { var it = Request["Items"]; var item = db.Items.Where(x => x.Name == it).SingleOrDefault(); if (item == null) { this.Flash("error", "Failed!"); return(View()); } InvoiceModel invoice = new InvoiceModel(); invoice.Status = "Unpaid"; invoice.Amount = item.Price * (rent.EndDate - rent.StartDate).TotalDays; invoice.Date = DateTime.Today; invoice.CVC = 100; invoice.CardOwner = "-"; invoice.Card = 0; var checkBox = Request.Form["checkBox"]; string tID = null; string itID = null; string inID = null; string inID2 = null; itID = item.Id.ToString(); if (checkBox != null) { TransportRequestModel transport = new TransportRequestModel(); transport.Delivery_Time = rent.StartDate; transport.Pickup_Time = rent.EndDate; transport.Status = "Created"; //db.TransportRequests.Add(transport); rent.Transport = transport; string sql = @"insert into dbo.Transport (Pickup_Time, Delivery_Time, Status, Notes) values (@Pickup_Time, @Delivery_Time, @Status, @Notes); SELECT MAX(ID) FROM dbo.Transport;"; tID = (SqlDataAccess.SaveData(sql, transport)).ToString(); tID = db.TransportRequests.OrderByDescending(u => u.Id).FirstOrDefault().Id.ToString(); InvoiceModel invoice2 = new InvoiceModel(); invoice2.Status = "Unpaid"; invoice2.Amount = item.Price * (rent.EndDate - rent.StartDate).TotalDays; invoice2.Date = DateTime.Today; invoice2.CVC = 100; invoice2.CardOwner = "-"; invoice2.Card = 0; string sqles = @"insert into dbo.Invoice (Amount, Date, Status, Card, CardOwner, CVC) values (@Amount, @Date, @Status, @Card, @CardOwner, @CVC); SELECT MAX(ID) FROM dbo.Invoice;"; inID2 = (SqlDataAccess.SaveData(sqles, invoice2)).ToString(); inID2 = db.Invoices.OrderByDescending(u => u.Id).FirstOrDefault().Id.ToString(); } rent.Status = "In rent"; rent.Invoice = invoice; rent.Item = item; rent.Comments = item.Description; string sqle = @"insert into dbo.Invoice (Amount, Date, Status, Card, CardOwner, CVC) values (@Amount, @Date, @Status, @Card, @CardOwner, @CVC); SELECT MAX(ID) FROM dbo.Invoice;"; inID = (SqlDataAccess.SaveData(sqle, invoice)).ToString(); inID = db.Invoices.OrderByDescending(u => u.Id).FirstOrDefault().Id.ToString(); if (checkBox != null) { sqle = @"insert into dbo.Rent (StartDate, EndDate, Comments, Transport_Id, Item_Id, Invoice_Id, InvoiceT_Id) values (@StartDate, @EndDate, @Comments, " + tID + ", " + itID + ", " + inID + ", " + inID2 + ");"; SqlDataAccess.SaveData(sqle, rent); } else { sqle = @"insert into dbo.Rent (StartDate, EndDate, Comments, Item_Id, Invoice_Id) values (@StartDate, @EndDate, @Comments, " + itID + ", " + inID + ");"; SqlDataAccess.SaveData(sqle, rent); } //db.Invoices.Add(invoice); //db.Rents.Add(rent this.Flash("success", "Added!"); return(RedirectToAction("RentList")); } this.Flash("error", "Failed!"); return(View()); } this.Flash("error", "Failed!"); return(View()); }