public IHttpActionResult PutTicket(int id, string reporter, string message)
{
try
{
//Use Put to create or replace
var ticket = db.TICKETS.FirstOrDefault((p) => p.Id == id);
if (ticket == null)
{
ticket = new TICKET(id, reporter, message);
db.TICKETS.Add(ticket);
db.SaveChanges();
return(Ok(ticket));
}
else
{
ticket.Message = message;
ticket.Reporter = reporter;
db.TICKETS.Attach(ticket);
var entry = db.Entry(ticket);
entry.Property(e => e.Message).IsModified = true;
entry.Property(e => e.Reporter).IsModified = true;
db.SaveChanges();
return(Ok(ticket));
}
}
catch (Exception e)
{
return(Content(HttpStatusCode.InternalServerError, e.Message));
}
}
public IHttpActionResult PutTICKET(int id, TICKET tICKET)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tICKET.id)
{
return(BadRequest());
}
db.Entry(tICKET).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TICKETExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void CopyFrom(TICKET t)
{
int i;
bData = new byte[t.bData.Length];
for (i = 0; i < bData.Length; i++)
{
bData[i] = t.bData[i];
}
isData = new short[t.isData.Length];
for (i = 0; i < isData.Length; i++)
{
isData[i] = t.isData[i];
}
iData = new int[t.iData.Length];
for (i = 0; i < iData.Length; i++)
{
iData[i] = t.iData[i];
}
tData = new DateTime[t.tData.Length];
for (i = 0; i < tData.Length; i++)
{
tData[i] = t.tData[i];
}
sData = new string[t.sData.Length];
for (i = 0; i < sData.Length; i++)
{
sData[i] = t.sData[i];
}
}
public ActionResult DeleteConfirmed(decimal id)
{
TICKET tICKET = db.TICKETs.Find(id);
db.TICKETs.Remove(tICKET);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed(short id)
{
TICKET tICKET = await db.TICKETs.FindAsync(id);
db.TICKETs.Remove(tICKET);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TicketID,TicketType")] TICKET tICKET)
{
if (ModelState.IsValid)
{
db.Entry(tICKET).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tICKET));
}
public ActionResult Create([Bind(Include = "TicketID,TicketType")] TICKET tICKET)
{
if (ModelState.IsValid)
{
db.TICKETs.Add(tICKET);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tICKET));
}
public IHttpActionResult GetTICKET(long id)
{
TICKET tICKET = db.TICKET.Find(id);
if (tICKET == null)
{
return(NotFound());
}
return(Ok(tICKET));
}
public static TICKET[] FromBytes(byte[] b)
{
try
{
TICKET[] ts = new TICKET[BitConverter.ToInt16(b, off_sum)];
int i, j, l;
l = off_packagehead;
for (i = 0; i < ts.Length; i++)
{
ts[i] = new TICKET();
ts[i].bData = new byte[b[l]];
l++;
for (j = 0; j < ts[i].bData.Length; j++)
{
ts[i].bData[j] = b[l];
l++;
}
ts[i].isData = new short[b[l]];
l++;
for (j = 0; j < ts[i].isData.Length; j++)
{
ts[i].isData[j] = BitConverter.ToInt16(b, l);
l += 2;
}
ts[i].iData = new int[b[l]];
l++;
for (j = 0; j < ts[i].iData.Length; j++)
{
ts[i].iData[j] = BitConverter.ToInt32(b, l);
l += 4;
}
ts[i].tData = new DateTime[b[l]];
l++;
for (j = 0; j < ts[i].tData.Length; j++)
{
ts[i].tData[j] = Tools.Byte2Time(b, l);
l += 6;
}
ts[i].sData = new string[b[l]];
l++;
for (j = 0; j < ts[i].sData.Length; j++)
{
ts[i].sData[j] = Tools.Byte2String(b, ref l);
}
}
return(ts);
}
catch
{
return(new TICKET[0]);
}
}
public ActionResult Edit([Bind(Include = "TICKETID,USERID,TRANSACTIONID,JOURNEYID,PRICE,SEATRESERVATION")] TICKET tICKET)
{
if (ModelState.IsValid)
{
db.Entry(tICKET).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.JOURNEYID = new SelectList(db.JOURNEYs, "JOURNEYID", "JOURNEYID", tICKET.JOURNEYID);
ViewBag.TRANSACTIONID = new SelectList(db.TRANSACTIONS, "TRANSACTIONID", "TRANSACTIONID", tICKET.TRANSACTIONID);
ViewBag.USERID = new SelectList(db.TRANSACTIONS, "USERID", "USERID");
return(View(tICKET));
}
public async Task <ActionResult> Edit([Bind(Include = "ID_TICKET,AMOUNT,MEMBER_ID,EVENT_ID")] TICKET tICKET)
{
if (ModelState.IsValid)
{
db.Entry(tICKET).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.EVENT_ID = new SelectList(db.EVENTs, "EVENT_ID", "EVENT_NAME", tICKET.EVENT_ID);
ViewBag.MEMBER_ID = new SelectList(db.MEMBERs, "MEMBER_ID", "USERNAME", tICKET.MEMBER_ID);
return(View(tICKET));
}
public IHttpActionResult PostTICKET(TICKET tICKET)
{
tICKET.date = DateTime.Now.Date + DateTime.Now.TimeOfDay;
//tICKET.date = DateTime.ParseExact(tICKET.date.ToString(), "yyyy-MM-dd HH:mm:ss",CultureInfo.InvariantCulture);
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
db.TICKET.Add(tICKET);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = tICKET.id }, tICKET));
}
public IHttpActionResult PostTicket(int id, string reporter, string message)
{
try
{
var ticket = new TICKET(id, reporter, message);
db.TICKETS.Add(ticket);
db.SaveChanges();
return(Ok(ticket));
}
catch (Exception e)
{
return(Content(HttpStatusCode.InternalServerError, e.Message));
}
}
// GET: TICKETs/Details/5
public async Task <ActionResult> Details(short?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKET tICKET = await db.TICKETs.FindAsync(id);
if (tICKET == null)
{
return(HttpNotFound());
}
return(View(tICKET));
}
// gets the id and displays the whole element with its values in the details view
// GET: Tickets/Details/5
public ActionResult Details(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKET tICKET = db.TICKETs.Find(id);
if (tICKET == null)
{
return(HttpNotFound());
}
return(View(tICKET));
}
public IHttpActionResult DeleteTICKET(long id)
{
TICKET tICKET = db.TICKET.Find(id);
if (tICKET == null)
{
return(NotFound());
}
db.TICKET.Remove(tICKET);
db.SaveChanges();
return(Ok(tICKET));
}
// GET: TICKETs/Edit/5
public async Task <ActionResult> Edit(short?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKET tICKET = await db.TICKETs.FindAsync(id);
if (tICKET == null)
{
return(HttpNotFound());
}
ViewBag.EVENT_ID = new SelectList(db.EVENTs, "EVENT_ID", "EVENT_NAME", tICKET.EVENT_ID);
ViewBag.MEMBER_ID = new SelectList(db.MEMBERs, "MEMBER_ID", "USERNAME", tICKET.MEMBER_ID);
return(View(tICKET));
}
public void GenerateTicket(TOURORDER order)
{
int i = 0;
var ticketRepo = dbcontext.Set <TICKET>();
do
{
var ticket = new TICKET()
{
CUSTOMER_ID = order.CUSTOMERs.FirstOrDefault().ID,
TOUR_ID = order.TOUR_ID,
};
ticketRepo.Add(ticket);
ticket.SEETNO = (int)ticket.ID;
i++;
}while (i < order.NUMOFPEOPLE);
}
/// <summary>
/// takes the id and returns the element with its values for edit
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
// GET: Tickets/Edit/5
public ActionResult Edit(decimal id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TICKET tICKET = db.TICKETs.Find(id);
if (tICKET == null)
{
return(HttpNotFound());
}
ViewBag.JOURNEYID = new SelectList(db.JOURNEYs, "JOURNEYID", "JOURNEYID", tICKET.JOURNEYID);
ViewBag.TRANSACTIONID = new SelectList(db.TRANSACTIONS, "TRANSACTIONID", "TRANSACTIONID", tICKET.TRANSACTIONID);
ViewBag.USERID = new SelectList(db.TRANSACTIONS, "USERID", "USERID");
return(View(tICKET));
}
/// <summary>
/// Trae el registro de Ticket como int Ticket
/// </summary>
/// <param name="idAsiento", name="idEvento">id del Asiento a Filtrar, id del Evento a Filtrar</param>
/// <returns></returns>
public int buscarTicket(int idAsiento, int idEvento)
{
try
{
TICKET dalcTick = (from tmpTicket in ConexionBLL.getConexion().TICKET
where tmpTicket.ID_ASIENTO == idAsiento && tmpTicket.ID_EVENTO == idEvento
select tmpTicket).FirstOrDefault();
if (dalcTick != null)
{
return((int)dalcTick.ID_TICKET);
}
return(-1);
}
catch
{
return(-1);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
// ddlMovie.Items.Clear();
// ddlSession.Items.Clear();
if (ddlMovie.SelectedIndex == 0 || ddlSession.SelectedIndex == 0)
{
lblMessage.Visible = true;
lblMessage.Text = "please choose";
}
else
{
CUSTOMER c = new CUSTOMER();
TICKET t = new TICKET();
t.Name = ddlMovie.SelectedValue;
t.Session = ddlSession.SelectedValue;
t.Person = txtTicket.Text;
t.Room = ddlRoom.SelectedValue;
t.Chair = ddlChair.SelectedValue;
int prc;
prc = Convert.ToInt32(txtTicket.Text) * 13;
db.TICKETs.InsertOnSubmit(t);
db.SubmitChanges();
lblMessage.Visible = true;
lblMessage.Text = "You take it successfully!";
lblMessagePrice.Visible = true;
lblMessagePrice.Text = prc.ToString() + "TL";
lblmessage1.Visible = true;
}
Session["Movie"] = ddlMovie.SelectedValue;
Session["Session"] = ddlSession.SelectedValue;
Session["Person"] = txtTicket.Text;
Session["Room"] = ddlRoom.SelectedValue;
Session["Chair"] = ddlChair.SelectedValue;
}
/// <summary>
/// auto generates unique id when is taken on the create page according to the last id
/// </summary>
/// <returns></returns>
// GET: Tickets/Create
public ActionResult Create()
{
ViewBag.JOURNEYID = new SelectList(db.JOURNEYs, "JOURNEYID", "JOURNEYID");
ViewBag.TRANSACTIONID = new SelectList(db.TRANSACTIONS, "TRANSACTIONID", "TRANSACTIONID");
ViewBag.USERID = new SelectList(db.TRANSACTIONS, "USERID", "USERID");
TICKET newTicket = new TICKET();
var lastTicket = db.TICKETs.OrderByDescending(x => x.TICKETID).FirstOrDefault();
if (lastTicket == null)
{
newTicket.TICKETID = 2001;
}
else if (lastTicket.TICKETID != 0)
{
newTicket.TICKETID = lastTicket.TICKETID + 1;
}
return(View(newTicket));
}
public bool Equal(TICKET t)
{
int i;
for (i = 0; i < bData.Length; i++)
{
if (bData[i] != t.bData[i])
{
return(false);
}
}
for (i = 0; i < isData.Length; i++)
{
if (isData[i] != t.isData[i])
{
return(false);
}
}
for (i = 0; i < iData.Length; i++)
{
if (iData[i] != t.iData[i])
{
return(false);
}
}
for (i = 0; i < tData.Length; i++)
{
if (tData[i] != t.tData[i])
{
return(false);
}
}
for (i = 0; i < sData.Length; i++)
{
if (sData[i] != t.sData[i])
{
return(false);
}
}
return(true);
}
/// <summary>
/// Agrega un nuevo registro de Ticket
/// </summary>
/// <param name="ticket">Objeto Ticket</param>
public int agregarTicket(TicketBEL ticket)
{
try
{
Entidades conexion = ConexionBLL.getConexion();
TICKET dalcTicket = new TICKET();
dalcTicket.ID_ASIENTO = ticket.IdAsiento;
dalcTicket.ID_EVENTO = ticket.IdEvento;
dalcTicket.ID_TIPO_TICKET = ticket.IdTipoTicket;
conexion.AddToTICKET(dalcTicket);
conexion.SaveChanges();
conexion.Dispose();
return(buscarTicket(ticket.IdAsiento, ticket.IdEvento));
}
catch
{
return(-1);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
CineKalyoncuDatabaseDataContext db = new CineKalyoncuDatabaseDataContext();
// ddlMovie.Items.Clear();
// ddlSession.Items.Clear();
if (ddlMovieName.SelectedIndex == 0 || ddlSession.SelectedIndex == 0 || ddlUsername.SelectedIndex == 0 || ddlUserSurname.SelectedIndex == 0)
{
lblMessage.Visible = true;
lblMessage.Text = "Please Check!";
}
else
{
TICKET t = new TICKET();
t.Name = ddlMovieName.SelectedValue;
t.Session = ddlSession.SelectedValue;
t.Room = ddlRoom.SelectedValue;
t.Chair = ddlChair.SelectedValue;
t.Person = txtPrice.Text;
int prc;
prc = Convert.ToInt32(txtPrice.Text) * 13;
db.TICKETs.InsertOnSubmit(t);
db.SubmitChanges();
lblMessage.Visible = true;
lblMessage.Text = "You sell it successfully!";
}
Session["MOVIENAME"] = ddlMovieName.SelectedValue;
Session["SESSION"] = ddlSession.SelectedValue;
Session["PERSON"] = txtPrice.Text;
Session["USERNAME"] = ddlUsername.SelectedValue;
Session["USERSURNAME"] = ddlUserSurname.SelectedValue;
Session["ROOM"] = ddlRoom.SelectedValue;
Session["CHAIR"] = ddlChair.SelectedValue;
}
partial void InsertTICKET(TICKET instance);
partial void UpdateTICKET(TICKET instance);
partial void DeleteTICKET(TICKET instance);