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 List <ADI_InventoryDetails> GetData()
{
String Query = "SELECT * FROM AdiInventoryDetails";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <ADI_InventoryDetails>(oDm.GetTable()));
}
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 List <Adi_Category> GetData()
{
String Query = "SELECT * FROM AdiCategory";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <Adi_Category>(oDm.GetTable()));
}
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 Count()
{
String Query = "SELECT COUNT(1) FROM SecLockCategory WITH (NOLOCK)";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return((int)oDm.GetTable().Rows[0][0]);
}
public int Count(InManufacturer manufacturer)
{
String Query = "SELECT COUNT(1) FROM SecLockManufacturerSeries WITH (NOLOCK) WHERE ManufacturerCode = '" + manufacturer.Code + "'";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return((int)oDm.GetTable().Rows[0][0]);
}
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()));
}
public List <InCategory> GetData(InCategory category)
{
String Query = "SELECT * FROM SecLockCategory WHERE Code = '" + category.Code + "' ORDER BY Name";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return(DataParser.ToList <InCategory>(oDm.GetTable()));
}
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 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 int Count()
{
String Query = "SELECT * FROM Final_Table WHERE SLD_PART IS NOT NULL";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return((int)oDm.GetTable().Rows[0][0]);
}
public void DeleteAll()
{
String Query = "DELETE FROM [SecLockCategory]";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
oDm.RunActionQuery();
}
public List <InManufacturerSeries> GetData(InManufacturerSeries manufacturer)
{
String Query = "SELECT * FROM SecLockManufacturerSeries WHERE ID = " + manufacturer.ID + " ORDER BY Name";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return(DataParser.ToList <InManufacturerSeries>(oDm.GetTable()));
}
public int DeleteAll()
{
String Query = "DELETE FROM AdiBrand";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(oDm.RunActionQuery());
}
public List <FinalTable> GetData()
{
String Query = "SELECT * FROM Final_Table WHERE SLD_PART IS NOT NULL AND SLD_PART <> ''";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <FinalTable>(oDm.GetTable()));
}
public List <Final_Table> GetAllAdiProducts()
{
String Query = "SELECT * FROM Final_Table WHERE AID_PART IS NOT NULL";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <Final_Table>(oDm.GetTable()));
}
public List <Final_Table> GetData()
{
String Query = "SELECT * FROM Final_Table";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <Final_Table>(oDm.GetTable()));
}
public List <ADI_Child> GetData()
{
String Query = "SELECT * FROM ADIChild";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <ADI_Child>(oDm.GetTable()));
}
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 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()));
}
//public int UpdateFlagsByAdiProduct(String AID_PART, Boolean ADI_ClearanceZone
// , Boolean ADI_HotDeals, Boolean ADI_OnlineSpecials, Boolean ADI_SaleCenter, Boolean ADI_InStock, String AID_LastUpdate)
//{
// String Query = "UPDATE Final_Table SET ADI_ClearanceZone = @ADI_ClearanceZone, "
// + "ADI_HotDeals = @ADI_HotDeals, ADI_OnlineSpecials = @ADI_OnlineSpecials, ADI_SaleCenter = @ADI_SaleCenter, "
// + "ADI_InStock = @ADI_InStock, AID_LastUpdate = @AID_LastUpdate"
// + " WHERE AID_PART = \"" + AID_PART + "\"";
// OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
// oDm.AddBoolPara("ADI_ClearanceZone", ADI_ClearanceZone);
// oDm.AddBoolPara("ADI_HotDeals", ADI_HotDeals);
// oDm.AddBoolPara("ADI_OnlineSpecials", ADI_OnlineSpecials);
// oDm.AddBoolPara("ADI_SaleCenter", ADI_SaleCenter);
// oDm.AddBoolPara("ADI_InStock", ADI_InStock);
// //oDm.AddVarcharPara("AID_PART", 4000, AID_PART);
// oDm.AddVarcharPara("AID_LastUpdate", 4000, AID_LastUpdate);
// return oDm.RunActionQuery();
//}
public List <FinalTable> GetPriorityData(Boolean ADI_Priority)
{
String Query = "SELECT * FROM Final_Table WHERE ADI_Priority = \"" + ADI_Priority + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddBoolPara("ADI_Priority", ADI_Priority);
return(DataParser.ToList <FinalTable>(oDm.GetTable()));
}
public int ValidAidProduct(string VDR_PART)
{
String Query = "SELECT COUNT(1) FROM Final_Table WHERE VDR_PART = \"" + VDR_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART);
return((int)oDm.GetTable().Rows[0][0]);
}
public List <FinalTable> GetProductByPARTNO(String VDR_PART)
{
String Query = "SELECT * FROM Final_Table WHERE VDR_PART = \"" + VDR_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("VDR_PART", 4000, VDR_PART);
return(DataParser.ToList <FinalTable>(oDm.GetTable()));
}
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 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());
}
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()));
}
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());
}
