public static CountryShippingMethod GetCountryShippingMethodByCountry(string Country)
{
CountryShippingMethod country = null;
using (var db = new LiteDatabase(AppKeys.GetDataContextString()))
{
var countries = db.GetCollection <CountryShippingMethod>("countries");
country = countries.Find(x => x.Country == Country).FirstOrDefault();
}
return(country);
}
/// <summary>
/// Returns true if new CountryShippingMethod is created. Returns false if CountryShippingMethod with Country is found
/// </summary>
/// <param name="ClientID"></param>
/// <param name="ClientName"></param>
/// <returns></returns>
public static bool CreateCountyShippingMethod(string Country, string ShippingMethod)
{
using (var db = new LiteDatabase(AppKeys.GetDataContextString()))
{
var countries = db.GetCollection <CountryShippingMethod>("countries");
var newcountry = countries.Find(x => x.Country == Country).FirstOrDefault();
if (newcountry == null)
{
newcountry = new CountryShippingMethod();
newcountry.Country = Country;
newcountry.Shipping_Method = ShippingMethod;
countries.Insert(newcountry);
countries.EnsureIndex(x => x.Country);
return(true);
}
}
return(false);
}
