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