Example #1
0
        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 { }
            }
        }
Example #3
0
        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 { }
        }