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);
}
public string DeleteBannerLstRow(string Action, string BannerId, string BannerDetailId)
{
BLLDBOperations blldb = new BLLDBOperations(InvConstr);
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", "DeleteBanner");
hst.Add("BannerId", BannerId);
hst.Add("BannerDetailId", BannerDetailId);
dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
return(dt.Rows[0][0].ToString());
}
public string SaveBannerDetail(string Action, string BannerId, string myfile)
{
BLLDBOperations blldb = new BLLDBOperations(InvConstr);
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", "SaveBannerDetail");
hst.Add("BannerId", BannerId);
hst.Add("ImagePath", myfile);
dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
return(dt.Rows[0][0].ToString());
}
public DataTable SaveBanner(string Action, string BannerCatId)
{
BLLDBOperations blldb = new BLLDBOperations(InvConstr);
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", "SaveBanner");
hst.Add("BannerCatId", BannerCatId);
// hst.Add("BannerId", BannerId);
// hst.Add("Bannername", Bannername);
//hst.Add("ImagePath", fname);
dt = blldb.GetDataTable("SP_BannerMaster", CommandType.StoredProcedure, hst);
return(dt);
//return dt.Rows[0][0].ToString();
}
public string SaveCompany(string Action, string CompanyId, string CompanyName, string CompanyDomain, string userId)
{
BLLDBOperations blldb = new BLLDBOperations();
Hashtable hst = new Hashtable();
DataTable dt;
hst.Add("Action", Action);
hst.Add("CompanyId", CompanyId);
hst.Add("CompanyName", CompanyName);
hst.Add("CompanyDomain", CompanyDomain);
hst.Add("userId", userId);
dt = blldb.GetDataTable("SP_CompanyMaster", CommandType.StoredProcedure, hst);
return(dt.Rows[0][0].ToString());
}