/// <summary>
/// Get the allocated project for specific user
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static IEnumerable<ProjectAssignment> GetAssignedProject(string userId)
{
var conn = new SqlConnection(SqlConString);
var assignments = new List<ProjectAssignment>();
try
{
var sqlQuery = string.Format("select UserId,ProjectId from DTSUserProject where UserId={0} and ProjectMgrId='"+HttpContext.Current.User.Identity.Name +"'", userId);
var sqlCommand = new SqlCommand { CommandText = sqlQuery, Connection = conn };
conn.Open();
var sqlReader = sqlCommand.ExecuteReader();
while (sqlReader.Read())
{
var ap = new ProjectAssignment
{
UserId = int.Parse(sqlReader[0].ToString()),
ProjectId = int.Parse(sqlReader[1].ToString())
};
assignments.Add(ap);
}
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
return assignments;
}
private static IEnumerable<ProjectAssignment> GetProjectAssignments(object[] assignments)
{
if (assignments == null)
{
return null;
}
var passignmetns = new List<ProjectAssignment>();
foreach (var assignment in assignments)
{
var passignment = new ProjectAssignment();
var tmp = (Dictionary<string, object>)assignment;
object objUserId = null;
object objProjectId = null;
if (tmp.TryGetValue("UserId", out objUserId))
passignment.UserId = int.Parse(objUserId.ToString());
if (tmp.TryGetValue("ProjectId", out objProjectId))
passignment.ProjectId = int.Parse(objProjectId.ToString());
passignmetns.Add(passignment);
}
return passignmetns;
}