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_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<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 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());
}
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 int Count()
{
String Query = "SELECT COUNT(1) FROM SecLockManufacturer WITH (NOLOCK)";
OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true);
return (int)oDm.GetTable().Rows[0][0];
}
public List<ADI_Inventory> GetData()
{
String Query = "SELECT * FROM ADIInventory";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return DataParser.ToList<ADI_Inventory>(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 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 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 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 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_Brand> GetData()
{
String Query = "SELECT * FROM AdiBrand";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return DataParser.ToList<Adi_Brand>(oDm.GetTable());
}
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 List<FinalTable> GetData()
{
String Query = "SELECT * FROM Final_Table WHERE AID_PART IS NOT NULL AND AID_PART <> ''";
OleDbDataManager oDm = new OleDbDataManager(ConnectionString, Query, true);
return DataParser.ToList<FinalTable>(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());
}