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;
}
}