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 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 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);
}
}
