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