public HttpResponseMessage employeeList([FromBody] ComplaintsModel objComplaintsModel)
{
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 = objComplaintsDL.getdrivercomplaintlist(objComplaintsModel);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "complaint added successfully", 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 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 login([FromBody] LoginModel loginm)
{
IP = System.Configuration.ConfigurationManager.AppSettings["IP"];
DataTable dt1 = new DataTable();
var result = objAuthorization.checkToken(loginm.token);
//for token
dt1 = objloginDL.checkUser(loginm);
//checking mobile and pin
if (dt1.Rows.Count > 0)
{
//Getting usertype
usertype = dt1.Rows[0]["userType"].ToString();
userid = dt1.Rows[0]["userId"].ToString();
token = dt1.Rows[0]["token"].ToString();
loginm.userId = userid;
result = objAuthorization.checkDevicekey(userid, loginm.devicekey);
if (result == false)
{
loginm.useridFK = Convert.ToInt16(dt1.Rows[0]["id"].ToString());
objloginDL.insert_DeicviceDetails(loginm);
}
dt2 = objAuthorization.usertype(usertype, dt1);
dt2.Columns.Add("token", typeof(System.String));
foreach (DataRow row in dt2.Rows)
{
//need to set value to NewColumn column
row["token"] = token;
row["profilePic"] = IP + dt2.Rows[0]["profilePic"].ToString();
}
resp = Request.CreateResponse <ResponseModel>(
HttpStatusCode.OK,
new ResponseModel()
{
message = "login sucessfull", output = dt2, statuscode = Convert.ToInt16(HttpStatusCode.OK)
}
);
resp.Headers.Add("token", token);
return(resp);
}
else
{
resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Mobile or Pin Wrong", error = true, statuscode = Convert.ToInt16(HttpStatusCode.OK)
});
return(resp);
}
}
public HttpResponseMessage employeeList([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)
{
dt = objSupervisorDL.getEmployesbyRoute(objRouteAssighnmentModel);
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 HttpResponseMessage createDrivertrip([FromBody] DriverTripsModel objDrivertripsModel)
{
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.Columns.AddRange(new DataColumn[1] {
new DataColumn("drivertripid", typeof(int))
});
int drivertripid = objDrivertripsDL.insert_starttrip(objDrivertripsModel);
// dt.Columns.Add("drivertripid", typeof(System.Int16));
DataRow dr = dt.NewRow();
dr["drivertripid"] = drivertripid; // or dr[0]="Mohammad";
// or dr[1]=24;
dt.Rows.Add(dr);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "your trip started successfully", output = dt, 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 createRoutes([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)
{
dt = objRouteDL.getroutes(objRouteAssighnmentModel[0].routeName);
if (dt.Rows.Count > 0)
{
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "already created this route", statuscode = Convert.ToInt16(HttpStatusCode.OK)
});
return(resp);
}
else
{
int routeid = objRouteDL.insert_Routenames(objRouteAssighnmentModel[0]);
for (int i = 0; i < objRouteAssighnmentModel.Length; i++)
{
objRouteAssighnmentModel[i].routeid = routeid;
objRouteDL.insert_Assighnment(objRouteAssighnmentModel[i]);
}
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "route Created sucessfully", 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 Registervehicle([FromBody] VehicleModel objvehicleModel)
{
if (objvehicleModel.token == null)
{
//token from user
var token = objvehicleModel.token;
//checking Token
var result = Authtoken.checkToken(token);
if (result == true)
{
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "no token", statuscode = Convert.ToInt16(HttpStatusCode.NoContent)
});
return(resp);
}
else
{
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel()
{
message = "UnAuthorized", statuscode = Convert.ToInt16(HttpStatusCode.NoContent)
});
return(resp);
}
}
else
{
objVehicleDL.insert_vehicleDetails(objvehicleModel);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Vehicle Register sucessfully", statuscode = Convert.ToInt16(HttpStatusCode.OK)
});
return(resp);
}
}
public HttpResponseMessage create_sosAlert(SosAlertsModel objSosAlertsModel)
{
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 = objSosAlertsModel.userId;
dt = objLoginDL.selectbyUserId(userId);
objSosAlertsModel.userIdfk = Convert.ToInt16(dt.Rows[0]["id"].ToString());
objSosAlertsDL.insert_SosAlert(objSosAlertsModel);
resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Your sos details saved succesfully", output = dt2, statuscode = Convert.ToInt16(HttpStatusCode.OK), error = false
});
return(resp);
}
else
{
resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK, new ResponseModel()
{
message = "UnAuthorized", statuscode = Convert.ToInt16(HttpStatusCode.OK), error = true
});
return(resp);
}
}
public HttpResponseMessage registerDriver([FromBody] DriverModel driverm)
{
// token from user
var token = driverm.token;
//checking Token
var result = Authtoken.checkToken(token);
if (result == true)
{
var Mobileexist = Authtoken.checkmobile(driverm.mobile);
if (Mobileexist == false)
{
/*---------------------------------------------------------------------------
* Inserting Login Details
* --------------------------------------------------------------------------
*/
dt = objDriverDl.getDriverscount();
objloginModel.mobile = driverm.mobile;
objloginModel.pin = driverm.pin;
objloginModel.token = Authtoken.genarateToken();
objloginModel.userId = Authtoken.genarateUserId();
objloginModel.driverId = Convert.ToInt16(dt.Rows[0]["drivercount"].ToString()) + 1;;
objloginModel.userType = "driver";
objDriverDl.insert_loginDetails(objloginModel);
/*---------------------------------------------------------------
* Insert Drivers Details
*---------------------------------------------------------------
*/
driverm.userid = Authtoken.usercount() + 1;
objDriverDl.insert_DriverDetails(driverm);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Driver Register Succesfully", statuscode = Convert.ToInt16(HttpStatusCode.OK)
}
);
return(resp);
}
else
{
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Already This Mobileno Registered", statuscode = Convert.ToInt16(HttpStatusCode.OK)
}
);
return(resp);
}
}
else
{
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "no token", statuscode = Convert.ToInt16(HttpStatusCode.NoContent)
});
return(resp);
}
}
public HttpResponseMessage login([FromBody] LoginModel loginm)
{
con.Close();
// SqlCommand cmd = new SqlCommand("select * from Tbl_Driver", con);
loginm.token = "ab0d80c5-df50-4068-8e28-79adf41f74f7";
var token = loginm.token;
var mobile = loginm.mobile;
var pin = loginm.pin;
SqlCommand cmd = new SqlCommand("select token from login where token='" + token + "'", con);
con.Close();
SqlDataAdapter data = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
data.Fill(dt);
AuthorizationToken onj = new AuthorizationToken();
var result = onj.checkToken(token);
if (result == true)
{
}
else
{
}
if (dt.Rows.Count > 0)
{
con.Open();
SqlCommand cmd1 = new SqlCommand("select * from login where mobile='" + mobile + "' and pin='" + pin + "'", con);
SqlDataAdapter data1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
con.Close();
data1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
string usertype = dt1.Rows[0]["userType"].ToString();
// string token;
if (usertype == "supervisor")
{
int sp1 = Convert.ToInt16(dt1.Rows[0]["supervisorId"].ToString());
con.Open();
SqlCommand cmd3 = new SqlCommand("select * from supervisor where superVisorId='" + sp1 + "'", con);
SqlDataAdapter data3 = new SqlDataAdapter(cmd3);
DataTable dt3 = new DataTable();
con.Close();
data3.Fill(dt3);
var resp = Request.CreateResponse <LoginResponseModel>(
HttpStatusCode.OK,
new LoginResponseModel()
{
message = "login sucessfull", token = token, output1 = dt3, statuscode = Convert.ToInt16(HttpStatusCode.OK)
}
);
return(resp);
}
var resp3 = Request.CreateResponse <LoginResponseModel>(
HttpStatusCode.OK,
new LoginResponseModel()
{
message = "login sucessfull", output1 = dt1
}
);
return(resp3);
}
else
{
var resp3 = Request.CreateResponse <LoginResponseModel>(
HttpStatusCode.OK,
new LoginResponseModel()
{
message = "Mobile or Pin Wrong", statuscode = Convert.ToInt16(HttpStatusCode.OK)
}
);
return(resp3);
}
}
else
{
var resp1 = Request.CreateResponse <LoginResponseModel>(
HttpStatusCode.OK,
new LoginResponseModel()
{
message = "unauthorized"
}
);
return(resp1);
}
// var msf = db.Tbl_Driver.AsEnumerable();
}
public HttpResponseMessage CreateEmployee([FromBody] EmployeeModel objEmployee)
{
//token from user
var token = objEmployee.token;
//checking Token
var result = Authtoken.checkToken(token);
if (result == true)
{
var Mobileexist = Authtoken.checkmobile(objEmployee.mobile);
if (Mobileexist == false)
{
//-----------------------------------------------------------------------------
// |> Inserting Employee Details <|
//-------------------------------------------------------------------------------
dt = objemployeeDL.getEmployescount();
objEmployee.pin = Authtoken.GeneratePin();
objEmployee.mobile = objEmployee.mobile;
objEmployee.token = Authtoken.genarateToken();
objEmployee.userId = Authtoken.genarateUserId();
//objEmployee.empId = Convert.ToInt16(dt.Rows[0]["empcount"].ToString())+1;
objEmployee.usertype = "employee";
//objemployeeDL.insert_loginDetails(objloginModel);
//-------------------------------------------------------------------------------
// |> Inserting Login Details <|
//-------------------------------------------------------------------------------
objEmployee.useridfk = Authtoken.usercount() + 1;
objemployeeDL.insert_EmployeeDetails(objEmployee);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Employee created sucessfully", statuscode = Convert.ToInt16(HttpStatusCode.OK)
});
return(resp);
}
else
{
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Already This Mobile no Registered", 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);
}
}
