public HttpResponseMessage createEmployeetrip([FromBody] EmptripsModel objEmptripsModel)
{
var re = Request;
var headers = re.Headers;
if (headers.Contains("token"))
{
token = headers.GetValues("token").First();
}
var result = Authtoken.checkToken(token);
if (result == true)
{
userId = objEmptripsModel.userId;
dt = objLoginDL.selectbyUserId(userId);
objEmptripsModel.userIdfk = Convert.ToInt16(dt.Rows[0]["id"].ToString());
objEmptripsModel.tripstatus = 1;
dt2 = objEmptripsDL.getemptripscount();
dt2.Columns.Add("emptripId", typeof(System.Int32));
int emptripId = objEmptripsDL.insert_starttrip(objEmptripsModel);
foreach (DataRow row in dt2.Rows)
{
//need to set value to NewColumn
row["emptripId"] = emptripId;
}
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Your trip started succesfully", output = dt2, statuscode = Convert.ToInt16(HttpStatusCode.OK), error = false
});
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 endEmployeetrip([FromBody] EmptripsModel objEmptripsModel)
{
var re = Request;
var headers = re.Headers;
if (headers.Contains("token"))
{
token = headers.GetValues("token").First();
}
var result = Authtoken.checkToken(token);
if (result == true)
{
userId = objEmptripsModel.userId;
dt = objLoginDL.selectbyUserId(userId);
objEmptripsModel.tripstatus = 2;
objEmptripsDL.insert_endttrip(objEmptripsModel);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Your trip ended succesfully", statuscode = Convert.ToInt16(HttpStatusCode.OK), error = false
});
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 insert_starttrip(EmptripsModel objEmptripsModel)
{
try
{
return(Execution.ExecuteNonQuery_with_result("sp_emptrips", new SqlParameter[]
{
new SqlParameter("@Command", "STARTTRIP"),
new SqlParameter("@startLatitude", objEmptripsModel.startLatitude),
new SqlParameter("@startLongitude", objEmptripsModel.startLongititude),
new SqlParameter("@startAddress", objEmptripsModel.startAddress),
new SqlParameter("@triptype", objEmptripsModel.triptype),
new SqlParameter("@tripstatus", objEmptripsModel.tripstatus),
new SqlParameter("@useridFk", objEmptripsModel.userIdfk),
new SqlParameter("@usertype", objEmptripsModel.userType),
new SqlParameter("@status", 1),
}));
}
catch (Exception ex)
{
throw ex;
}
}
public int insert_endttrip(EmptripsModel objEmptripsModel)
{
try
{
return(Execution.ExecuteNonQuery_with_result("sp_emptrips", new SqlParameter[]
{
new SqlParameter("@Command", "ENDTRIP"),
new SqlParameter("@emptripId", objEmptripsModel.emptripId),
new SqlParameter("@endLatitude", objEmptripsModel.endLatitude),
new SqlParameter("@endLongitude", objEmptripsModel.endLongitude),
new SqlParameter("@isemergencystop", objEmptripsModel.isemergencystop),
new SqlParameter("@endAddress", objEmptripsModel.endAddress),
new SqlParameter("@tripstatus", objEmptripsModel.tripstatus),
}));
}
catch (Exception ex)
{
throw ex;
}
}
