public DevelopmentMembers GetCurrentMember(DevelopmentMembers member)
{
string queryCommand = "GETUSER";
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", member.AgencyId));
command.Parameters.Add(new SqlParameter("@UserId", member.UserId));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.CommandText = "USP_MembersForReview";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if ((_dataset.Tables[0] != null) && (_dataset.Tables[0].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
member = new DevelopmentMembers();
member.UserId = (!string.IsNullOrEmpty(dr["UserId"].ToString())) ? new Guid(dr["UserId"].ToString()) : (Guid?)null;
member.FullName = dr["MemberName"].ToString();
member.UserColor = dr["UserColor"].ToString();
member.RoleId = new Guid(dr["RoleId"].ToString());
member.UserColor = dr["UserColor"].ToString();
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(member);
}
public List <DevelopmentMembers> GetDevelopmentMembers(out int ContributorCount, DevelopmentMembers members)
{
List <DevelopmentMembers> membersList = new List <DevelopmentMembers>();
DevelopmentMembers dev_members = null;
string queryCommand = "SELECT";
ContributorCount = 0;
try
{
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", members.AgencyId));
command.Parameters.Add(new SqlParameter("@ClientId", members.ClientId));
command.Parameters.Add(new SqlParameter("@AttendanceMonth", members.ReviewMonth));
command.Parameters.Add(new SqlParameter("@UserId", members.UserId));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.CommandText = "USP_MembersForReview";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if ((_dataset.Tables[0] != null) && (_dataset.Tables[0].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
dev_members = new DevelopmentMembers();
dev_members.UserId = (!string.IsNullOrEmpty(dr["UserId"].ToString())) ? new Guid(dr["UserId"].ToString()) : (Guid?)null;
dev_members.FullName = dr["MemberName"].ToString();
dev_members.UserColor = dr["UserColor"].ToString();
dev_members.RoleId = new Guid(dr["RoleId"].ToString());
dev_members.RoleName = dr["RoleName"].ToString();
dev_members.IsContributor = Convert.ToBoolean(dr["IsContributor"]);
if ((dev_members.UserId == members.UserId) && (!dev_members.IsContributor))
{
dev_members.IsPresent = true;
dev_members.IsEdit = false;
}
else
{
dev_members.IsEdit = true;
dev_members.IsPresent = (string.IsNullOrEmpty(dr["IsPresent"].ToString()))?false: Convert.ToBoolean(dr["IsPresent"]);
}
membersList.Add(dev_members);
}
// membersList = membersList.Where(x => x.UserId != null).ToList();
}
if ((_dataset.Tables[1] != null) && (_dataset.Tables[1].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[1].Rows)
{
ContributorCount = (string.IsNullOrEmpty(dr["ContributorCount"].ToString())) ? 0 : Convert.ToInt32(dr["ContributorCount"]);
}
}
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(membersList);
}
public DevelopmentMembers CheckIsHost(string month, Guid?AgencyId, Guid userID, long clientId)
{
// bool isRowAffected = false;
DevelopmentMembers devMembers = new DevelopmentMembers();
try
{
string queryCommand = "CHECKHOST";
if (Connection.State == ConnectionState.Open)
{
Connection.Close();
}
Connection.Open();
command.Connection = Connection;
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Agencyid", AgencyId));
command.Parameters.Add(new SqlParameter("@ClientId", clientId));
command.Parameters.Add(new SqlParameter("@AttendanceMonth", month));
command.Parameters.Add(new SqlParameter("@UserId", userID));
command.Parameters.Add(new SqlParameter("@Command", queryCommand));
command.CommandText = "USP_MembersForReview";
DataAdapter = new SqlDataAdapter(command);
_dataset = new DataSet();
DataAdapter.Fill(_dataset);
if ((_dataset.Tables[0] != null) && (_dataset.Tables[0].Rows.Count > 0))
{
foreach (DataRow dr in _dataset.Tables[0].Rows)
{
devMembers.UserId = (!string.IsNullOrEmpty(dr["HostUserId"].ToString())) ? new Guid(dr["HostUserId"].ToString()) : (Guid?)null;
devMembers.FullName = dr["HostName"].ToString();
devMembers.UserColor = dr["HostUserColor"].ToString();
devMembers.RoleId = new Guid(dr["HostRoleId"].ToString());
devMembers.RoleName = dr["HostRoleName"].ToString();
devMembers.IsHost = Convert.ToBoolean(dr["IsHost"]);
}
// membersList = membersList.Where(x => x.UserId != null).ToList();
}
else
{
devMembers.UserId = (Guid?)null;
devMembers.FullName = "";
devMembers.UserColor = "";
devMembers.RoleName = "";
devMembers.IsHost = true;
}
//var obj = command.ExecuteScalar();
//isRowAffected = Convert.ToBoolean(obj);
}
catch (Exception ex)
{
clsError.WriteException(ex);
}
finally
{
Connection.Close();
command.Dispose();
}
return(devMembers);
}
