public ActionResult DeleteConfirmed(int id) { tblTicket tblTicket = db.tblTickets.Find(id); db.tblTickets.Remove(tblTicket); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "TicketId,Name")] tblTicket tblTicket) { if (ModelState.IsValid) { db.Entry(tblTicket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblTicket)); }
public ActionResult Edit([Bind(Include = "Ticket_ID,Ticket_Name,Track_Type,Date,Booking_ID")] tblTicket tblTicket) { if (ModelState.IsValid) { db.Entry(tblTicket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Booking_ID = new SelectList(db.tblBookings, "Booking_ID", "Number_Of_People", tblTicket.Booking_ID); return(View(tblTicket)); }
public ActionResult Create([Bind(Include = "TicketId,Name")] tblTicket tblTicket) { if (ModelState.IsValid) { db.tblTickets.Add(tblTicket); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblTicket)); }
public ActionResult Edit([Bind(Include = "idsTicket,idsSeverityType,dtmCreate,idsUserCreate,txtIssue,blnResolved")] tblTicket tblTicket) { if (ModelState.IsValid) { db.Entry(tblTicket).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idsUserCreate = new SelectList(db.tblUsers, "idsUser", "txtUserName", tblTicket.idsUserCreate); ViewBag.idsSeverityType = new SelectList(db.tlkpSeverityTypes, "idsSeverityType", "txtSeverityType", tblTicket.idsSeverityType); return(View(tblTicket)); }
//public tblTicket Get(int id) //{ // var tblTicket = db.tblTickets.SqlQuery("SELECT * FROM tblTicket WHERE blnResolved = 1"); // return View(tblTicket.ToList()); //} // GET: ResolvedTicket/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblTicket tblTicket = db.tblTickets.Find(id); if (tblTicket == null) { return(HttpNotFound()); } return(View(tblTicket)); }
public ActionResult Create([Bind(Include = "idsTicket,idsSeverityType,dtmCreate,idsUserCreate,txtIssue,blnResolved")] tblTicket tblTicket) { if (ModelState.IsValid) { db.tblTickets.Add(tblTicket); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idsUserCreate = new SelectList(db.tblUsers, "idsUser", "txtUserName", tblTicket.idsUserCreate); ViewBag.idsSeverityType = new SelectList(db.tlkpSeverityTypes, "idsSeverityType", "txtSeverityType", tblTicket.idsSeverityType); ViewBag.dtmCreate = DateTime.Now.ToShortDateString(); return(View(tblTicket)); }
// GET: tblTickets/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblTicket tblTicket = db.tblTickets.Find(id); if (tblTicket == null) { return(HttpNotFound()); } ViewBag.Booking_ID = new SelectList(db.tblBookings, "Booking_ID", "Number_Of_People", tblTicket.Booking_ID); return(View(tblTicket)); }
// GET: ResolvedTicket/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblTicket tblTicket = db.tblTickets.Find(id); if (tblTicket == null) { return(HttpNotFound()); } ViewBag.idsUserCreate = new SelectList(db.tblUsers, "idsUser", "txtUserName", tblTicket.idsUserCreate); ViewBag.idsSeverityType = new SelectList(db.tlkpSeverityTypes, "idsSeverityType", "txtSeverityType", tblTicket.idsSeverityType); return(View(tblTicket)); }
public bool SaveTicket(mdlTicket mdl) { _validationResultList.Clear(); if (mdl.Id == 0) { tblTicket tblticket = new tblTicket() { CustomerId = mdl.CustomerId, TicketCategory = mdl.TicketCategory, TicketMasterId = mdl.TicketMasterId, TicketStatus = mdl.TicketStatus, TicketSubStatus = mdl.TicketSubStatus, Reason = mdl.Reason, Description = mdl.Description, AttachedFile = mdl.AttachedFile, ReffTransactionNo = mdl.ReffTransactionNo, RequestedBy = mdl.RequestedBy, RequestedDate = DateTime.Now, ClosedBy = mdl.ClosedBy, ClosedRemarks = mdl.ClosedRemarks, ClosedDate = mdl.ClosedDate, EstimatedTime = mdl.EstimatedTime, EstimatedCloseTime = mdl.EstimatedCloseTime, ActualTime = mdl.ActualTime, tblTicketDetails = mdl.mdlTicketDetails.Select(p => new tblTicketDetails { ProcessBy = _UserId, ProcessDate = DateTime.Now, ProcessRemarks = p.ProcessRemarks, TicketStatus = p.TicketStatus, TicketSubStatus = p.TicketSubStatus }).ToList() }; _context.tblTicket.Add(tblticket); _context.SaveChanges(); mdl.Id = tblticket.Id; } else { var Existing = _context.tblTicket.Where(p => p.Id == mdl.Id).FirstOrDefault(); if (Existing == null) { _validationResultList.Add(new ValidationResult("Invalid Ticket Id")); return(false); } else if (Existing.TicketStatus == enmTicketStatus.Close) { _validationResultList.Add(new ValidationResult("Ticket is Already Closed")); return(false); } var mdlTicketDetail = mdl.mdlTicketDetails.Where(p => p.DetailId == 0).FirstOrDefault(); if (mdlTicketDetail != null) { if (mdlTicketDetail.TicketStatus == enmTicketStatus.Close) { TimeSpan span = mdlTicketDetail.ProcessDate.Subtract(Existing.RequestedDate); Existing.TicketStatus = enmTicketStatus.Close; Existing.ClosedBy = _UserId; Existing.ClosedDate = mdlTicketDetail.ProcessDate; Existing.ClosedRemarks = mdlTicketDetail.ProcessRemarks; Existing.ActualTime = span.Hours * 60 + span.Minutes; } Existing.TicketSubStatus = mdlTicketDetail.TicketSubStatus; _context.tblTicketDetails.Add(new tblTicketDetails() { ProcessBy = _UserId, ProcessRemarks = mdlTicketDetail.ProcessRemarks, ProcessDate = mdlTicketDetail.ProcessDate, TicketId = Existing.Id, TicketStatus = mdlTicketDetail.TicketStatus, TicketSubStatus = mdlTicketDetail.TicketSubStatus }); _context.Update(Existing); _context.SaveChanges(); return(true); } else { _validationResultList.Add(new ValidationResult("No data found for update")); return(false); } } return(true); }
private void btnOrder_Click(object sender, RoutedEventArgs e) { try { CinemaDataContext Context = new CinemaDataContext(); List <tblTicket> TempSeats = new List <tblTicket>(); int Sum = 0; for (int i = 0; i < Seats.GetLength(0); i++) { for (int j = 0; j < Seats.GetLength(1); j++) { if (Seats[i, j].IsSelected) { if ((from T in Context.tblTickets where T.ShowID == Show.ShowID && T.Row == i + 1 && T.Seat == j + 1 && T.Status == 1 select T).Count() != 0) { throw new Exception("Место " + (j + 1).ToString() + " в ряду " + (i + 1).ToString() + " уже занято" + Environment.NewLine + "Заказ будет отменен"); } tblTicket Ticket = (from T in Context.tblTickets where T.Row == i + 1 && T.Seat == j + 1 && T.ShowID == Show.ShowID select T).First(); TempSeats.Add(Ticket); if (Seats[i, j].IsVip) { Sum += Show.VipPrice; } else { Sum += Show.NotVipPrice; } } } } foreach (var T in TempSeats) { tblSoldTicket SoldTicket = new tblSoldTicket(); SoldTicket.UserID = (int)Settings.UserID; SoldTicket.TicketID = T.TicketID; T.Status = 1; Context.tblSoldTickets.InsertOnSubmit(SoldTicket); } try { Context.SubmitChanges(); MessageBox.Show("Вы заказали " + TempSeats.Count + " билет(а/ов)" + Environment.NewLine + "на сумму " + Sum + " руб."); foreach (var T in TempSeats) { Ticket TicketWindow = new Ticket(MovieName, Show.Date, Show.Session, Show.RoomID, (int)T.Row, (int)T.Seat, Seats[(int)T.Row - 1, (int)T.Seat - 1].IsVip ? Show.VipPrice : Show.NotVipPrice); TicketWindow.ShowDialog(); } } catch (Exception E) { MessageBox.Show("Невозможно сделать заказ: " + E.Message); } } catch (Exception E) { MessageBox.Show("Ошибка: " + E.Message); } button2_Click(sender, e); }