private bool InsertTripDataFromApi(int tripId)
{
//Webservice to fetch data related to trip this tripId
apiUri = string.Format("{0}/{1}", "trips", tripId);
var tripObject = new KTApi <TripDto>().Get(apiUri);
if (tripObject == null)
{
return(false);
}
//Insert to db object
var tripService = new TripServices()
{
Id = tripObject.TripId,
Name = tripObject.TripName,
ItineraryId = Convert.ToInt32(tripObject.SystemOfRecordId.Replace("KT:IT-", "")),
RefNum = tripObject.TripReference,
StartDate = tripObject.TripStartDate,
NoOfDays = tripObject.NumberOfDays,
NoOfPeople = tripObject.NumberOfPeople,
GroupName = tripObject.GroupName,
ImageSrc = "",
IsArchived = 0
};
//Initialize db
var ktdb = new KT.DAL.KTdb();
//insert trip
var insertCount = ktdb.Insert(tripService);
return(true);
}
public ItineraryDays[] GetItineraryDays(int itineraryId)
{
var itineraryDays = new List <ItineraryDays>();
//validation
if (itineraryId <= 0)
{
throw new ArgumentException("Provide a valid ItineraryId.");
}
//If this id already exists in db return from db
var ktdb = new KT.DAL.KTdb();
var itinIdExists = ktdb.ExecuteScalar <int>("select count(ItineraryId) from ItineraryDays where ItineraryId = ?", itineraryId);
if (itinIdExists > 0)
{
return(ktdb.Table <ItineraryDays>().Where(x => x.ItineraryId == itineraryId).ToArray());
}
//hit api to fetch itineraryDays
apiUri = string.Format("{0}/{1}/{2}", "itineraries", itineraryId, "days");
var itineraryDayList = new KTApi <List <ItineraryDays> >().Get(apiUri);
if (itineraryDayList != null && itineraryDayList.Count > 0)
{
//hit api to fetch ItineraryService Data
apiUri = string.Format("itineraries/itineraryId/itineraryservices?itineraryid={0}&request.itineraryId={0}&request.includeServiceDescriptions=true", itineraryId);
var itinServiceDto = new KTApi <List <ItineraryServiceDto> >().Get(apiUri);
//insert each object to db
foreach (var dayObj in itineraryDayList)
{
if (dayObj.Day == null)
{
continue;
}
var day = new ItineraryDays()
{
ItineraryDayId = dayObj.ItineraryDayId,
Day = dayObj.Day,
Deleted = dayObj.Deleted,
ItineraryId = dayObj.ItineraryId,
Notes = dayObj.Notes,
ItineraryDayDate = dayObj.ItineraryDayDate,
IsCustomDescription = dayObj.IsCustomDescription,
PictureId = dayObj.PictureId,
};
//Save ItineraryDayDesc
var itinDayDesc = GetItineraryService(itinServiceDto.FirstOrDefault(x => x.ItineraryDayId == dayObj.ItineraryDayId && x.ItineraryId == dayObj.ItineraryId));
var insertCount = ktdb.Insert(itinDayDesc);
day.Summary = (itinDayDesc.SourceName == itinDayDesc.DestName ? itinDayDesc.SourceName : itinDayDesc.SourceName + "|" + itinDayDesc.DestName); //Save ItineraryDays
insertCount = ktdb.Insert(day);
itineraryDays.Add(day);
}
}
return(itineraryDays.ToArray());
}
public TripServices GetItinerary(string tripRefNumber)
{
//validate triprefnumber for '-' or emptystring
if (string.IsNullOrWhiteSpace(tripRefNumber))
{
throw new ArgumentException("TripRefNumber cannot be empty");
}
if (!tripRefNumber.Contains("-"))
{
throw new ArgumentException("Provider a valid trip ref number Ex.Wil5T-000100 ");
}
var tripId = tripRefNumber.Split('-')[1];
//Initialize db
var ktdb = new KT.DAL.KTdb();
//Check if this TripId is already in db then return from db
var tripIdInt = Convert.ToInt32(tripId);
var tripServiceId = ktdb.ExecuteScalar <int>("select Id from TripServices where Id = ?", tripIdInt);
//return from db if pk is already exists
if (tripServiceId > 0)
{
return(ktdb.Get <TripServices>(x => x.Id == tripIdInt));
}
//Call webservice to fetch data related to trip this tripId
apiUri = string.Format("{0}/{1}", "trips", tripId);
var tripObject = new KTApi <TripDto>().Get(apiUri);
//Insert to db object
var tripService = new TripServices()
{
Id = tripObject.TripId,
Name = tripObject.TripName,
ItineraryId = Convert.ToInt32(tripObject.SystemOfRecordId.Replace("KT:IT-", "")),
RefNum = tripObject.TripReference,
StartDate = tripObject.TripStartDate,
NoOfDays = tripObject.NumberOfDays,
NoOfPeople = tripObject.NumberOfPeople,
GroupName = tripObject.GroupName,
ImageSrc = "",
IsArchived = 0
};
//insert to db
var insertCount = ktdb.Insert(tripService);
return(tripService);
}
public TripImportStatus AddItinerary(string tripRefNumber)
{
//validate triprefnumber for '-' or emptystring
if (string.IsNullOrWhiteSpace(tripRefNumber))
{
throw new ArgumentException("TripRefNumber cannot be empty");
}
if (!tripRefNumber.Contains("-"))
{
throw new ArgumentException("Provider a valid trip ref number Ex.Wil5T-000100 ");
}
var tripId = tripRefNumber.Split('-')[1];
//Check if this TripId is already in db then return from db
var tripIdInt = Convert.ToInt32(tripId);
var ktdb = new DAL.KTdb();
var tripServiceId = ktdb.ExecuteScalar <int>("select Id from TripServices where Id = ?", tripIdInt);
//Add
if (tripServiceId == 0)
{
var apiResponse = InsertTripDataFromApi(tripIdInt);
if (!apiResponse)
{
return(TripImportStatus.Error);
}
//get itineraryId
var itinId = ktdb.ExecuteScalar <int>("select ItineraryId from TripServices where Id = ?", tripIdInt);
GetItineraryDays(itinId);
return(TripImportStatus.Add);
}
//return from db if pk is already exists
if (tripServiceId > 0)
{
//save itineraryId
var itinId = ktdb.ExecuteScalar <int>("select ItineraryId from TripServices where Id = ?", tripIdInt);
//Webservice to fetch data related to trip this tripId
apiUri = string.Format("{0}/{1}", "trips", tripIdInt);
var tripApiResponseObject = new KTApi <TripDto>().Get(apiUri);
if (tripApiResponseObject == null)
{
return(TripImportStatus.Error);
}
//IF api response is GOOD, then delete data for this trip
ktdb.Table <ItineraryDayDesc>().Delete(x => x.ItineraryId == itinId);
ktdb.Table <ItineraryDays>().Delete(x => x.ItineraryId == itinId);
ktdb.Table <TripServices>().Delete(x => x.Id == tripServiceId);
//Insert new record in DB
var apiResponse = InsertTripDataFromApi(tripApiResponseObject);
if (!apiResponse)
{
return(TripImportStatus.Error);
}
//Retreive from Db, with latest updates
GetItineraryDays(itinId);
//update as status
return(TripImportStatus.Update);
}
return(TripImportStatus.Error);
}
public ItineraryDayDto[] GetItineraryDays(int itineraryId)
{
var itineraryDays = new List <ItineraryDayDto>();
//validation
if (itineraryId <= 0)
{
throw new ArgumentException("Provide a valid ItineraryId.");
}
//If this id already exists in db return from db
var ktdb = new KT.DAL.KTdb();
var itinIdExists = ktdb.ExecuteScalar <int>("select count(ItineraryId) from ItineraryDays where ItineraryId = ?", itineraryId);
if (itinIdExists > 0)
{
var itinDays = ktdb.Table <ItineraryDays>().Where(x => x.ItineraryId == itineraryId).ToArray();
foreach (var dayObj in itinDays)
{
var dayDto = new ItineraryDayDto()
{
ItineraryDayId = dayObj.ItineraryDayId,
Day = dayObj.Day,
Deleted = dayObj.Deleted,
ItineraryId = dayObj.ItineraryId,
Notes = dayObj.Notes,
ItineraryDayDate = dayObj.ItineraryDayDate,
IsCustomDescription = dayObj.IsCustomDescription,
PictureId = dayObj.PictureId,
Summary = dayObj.Summary,
Highlights = GetItineraryDayHighlights(itineraryId, dayObj.ItineraryDayId)
};
itineraryDays.Add(dayDto);
}
return(itineraryDays.ToArray());
}
//hit api to fetch itineraryDays
apiUri = string.Format("{0}/{1}/{2}", "itineraries", itineraryId, "days");
var itineraryDayList = new KTApi <List <ItineraryDays> >().Get(apiUri);
if (itineraryDayList != null && itineraryDayList.Count > 0)
{
//hit api to fetch ItineraryService Data
apiUri = string.Format("itineraries/itineraryId/itineraryservices?itineraryid={0}&request.itineraryId={0}&request.includeServiceDescriptions=true", itineraryId);
var itinServiceDto = new KTApi <List <ItineraryServiceDto> >().Get(apiUri);
//insert each object to db
foreach (var dayObj in itineraryDayList)
{
if (dayObj.Day == null)
{
continue;
}
var day = new ItineraryDays()
{
ItineraryDayId = dayObj.ItineraryDayId,
Day = dayObj.Day,
Deleted = dayObj.Deleted,
ItineraryId = dayObj.ItineraryId,
Notes = dayObj.Notes,
ItineraryDayDate = dayObj.ItineraryDayDate,
IsCustomDescription = dayObj.IsCustomDescription,
PictureId = dayObj.PictureId,
};
//Save ItineraryDayDesc
var itinDayDesc = GetItineraryService(itineraryId, itinServiceDto.Where(x => x.ItineraryDayId == dayObj.ItineraryDayId && x.ItineraryId == dayObj.ItineraryId).ToList());
var insertCount = ktdb.InsertAll(itinDayDesc);
//find source and destination to update in ItineraryDay table
List <string> srcDest = new List <string>();
foreach (var dayDesc in itinDayDesc)
{
if (!string.IsNullOrEmpty(dayDesc.SourceName) && dayDesc.SourceName != "Global Location")
{
if (!srcDest.Contains(dayDesc.SourceName))
{
srcDest.Add(dayDesc.SourceName);
}
}
if (!string.IsNullOrEmpty(dayDesc.DestName) && dayDesc.DestName != "Global Location")
{
if (!srcDest.Contains(dayDesc.DestName))
{
srcDest.Add(dayDesc.DestName);
}
}
}
day.Summary = string.Join("|", srcDest);
insertCount = ktdb.Insert(day);
itineraryDays.Add(new ItineraryDayDto()
{
ItineraryDayId = day.ItineraryDayId,
Day = day.Day,
Deleted = day.Deleted,
ItineraryId = day.ItineraryId,
Notes = day.Notes,
ItineraryDayDate = day.ItineraryDayDate,
IsCustomDescription = day.IsCustomDescription,
PictureId = day.PictureId,
Summary = day.Summary,
Highlights = GetItineraryDayHighlights(itineraryId, day.ItineraryDayId)
});
}
}
return(itineraryDays.ToArray());
}