public List <ClusterAssignmentDto> ClusterGetByEmpID(int ID)
{
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
List <ClusterAssignmentDto> listcluster = new List <ClusterAssignmentDto>();
SqlCommand cmd = new SqlCommand("uspClusterDetailsgetbyEmpid", con);
cmd.Parameters.AddWithValue("@EmpID", ID);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ClusterAssignmentDto clusterdto = null;
while (dr.Read())
{
clusterdto = new ClusterAssignmentDto();
clusterdto.ClusterID = Convert.ToInt32(dr["ClusterID"]);
listcluster.Add(clusterdto);
}
return(listcluster);
}
public List <ClusterAssignmentDto> GetAllClusterAssignments()
{
SqlConnection con = new SqlConnection(DBConstants.MFIS_CS);
List <ClusterAssignmentDto> lstClusterAssignments = new List <ClusterAssignmentDto>();
SqlCommand cmd = new SqlCommand("uspAssignClustertoEmployeedetails", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
ClusterAssignmentDto clusterdto = null;
while (dr.Read())
{
clusterdto = new ClusterAssignmentDto();
clusterdto.ClusterID = Convert.ToInt32(dr["EMPid"]);
clusterdto.ClusterName = Convert.ToString(dr["ClusterName"]);
clusterdto.EmployeeName = Convert.ToString(dr["EmployeeName"]);
clusterdto.RoleName = Convert.ToString(dr["RoleName"]);
lstClusterAssignments.Add(clusterdto);
}
return(lstClusterAssignments);
}
