protected void Page_Load(object sender, EventArgs e) { string eventID = Request.QueryString["ev"]; // GetNumViews(string eventID, string Type) EventServiceClient esv = new EventServiceClient(); ReportServiceClient reportClient = new ReportServiceClient(); EventModel myEvent = new EventModel(); //Get Number of Event Vies int EventViews = esv.GetNumViews(eventID, "Views"); int EventShares = esv.GetNumViews(eventID, "Shares"); string RecentShareDate = reportClient.GetLatestView(eventID, "Shares"); string RecentViewDate = reportClient.GetLatestView(eventID, "Views"); numViews.InnerHtml = Convert.ToString(EventViews); numShares.InnerHtml = Convert.ToString(EventShares); ViewDate.InnerHtml = RecentViewDate; shareDate.InnerHtml = RecentShareDate; //Get Event Details myEvent = esv.findByEventID(eventID); //EventProduct //getProductByEventID(string EventID) ProductServiceClient psv = new ProductServiceClient(); List <EventProduct> product = new List <EventProduct>(); product = psv.getProductByEventID(eventID); if (product.Count() != 0) { string htmtag = ""; int count = 1; foreach (EventProduct _prod in product) { double productSold = _prod._Quantity - _prod.ProdRemaining; double half = Math.Round((double)(_prod._Quantity) / 2, 2); double perc = Math.Round((productSold / _prod._Quantity) * 100); htmtag += "<tr>"; htmtag += "<td scope ='row' style='text-align:center;'>" + count + "</td>"; htmtag += "<td style='text-align:center;'>" + _prod._Name + "</td>"; if (productSold > _prod.ProdRemaining) //sold more than half of toltal product { htmtag += "<td style='text-align:center;'><span class='label label-success'>" + productSold + "</span></td>"; htmtag += "<td style='text-align:center;'><span class='label label-success'>" + _prod.ProdRemaining + "</span></td>"; htmtag += "<td style='text-align:center;'><h5>" + perc + "%<i class='fa fa-level-up'></i></h5></td></tr>"; } else //Less than half of the product were sold { htmtag += "<td style='text-align:center;'><span class='label label-danger'>" + productSold + "</span></td>"; htmtag += "<td style='text-align:center;'><span class='label label-danger'>" + _prod.ProdRemaining + "</span></td>"; htmtag += "<td style='text-align:center;'><h5>" + perc + "%<i class='fa fa-level-down'></i></h5></td></tr>"; } count++; } ProductRowDiv.InnerHtml = htmtag; //Number Scans Per Work Stations //string html = ""; //int count = 0; //for (int i = 0; i < 4; i++) //{ // count = i + 50; // html += "<div class='col-md-3 col-sm-6'>"; // html += "<div class='our-progress' >"; // html += "<div class='chart' data-percent='" + count + "'>"; // html += "<span class='percent'>" + count + "</span>"; // html += "</div></div></div>"; // count += 20; //} //piechart.InnerHtml = html; // String request = (Request.QueryString["EventID"]); // string eventID = Request.QueryString["EventID"]; List <StaffModel> StaffList = new List <StaffModel>(); List <double> percentageList = new List <double>(); ReportServiceClient _report = new ReportServiceClient(); StaffList = _report.GetMostUsedWorkstation(eventID); if (StaffList != null) { percentageList = calculatepercentage(StaffList); string html = ""; for (int i = 0; i < percentageList.Count(); i++) { html += "<div class='col-md-3 col-sm-6'>"; html += "<div class='Number of Tickets by Type' >"; html += "<div class='chart' data-percent='" + percentageList[i] + "'>"; html += "<span class='percent'>" + percentageList[i] + "</span></div>"; html += "<span>" + StaffList[i].NAME + "</span>"; html += "<span>" + StaffList[i].WorkStation + "</span>"; html += "</div></div>"; } piechart.InnerHtml = html; } //Track Most CHecked In Entrance List <StaffModel> ch_StaffList = new List <StaffModel>(); List <double> ch_percentageList = new List <double>(); ch_StaffList = _report.GetMostCheckedinEntrance(eventID); if (ch_StaffList != null) { ch_percentageList = calculatepercentage(ch_StaffList); string html = ""; for (int i = 0; i < ch_percentageList.Count(); i++) { html += "<div class='col-md-3 col-sm-6'>"; html += "<div class='Number of Tickets by Type' >"; html += "<div class='chart' data-percent='" + ch_percentageList[i] + "'>"; html += "<span class='percent'>" + ch_percentageList[i] + "</span></div>"; html += "<span>" + ch_StaffList[i].NAME + "</span>"; html += "<span>" + ch_StaffList[i].WorkStation + "</span>"; html += "</div></div>"; } DivCheckedIn.InnerHtml = html; } } //Declined Guest List <GuestModel> Declinedguests = new List <GuestModel>(); Declinedguests = reportClient.RSVPGuest(eventID, "Declined"); //declinedRSVP.InnerHtml = Convert.ToString(Declinedguests.Count()); //list of RSVP'd geust //RSVPd_Guest if (Declinedguests.Count() != 0) { string htmltage = ""; foreach (GuestModel guest in Declinedguests) { htmltage += "<li>Guest Name: " + guest.NAME + ", Email: " + guest.EMAIL + "</li>"; } //Send to front End } //Get Number of RSVP'd guest List <GuestModel> Confirmedguests = new List <GuestModel>(); Confirmedguests = reportClient.RSVPGuest(eventID, "Confirmed"); // confirmedRSVP.InnerHtml = Convert.ToString(Confirmedguests.Count()); //list of RSVP'd geust //RSVPd_Guest if (Confirmedguests.Count() != 0) { string htmltage = ""; foreach (GuestModel guest in Confirmedguests) { htmltage += "<li>Guest Name: " + guest.NAME + ", Email: " + guest.EMAIL + "</li>"; } //Send to front End // RSVPd_Guest.InnerHtml = htmltage; } }
protected void Page_Load(object sender, EventArgs e) { string eventID = Request.QueryString["ev"]; // GetNumViews(string eventID, string Type) EventServiceClient esv = new EventServiceClient(); ReportServiceClient reportClient = new ReportServiceClient(); EventModel myEvent = new EventModel(); //Get Number of Event Vies int EventViews = esv.GetNumViews(eventID, "Views"); int EventShares = esv.GetNumViews(eventID, "Shares"); string RecentShareDate = reportClient.GetLatestView(eventID, "Shares"); string RecentViewDate = reportClient.GetLatestView(eventID, "Views"); numViews.InnerHtml = Convert.ToString(EventViews); numShares.InnerHtml = Convert.ToString(EventShares); ViewDate.InnerHtml = RecentViewDate; shareDate.InnerHtml = RecentShareDate; String request = (Request.QueryString["ev"]); string HostLevel = Convert.ToString(Session["Level"]); int HostID = Convert.ToInt32(Session["ID"]); //Trigger event views EventServiceClient evsc = new EventServiceClient(); EventViews newView = new EventViews(); newView.E_ID = Convert.ToInt32(request); if (HostLevel.ToLower().Equals("host")) { MapVsReportContainer.InnerHtml = "<span class='title' style='text-align:center;'>Ticket Statistics</span>"; EventServiceClient Service_Client = new EventServiceClient(); EventModel _event = new EventModel(); _event = Service_Client.findByEventID(request); if (_event.HostID == HostID) { btnDelete.Visible = true; btnEdit.Visible = true; btnReport.Visible = true; googleMap.Visible = false; PieChart.Visible = true; market.Visible = true; ticket.Visible = false; } else { btnDelete.Visible = false; btnEdit.Visible = false; btnReport.Visible = false; googleMap.Visible = true; PieChart.Visible = false; market.Visible = false; ticket.Visible = true; } EventModel view = new EventModel(); view.EventID = Convert.ToInt32(request); view.HostID = Convert.ToInt32(HostID); view.Type = "Views"; evsc.addEventView(view); } else if (HostLevel.ToLower().Equals("guest")) { MapVsReportContainer.InnerHtml = "<span class='title' style='text-align:center;'>Get Directions</span>"; btnDelete.Visible = false; btnEdit.Visible = false; btnReport.Visible = false; googleMap.Visible = true; PieChart.Visible = false; market.Visible = false; ticket.Visible = true; EventModel view = new EventModel(); view.EventID = Convert.ToInt32(request); view.GuestID = Convert.ToInt32(HostID); view.Type = "View"; evsc.addEventView(view); } else { MapVsReportContainer.InnerHtml = "<span class='title' style='text-align:center;'>Get Directions</span>"; btnDelete.Visible = false; btnEdit.Visible = false; btnReport.Visible = false; googleMap.Visible = true; PieChart.Visible = false; market.Visible = false; ticket.Visible = true; } //bool addViews = false; EventModel _View = new EventModel(); _View.EventID = Convert.ToInt32(request); _View.EventView = EventViews; DateTime dummyTime = new DateTime(); dummyTime = DateTime.Now; _View.sDate = Convert.ToString(dummyTime); _View.eDate = Convert.ToString(dummyTime); int EventID = Convert.ToInt32(request); strEventID = EventID; EventModel em = new EventModel(); ImageFile img = new ImageFile(); List <ImageFile> listimages = new List <ImageFile>(); List <EventProduct> products = new List <EventProduct>(); EventTicket EB_tickets = new EventTicket(); EventTicket REG_tickets = new EventTicket(); EventTicket VIP_tickets = new EventTicket(); EventTicket VVIP_tickets = new EventTicket(); EventServiceClient eventClient = new EventServiceClient(); FileUploadClient fuc = new FileUploadClient(); TicketServiceClient tsc = new TicketServiceClient(); ProductServiceClient psc = new ProductServiceClient(); em = eventClient.findByEventID(request); img = fuc.getImageById(request); listimages = fuc.getMultipleImagesById(request); string output = ""; string imgLocation = ""; ImageFile mainPic = new ImageFile(); if (listimages.Count == 0) { output = "/Events/Eventrix_Default_Image.png"; string strIhtml = "<img src='" + output + "' class='img-responsive' alt=''/>"; divImageSlider.InnerHtml = strIhtml; //secondaryImageSlider.Visible = false; } else if (listimages.Count == 1) //one pic uploaded { imgLocation = img.Location; output = imgLocation.Substring(imgLocation.IndexOf('E')); //trim string path from Event //image slider string strIhtml = "<img src='" + output + "' class='img-responsive' alt=''/>"; divImageSlider.InnerHtml = strIhtml; // secondaryImageSlider.Visible = false; } string htmltag = ""; htmltag = "Event Name: " + em.Name; EName.InnerHtml = htmltag; htmltag = "<span class='title'>Start Date : </span>" + em.sDate; StartDate.InnerHtml = htmltag; htmltag = "<span class='title'>End Date : </span>" + em.eDate; EndDate.InnerHtml = htmltag; htmltag = em.Desc; Description.InnerHtml = htmltag; htmltag = ""; //clean string EB_tickets = tsc.getEBTicket(request); REG_tickets = tsc.getRegularTicket(request); VIP_tickets = tsc.getVIPTicket(request); VVIP_tickets = tsc.getVVIPTicket(request); if (EB_tickets != null) { if (EB_tickets._Price.Equals(0)) { htmltag += "<li><span class='title'>Early Bird Tickets :Available " + em.EB_Quantity + " </span> Price: For Free!, Available Till: " + EB_tickets._EndDate + "</li>"; } else { htmltag += "<li><span class='title'>Early Bird Tickets :Available " + em.EB_Quantity + " </span> Price: R" + EB_tickets._Price + ", Available Till: " + EB_tickets._EndDate + "</li>"; } htmltag += "<li><a class='btn btn-primary animated bounceIn' href ='PurchaseTicket.aspx?EBT_ID=" + EB_tickets._TicketID + "&E_ID=" + request + "'>Buy Early Bird Ticket</a></li><hr/>"; } if (REG_tickets != null) { if (REG_tickets._Price.Equals(0)) { htmltag += "<li><span class='title'>Regular Tickets :Available " + em.Reg_Quantity + " </span> Price: For Free!, Available Till: " + REG_tickets._EndDate + "</li>"; } else { htmltag += "<li><span class='title'>Regular Tickets :Available " + em.Reg_Quantity + " </span> Price: R" + REG_tickets._Price + ", Available Till: " + REG_tickets._EndDate + "</li>"; } htmltag += "<li><a class='btn btn-primary animated bounceIn' href ='PurchaseTicket.aspx?RBT_ID=" + REG_tickets._TicketID + "&E_ID=" + request + "'>Buy Regular Ticket</a></li><hr/>"; } if (VIP_tickets != null) { if (VIP_tickets._Price.Equals(0)) { htmltag += "<li><span class='title'>VIP Tickets :Available " + em.VIP_Quantity + " </span> Price: For Free!, Available Till: " + VIP_tickets._EndDate + "</li>"; } else { htmltag += "<li><span class='title'>VIP Tickets :Available " + em.VIP_Quantity + " </span> Price: R" + VIP_tickets._Price + ", Available Till: " + VIP_tickets._EndDate + "</li>"; } htmltag += "<li><a class='btn btn-primary animated bounceIn' href ='PurchaseTicket.aspx?VT_ID=" + VIP_tickets._TicketID + "&E_ID=" + request + "'>Buy VIP Ticket</a></li><hr/>"; } if (VVIP_tickets != null) { if (VVIP_tickets._Price.Equals(0)) { htmltag += "<li><span class='title'>VVIP Tickets :Available " + em.VVIP_Quantity + " </span> Price: For Free!, Available Till: " + VVIP_tickets._EndDate + "</li>"; } else { htmltag += "<li><span class='title'>VVIP Tickets :Available " + em.VVIP_Quantity + " </span> Price: R" + VVIP_tickets._Price + ", Available Till: " + VVIP_tickets._EndDate + "</li>"; } htmltag += "<li><a class='btn btn-primary animated bounceIn' href ='PurchaseTicket.aspx?VVT_ID=" + VVIP_tickets._TicketID + "&E_ID=" + request + "'>Buy VVIP Ticket</a></li><hr/>"; } ticketInfo.InnerHtml = htmltag; //check if ticket entrance is for free if (EB_tickets == null && REG_tickets == null && VIP_tickets == null && VVIP_tickets == null) { AttendEvent.Visible = true; } else { AttendEvent.Visible = false; } htmltag = ""; //clean string products = psc.getProductByEventID(request); int PC = products.Count(); int count = 1; if (products != null) { if (PC != 0) { htmltag = "<span class='title'>Products Sold</span>"; // ProductsHeading.InnerHtml = htmltag; htmltag = ""; } foreach (EventProduct ep in products) { htmltag += "<li><span class='title'>" + count + ". " + ep._Name + "</span>Price: R" + ep._Price + "</li>"; count++; } Products.InnerHtml = htmltag; } }