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