public DataSet DALGetSpecificUrl(DownloadurlBLL ur)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
DataSet ds = new DataSet();
try
{
ds = SqlHelper.ExecuteDataset(cn, CommandType.StoredProcedure, "GetDownloadurl");
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
return(ds);
}
public DataSet DALGetURLRecord(DownloadurlBLL ur)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
DataSet ds = new DataSet();
try
{
SqlParameter[] par = new SqlParameter[1];
par[0] = new SqlParameter("@url", ur.Url);
ds = SqlHelper.ExecuteDataset(cn, CommandType.StoredProcedure, "GetDownloadurlRecord", par);
}
catch (Exception ex)
{
}
finally
{
cn.Close();
}
return(ds);
}
public DataSet BLLGetDownloadRecord(DownloadurlBLL ur)
{
DataSet ds = dalobj.DALGetURLRecord(ur);
return(ds);
}
public DataSet BLLGetAllurl(DownloadurlBLL ur)
{
DataSet ds = dalobj.DALGetAllUrl(ur);
return(ds);
}
public DataSet BLLGetSpecificurl(DownloadurlBLL ur)
{
DataSet ds = dalobj.DALGetSpecificUrl(ur);
return(ds);
}