public IEnumerable <E_BannerCat> Get_BannerCatList()
{
BLLDBOperations blldb = new BLLDBOperations(InvConstr);
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", "GetBannerCatList");
dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
IEnumerable <E_BannerCat> lst = DbOperation.ConvertDataTable <E_BannerCat>(dt);
return(lst);
}
public IEnumerable <E_Banner> SrchBanner()
{
BLLDBOperations blldb = new BLLDBOperations(InvConstr);
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", "SrchBanner");
//hst.Add("BannerName", BannerName);
dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
IEnumerable <E_Banner> lst = DbOperation.ConvertDataTable <E_Banner>(dt);
return(lst);
}
public IEnumerable <E_Company> SrchCompany()
{
BLLDBOperations blldb = new BLLDBOperations();
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", "SrchCompany");
//hst.Add("CompanyName", CompanyName);
dt = blldb.GetDataTable("SP_CompanyMaster", CommandType.StoredProcedure, hst);
IEnumerable <E_Company> lst = DbOperation.ConvertDataTable <E_Company>(dt);
return(lst);
}