protected void Page_Load(object sender, EventArgs e) { if (!Page.IsCallback) { string qID = Request.QueryString["id"]; if (!string.IsNullOrEmpty(qID)) { try { Guid qGUI = Guid.Parse(qID); HelperClass_Ticket hct = new HelperClass_Ticket(); MembershipUser u = Membership.GetUser(User.Identity.Name); string email = string.Empty; if (u != null) email = u.Email; Ticket t = hct.GenerateNextTicket(qGUI, email); this.lblTicketIncr.Text = t.Ticket_Increment.ToString(); this.lblTicketPwd.Text = t.Ticket_Password; Session["lastTicketID"] = t.Ticket_ID; } catch (Exception ex) { this.divGetTicket.InnerText = ex.Message; } } } }
protected void Page_Load(object sender, EventArgs e) { string qID = Request.QueryString["id"]; if (!string.IsNullOrEmpty(qID)) { try { Guid qGUI = Guid.Parse(qID); HelperClass_Queue hcq = new HelperClass_Queue(); HelperClass_Ticket hct = new HelperClass_Ticket(); Queue q = hcq.GetQueue(qGUI); if (q.Queue_Current_Ticket_ID == null) return; Ticket t = hct.GetTicket((Guid)q.Queue_Current_Ticket_ID); this.lblEmail.Text = t.Ticket_Email; this.lblNumero.Text = t.Ticket_Increment.ToString(); this.lblPwd.Text = t.Ticket_Password; } catch { } } }
protected void ButtonAlert_Click(object sender, EventArgs e) { HelperClass_Ticket hct = new HelperClass_Ticket(); Guid tID = (Guid)Session["lastTicketID"]; Ticket t = hct.GetTicket(tID); hct.UpdateAlertEmail(tID, this.alertEmailTxtBox.Text); this.alertActivated.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { string qID = Request.QueryString["id"]; string showDetails = Request.QueryString["showDetails"]; if (!string.IsNullOrEmpty(qID)) { try { Guid qGUI = Guid.Parse(qID); HelperClass_Queue hcq = new HelperClass_Queue(); HelperClass_Ticket hct = new HelperClass_Ticket(); Queue q = hcq.GetQueue(qGUI); this.queueName.InnerText = q.Queue_Name; if (q.Queue_Current_Ticket_ID != null) this.currentTicketNumber.InnerText = hct.GetTicket((Guid)q.Queue_Current_Ticket_ID).Ticket_Increment.ToString(); else this.currentTicketNumber.InnerText = "--"; if (q.Queue_ExpectedHandlingTime != null) this.expectedHandlingTime.InnerText = "Estimated processing time per ticket: " + q.Queue_ExpectedHandlingTime.ToString() + " min."; this.invalidQueue.Visible = false; this.TicketDetails.Visible = false; this.activeDateOver.Visible = false; if (showDetails == "1") { if (q.Queue_UserID == (Guid)Membership.GetUser().ProviderUserKey) { this.TicketDetails.Visible = true; } } if (!hcq.IsActive(q)) this.activeDateOver.Visible = true; return; } catch { } } this.invalidQueue.Visible = true; }
public Queue GetQueueByTicketID(Guid ticketID) { HelperClass_Ticket hct = new HelperClass_Ticket(); Ticket t = hct.GetTicket(ticketID); return this.GetQueue(t.Ticket_Queue_ID); }
public void ValidateCurrentTicket(Guid queueID, bool cancel) { Queue queue = null; try { FreeQ_DBEntities db = new FreeQ_DBEntities(); queue = this.GetQueue(db, queueID); HelperClass_Ticket hct = new HelperClass_Ticket(); HelperClass_Queue hcq = new HelperClass_Queue(); if (!hcq.IsActive(queue)) throw new Exception("This queue isn't active; you can't handle tickets anymore."); if (queue.Queue_Current_Ticket_ID == null) { List<Ticket> tickets = (from t in db.Ticket where t.Ticket_Queue_ID == queueID orderby t.Ticket_ID select t).ToList<Ticket>(); if (tickets.Count > 0) queue.Queue_Current_Ticket_ID = tickets[0].Ticket_ID; } else { Ticket t = hct.GetTicket(db, (Guid)queue.Queue_Current_Ticket_ID); if (t == null) return; if (cancel) t.Ticket_StateID = 3; else t.Ticket_StateID = 2; List<Ticket> tickets = (from ti in db.Ticket where ti.Ticket_Queue_ID == queueID && ti.Ticket_UniversalIncrement > t.Ticket_UniversalIncrement orderby ti.Ticket_ID select ti). ToList<Ticket>(); if (tickets.Count > 0) queue.Queue_Current_Ticket_ID = tickets[0].Ticket_ID; } int result = db.SaveChanges(); // Send alert Ticket ct = hct.GetTicket(db, (Guid)queue.Queue_Current_Ticket_ID); List<Ticket> nextTicket = (from ti in db.Ticket where ti.Ticket_Queue_ID == queueID && ti.Ticket_UniversalIncrement == ct.Ticket_UniversalIncrement + 2 orderby ti.Ticket_ID select ti).ToList<Ticket>(); if (nextTicket.Count == 1 && !String.IsNullOrEmpty(nextTicket[0].Ticket_Email)) { HelperClass_Email.SendEmail(nextTicket[0].Ticket_Email, "Quddle - it is almost your turn!", "Hey, only 2 persons are in front of you ; it is time to go..."); } } catch { } }