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);
}
private void GenerateDataBase()
{
string fileName = "XF-Test-Json";
string filePath = Path.GetFullPath(fileName);
FileInfo fileInfo = new FileInfo(fileName);
string path = Path.Combine(Environment.CurrentDirectory, @"JsonFile/XF-Test-Json");
string JSONstring = File.ReadAllText(path);
CarWashVisitDataModel carwashVisitDetails = JsonConvert.DeserializeObject <CarWashVisitDataModel>(JSONstring, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
});
GenrateDatabase(carwashVisitDetails);
}
private async void GenrateDatabase(CarWashVisitDataModel carwashvisit)
{
try
{
foreach (var carwashVisitDetails in carwashvisit.CarwashVisitDetails)
{
Models.CarwashVisitDetails carwashVisit = new Models.CarwashVisitDetails
{
VisitId = carwashVisitDetails.VisitId,
HomeBobEmployeeId = carwashVisitDetails.VisitId,
HouseOwnerId = carwashVisitDetails.VisitId,
IsBlocked = carwashVisitDetails.IsBlocked,
StartTimeUtc = carwashVisitDetails.StartTimeUtc,
EndTimeUtc = carwashVisitDetails.EndTimeUtc,
Title = carwashVisitDetails.Title,
IsReviewed = carwashVisitDetails.IsReviewed,
IsFirstVisit = carwashVisitDetails.IsFirstVisit,
IsManual = carwashVisitDetails.IsManual,
VisitTimeUsed = carwashVisitDetails.VisitTimeUsed,
RememberToday = carwashVisitDetails.RememberToday,
HouseOwnerFirstName = carwashVisitDetails.HouseOwnerFirstName,
HouseOwnerLastName = carwashVisitDetails.HouseOwnerLastName,
HouseOwnerMobilePhone = carwashVisitDetails.HouseOwnerMobilePhone,
HouseOwnerAddress = carwashVisitDetails.HouseOwnerAddress,
HouseOwnerZip = carwashVisitDetails.HouseOwnerZip,
HouseOwnerCity = carwashVisitDetails.HouseOwnerCity,
HouseOwnerLatitude = carwashVisitDetails.HouseOwnerLatitude,
HouseOwnerLongitude = carwashVisitDetails.HouseOwnerLongitude,
IsSubscriber = carwashVisitDetails.IsSubscriber,
RememberAlways = carwashVisitDetails.RememberAlways,
Professional = carwashVisitDetails.Professional,
VisitState = carwashVisitDetails.VisitState,
StateOrder = carwashVisitDetails.StateOrder,
ExpectedTime = carwashVisitDetails.ExpectedTime,
};
int IsExists = Database.CheckIsExists(carwashVisit);// .Table<CarwashVisitDetails>().Where(array => array.VisitId == taskDetails.TaskId).CountAsync().Result;
if (IsExists == 0)
{
await Database.SaveCarWashDetailsAsync(carwashVisit);
foreach (var item in carwashVisitDetails.Tasks)
{
await Database.SaveTaskDetailsAsync(new Models.TaskDetails
{
VisitTaskId = carwashVisitDetails.VisitId.ToString(),
TaskId = item.TaskId,
Title = item.Title,
TimesInMinutes = item.TimesInMinutes,
IsTemplate = item.IsTemplate,
Price = item.Price,
PaymentTypeId = item.PaymentTypeId,
PaymentTypes = item.PaymentTypes,
CreateDateUtc = item.CreateDateUtc,
LastUpdateDateUtc = item.LastUpdateDateUtc
});
}
}
}
}
catch (Exception)
{
}
}