public static void SaveBaseVehicleAppData(string connectionString)
{
using (var context = new AutoCareDataContext(connectionString))
{
var appData = context.CKDownloadedVariant.OrderBy(I => I.ProductID).ThenBy(I => I.VariantID).ThenBy(I => I.SubModel).ToList();
foreach (var a in appData)
{
context.CKDownloadedVariant.Attach(a);
var baseVehicleId =
CallService(
$"http://api.coverking.com/getData.asmx/GetSubmodel?Productid={a.ProductID}&Year={a.From_Year}&Make={a.Make_Descr}&Model={a.Model_Descr}",
"//ns:Submodel_table/ns:Basevehicle");
a.BaseVehicleID = baseVehicleId;
if (baseVehicleId != null)
{
var recID =
CallService(
$"http://api.coverking.com/getData.asmx/Get_options_gen?Basevehicle={baseVehicleId}&Productid={a.ProductID}&Submodel=&Customer_IP=223.223.154.114&DealerID=ACG92",
"//ns:ArrayOfOptions/ns:Options/ns:recid");
a.RecID = recID;
context.Entry(a).Property(I => I.RecID).IsModified = true;
}
context.Entry(a).Property(I => I.BaseVehicleID).IsModified = true;
}
context.SaveChanges();
}
}
public static void UpdateOrderStatus(string connectionString, List <order_tracking> trackingList)
{
using (var context = new AutoCareDataContext(connectionString))
{
foreach (var tracking in trackingList)
{
context.Entry(tracking).State = EntityState.Modified;
context.OrderTracking.Attach(entity: tracking);
tracking.processed = 1;
context.Entry(tracking).Property(I => I.processed).IsModified = true;
}
context.SaveChanges();
}
}
public static void SaveProductOnJobber(string connectionString)
{
using (var context = new AutoCareDataContext(connectionString))
{
var products = context.CKProductMaster.ToList();
foreach (var p in products)
{
var jobbers = context.CKDownloadedItem.Where(I => I.ItemID.StartsWith(p.product_id) && I.Product_Family_ID == p.product_family_id).ToList();
if (jobbers.Count > 0)
{
foreach (var jobber in jobbers)
{
context.CKDownloadedItem.Attach(jobber);
jobber.ProductID = p.product_id;
jobber.MaterialID = jobber.ItemID.Replace(p.product_id, "");
context.Entry(jobber).Property(I => I.ProductID).IsModified = true;
context.Entry(jobber).Property(I => I.MaterialID).IsModified = true;
}
}
}
context.SaveChanges();
}
}