public EmpEntityList GetAllEmps()
{
try
{
EmpEntityList listObject = new EmpEntityList();
// List<EmployeeEntity> list = new List<EmployeeEntity>();
SqlCommand cmd = new SqlCommand("Proc_Employee_Details", connStr);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SQL_CMD_TYPE", "SELECT");
if (connStr.State == ConnectionState.Closed)
{
connStr.Open();
}
SqlDataAdapter sd = new SqlDataAdapter(cmd);
DataSet tab = new DataSet();
sd.Fill(tab);
// int count1= tab.Tables[0].Rows.Count;
listObject.Emplist = new List <EmployeeEntity>();
listObject.DesnList = new List <LookupEntity>();
listObject.DeptList = new List <LookupEntity>();
listObject.SupervisorList = new List <EmployeeEntity>();
if (tab.Tables.Count > 0)
{
foreach (DataRow row in tab.Tables[0].Rows)
{
listObject.Emplist.Add(new EmployeeEntity
{
Id = Convert.ToInt32(row["ID"]),
Name = row["NAME"].ToString(),
DesgnationId = Convert.ToInt32(row["DESIGNATION_ID"]),
Designation = row["DESIGNATION_NAME"].ToString(),
Gender = row["GENDER"].ToString(),
DepartmentId = Convert.ToInt32(row["DEPARTMENT_ID"]),
Department = row["DEPARTMENT_NAME"].ToString(),
Experience = Convert.ToInt32(row["EXPERIENCE"]),
Skills = row["SKILLS"].ToString(),
EmailId = row["EMAIL_ID"].ToString(),
ContactNo = row["CONTACT_NUMBER"].ToString(),
SupervisorId = row["SUPERVISOR_ID"] == DBNull.Value ? (int?)null : Convert.ToInt32(row["SUPERVISOR_ID"]),
Supervisor = row["SUPERVISOR"].ToString(),
DateOfBirth = Convert.ToDateTime(row["DATE_OF_BIRTH"].ToString()),
Address = row["ADDRESS"].ToString(),
InsertedBy = row["INSERTED_BY"] == DBNull.Value ? null : row["INSERTED_BY"].ToString(),
InsertedOn = row["INSERTED_ON"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(row["DATE_OF_BIRTH"].ToString()),
UpdatedBy = row["UPDATED_BY"] == DBNull.Value ? null : row["UPDATED_BY"].ToString(),
UpdatedOn = row["UPDATED_ON"] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(row["DATE_OF_BIRTH"].ToString())
});
}
}
return(listObject);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(null);
}
finally
{
connStr.Close();
}
}
// public static List<DTOClass> listDto;
public DtoList GetDtoData()
{
try
{
DALClass Obj = new DALClass();
DtoList listDto = new DtoList();
listDto.Emplist = new List <DTOClass>();
EmpEntityList emp = Obj.GetAllDetails();
foreach (var data in emp.Emplist)
{
DTOClass dt = new DTOClass
{
Id = data.Id,
Name = data.Name,
DesgnationId = data.DesgnationId,
Designation = data.Designation,
Gender = data.Gender,
DepartmentId = data.DepartmentId,
Department = data.Department,
Experience = data.Experience,
Skills = data.Skills,
EmailId = data.EmailId,
ContactNo = data.ContactNo,
SupervisorId = data.SupervisorId,
Supervisor = data.Supervisor,
DateOfBirth = data.DateOfBirth,
Address = data.Address,
InsertedBy = data.InsertedBy,
InsertedOn = data.InsertedOn,
UpdatedBy = data.UpdatedBy,
UpdatedOn = data.UpdatedOn
};
listDto.Emplist.Add(dt);
}
listDto.DesnList = new List <LookupDTO>();
foreach (var data in emp.DesnList)
{
LookupDTO desgObj = new LookupDTO()
{
Id = data.Id,
Name = data.Name
};
listDto.DesnList.Add(desgObj);
}
listDto.DeptList = new List <LookupDTO>();
foreach (var data in emp.DeptList)
{
LookupDTO deptObj = new LookupDTO()
{
Id = data.Id,
Name = data.Name
};
listDto.DeptList.Add(deptObj);
}
listDto.SupervisorList = new List <DTOClass>();
int c = emp.SupervisorList.Count();
foreach (var data in emp.SupervisorList)
{
DTOClass superObj = new DTOClass()
{
Id = data.Id,
Supervisor = data.Supervisor
};
listDto.SupervisorList.Add(superObj);
}
return(listDto);
}
catch
{
return(null);
}
}
