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 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 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 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 <ADI_InventoryDetails> GetData()
{
String Query = "SELECT * FROM AdiInventoryDetails";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <ADI_InventoryDetails>(oDm.GetTable()));
}
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 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 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 <ADI_Child> GetData()
{
String Query = "SELECT * FROM ADIChild";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return(DataParser.ToList <ADI_Child>(oDm.GetTable()));
}
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 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 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()));
}
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 List <ADI_InventoryDetails> GetData(String AdiNumber)
{
String Query = "SELECT * FROM AdiInventoryDetails WHERE AdiNumber = \"" + AdiNumber + "\"";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
//oDm.AddVarcharPara("AdiNumber", 4000, AdiNumber);
return(DataParser.ToList <ADI_InventoryDetails>(oDm.GetTable()));
}
public List <ADI_InventoryDetails> GetData(String AdiNumber, String id, String dc, String region, String storeName)
{
String Query = "SELECT * FROM AdiInventoryDetails WHERE AdiNumber = \"" + AdiNumber
+ "\" and id = \"" + id + "\" and dc = \"" + dc + "\" and region = \"" + region + "\" and storeName = \"" + storeName + "\"";
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);
return(DataParser.ToList <ADI_InventoryDetails>(oDm.GetTable()));
}