public List <mediaModel> getUsersMediaList(mediaModel mediaParams)
{
using (DAL db = new DAL())
{
List <mediaModel> lsmedia = new List <mediaModel>();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_GetUsersMediaList";
cmd.Parameters.AddWithValue("@showOnHomePage", Convert.ToBoolean(mediaParams.onHomePage));
DataSet ds = db.ReturnDataset(cmd);
foreach (DataRow item in ds.Tables[0].Rows)
{
mediaModel data = new mediaModel();
lsmedia.Add(data);
}
return(lsmedia);
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <mediaModel> getAdminMediaList()
{
using (DAL db = new DAL())
{
List <mediaModel> lsmedia = new List <mediaModel>();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_GetAdminMediaList";
DataSet ds = db.ReturnDataset(cmd);
foreach (DataRow item in ds.Tables[0].Rows)
{
mediaModel data = new mediaModel();
lsmedia.Add(data);
}
return(lsmedia);
}
catch (Exception ex)
{
throw ex;
}
}
}