public DataSet DALGetUserVisitors(UserDisplayBLL obj)
{
try
{
SqlParameter[] par = new SqlParameter[2];
par[0] = new SqlParameter("@usrUserid", obj.Userid);
ds = SqlHelper.ExecuteDataset(cn, CommandType.StoredProcedure, "GetUserVisitors", par);
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
return(ds);
}
public int DALGetUserVisitorsUpdate(UserDisplayBLL obj)
{
try
{
SqlParameter[] par = new SqlParameter[2];
par[0] = new SqlParameter("@userid", obj.Userid);
par[1] = new SqlParameter("@usrRecentVisitor", obj.Recentvisitor);
par[2] = new SqlParameter("@status", 1);
par[2].Direction = ParameterDirection.Output;
status = SqlHelper.ExecuteNonQuery(cn, CommandType.StoredProcedure, "GetUserVisitorsUpdate", par);
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
return(status);
}
public int BLLGetUserVisitorsUpdate(UserDisplayBLL obj)
{
status = objdal.DALGetUserVisitorsUpdate(obj);
return(status);
}
public DataSet BLLGetUserVisitors(UserDisplayBLL obj)
{
DataSet ds = objdal.DALGetUserVisitors(obj);
return(ds);
}