//return number of tickets remaining for each ticket type //doughnut public List <int> GetTicketCountPerEvent(string EventID) { int _id = Convert.ToInt32(EventID); List <int> data = null; try { data = new List <int>(); using (EventrixDBDataContext db = new EventrixDBDataContext()) { MAIN_EVENT QueryOne = (from count in db.MAIN_EVENTs where count.E_ID == _id select count).First(); if (QueryOne != null) { data.Add(Convert.ToInt32(QueryOne.E_EB_Ticket)); data.Add(Convert.ToInt32(QueryOne.E_RG_Ticket)); data.Add(Convert.ToInt32(QueryOne.E_VIP_Ticket)); data.Add(Convert.ToInt32(QueryOne.E_VVIP_Ticket)); } return(data); } } catch (Exception) { return(null); } }
public EventModel updateEvent(string id, EventModel _event) { using (EventrixDBDataContext db = new EventrixDBDataContext()) { try { // FileUpload fileService = new FileUpload(); var query = (from add in db.MAIN_EVENTs where add.E_ID.Equals(Convert.ToInt32(id)) select add); if (query.Count() == 1) { MAIN_EVENT res = query.Single(); res.E_Name = _event.Name; res.E_Desc = _event.Desc; res.E_Type = _event.Type; res.E_EB_Ticket = _event.EB_Quantity; res.E_RG_Ticket = _event.Reg_Quantity; res.E_VIP_Ticket = _event.VIP_Quantity; res.E_VVIP_Ticket = _event.VVIP_Quantity; res.E_StartDate = Convert.ToDateTime(_event.sDate); res.E_EndDate = Convert.ToDateTime(_event.eDate); res.Category = _event.Category; // res.E_NumProduct = _event.Product_Quantity; db.SubmitChanges(); _event = new EventModel() { EventID = res.E_ID, HostID = Convert.ToInt32(res.EH_ID), Name = res.E_Name, Desc= res.E_Desc, Type = res.E_Type, EB_Quantity = Convert.ToInt32(res.E_EB_Ticket), Reg_Quantity = Convert.ToInt32(res.E_RG_Ticket), VIP_Quantity= Convert.ToInt32(res.E_VIP_Ticket), VVIP_Quantity= Convert.ToInt32(res.E_VVIP_Ticket), sDate = Convert.ToString(res.E_StartDate), eDate= Convert.ToString(res.E_EndDate), Category = res.Category, // ImageLocation = fileService.getImageLocationByEventId(Convert.ToString(id)), }; return _event; } else { return null; } } catch (Exception) { return null; } } }
public int findEventID(EventModel _event) { try { using (EventrixDBDataContext db = new EventrixDBDataContext()) { MAIN_EVENT ev = db.MAIN_EVENTs.Single(_ev => _ev.EH_ID == _event.HostID && _ev.AD_Id == _event.EventAddress && _ev.E_Name.Equals(_event.Name) && _ev.E_Type.Equals(_event.Type)); int EVENTID = ev.E_ID; return EVENTID; }; } catch (Exception) { return 000; } }
public string createEvent(EventModel _event) { using (EventrixDBDataContext dbd = new EventrixDBDataContext()) { try { MAIN_EVENT myevent = new MAIN_EVENT(); myevent.E_Name = _event.Name; myevent.E_Type = _event.Type; myevent.E_Desc = _event.Desc; myevent.EH_ID = _event.HostID; myevent.AD_Id = _event.EventAddress; myevent.E_EB_Ticket = _event.EB_Quantity; myevent.E_RG_Ticket = _event.Reg_Quantity; myevent.E_VIP_Ticket = _event.VIP_Quantity; myevent.E_VVIP_Ticket = _event.VVIP_Quantity; myevent.E_NumProduct = _event.Product_Quantity; myevent.E_StartDate = Convert.ToDateTime(_event.sDate); myevent.E_EndDate = Convert.ToDateTime(_event.eDate); myevent.NumViews = 0; if(_event.Category == null) { myevent.Category = "All"; } else { myevent.Category = _event.Category; } dbd.MAIN_EVENTs.InsertOnSubmit(myevent); dbd.SubmitChanges(); return "success"; } catch(Exception) { return "failed"; } }; }