public static void ExportProductUpdate(String productCode)
{
String ConnStr = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Persist Security Info=True", Settings.GetValue("FinalTable"));
InProduct product = new InProduct();
product.Code = productCode;
var secLockProduct = new InProductManager(Constants.ConnectionString).GetData(product);
if (secLockProduct.Count() == 0)
{
return;
}
product = secLockProduct[0];
FinalTable ft = new FinalTable();
ft.SLD_SOURCE_ID = String.Empty;
ft.SLD_COST = product.YourPrice;
ft.SLD_PART = product.Code;
ft.SLD_IMG1 = product.ImageUrl1;
ft.SLD_IMG2 = product.ImageUrl2;
ft.SLD_VENDOR = product.ManufacturerName;
ft.SLD_INV = product.Stock;
ft.SLD_LastUpdate = DateTime.Now.ToString(Settings.GetValue("DateFormat"));
new FinalTableManager(ConnStr).SaveProduct(ft);
}
public int SaveAdiPart(FinalTable finalTable)
{
return(SaveAdiPart(finalTable.ID, finalTable.UPC, finalTable.VDR_PART, finalTable.VDR_IT_DSC
, finalTable.Image_Folder, finalTable.ADI_SOURCE_ID, finalTable.ADI_PART, finalTable.ADI_COST == null ? 0 : (decimal)finalTable.ADI_COST
, finalTable.ADI_IMG1, finalTable.ADI_IMG2, finalTable.ADI_VENDOR, finalTable.ADI_INV
, finalTable.ADI_LastUpdate));
}
private int Insert(FinalTable finalTable)
{
String Query = "INSERT INTO [Final_Table] ([SLD_SOURCE_ID], [SLD_COST], [SLD_PART], [SLD_IMG1], [SLD_IMG2], [SLD_VENDOR], [SLD_INV], [SLD_DESC], [SLD_TECHDOC], [SLD_LastUpdate])"
+ "VALUES ('" + finalTable.SLD_SOURCE_ID + "'," + finalTable.SLD_COST + " , '" + finalTable.SLD_PART + "', '"
+ finalTable.SLD_IMG1 + "', '" + finalTable.SLD_IMG2 + "', '" + finalTable.SLD_VENDOR + "', '"
+ finalTable.SLD_INV + "', '" + finalTable.SLD_DESC + "', '" + finalTable.SLD_TECHDOC + "', '" + finalTable.SLD_LastUpdate + "')";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return(oDm.RunActionQuery());
}
public int SaveProduct(FinalTable finalTable)
{
if (GetData(finalTable.SLD_PART).Count() == 0)
{
return(Insert(finalTable));
}
else
{
return(Update(finalTable));
}
}
private int Update(FinalTable finalTable)
{
String Query = "UPDATE [Final_Table] SET [SLD_SOURCE_ID] = '" + finalTable.SLD_SOURCE_ID
+ "', [SLD_COST] = " + finalTable.SLD_COST
+ ", [SLD_IMG1] = '" + finalTable.SLD_IMG1
+ "', [SLD_IMG2] = '" + finalTable.SLD_IMG2
+ "', [SLD_VENDOR] = '" + finalTable.SLD_VENDOR
+ "', [SLD_INV] = '" + finalTable.SLD_INV
+ "', [SLD_DESC] = '" + finalTable.SLD_DESC
+ "', [SLD_TECHDOC] = '" + finalTable.SLD_TECHDOC
+ "', [SLD_LastUpdate] = '" + finalTable.SLD_LastUpdate
+ "' WHERE [SLD_PART] = '" + finalTable.SLD_PART
+ "'";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return(oDm.RunActionQuery());
}
