コード例 #1
0
        public ActionResult <CarWashVisitDataModel> GetDetails()
        {
            CarWashVisitDatabase  carWashVisitDatabase  = new CarWashVisitDatabase(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "CarWashVisit_DatabaseNew.db3"));
            CarWashVisitDataModel carWashVisitDataModel = new CarWashVisitDataModel();

            carWashVisitDataModel.Code                = 200;
            carWashVisitDataModel.Message             = "successfully exicuted";
            carWashVisitDataModel.Success             = true;
            carWashVisitDataModel.CarwashVisitDetails = new ObservableCollection <CarwashVisitDetails>();

            ObservableCollection <Models.CarwashVisitDetails> ListOfCarwashVisitDetails = carWashVisitDatabase.GetCarwashVisitDetailsAsync();

            foreach (var item in ListOfCarwashVisitDetails)
            {
                CarwashVisitDetails carwashVisitDetails = ClassConverter.CastCarwashVisitDetails <CarwashVisitDetails>(item);
                //carwashVisitDetails.Tasks = new ObservableCollection<TaskDetails>();
                ObservableCollection <Models.TaskDetails> ListOfCarwashTaskDetails = carWashVisitDatabase.GetTaskDetailsAsync();
                foreach (var taskDetails in ListOfCarwashTaskDetails)
                {
                    TaskDetails carwashTaskDetails = ClassConverter.CastTaskDetails <TaskDetails>(taskDetails);
                    if (item.VisitId.ToString() == taskDetails.VisitTaskId)
                    {
                        carwashVisitDetails.Tasks.Add(carwashTaskDetails);
                    }
                }

                carWashVisitDataModel.CarwashVisitDetails.Add(carwashVisitDetails);
            }

            return(carWashVisitDataModel);
        }
コード例 #2
0
 internal int CheckIsExists(CarwashVisitDetails carwashVisit)
 {
     return(_database.Table <CarwashVisitDetails>().Where(array => array.VisitId == carwashVisit.VisitId).CountAsync().Result);
 }
コード例 #3
0
 public Task <int> SaveCarWashDetailsAsync(CarwashVisitDetails carwashVisitDetails)
 {
     return(_database.InsertAsync(carwashVisitDetails));
 }