public HttpResponseMessage addemployee([FromBody] RouteAssighnmentModel objRouteAssighnmentModel) { var re = Request; var headers = re.Headers; if (headers.Contains("token")) { token = headers.GetValues("token").First(); } var result = Authtoken.checkToken(token); if (result == true) { int result1 = objSupervisorDL.addemployeetoroute(objRouteAssighnmentModel); var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "Employee Location added successfully", statuscode = Convert.ToInt16(HttpStatusCode.OK) }); return(resp); } else { var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "UnAuthorized", statuscode = Convert.ToInt16(HttpStatusCode.OK), error = true }); return(resp); } }
public HttpResponseMessage routeList([FromBody] RouteAssighnmentModel objRoutenamesModel) { var re = Request; var headers = re.Headers; if (headers.Contains("token")) { token = headers.GetValues("token").First(); } var result = Authtoken.checkToken(token); if (result == true) { dt = objRouteAssignmentDL.GeroutesforDriver(objRoutenamesModel); var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "ok successful", output = dt, statuscode = Convert.ToInt16(HttpStatusCode.OK) }); return(resp); } else { var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "UnAuthorized", statuscode = Convert.ToInt16(HttpStatusCode.OK), error = true }); return(resp); } }
public DataTable GeroutesforDriver(RouteAssighnmentModel objRoutenamesModel) { try { return(Execution.ExecuteParamerizedSelectCommand("sp_routeallocation", new SqlParameter[] { new SqlParameter("@Command", "GETROUTESFORDRIVER"), new SqlParameter("@driverid", objRoutenamesModel.driverid), })); } catch (Exception ex) { throw ex; } }
public DataTable getEmployesbyRoute(RouteAssighnmentModel objRouteAssighnmentModel) { try { return(Execution.ExecuteParamerizedSelectCommand("sp_routeallocation", new SqlParameter[] { new SqlParameter("@Command", "GETROUTEUPDATE"), new SqlParameter("@shiftid", objRouteAssighnmentModel.shiftid), new SqlParameter("@routeid", objRouteAssighnmentModel.routeid), })); } catch (Exception ex) { throw ex; } }
public int insert_Routenames(RouteAssighnmentModel objRoutenamesModel) { try { return(Execution.ExecuteNonQuery_with_result("sp_routeallocation", new SqlParameter[] { new SqlParameter("@Command", "INSERTROUTE"), new SqlParameter("@routeName", objRoutenamesModel.routeName), new SqlParameter("@status", 1), })); } catch (Exception ex) { throw ex; } }
public HttpResponseMessage trackcabs([FromBody] RouteAssighnmentModel objRouteAssighnmentModel) { var re = Request; var headers = re.Headers; if (headers.Contains("token")) { token = headers.GetValues("token").First(); } var result = Authtoken.checkToken(token); if (result == true) { DataSet ds = new DataSet(); dt = objRouteAssignmentDL.getfemaleroutes(); dt1 = objRouteAssignmentDL.getstartedroutes(); dt2 = objRouteAssignmentDL.getidleroutes(); ds.Merge(dt); ds.Merge(dt1); ds.Merge(dt2); ds.Tables[0].TableName = "femalecabs"; ds.Tables[1].TableName = "startedcabs"; ds.Tables[2].TableName = "idlecabs"; var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "ok successfull", output = ds, statuscode = Convert.ToInt16(HttpStatusCode.OK) }); return(resp); } else { var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel() { message = "UnAuthorized", statuscode = Convert.ToInt16(HttpStatusCode.OK), error = true }); return(resp); } }
public int updateemployeetoroute(RouteAssighnmentModel objRouteAssighnmentModel) { try { return(Execution.ExecuteNonQuery_with_result("sp_routeallocation", new SqlParameter[] { new SqlParameter("@Command", "UPDATEASSIGNROUTE"), new SqlParameter("@actionstatus", objRouteAssighnmentModel.actionstatus), new SqlParameter("@routeid", objRouteAssighnmentModel.routeid), new SqlParameter("@empId", objRouteAssighnmentModel.empid), new SqlParameter("@shiftid", objRouteAssighnmentModel.shiftid), })); } catch (Exception ex) { throw ex; } }
public int removeemployeetoroute(RouteAssighnmentModel objRouteAssighnmentModel) { try { return(Execution.ExecuteNonQuery_with_result("sp_routeallocation", new SqlParameter[] { new SqlParameter("@Command", "REMOVEASSIGNSTATUS"), new SqlParameter("@routeid", objRouteAssighnmentModel.routeid), new SqlParameter("@empid", objRouteAssighnmentModel.empid), new SqlParameter("@shiftid", objRouteAssighnmentModel.shiftid), new SqlParameter("@status", 1) })); } catch (Exception ex) { throw ex; } }