public HttpResponseMessage GetEmployeeList() { var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, _gtEmployeeGetway.GetIdCasCadeDropDown("SELECT Id,Code AS Name From tbl_EMPLOYEE_HR Order By Id"), formatter)); }
public HttpResponseMessage GetGenderList() { var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, _gtEmployeeGetway.GetIdCasCadeDropDown("SELECT Id,Name From tbl_GENDER_INFO_MST Order By Id"), formatter)); }
public HttpResponseMessage GetEmployeeCode() { var formatter = RequestFormat.JsonFormaterString(); return(Request.CreateResponse(HttpStatusCode.OK, _gtEmployeeGetway.GetIdCasCadeDropDown("Select DISTINCT a.EmpId AS Id,b.Code AS Name from tbl_HR_GLO_PAYREGISTER AS a inner join tbl_HR_GLO_EMPLOYEE AS b ON a.EmpId = b.Id "), formatter)); }