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 int Update(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 = "UPDATE AdiInventoryDetails SET dc = @dc ,region = @region ,storeName = @storeName ,address1 = @address1 ,address2 = @address2 ,address3 = @address3 "
+ ",country = @country ,city = @city ,state = @state ,stateName = @stateName ,zip = @zip ,phone = @phone ,fax = @fax ,lat = @lat ,lon = @lon "
+ ",inventory = @inventory ,manager = @manager ,responseCode = @responseCode ,responseMessage = @responseMessage ,IsHub = @IsHub "
+ ",LastUpdate = @LastUpdate WHERE AdiNumber = @AdiNumber AND id = \"" + id + "\"";
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 int Update(Int64 ID, String UPC, String VDR_PART, String VDR_IT_DSC, String Image_Folder, String AID_SOURCE_ID, String AID_PART, decimal AID_COST, String AID_IMG1, String AID_IMG2, String AID_VENDOR, String AID_INV, String AID_LastUpdate)
{
//String Query = "UPDATE Final_Table SET UPC = @UPC, VDR_PART = @VDR_PART, VDR_IT_DSC = @VDR_IT_DSC, Image_Folder = @Image_Folder, AID_SOURCE_ID = @AID_SOURCE_ID, AID_PART = @AID_PART, AID_COST = @AID_COST, AID_IMG1 = @AID_IMG1, AID_IMG2 = @AID_IMG2, AID_VENDOR = @AID_VENDOR, AID_INV = @AID_INV, AID_LastUpdate = @AID_LastUpdate, AID_LeastCount = @AID_LeastCount, AID_Priority = @AID_Priority"
// + " WHERE ID = @ID";
String Query = "UPDATE Final_Table SET UPC = @UPC, VDR_PART = @VDR_PART, VDR_IT_DSC = @VDR_IT_DSC, Image_Folder = @Image_Folder, AID_SOURCE_ID = @AID_SOURCE_ID, AID_PART = @AID_PART, AID_COST = @AID_COST, AID_IMG1 = @AID_IMG1, AID_IMG2 = @AID_IMG2, AID_VENDOR = @AID_VENDOR, AID_INV = @AID_INV, AID_LastUpdate = @AID_LastUpdate"
+ " WHERE ID = " + ID.ToString();
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);
////oDm.AddIntegerPara("AID_LeastCount", AID_LeastCount);
////oDm.AddBoolPara("AID_Priority", AID_Priority);
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();
}
public int DeleteAll()
{
String Query = "DELETE FROM AdiInventoryDetails";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
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 Insert(Int64 ID, String UPC, String VDR_PART, String VDR_IT_DSC, String Image_Folder, String AID_SOURCE_ID,
String AID_PART, decimal AID_COST, String AID_IMG1, String AID_IMG2, String AID_VENDOR, String AID_INV,
Boolean AID_ClearanceZone, Boolean AID_HotDeals, Boolean AID_OnlineSpecials, Boolean AID_SaleCenter, Boolean AID_InStock, String AID_LastUpdate)
{
String Query = "INSERT INTO Final_Table (UPC, VDR_PART, VDR_IT_DSC, Image_Folder, AID_SOURCE_ID, AID_PART, AID_COST, AID_IMG1, AID_IMG2, AID_VENDOR, AID_INV, "
+ "AID_ClearanceZone, AID_HotDeals, AID_OnlineSpecials, AID_SaleCenter, AID_InStock, AID_LastUpdate)"
+ " VALUES (@UPC, @VDR_PART, @VDR_IT_DSC, @Image_Folder, @AID_SOURCE_ID, @AID_PART, @AID_COST, @AID_IMG1, @AID_IMG2, @AID_VENDOR, @AID_INV, "
+ "@AID_ClearanceZone, @AID_HotDeals, @AID_OnlineSpecials, @AID_SaleCenter, @AID_InStock, @AID_LastUpdate)";
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.AddBoolPara("AID_ClearanceZone", AID_ClearanceZone);
oDm.AddBoolPara("AID_HotDeals", AID_HotDeals);
oDm.AddBoolPara("AID_OnlineSpecials", AID_OnlineSpecials);
oDm.AddBoolPara("AID_SaleCenter", AID_SaleCenter);
oDm.AddBoolPara("AID_InStock", AID_InStock);
oDm.AddVarcharPara("AID_LastUpdate", 4000, AID_LastUpdate);
//oDm.AddIntegerPara("AID_LeastCount", AID_LeastCount);
//oDm.AddBoolPara("AID_Priority", AID_Priority);
return(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))";
oDm = new OleDbDataManager(this.ConnectionString, Query, true);
oDm.RunActionQuery();
return("Generated Final_Table Structure");
}
catch (Exception ex)
{
return(ex.Message);
}
}
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))";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
oDm.RunActionQuery();
return("Generated \'Final_Table\' Structure");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void DeleteAll()
{
String Query = "DELETE FROM [SecLockCategory]";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
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 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());
}
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 AdiChild 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 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 ADIInventory SET 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 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 int UpdateInvBYPartNO(String AID_INV, String AID_LastUpdate, String VDR_PART)
{
String Query = "UPDATE Final_Table SET AID_INV = @AID_INV, AID_LastUpdate = @AID_LastUpdate"
+ " WHERE VDR_PART = \"" + VDR_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART);
oDm.AddVarcharPara("AID_INV", 4000, AID_INV);
oDm.AddVarcharPara("AID_LastUpdate", 4000, AID_LastUpdate);
return(oDm.RunActionQuery());
}
public int Update(String PART_NUM, String PropertyName, String PropertyValue)
{
String Query = "UPDATE AdiChild SET PropertyValue = @PropertyValue"
+ " 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);
oDm.AddVarcharPara("PropertyValue", 4000, PropertyValue);
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 UpdateImageByPartNo(string Image_Folder, string AID_IMG1, string AID_IMG2, string VDR_PART)
{
String Query = "UPDATE Final_Table SET Image_Folder = @Image_Folder, AID_IMG1 = @AID_IMG1, AID_IMG2 = @AID_IMG2, AID_LastUpdate = @AID_LastUpdate"
+ " WHERE VDR_PART = \"" + VDR_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART);
oDm.AddVarcharPara("Image_Folder", 4000, Image_Folder);
oDm.AddVarcharPara("AID_IMG1", 4000, AID_IMG1);
oDm.AddVarcharPara("AID_IMG2", 4000, AID_IMG2);
oDm.AddVarcharPara("AID_LastUpdate", 4000, DateTime.Now.ToString());
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());
}
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 GenerateSecLockCategory()
{
try
{
String Query = "CREATE TABLE SecLockCategory ("
+ "Code TEXT(255), "
+ "Name TEXT(255))";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
oDm.RunActionQuery();
return("Generated \'SecLockCategory\' Structure");
}
catch (Exception ex)
{
return(ex.Message);
}
}
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);
}
}