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 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));
}
InsertTripDataFromApi(tripIdInt);
return(ktdb.Get <TripServices>(x => x.Id == tripIdInt));
}
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 List <int> GetItineraryDaysList(int itineraryId)
{
//fetch and return from db
var ktdb = new KT.DAL.KTdb();
//var itinIdExists = ktdb.ExecuteScalar<int>("select DayNumber from ItineraryDayDesc where ItineraryId = ?", itineraryId);
var result = ktdb.Table <ItineraryDayDesc>().Where(x => x.ItineraryId == itineraryId).Select(func => func.DayNumber).ToList();
return(result);
}
public Itinerary()
{
//KT db instance
var ktdb = new KT.DAL.KTdb();
//below CreateTable creates table if not exists - any model changes - it alters the table to new model structure
ktdb.CreateTable <TripServices>();
ktdb.CreateTable <ItineraryDays>();
ktdb.CreateTable <ItineraryDayDesc>();
}
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);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <TripServices> GetItineraryList()
{
//fetch and return from db
var ktdb = new KT.DAL.KTdb();
var itinIdExists = ktdb.ExecuteScalar <int>("select count(1) from TripServices");
if (itinIdExists > 0)
{
return(ktdb.Table <TripServices>().ToList());
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="itineraryDayId"></param>
/// <returns></returns>
public ItineraryDayDescDto GetItineraryPreviousDay(int itineraryDayId, int itineraryId, int dayNum)
{
var ktdb = new KT.DAL.KTdb();
var itinIdExists = ktdb.ExecuteScalar <int>("select count(1) from ItineraryDayDesc where ItineraryDayId = ?", itineraryDayId);
if (itinIdExists > 0)
{
var result = ktdb.Table <ItineraryDayDesc>().Where(x => x.ItineraryId == itineraryId && x.ItineraryDayId < itineraryDayId && x.DayNumber < dayNum).OrderByDescending(func => func.DayNumber).FirstOrDefault();
if (result != null)
{
return(GetItineraryDayDesc(result.ItineraryDayId));
}
}
return(null);
}
public ItineraryDayDesc GetItineraryDayDesc(int itineraryDayId)
{
//validation
if (itineraryDayId < 0)
{
throw new ArgumentException("Provide a valid ItineraryDayId.");
}
//fetch and return from db
var ktdb = new KT.DAL.KTdb();
var itinIdExists = ktdb.ExecuteScalar <int>("select count(1) from ItineraryDayDesc where ItineraryDayId = ?", itineraryDayId);
if (itinIdExists > 0)
{
return(ktdb.Get <ItineraryDayDesc>(x => x.ItineraryDayId == itineraryDayId));
}
return(null);
}
private bool InsertTripDataFromApi(TripDto tripApiResponseObject)
{
//Insert to db object
var tripService = new TripServices()
{
Id = tripApiResponseObject.TripId,
Name = tripApiResponseObject.TripName,
ItineraryId = Convert.ToInt32(tripApiResponseObject.SystemOfRecordId.Replace("KT:IT-", "")),
RefNum = tripApiResponseObject.TripReference,
StartDate = tripApiResponseObject.TripStartDate,
NoOfDays = tripApiResponseObject.NumberOfDays,
NoOfPeople = tripApiResponseObject.NumberOfPeople,
GroupName = tripApiResponseObject.GroupName,
ImageSrc = "",
IsArchived = 0
};
//Initialize db
var ktdb = new KT.DAL.KTdb();
//insert trip
var insertCount = ktdb.Insert(tripService);
return(true);
}
/// <summary>
///
/// </summary>
/// <param name="itineraryDayId"></param>
/// <returns></returns>
public ItineraryDayDescDto GetItineraryDayDesc(int itineraryDayId)
{
var dayDescDto = new ItineraryDayDescDto();
//validation
if (itineraryDayId < 0)
{
throw new ArgumentException("Provide a valid ItineraryDayId.");
}
//fetch and return from db
var ktdb = new KT.DAL.KTdb();
var itinIdExists = ktdb.ExecuteScalar <int>("select count(1) from ItineraryDayDesc where ItineraryDayId = ?", itineraryDayId);
if (itinIdExists > 0)
{
var dayDescList = ktdb.Table <ItineraryDayDesc>().Where(x => x.ItineraryDayId == itineraryDayId).OrderBy(y => y.TimeOfDayId).ThenBy(z => z.DisplayOrder).ToList();
var summaryDescList = new List <SummaryDto>();
//find source and destination to update in ItineraryDay table
List <string> srcDest = new List <string>();
foreach (var dayDesc in dayDescList)
{
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);
}
}
var summayDesc = new SummaryDto()
{
Name = dayDesc.CustomDisplayName,
Description = dayDesc.Description
};
summaryDescList.Add(summayDesc);
}
var day = dayDescList.FirstOrDefault();
dayDescDto = new ItineraryDayDescDto()
{
Id = day.Id,
TripStartDate = day.TripStartDate,
ItineraryDayId = day.ItineraryDayId,
ItineraryId = day.ItineraryId,
LocationName = string.Join("-", srcDest),
DayNumber = day.DayNumber,
Summary = summaryDescList
};
}
return(dayDescDto);
}
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());
}
