public void addEvent(int id, string name, string eventtype, float longtitude, float latitude, int peoplecount, string description,string city, string country, string eventname)
{
IEventTypes eventType = certainEvent(eventtype);
try
{
using(ProjektasEntities2 database = new ProjektasEntities2())
{
var event1 = new Event
{
EventId = id,
Name = name,
EventName = eventname,
EventType = eventType.Id,
Longitude = longtitude,
Latitude = latitude,
PeopleCount = peoplecount,
Description = description,
City = city,
Country = country,
};
database.Events.Add(event1);
database.SaveChanges();
}
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
}
public string getEventType(int id)
{
string eventtype = "";
try
{
using (ProjektasEntities2 database = new ProjektasEntities2())
{
var event1 = (from eventtipai in database.EventTypes
where eventtipai.Id == id
select eventtipai).FirstOrDefault();
eventtype = event1.Name;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return eventtype;
}
public void deleteEvent(string name, string eventname, int id)
{
try
{
using (ProjektasEntities2 database = new ProjektasEntities2())
{
var event1 = (from eventai in database.Events
where eventai.EventId == id && eventai.EventName.Equals(eventname) && eventai.Name.Equals(name)
select eventai).FirstOrDefault();
database.Events.Remove(event1);
database.SaveChanges();
}
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
}
public List<Eventas> getCityAllEvents(string city)
{
List<Eventas> ListOfAllEvents = new List<Eventas>();
Eventas event1 = new Eventas();
try
{
using (ProjektasEntities2 database = new ProjektasEntities2())
{
foreach (var getevent1 in database.Events)
{
if (getevent1.City.Equals(city))
{
event1.eventid = getevent1.EventId;
event1.eventname = getevent1.EventName;
event1.EventTypes = certainEvent(getEventType(getevent1.EventType));
event1.latitude = (float)getevent1.Latitude;
event1.longitude = (float)getevent1.Longitude;
event1.name = getevent1.Name;
event1.peoplecount = (int)getevent1.PeopleCount;
event1.city = getevent1.City;
event1.country = getevent1.Country;
event1.description = getevent1.Description;
ListOfAllEvents.Add(event1);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return ListOfAllEvents;
}
public Eventas getEvent(int id)
{
Eventas event1 = new Eventas();
try
{
using (ProjektasEntities2 database = new ProjektasEntities2())
{
var getevent1 = database.Events.First((p) => p.EventId == id);
event1.eventid = getevent1.EventId;
event1.eventname = getevent1.EventName;
event1.EventTypes = certainEvent(getEventType(getevent1.EventType));
event1.latitude = (float)getevent1.Latitude;
event1.longitude = (float)getevent1.Longitude;
event1.name = getevent1.Name;
event1.peoplecount =(int) getevent1.PeopleCount;
event1.city = getevent1.City;
event1.country = getevent1.Country;
event1.description = getevent1.Description;
}
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
return event1;
}
public void updateEvent(int id, string name, string eventtype, float longtitude, float latitude, int peoplecount, string description, string city, string country, string eventname)
{
IEventTypes eventType = certainEvent(eventtype);
try
{
using (ProjektasEntities2 database = new ProjektasEntities2())
{
var event1 = database.Events.SingleOrDefault(b => b.EventId == id);
if (event1 != null)
{
if (name != "")
event1.Name = name;
if (eventtype != "")
event1.EventType = eventType.Id;
if (longtitude != 1000)
event1.Longitude = longtitude;
if (latitude != 1000)
event1.Latitude = latitude;
if (peoplecount != -1)
event1.PeopleCount = peoplecount;
if (description != "")
event1.Description = description;
if (city != "")
event1.City = city;
if (country != "")
event1.Country = country;
if (eventname != "")
event1.EventName = eventname;
database.SaveChanges();
}
}
}
catch(Exception e)
{
Console.WriteLine(e.Message);
}
}
