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 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 List<ADI_Inventory> GetData(String PART_NUM)
{
String Query = "SELECT * FROM ADIInventory WHERE PART_NUM = \"" + PART_NUM + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("PART_NUM", 4000, PART_NUM);
return DataParser.ToList<ADI_Inventory>(oDm.GetTable());
}
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(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 List<ADI_Child> GetData(String AID_PART)
{
String Query = "SELECT * FROM ADIChild WHERE PART_NUM = \"" + AID_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("AID_PART", 4000, AID_PART);
return DataParser.ToList<ADI_Child>(oDm.GetTable());
}
public List<Final_Table> GetDataByAdiPart(String AID_PART)
{
String Query = "SELECT * FROM Final_Table WHERE AID_PART = \"" + AID_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("AID_PART", 4000, AID_PART);
return DataParser.ToList<Final_Table>(oDm.GetTable());
}
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 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(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();
}
public int Insert(String AdiNumber, String id, String dc, String region, String storeName, String address1, String address2, String address3
, String country, String city, String state, String stateName, String zip, String phone, String fax, float? lat, float? lon, String inventory
, String manager, String responseCode, String responseMessage, Boolean IsHub, DateTime LastUpdate)
{
String Query = "INSERT INTO AdiInventoryDetails (AdiNumber, id ,dc ,region ,storeName ,address1 ,address2 ,address3 ,country ,city ,state ,stateName ,zip ,phone ,fax ,lat ,lon ,inventory ,manager ,responseCode ,responseMessage ,IsHub, LastUpdate) "
+ "VALUES (@AdiNumber, @id ,@dc ,@region ,@storeName ,@address1 ,@address2 ,@address3 ,@country ,@city ,@state ,@stateName ,@zip ,@phone ,@fax ,@lat ,@lon ,@inventory ,@manager ,@responseCode ,@responseMessage ,@IsHub, @LastUpdate)";
//String Query = "INSERT INTO AdiInventoryDetails (AdiNumber, id ,dc ,region ,storeName ,address1 ,address2 ,address3 ,country ,city ,state ,stateName ,zip ,phone ,fax,inventory ,manager ,responseCode ,responseMessage ,IsHub, LastUpdate) "
// + "VALUES (@AdiNumber, @id ,@dc ,@region ,@storeName ,@address1 ,@address2 ,@address3 ,@country ,@city ,@state ,@stateName ,@zip ,@phone ,@fax ,@inventory ,@manager ,@responseCode ,@responseMessage ,@IsHub, @LastUpdate)";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
oDm.AddVarcharPara("id", 4000, id);
oDm.AddVarcharPara("dc", 4000, dc);
oDm.AddVarcharPara("region", 4000, region);
oDm.AddVarcharPara("storeName", 4000, storeName);
oDm.AddVarcharPara("address1", 4000, address1);
oDm.AddVarcharPara("address2", 4000, address2);
oDm.AddVarcharPara("address3", 4000, address3);
oDm.AddVarcharPara("country", 4000, country);
oDm.AddVarcharPara("city", 4000, city);
oDm.AddVarcharPara("state", 4000, state);
oDm.AddVarcharPara("stateName", 4000, stateName);
oDm.AddVarcharPara("zip", 4000, zip);
oDm.AddVarcharPara("phone", 4000, phone);
oDm.AddVarcharPara("fax", 4000, fax);
oDm.AddFloatPara("lat", lat);
oDm.AddFloatPara("lon", lon);
oDm.AddVarcharPara("inventory", 4000, inventory);
oDm.AddVarcharPara("manager", 4000, manager);
oDm.AddVarcharPara("responseCode", 4000, responseCode);
oDm.AddVarcharPara("responseMessage", 4000, responseMessage);
oDm.AddBoolPara("IsHub", IsHub);
oDm.AddDateTimePara("LastUpdate", LastUpdate);
return oDm.RunActionQuery();
}
public List<Adi_Brand> GetData(String Value)
{
String Query = "SELECT * FROM AdiBrand WHERE Value = @Value";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
oDm.AddVarcharPara("Value", 4000, Value);
return DataParser.ToList<Adi_Brand>(oDm.GetTable());
}
public List<ADI_InventoryDetails> GetData(String AdiNumber)
{
String Query = "SELECT * FROM AdiInventoryDetails WHERE AdiNumber = \"" + AdiNumber + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
return DataParser.ToList<ADI_InventoryDetails>(oDm.GetTable());
}
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 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();
}
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 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 List<ADI_InventoryDetails> GetData(String AdiNumber, String id, String dc, String region, String storeName)
{
String Query = "SELECT * FROM AdiInventoryDetails WHERE AdiNumber = \"" + AdiNumber
+ "\" and id = \"" + id + "\" and dc = \"" + dc + "\" and region = \"" + region + "\" and storeName = \"" + storeName + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
//oDm.AddVarcharPara("id", 4000, id);
//oDm.AddVarcharPara("dc", 4000, dc);
//oDm.AddVarcharPara("region", 4000, region);
//oDm.AddVarcharPara("storename", 4000, storeName);
return DataParser.ToList<ADI_InventoryDetails>(oDm.GetTable());
}
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();
}
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();
}
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 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 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 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 List<Adi_Brand> GetData()
{
String Query = "SELECT * FROM AdiBrand";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return DataParser.ToList<Adi_Brand>(oDm.GetTable());
}
public int DeleteAll()
{
String Query = "DELETE FROM AdiBrand";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return oDm.RunActionQuery();
}
public List<InManufacturer> GetData(InManufacturer manufacturer)
{
String Query = "SELECT * FROM SecLockManufacturer WHERE Code = '" + manufacturer.Code +"' ORDER BY Name";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return DataParser.ToList<InManufacturer>(oDm.GetTable());
}