public string InsertData(DateTime date, double lat, double lng, int carId, float battery) { try { base.Log("Inser Data"); using(var context = new CarCommunicatorEntities()) { CarData data = new CarData(); data.Lat = lat; data.Lng = lng; data.ReceiveDate = date; data.CarInformationId = carId; data.BatteryPercent = battery; context.CarData.Add(data); context.SaveChanges(); return "Success added information"; } } catch(Exception ex) { base.Exception(ex.Message); return ex.Message; } }
private void SaveLogger() { try { using(var context = new CarCommunicator.Common.Data.CarCommunicatorEntities()) { LoggerBase logger = new LoggerBase(); logger.User = this._maker.User; logger.Guid = this._logingActions.ReuqestGuid.ToString(); context.LoggerBase.Add(logger); foreach(var ac in _logingActions.GetActions) { LoggerInformation info = new LoggerInformation(); info.LoggerBase = logger; info.Message = ac.Message; info.MessageType = (int)ac.Type; info.ActionDate = ac.LocalTime; context.LoggerInformation.Add(info); } context.SaveChanges(); } } catch (Exception ex) { } }
public CarCommunicator.Common.ServiceData.CarInfo GetCarInformation(int id) { try { base.Log("GetCarInformation"); using (var context = new CarCommunicatorEntities()) { var carInfo = (from c in context.CarData where c.CarInformation.ID == id && c.Lat.HasValue && c.Lng.HasValue orderby c.ReceiveDate descending select c).FirstOrDefault(); return Common.Adaptors.WcfCarInfo(carInfo); } } catch (Exception ex) { base.Exception(ex.Message); return null; } }