public JsonResultEntity Create([FromBody] EventPlaceLocationEntity eventplacelocationEntity) { EventPlaceLocationBL eventplacelocationBL = new EventPlaceLocationBL(); JsonResultEntity response = new JsonResultEntity(); try { var result = eventplacelocationBL.Create(eventplacelocationEntity); if (result.HasWarning()) { response.Message = String.Join(",", result.Warning); return(response); } response.Success = true; response.Data = result.Value; } catch (Exception ex) { response.Message = ex.Message; LoggerHelper.Error(ex); } return(response); }
public EventPlaceLocationEntity Create(EventPlaceLocationEntity eventplacelocationEntity) { var query = @"INSERT INTO ""EventPlaceLocation""(""PlaceID"",""EventID"") VALUES(@PlaceID,@EventID) RETURNING ""ID"";"; int id = DbConnection.Query <int>(query, eventplacelocationEntity).Single(); eventplacelocationEntity.ID = id; return(eventplacelocationEntity); }
public ResultEntity <EventPlaceLocationEntity> Create(EventPlaceLocationEntity eventplacelocationEntity) { var validationResult = new ResultEntity <EventPlaceLocationEntity>(); using (var eventplacelocationDA = new EventPlaceLocationDA()) { validationResult.Value = eventplacelocationDA.Create(eventplacelocationEntity); } return(validationResult); }
public int Update(EventPlaceLocationEntity eventplacelocationEntity) { int affectedRows = 0; if (IsHaveId <EventPlaceLocationEntity>(eventplacelocationEntity) == false) { var query = @"UPDATE ""EventPlaceLocation"" SET ""PlaceID""=@PlaceID,""EventID""=@EventID WHERE ""ID""=@ID"; affectedRows = DbConnection.Execute(query, eventplacelocationEntity); } return(affectedRows); }
public ResultEntity <EventPlaceLocationEntity> Update(EventPlaceLocationEntity eventplacelocationEntity) { var validationResult = new ResultEntity <EventPlaceLocationEntity>(); using (var eventplacelocationDA = new EventPlaceLocationDA()) { var resultUpdate = eventplacelocationDA.Update(eventplacelocationEntity); if (resultUpdate <= 0) { validationResult.Warning.Add("Failed Updating EventPlaceLocation!"); return(validationResult); } validationResult.Value = eventplacelocationEntity; } return(validationResult); }