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 List<FinalTable> GetPriorityData(Boolean AID_Priority)
{
String Query = "SELECT * FROM Final_Table WHERE AID_Priority = \"" + AID_Priority + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
oDm.AddBoolPara("AID_Priority", AID_Priority);
return DataParser.ToList<FinalTable>(oDm.GetTable());
}
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 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,
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 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(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();
}