public FrayteCountry GetCountryDetail(int countryId)
{
FrayteCountry frayteCountry = new FrayteCountry();
var country = dbContext.Countries.Where(p => p.CountryId == countryId).FirstOrDefault();
if (country != null)
{
var countryDocument = dbContext.CountryDocuments.Where(p => p.CountryId == countryId).ToList();
//To Dos: Need to add public holiday information here
var countryPublicHoliday = new List <FrayteCountryPublicHoliday>();
frayteCountry.Air = countryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Air).ToList().Count > 0 ? true : false;
frayteCountry.Courier = countryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Courier).ToList().Count > 0 ? true : false;
frayteCountry.Expryes = countryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Expryes).ToList().Count > 0 ? true : false;
frayteCountry.Sea = countryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Sea).ToList().Count > 0 ? true : false;
frayteCountry.CountryId = country.CountryId;
frayteCountry.Name = country.CountryName;
frayteCountry.Code = country.CountryCode;
frayteCountry.CountryDocuments = new List <CountryDocument>();
frayteCountry.CountryDocuments = countryDocument;
frayteCountry.CountryPublicHolidays = new List <FrayteCountryPublicHoliday>();
frayteCountry.CountryPublicHolidays = GetCountyPublicHolidayList(countryId);
}
return(frayteCountry);
}
public List <FrayteCountry> GetCountryList()
{
var lstCountry = dbContext.Countries.ToList();
var lstCountryDocument = dbContext.CountryDocuments.ToList();
List <FrayteCountry> lstFrayteCountry = new List <FrayteCountry>();
foreach (Country country in lstCountry)
{
FrayteCountry frayteCountry = new FrayteCountry();
frayteCountry.Air = lstCountryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Air).ToList().Count > 0 ? true : false;
frayteCountry.Courier = lstCountryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Courier).ToList().Count > 0 ? true : false;
frayteCountry.Expryes = lstCountryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Expryes).ToList().Count > 0 ? true : false;
frayteCountry.Sea = lstCountryDocument.Where(p => p.CountryId == country.CountryId && p.ShipmentType == FrayteShipmentType.Sea).ToList().Count > 0 ? true : false;
frayteCountry.CountryId = country.CountryId;
frayteCountry.Name = country.CountryName;
frayteCountry.Code = country.CountryCode;
frayteCountry.CountryDocuments = new List <CountryDocument>();
lstFrayteCountry.Add(frayteCountry);
}
return(lstFrayteCountry);
}
public FrayteCountry GetCountryDetail(int countryId)
{
FrayteCountry countryDetail = new FrayteCountry();
countryDetail = new CountryRepository().GetCountryDetail(countryId);
return(countryDetail);
}
public FrayteCountry SaveCountry(FrayteCountry frayteCountry)
{
return(new CountryRepository().SaveCountry(frayteCountry));
}
public FrayteCountry SaveCountry(FrayteCountry frayteCountry)
{
Country saveCountry;
if (frayteCountry.CountryId > 0)
{
saveCountry = dbContext.Countries.Where(p => p.CountryId == frayteCountry.CountryId).FirstOrDefault();
saveCountry.CountryName = frayteCountry.Name;
saveCountry.CountryCode = frayteCountry.Code;
}
else
{
saveCountry = new Country();
saveCountry.CountryName = frayteCountry.Name;
saveCountry.CountryCode = frayteCountry.Code;
dbContext.Countries.Add(saveCountry);
}
dbContext.SaveChanges();
frayteCountry.CountryId = saveCountry.CountryId;
//After saving the country information, we need to save its document information
if (frayteCountry.CountryDocuments != null && frayteCountry.CountryDocuments.Count > 0)
{
foreach (CountryDocument document in frayteCountry.CountryDocuments)
{
CountryDocument saveDocument;
if (document.CountryDocumentId > 0)
{
saveDocument = dbContext.CountryDocuments.Where(p => p.CountryDocumentId == document.CountryDocumentId).FirstOrDefault();
saveDocument.DocumentName = document.DocumentName;
saveDocument.ShipmentType = document.ShipmentType;
}
else
{
saveDocument = new CountryDocument();
saveDocument.CountryId = frayteCountry.CountryId;
saveDocument.DocumentName = document.DocumentName;
saveDocument.ShipmentType = document.ShipmentType;
dbContext.CountryDocuments.Add(saveDocument);
}
dbContext.SaveChanges();
document.CountryDocumentId = saveDocument.CountryDocumentId;
}
}
if (frayteCountry.CountryPublicHolidays != null && frayteCountry.CountryPublicHolidays.Count > 0)
{
foreach (var document in frayteCountry.CountryPublicHolidays)
{
CountryPublicHoliday countrypublicholiday;
if (document.CountryPublicHolidayId > 0)
{
countrypublicholiday = dbContext.CountryPublicHolidays.Where(p => p.CountryPublicHolidayId == document.CountryPublicHolidayId).FirstOrDefault();
countrypublicholiday.CountryId = frayteCountry.CountryId;
countrypublicholiday.Description = document.Description;
countrypublicholiday.PublicHolidayDate = document.PublicHolidayDate;
}
else
{
countrypublicholiday = new CountryPublicHoliday();
countrypublicholiday.CountryId = frayteCountry.CountryId;
countrypublicholiday.Description = document.Description;
countrypublicholiday.PublicHolidayDate = document.PublicHolidayDate;
dbContext.CountryPublicHolidays.Add(countrypublicholiday);
}
dbContext.SaveChanges();
document.CountryPublicHolidayId = countrypublicholiday.CountryPublicHolidayId;
}
}
return(frayteCountry);
}
