public int Delete(String Value) { String Query = "DELETE FROM AdiBrand WHERE Value = @Value"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("Value", 4000, Value); return oDm.RunActionQuery(); }
private int Insert(String ManufacturerCode, InManufacturerSeries manufacturer) { String Query = "INSERT INTO [SecLockManufacturerSeries]([ManufacturerCode],[Name]) VALUES('" + ManufacturerCode + "','" + manufacturer.Name + "');"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public void CreateSchema() { String Query = "CREATE TABLE Final_Table (" + "ID AUTOINCREMENT PRIMARY KEY, " + "UPC TEXT(255), " + "VDR_PART TEXT(255), " + "VDR_IT_DSC TEXT(255), " + "Image_Folder TEXT(255), " + "AID_SOURCE_ID TEXT(255), " + "AID_PART TEXT(255), " + "AID_COST DECIMAL, " + "AID_IMG1 TEXT(255), " + "AID_IMG2 TEXT(255), " + "AID_VENDOR TEXT(255), " + "AID_INV TEXT(255), " + "AID_ClearanceZone BIT" + "AID_HotDeals BIT" + "AID_OnlineSpecials BIT" + "AID_SaleCenter BIT" + "AID_InStock BIT" + "AID_LastUpdate TEXT(255), " + "AID_LeastCount INT, " + "AID_Priority BIT " + ")"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.RunActionQuery(); }
private int Insert(InCategory category) { String Query = "INSERT INTO [SecLockCategory]([Code],[Name]) VALUES('" + category.Code + "','" + category.Name + "');"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
private int Insert(InManufacturer manufacturer) { String Query = "INSERT INTO [SecLockManufacturer]([Code],[Name],[ImagePath],[Url]) VALUES('" + manufacturer.Code + "','" + manufacturer.Name + "','" + manufacturer.ImagePath + "','" + manufacturer.Url + "');"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public int Delete(String PART_NUM) { String Query = "DELETE FROM ADIInventory SET WHERE PART_NUM = \"" + PART_NUM + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); return oDm.RunActionQuery(); }
private int Update(InCategory category) { String Query = "UPDATE [SecLockCategory] SET [Name] = '" + category.Name + "' WHERE [Code] = '" + category.Code + "'"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public int Delete(String AdiNumber) { String Query = "DELETE FROM AdiInventoryDetails WHERE AdiNumber = @AdiNumber"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber); return oDm.RunActionQuery(); }
public int Delete(String PART_NUM, String PropertyName) { String Query = "DELETE FROM AdiChild WHERE PART_NUM = \"" + PART_NUM + "\" AND PropertyName = \"" + PropertyName + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); //oDm.AddVarcharPara("PropertyName", 4000, PropertyName); return oDm.RunActionQuery(); }
private int Update(String ManufacturerCode, InManufacturerSeries manufacturer) { String Query = "UPDATE [SecLockManufacturerSeries] SET [Name] = '" + manufacturer.Name + "',[ManufacturerCode] = '" + ManufacturerCode + "' WHERE [Name] = '" + manufacturer.Name + "'"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
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(); }
private int Update(InManufacturer manufacturer) { String Query = "UPDATE [SecLockManufacturer] SET [Name] = '" + manufacturer.Name + "',[ImagePath] = '" + manufacturer.ImagePath + "', [Url] = '" + manufacturer.Url + "' WHERE [Code] = '" + manufacturer.Code + "'"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public int Insert(String PART_NUM, String PropertyName, String PropertyValue) { String Query = "INSERT INTO AdiChild (PART_NUM, PropertyName, PropertyValue)" + " VALUES (@PART_NUM, @PropertyName, @PropertyValue)"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddVarcharPara("PropertyName", 4000, PropertyName); oDm.AddVarcharPara("PropertyValue", 4000, PropertyValue); return oDm.RunActionQuery(); }
public int Insert(String Value, String DisplayName, bool ClearanceZone, bool SaleCenter, bool OnlineSpecials, bool HotDeals) { String Query = "INSERT INTO AdiBrand ([Value], DisplayName, ClearanceZone, SaleCenter, OnlineSpecials, HotDeals)" + " VALUES (@Value, @DisplayName, @ClearanceZone, @SaleCenter, @OnlineSpecials, @HotDeals)"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("Value", 4000, Value); oDm.AddVarcharPara("DisplayName", 4000, DisplayName); oDm.AddBoolPara("ClearanceZone", ClearanceZone); oDm.AddBoolPara("SaleCenter", SaleCenter); oDm.AddBoolPara("OnlineSpecials", OnlineSpecials); oDm.AddBoolPara("HotDeals", HotDeals); return oDm.RunActionQuery(); }
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(); }
public String GenerateAdiChild() { try { String Query = "CREATE TABLE ADIChild (" + "ID AUTOINCREMENT PRIMARY KEY, " + "PART_NUM TEXT(255), " + "PropertyName TEXT(255), " + "PropertyValue MEMO)"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'ADIChild\' Structure"; } catch (Exception ex) { return ex.Message; } }
public String GenerateAdiBrand() { try { String Query = "CREATE TABLE AdiBrand (" + "[Value] TEXT(255), " + "DisplayName TEXT(255), " + "ClearanceZone BIT, " + "SaleCenter BIT, " + "OnlineSpecials BIT, " + "HotDeals BIT)"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'AdiBrand\' Structure"; } catch (Exception ex) { return ex.Message; } }
public int Delete(Int64 ID) { String Query = "DELETE FROM Final_Table SET WHERE ID = @ID"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddIntegerBigPara("ID", ID); //oDm.AddVarcharPara("UPC", 4000, UPC); //oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART); //oDm.AddVarcharPara("VDR_IT_DSC", 4000, VDR_IT_DSC); //oDm.AddVarcharPara("Image_Folder", 4000, Image_Folder); //oDm.AddVarcharPara("AID_SOURCE_ID", 4000, AID_SOURCE_ID); //oDm.AddVarcharPara("AID_PART", 4000, AID_PART); //oDm.AddDecimalPara("AID_COST", 2, 10, AID_COST); //oDm.AddVarcharPara("AID_IMG1", 4000, AID_IMG1); //oDm.AddVarcharPara("AID_IMG2", 4000, AID_IMG2); //oDm.AddVarcharPara("AID_VENDOR", 4000, AID_VENDOR); //oDm.AddVarcharPara("AID_INV", 4000, AID_INV); //oDm.AddVarcharPara("AID_LastUpdate", 4000, AID_LastUpdate); return oDm.RunActionQuery(); }
public int Insert(long ID, string PART_NUM, int? TotalInventory, int? Dallas, int? DC_AtlantaHub, int? DC_Dallas_Hub, int? DC_Elk_Grove_Hub , int? DC_Feura_Bush, int? DC_Louisville_Hub, int? DC_Reno_Hub, int? DC_Richmond_Dist_Ctr, int? Oklahama, int? RemainingBranches, DateTime? LastUpdate) { String Query = "INSERT INTO ADIInventory (PART_NUM, TotalInventory, Dallas, DC_AtlantaHub, DC_Dallas_Hub, DC_Elk_Grove_Hub, DC_Feura_Bush, DC_Louisville_Hub, DC_Reno_Hub, DC_Richmond_Dist_Ctr, Oklahama, RemainingBranches, LastUpdate)" + " VALUES ( @PART_NUM, @TotalInventory, @Dallas, @DC_AtlantaHub, @DC_Dallas_Hub, @DC_Elk_Grove_Hub, @DC_Feura_Bush, @DC_Louisville_Hub, @DC_Reno_Hub, @DC_Richmond_Dist_Ctr, @Oklahama, @RemainingBranches, @LastUpdate)"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddIntegerBigPara("ID", ID); oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddIntegerPara("TotalInventory", TotalInventory); oDm.AddIntegerPara("Dallas", Dallas); oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub); oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub); oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub); oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush); oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub); oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub); oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr); oDm.AddIntegerPara("Oklahama", Oklahama); oDm.AddIntegerPara("RemainingBranches", RemainingBranches); oDm.AddDateTimePara("LastUpdate", LastUpdate); return oDm.RunActionQuery(); }
public String GenerateAdiInventoryDetails() { try { String Query = "CREATE TABLE AdiInventoryDetails (" + "AdiNumber TEXT(255), " + "id TEXT(255), " + "dc TEXT(255), " + "region TEXT(255), " + "storeName TEXT(255), " + "address1 TEXT(255), " + "address2 TEXT(255), " + "address3 TEXT(255), " + "country TEXT(255), " + "city TEXT(255), " + "state TEXT(255), " + "stateName TEXT(255), " + "zip TEXT(255), " + "phone TEXT(255), " + "fax TEXT(255), " + "lat SINGLE, " + "lon SINGLE, " + "inventory TEXT(255), " + "manager TEXT(255), " + "responseCode TEXT(255), " + "responseMessage TEXT(255), " + "IsHub BIT, " + "LastUpdate TEXT(255))"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'AdiInventoryDetails\' Structure"; } catch (Exception ex) { return ex.Message; } }
public void DeleteAll() { String Query = "DELETE FROM [SecLockManufacturer]"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); }
public String GenerateFinalTableUpdate() { try { String Query = String.Empty; OleDbDataManager oDm; Query = "CREATE TABLE Final_Table (" + "ID AUTOINCREMENT PRIMARY KEY, " + "UPC TEXT(255), " + "VDR_PART TEXT(255), " + "VDR_IT_DSC TEXT(255), " + "Image_Folder TEXT(255), " + "AID_SOURCE_ID TEXT(255), " + "AID_PART TEXT(255), " + "AID_COST CURRENCY, " + "AID_IMG1 TEXT(255), " + "AID_IMG2 TEXT(255), " + "AID_VENDOR TEXT(255), " + "AID_INV TEXT(255), " + "AID_LastUpdate TEXT(255), " + "SLD_SOURCE_ID TEXT(255), " + "SLD_COST CURRENCY, " + "SLD_PART TEXT(255), " + "SLD_IMG1 TEXT(255), " + "SLD_IMG2 TEXT(255), " + "SLD_VENDOR TEXT(255), " + "SLD_INV TEXT(255), " + "SLD_DESC MEMO, " + "SLD_TECHDOC MEMO, " + "SLD_LastUpdate TEXT(255)) "; oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated Final_Table Structure"; } catch (Exception ex) { return ex.Message; } }
public int Update(long ID, string PART_NUM, int? TotalInventory, int? Dallas, int? DC_AtlantaHub, int? DC_Dallas_Hub, int? DC_Elk_Grove_Hub , int? DC_Feura_Bush, int? DC_Louisville_Hub, int? DC_Reno_Hub, int? DC_Richmond_Dist_Ctr, int? Oklahama, int? RemainingBranches, DateTime? LastUpdate) { String Query = "UPDATE ADIInventory SET TotalInventory = @TotalInventory, Dallas = @Dallas, " + " DC_AtlantaHub = @DC_AtlantaHub, DC_Dallas_Hub = @DC_Dallas_Hub, DC_Elk_Grove_Hub = @DC_Elk_Grove_Hub, " + " DC_Feura_Bush = @DC_Feura_Bush, DC_Louisville_Hub = @DC_Louisville_Hub, DC_Reno_Hub = @DC_Reno_Hub, " + " DC_Richmond_Dist_Ctr = @DC_Richmond_Dist_Ctr, Oklahama = @Oklahama, RemainingBranches = @RemainingBranches, LastUpdate = @LastUpdate" + " WHERE PART_NUM = \"" + PART_NUM + "\" AND ID = " + ID.ToString(); OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddIntegerBigPara("ID", ID); //oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM); oDm.AddIntegerPara("TotalInventory", TotalInventory); oDm.AddIntegerPara("Dallas", Dallas); oDm.AddIntegerPara("DC_AtlantaHub", DC_AtlantaHub); oDm.AddIntegerPara("DC_Dallas_Hub", DC_Dallas_Hub); oDm.AddIntegerPara("DC_Elk_Grove_Hub", DC_Elk_Grove_Hub); oDm.AddIntegerPara("DC_Feura_Bush", DC_Feura_Bush); oDm.AddIntegerPara("DC_Louisville_Hub", DC_Louisville_Hub); oDm.AddIntegerPara("DC_Reno_Hub", DC_Reno_Hub); oDm.AddIntegerPara("DC_Richmond_Dist_Ctr", DC_Richmond_Dist_Ctr); oDm.AddIntegerPara("Oklahama", Oklahama); oDm.AddIntegerPara("RemainingBranches", RemainingBranches); oDm.AddDateTimePara("LastUpdate", LastUpdate); return oDm.RunActionQuery(); }
public String GenerateSecLockManufacturerSeries() { try { String Query = "CREATE TABLE SecLockManufacturerSeries (" + "ID NUMBER, " + "ManufacturerCode TEXT(100), " + "Name TEXT(100)) "; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'SecLockManufacturer\' Structure"; } catch (Exception ex) { return ex.Message; } }
public int UpdatePriceByPartNO(decimal? AID_COST, string VDR_PART) { String Query = "UPDATE Final_Table SET AID_COST = @AID_COST, AID_LastUpdate = @AID_LastUpdate WHERE VDR_PART = \"" + @VDR_PART + "\""; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); //oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART); oDm.AddDecimalPara("AID_COST", 2, 10, AID_COST); oDm.AddVarcharPara("AID_LastUpdate", 4000, DateTime.Now.ToString()); return oDm.RunActionQuery(); }
public String GenerateAdiInventory() { try { String Query = "CREATE TABLE ADIInventory (" + "ID AUTOINCREMENT PRIMARY KEY, " + "PART_NUM TEXT(255), " + "TotalInventory NUMBER, " + "Dallas NUMBER, " + "DC_AtlantaHub NUMBER, " + "DC_Dallas_Hub NUMBER, " + "DC_Elk_Grove_Hub NUMBER, " + "DC_Feura_Bush NUMBER, " + "DC_Louisville_Hub NUMBER, " + "DC_Reno_Hub NUMBER, " + "DC_Richmond_Dist_Ctr NUMBER, " + "Oklahama NUMBER, " + "RemainingBranches NUMBER, " + "LastUpdate DATETIME)"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'ADIInventory\' Structure"; } catch (Exception ex) { return ex.Message; } }
public int DeleteAll() { String Query = "DELETE FROM AdiBrand"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); return oDm.RunActionQuery(); }
public String GenerateFinalTable() { try { String Query = "CREATE TABLE Final_Table (" + "ID AUTOINCREMENT PRIMARY KEY, " + "UPC TEXT(255), " + "VDR_PART TEXT(255), " + "VDR_IT_DSC TEXT(255), " + "Image_Folder TEXT(255), " + "AID_SOURCE_ID TEXT(255), " + "AID_PART TEXT(255), " + "AID_COST CURRENCY, " + "AID_IMG1 TEXT(255), " + "AID_IMG2 TEXT(255), " + "AID_VENDOR TEXT(255), " + "AID_INV TEXT(255), " + "AID_ClearanceZone YesNo DEFAULT No, " + "AID_HotDeals YesNo DEFAULT No, " + "AID_OnlineSpecials YesNo DEFAULT No, " + "AID_SaleCenter YesNo DEFAULT No, " + "AID_InStock YesNo DEFAULT No, " //+ "ADI_LeastCount NUMBER, " //+ "ADI_Priority TEXT(255), " + "AID_LastUpdate TEXT(255), " + "SLD_SOURCE_ID TEXT(255), " + "SLD_COST CURRENCY, " + "SLD_PART TEXT(255), " + "SLD_IMG1 TEXT(255), " + "SLD_IMG2 TEXT(255), " + "SLD_VENDOR TEXT(255), " + "SLD_INV TEXT(255), " + "SLD_DESC MEMO, " + "SLD_TECHDOC MEMO, " + "SLD_LastUpdate TEXT(255))"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'Final_Table\' Structure"; } catch (Exception ex) { return ex.Message; } }
public int Update(String Value, String DisplayName, bool ClearanceZone, bool SaleCenter, bool OnlineSpecials, bool HotDeals) { String Query = "UPDATE AdiBrand SET DisplayName = @DisplayName, " + "ClearanceZone = @ClearanceZone, SaleCenter = @SaleCenter, OnlineSpecials = @OnlineSpecials, HotDeals = @HotDeals " + "WHERE [Value] = @Value"; OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true); oDm.AddVarcharPara("Value", 4000, Value); oDm.AddVarcharPara("DisplayName", 4000, DisplayName); oDm.AddBoolPara("ClearanceZone", ClearanceZone); oDm.AddBoolPara("SaleCenter", SaleCenter); oDm.AddBoolPara("OnlineSpecials", OnlineSpecials); oDm.AddBoolPara("HotDeals", HotDeals); return oDm.RunActionQuery(); }
public String GenerateSecLockManufacturer() { try { String Query = "CREATE TABLE SecLockManufacturer (" + "Code TEXT(255), " + "Name TEXT(255), " + "ImagePath TEXT(255), " + "Url TEXT(255))"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); oDm.RunActionQuery(); return "Generated \'SecLockManufacturer\' Structure"; } catch (Exception ex) { return ex.Message; } }