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 UpdateProduct(ConfigurationData config, int qbId, string sku)
{
using (var context = new AutoCareDataContext(config.ConnectionString))
{
context.Database.ExecuteSqlCommand(
$"UPDATE `3dc_products` SET qb_product_id = {qbId} WHERE SKU = '{sku}'");
context.SaveChanges();
}
}
public static void UpdateCustomer(ConfigurationData config, int qbId, long customerId)
{
using (var context = new AutoCareDataContext(config.ConnectionString))
{
context.Database.ExecuteSqlCommand(
$"UPDATE customers SET qb_customer_id = {qbId} WHERE customer_id = {customerId}");
context.SaveChanges();
}
}
public static void SaveJFWOrders(string connectionString, List <jfw_orders> orders, string filename)
{
using (var context = new AutoCareDataContext(connectionString))
{
foreach (var order in orders)
{
Console.WriteLine(string.Format(" Storing JFW PO to JFW table {0} ", order.PO));
order.Filename = filename;
context.JFWOrders.Add(order);
}
context.SaveChanges();
}
}
private static void AddProducts(string connectionString, List <Product> products)
{
List <products> productDB = GetProducts(products);
using (var context = new AutoCareDataContext(connectionString))
{
foreach (var prod in productDB)
{
context.Products.AddOrUpdate(prod);
}
context.SaveChanges();
}
}
public static void Save(string connectionString, IEnumerable <IEnumerable <AmazonVariant> > amazonVariants)
{
using (var context = new AutoCareDataContext(connectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
context.Database.ExecuteSqlCommand("TRUNCATE ck_amazon_variant;");
foreach (var item in amazonVariants)
{
var groupItem = item.GroupBy(i => i.ASIN).Select(j => j.First()).ToList();
context.CKAmazonVariant.AddRange(groupItem);
context.SaveChanges();
}
context.Configuration.AutoDetectChangesEnabled = true;
context.Configuration.ValidateOnSaveEnabled = true;
var data = context.Database.SqlQuery <string>(
"SELECT ASIN FROM car.ck_temp_amazon_variant GROUP BY ASIN HAVING COUNT(1) >1").ToList();
if (data.Count > 0)
{
foreach (var d in data)
{
var dupObjs = context.CKAmazonVariant.Where(I => I.ASIN == d).ToList();
foreach (var dup in dupObjs)
{
var item = context.CKDownloadedItem.FirstOrDefault(I => I.ItemID == dup.NavItem);
if (item == null)
{
context.CKAmazonVariant.Remove(dup);
}
}
//context.CKAmazonVariant.Remove()
}
}
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 Save(string connectionString, IEnumerable <IEnumerable <DownloadVariant> > downloadedVariant)
{
using (var context = new AutoCareDataContext(connectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
context.Database.ExecuteSqlCommand("TRUNCATE ck_app_data;");
foreach (var items in downloadedVariant)
{
context.CKDownloadedVariant.AddRange(items);
}
context.SaveChanges();
context.Configuration.AutoDetectChangesEnabled = true;
context.Configuration.ValidateOnSaveEnabled = true;
}
}
public static void AddCustomers(string connectionString, List <Customer> customers, List <CustomerGroup> customerGroups)
{
var customerAndGroup = GetCustomers(customers, customerGroups);
var customerDB = customerAndGroup.Item1;
var customerGroupDB = customerAndGroup.Item2;
using (var context = new AutoCareDataContext(connectionString))
{
foreach (var cust in customerDB)
{
context.Customers.AddOrUpdate(cust);
}
foreach (var custGrp in customerGroupDB)
{
context.CustomerGroups.AddOrUpdate(custGrp);
}
context.SaveChanges();
}
}
public static void SaveCKVariant(string connectionString, List <TempCKVariant> variants)
{
var group_variant = variants.GroupBy(i => i.SKU).Select(j => j.First()).ToList();
using (var context = new AutoCareDataContext(connectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
foreach (var ck_var in group_variant)
{
var this_set = context.TempCKVariants.FirstOrDefault(i => i.SKU == ck_var.SKU);
if (this_set == null)
{
context.TempCKVariants.AddOrUpdate(ck_var);
}
}
context.SaveChanges();
context.Configuration.AutoDetectChangesEnabled = true;
context.Configuration.ValidateOnSaveEnabled = true;
}
}
public static void SaveOrderTracking(string connectionString, List <order_tracking> trackings)
{
DateTime thisDateMinus2 = DateTime.Now.AddDays(-20);
StringBuilder sb = new StringBuilder("");
using (var context = new AutoCareDataContext(connectionString))
{
context.Configuration.AutoDetectChangesEnabled = false;
context.Configuration.ValidateOnSaveEnabled = false;
var query = trackings.GroupBy(x => x.tracking_no)
.Select(y => y.FirstOrDefault());
foreach (var tracking in query)
{
var existingEntry =
context.OrderTracking.FirstOrDefault(I => I.po_no == tracking.po_no &&
I.tracking_no == tracking.tracking_no && I.SKU == tracking.SKU);
// Sam: changed on Sep 20 - only change New tracking entries.
// Sam: Changed on Sep 28 - only update if tracking data is within last 2 days
/*if (existingEntry != null)
* {
* tracking.processed = existingEntry.processed;
* }
* context.OrderTracking.AddOrUpdate(tracking);
*/
if (existingEntry == null && tracking.ship_date >= thisDateMinus2)
{
// context.OrderTracking.AddOrUpdate(tracking);
sb.AppendLine(string.Format("INSERT INTO `order_tracking` (`po_no`,`order_no`,`order_date`,`SKU`,`ship_address`,`ship_date`,`tracking_no`,`ship_agent`,`ship_service`,`processed`) values (" +
"'{0}','{1}','{2} 00:00:00','{3}','{4}','{5} 00:00:00','{6}','{7}','{8}',0);", tracking.po_no, tracking.order_no, tracking.order_date.ToString("yyyy-MM-dd"), tracking.SKU,
tracking.ship_address, tracking.ship_date.ToString("yyyy-MM-dd"), tracking.tracking_no, tracking.ship_agent, tracking.ship_service));
}
}
context.SaveChanges();
context.Configuration.AutoDetectChangesEnabled = true;
context.Configuration.ValidateOnSaveEnabled = true;
}
}
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();
}
}
