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()); } }