Пример #1
0
        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;
            }
        }
Пример #2
0
        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)
            {

            }
        }
Пример #3
0
        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;
            }
        }