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);
}
