public DataSet DALGetUserGroupTotal(ProfileSetting1BLL obj)
{
try
{
SqlParameter[] par = new SqlParameter[2];
par[0] = new SqlParameter("@usrUserid", obj.Userid);
ds = SqlHelper.ExecuteDataset(cn, CommandType.StoredProcedure, "GetUserGroupTotal", par);
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
return(ds);
}
public int DALUserGroupNameUpdate(ProfileSetting1BLL obj)
{
try
{
SqlParameter[] par = new SqlParameter[4];
par[0] = new SqlParameter("@userid", obj.Userid);
par[1] = new SqlParameter("@groupid", obj.Groupid);
par[2] = new SqlParameter("@groupname", obj.GroupName);
par[3] = new SqlParameter("@status", 1);
par[3].Direction = ParameterDirection.Output;
status = SqlHelper.ExecuteNonQuery(cn, CommandType.StoredProcedure, "UserGroupNameUpdate", par);
}
catch (Exception ex)
{ }
finally
{
cn.Close();
}
return(status);
}
public DataSet BLLGetUserGroupTotal(ProfileSetting1BLL obj)
{
DataSet ds = objdal.DALGetUserGroupTotal(obj);
return(ds);
}
public int BLLUserGroupNameUpdate(ProfileSetting1BLL obj)
{
status = objdal.DALUserGroupNameUpdate(obj);
return(status);
}
public DataSet BLLGetUserFriendNameRelationById(ProfileSetting1BLL obj)
{
DataSet ds = objdal.DALGetUserFriendNameRelationById(obj);
return(ds);
}