//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";
}
};
}
