public async Task <List <ContactEmployeeDTO> > GetContactDetails(string ConnectionString)
{
lstContactEmployeeDTO = new List <ContactEmployeeDTO>();
await Task.Run(() =>
{
try
{
string Query = "select t1.contactid,t1.contactreferenceid,t2.tbl_mst_employee_id,coalesce(t2.role_id,0) as roleid,t1.name,(select rolename from tblmstemployeerole where roleid=t2.role_id) from tblmstcontact t1 join tbl_mst_employee t2 on t1.contactid=t2.contact_id where t1.statusid=1 and t1.contactreferenceid not in(select coalesce(contactrefid,'') as contactrefid from tblmstusers);";
//string Query = "select x.*,coalesce(y.rolename,'') as rolename,coalesce(y.roleid,0) as roleid from (select t1.contactid,t1.contactreferenceid,t2.employeeid,t2.name from tblmstcontact t1 join tblmstemployee t2 on t1.contactid=t2.contactid where t1.statusid=" + Convert.ToInt32(Status.Active) + ") x join tblmstemployeeemploymentdetails y on x.employeeid=y.employeeid where x.contactreferenceid not in(select coalesce(contactrefid,'') as contactrefid from tblmstusers);";
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, Query))
{
while (dr.Read())
{
ContactEmployeeDTO ContactEmployeeDTO = new ContactEmployeeDTO();
ContactEmployeeDTO.pContactID = Convert.ToInt64(dr["contactid"]);
ContactEmployeeDTO.pContactRefID = dr["contactreferenceid"].ToString();
ContactEmployeeDTO.pEmployeeid = Convert.ToInt64(dr["tbl_mst_employee_id"]);
ContactEmployeeDTO.pEmployeeName = dr["name"].ToString();
ContactEmployeeDTO.pRoleid = Convert.ToInt64(dr["roleid"]);
ContactEmployeeDTO.pRoleName = Convert.ToString(dr["rolename"]);
lstContactEmployeeDTO.Add(ContactEmployeeDTO);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(lstContactEmployeeDTO);
}
public async Task <ContactEmployeeDTO> ViewEmployeeContactDetails(string refernceid)
{
try
{
ContactEmployeeDTO EmployeeDTO = new ContactEmployeeDTO();
EmployeeDTO = await obj.GetEmployeedeatils(Con, refernceid);
return(EmployeeDTO);
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
}
public IActionResult SaveContactEmployee([FromBody] ContactEmployeeDTO EmployeeDTO)
{
try
{
if (obj.SaveContactEmployee(Con, EmployeeDTO))
{
return(Ok(true));
}
else
{
return(StatusCode((int)HttpStatusCode.NotModified));
}
}
catch (Exception ex)
{
throw new FinstaAppException(ex.ToString());
}
}
