private void GetOmgLiveResult(string searchString, string MID, string minPrice, string MaxPrice)
{
string dateSignData = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.fff");
string encryptedSignature = clsUtility.EncryptString(dateSignData, "98e2106077d34d2c900cdd7c7121906e");
string url = "http://api.omgpm.com/network/OMGNetworkApi.svc/v1.1/ProductFeeds/GetProducts?AgencyID=95&AID=764019&MID=" + MID + "&Keyword=" + searchString + "&MinPrice=" + minPrice + "&MaxPrice=" + MaxPrice + "&Currency=INR&DiscountedOnly=false&ProductSKU=&Key=0e1a4b99-8aa0-43e7-81d7-22dd4e0f6786&Sig=" + Server.UrlEncode(encryptedSignature) + "&SigData=" + dateSignData;
//if (SearchLiveData == null)
//SearchLiveData = clsOMGProductFeedList.ProductJsonList(url).ToList();
var p = (from i in clsOMGProductFeedList.ProductJsonList(url)
// where i.CategoryName.Contains("Mobile Phones") || i.CategoryName.Contains("Mobiles")
select i).ToList();
foreach (clsOMGProductFeed pFeed in p)
{
Tbl_ItemsDetails_More item = new Tbl_ItemsDetails_More();
item.DiscountedPrice = pFeed.DiscountedPrice;
item.MerchantID = pFeed.MID;
item.MerchantName = pFeed.MerchantDomain;
item.MerchantProductID = pFeed.ProductSKU;
item.NavigationURL = pFeed.ProductURL;
item.ProductPrice = pFeed.ProductPrice;
item.Title = pFeed.ProductName;
clsAddItems.AddMasterItemDetails_MOre(item);
}
//AddMasterItemDetails_MOre
}
public static void AddMasterItemDetails_MOre(Tbl_ItemsDetails_More items)
{
using (cos_OtherEntities model = new cos_OtherEntities())
{
Tbl_ItemsDetails_More item = new Tbl_ItemsDetails_More();
var original = model.Tbl_ItemsDetails_Mores.Where(c => c.MerchantID == items.MerchantID && c.MerchantProductID == items.MerchantProductID).SingleOrDefault();
if (original == null)
{
item.Availability = items.Availability;
item.Brand = items.Brand;
item.Color = items.Color;
item.Custom1 = items.Custom1;
item.Custom2 = items.Custom2;
item.Custom3 = items.Custom3;
item.Description = items.Description;
item.DiscountedPrice = items.DiscountedPrice;
item.ImageUrl = items.ImageUrl;
item.Location = items.Location;
item.MerchantID = items.MerchantID;
item.MerchantName = items.MerchantName;
item.MerchantProductID = items.MerchantProductID;
item.NavigationURL = items.NavigationURL;
item.ProductID = items.ProductID;
item.ProductPrice = items.ProductPrice;
item.ProductPriceCurrency = items.ProductPriceCurrency;
item.SKUID = items.SKUID;
item.Title = items.Title;
model.AddToTbl_ItemsDetails_Mores(item);
model.SaveChanges();
}
else
{
if (original.ProductPrice < item.ProductPrice || original.DiscountedPrice < item.DiscountedPrice)
{
original.ProductPrice = items.ProductPrice;
original.DiscountedPrice = items.DiscountedPrice;
model.SaveChanges();
model.Dispose();
}
}
}
}
