public Result <object> DeleteEvent(EventDataContract evnt) { var result = new Result <object>(); try { if (evnt == null) { throw new Exception("Событие не задано"); } using (var ctx = new PolicyProjectEntities()) { var delEvent = ctx.tbl_event.FirstOrDefault(x => x.id == evnt.EventId); ctx.tbl_event.Remove(delEvent); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления события. ", ex.Message); } return(result); }
public static tbl_event FromEventDataContractToTblEvent(EventDataContract eventData) { if (eventData.EventId < 1 || string.IsNullOrEmpty(eventData.EventName)) { return(null); } return(new tbl_event { id = eventData.EventId, event_name = eventData.EventName }); }
public Result <EventDataContract[]> GetEvent(EventDataContract eventFilter) { var result = new Result <EventDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (eventFilter == null) { result.SomeResult = ctx.tbl_event.Select( eventTblData => new EventDataContract { EventId = eventTblData.id, EventName = eventTblData.event_name }).ToArray(); } else { result.SomeResult = ctx.tbl_event.Where(x => x.id == eventFilter.EventId) .Select(eventTblData => new EventDataContract { EventId = eventTblData.id, EventName = eventTblData.event_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка событий. ", ex.Message); } return(result); }
public static bool Compare(EventDataContract obj1, EventDataContract obj2) { if (obj1 == null && obj2 == null) { return(true); } if (obj1 == null && obj2 != null) { return(false); } if (obj1 != null && obj2 == null) { return(false); } return(obj1.EventId == obj2.EventId && string.Equals(obj1.EventName.Trim(), obj2.EventName.Trim(), StringComparison.CurrentCultureIgnoreCase)); }
public Result <object> AddEvent(EventDataContract evnt) { var result = new Result <object>(); try { if (evnt == null) { throw new Exception("Новое событие не задано"); } using (var ctx = new PolicyProjectEntities()) { var selected = ctx.tbl_event.FirstOrDefault( x => x.event_name.Trim() .Equals(evnt.EventName.Trim(), StringComparison.InvariantCultureIgnoreCase)); if (selected != null) { throw new Exception("Событие уже существует"); } evnt.EventId = ctx.tbl_event.Any() ? ctx.tbl_event.Max(x => x.id) + 1 : 1; var newEvent = EventDataContract.FromEventDataContractToTblEvent(evnt); ctx.tbl_event.Add(newEvent); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка добавления события. ", ex.Message); } return(result); }
public Result <object> UpdateEvent(EventDataContract oldEvent, EventDataContract newEvent) { var result = new Result <object>(); try { if (oldEvent == null) { throw new Exception("Текущее событие не задано"); } if (newEvent == null) { throw new Exception("Новое событие не задано"); } using (var ctx = new PolicyProjectEntities()) { var selected = ctx.tbl_event.FirstOrDefault(x => x.id == oldEvent.EventId); if (selected == null) { throw new Exception("Текущее событие не найдено"); } selected.event_name = newEvent.EventName; result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка изменения события. ", ex.Message); } return(result); }
public string GetEventRest(EventDataContract eventFilter) { var queryResult = GetEvent(eventFilter); return(JsonConvert.SerializeObject(queryResult)); }