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 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 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 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 Value)
{
String Query = "DELETE FROM AdiBrand WHERE Value = @Value";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
oDm.AddVarcharPara("Value", 4000, Value);
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 int ValidADIProduct(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 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 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 UpdateFlagsByAdiProduct(String AID_PART, Boolean AID_ClearanceZone
, Boolean AID_HotDeals, Boolean AID_OnlineSpecials, Boolean AID_SaleCenter, Boolean AID_InStock, String AID_LastUpdate)
{
String Query = "UPDATE Final_Table SET AID_ClearanceZone = @AID_ClearanceZone, "
+ "AID_HotDeals = @AID_HotDeals, AID_OnlineSpecials = @AID_OnlineSpecials, AID_SaleCenter = @AID_SaleCenter, "
+ "AID_InStock = @AID_InStock, AID_LastUpdate = @AID_LastUpdate"
+ " WHERE AID_PART = \"" + AID_PART + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
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_PART", 4000, AID_PART);
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 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 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,
Boolean AID_ClearanceZone, Boolean AID_HotDeals, Boolean AID_OnlineSpecials, Boolean AID_SaleCenter, Boolean AID_InStock, 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_ClearanceZone = @AID_ClearanceZone, AID_HotDeals = @AID_HotDeals"
+ ", AID_OnlineSpecials= @AID_OnlineSpecials, AID_SaleCenter = @AID_SaleCenter, AID_InStock = @AID_InStock, 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.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 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, 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_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_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.AddVarcharPara("AID_LastUpdate", 4000, AID_LastUpdate);
//oDm.AddIntegerPara("ADI_LeastCount", ADI_LeastCount);
//oDm.AddBoolPara("ADI_Priority", ADI_Priority);
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"
+ " WHERE [ID] = " + ID.ToString(); // " @ID";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddIntegerPara("@ID", (int) 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 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());
}