public ActionResult GetWhitePagesDetails(string cai) { com.chevron.ctpeople.getpeople ws = new TSDTReports.com.chevron.ctpeople.getpeople(); List <string> subList = new List <string>(); try { var test = ws.dsGetPersonByCAI(cai).Tables[0].Rows[0]; var jsondata = new { WhitePagesDetails = ( new { firstname = test.ItemArray[6], surname = test.ItemArray[8] } ) }; return(Json(jsondata)); } catch { return(Json(new { Status = false, Message = "Fail" })); } }
public ActionResult GetUserEmployees(string cai) { string Surname = ""; try { com.chevron.ctpeople.getpeople ws = new TSDTReports.com.chevron.ctpeople.getpeople(); var test = ws.dsGetPersonByCAI(cai).Tables[0].Rows[0]; Surname = test.ItemArray[8].ToString(); } catch { return(Json(new { Status = false, Message = "This user does not exist in WhitePages" })); } try { var jsondata = new { employees = ( from e in sacodb.EmployeeList(Surname.Trim()) select new { employee_number = e.EmployeeNumber, employee_surname = e.Surname, employee_firstname = e.FirstName, employee_company = e.Company.Name, employee_companyid = e.CompanyId } ) }; return(Json(jsondata)); } catch (Exception ex) { return(Json(new { Status = false, Message = "This user does not exist in Saco" })); } }
public ActionResult GetWhitePagesDetails(string cai) { com.chevron.ctpeople.getpeople ws = new TSDTReports.com.chevron.ctpeople.getpeople(); List<string> subList = new List<string>(); try { var test = ws.dsGetPersonByCAI(cai).Tables[0].Rows[0]; var jsondata = new { WhitePagesDetails = ( new { firstname = test.ItemArray[6], surname = test.ItemArray[8] } ) }; return Json(jsondata); } catch { return Json(new { Status = false, Message = "Fail" }); } }
public ActionResult GetUserEmployees(string cai) { string Surname = ""; try { com.chevron.ctpeople.getpeople ws = new TSDTReports.com.chevron.ctpeople.getpeople(); var test = ws.dsGetPersonByCAI(cai).Tables[0].Rows[0]; Surname = test.ItemArray[8].ToString(); } catch { return Json(new { Status = false, Message = "This user does not exist in WhitePages" }); } try { var jsondata = new { employees = ( from e in sacodb.EmployeeList(Surname.Trim()) select new { employee_number = e.EmployeeNumber, employee_surname = e.Surname, employee_firstname = e.FirstName, employee_company = e.Company.Name, employee_companyid = e.CompanyId } ) }; return Json(jsondata); } catch (Exception ex) { return Json(new { Status = false, Message = "This user does not exist in Saco" }); } }