public HttpResponseMessage DeleteEmployeelocations([FromBody] PickuplocModel objPickuplocModel)
{
var re = Request;
var headers = re.Headers;
if (headers.Contains("token"))
{
token = headers.GetValues("token").First();
}
var result = Authtoken.checkToken(token);
if (result == true)
{
objemployeeDL.deletePickuplocation(objPickuplocModel);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "location Deleted 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 GetEmployeelocations([FromBody] PickuplocModel objPickuplocModel)
{
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 = objPickuplocModel.userId;
dt2 = objemployeeDL.getPickupLocationbyuserId(userId);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "ok sucessful", output = dt2, 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 GetPickupLocation([FromBody] PickuplocModel objPickuplocModel)
{
var re = Request;
var headers = re.Headers;
if (headers.Contains("token"))
{
token = headers.GetValues("token").First();
}
//token from user
var result = Authtoken.checkToken(token);
if (result == true)
{
if (objPickuplocModel.idindex == 0)
{
userId = objPickuplocModel.userId;
dt = objLoginDL.selectbyUserId(userId);
int useridfk = Convert.ToInt16(dt.Rows[0]["id"].ToString());
dt1 = objemployeeDL.getindexcount(userId);
objPickuplocModel.idindex = Convert.ToInt16(dt1.Rows[0]["count"].ToString()) + 1;
objPickuplocModel.userid = useridfk;
objemployeeDL.getPickuplocation(objPickuplocModel);
dt2 = objemployeeDL.getPickupLocationbyuserId(userId);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Pickup Location Added sucessfully", output = dt2, statuscode = Convert.ToInt16(HttpStatusCode.OK)
});
return(resp);
}
else
{
objemployeeDL.updatePickuplocation(objPickuplocModel);
var resp = Request.CreateResponse <ResponseModel>(HttpStatusCode.OK,
new ResponseModel()
{
message = "Pickup Location Updated sucessfully", output = dt2, 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 deletePickuplocation(PickuplocModel objPickuplocModel)
{
try
{
return(Execution.ExecuteNonQuery_with_result("sp_pickuplocation", new SqlParameter[]
{
new SqlParameter("@Command", "DELETELOCATION"),
new SqlParameter("@userid1", objPickuplocModel.userId),
new SqlParameter("@idindex", objPickuplocModel.idindex)
}));
}
catch (Exception ex)
{
throw ex;
}
}
public int updatePickuplocation(PickuplocModel objPickuplocModel)
{
try
{
return(Execution.ExecuteNonQuery_with_result("sp_pickuplocation", new SqlParameter[]
{
new SqlParameter("@Command", "UPDATELOCATION"),
new SqlParameter("@pickuplat", objPickuplocModel.pickuplat),
new SqlParameter("@pickuplong", objPickuplocModel.pickuplong),
new SqlParameter("@pickupaddress", objPickuplocModel.pickupaddress),
new SqlParameter("@placename", objPickuplocModel.placename),
new SqlParameter("@userid1", objPickuplocModel.userId),
new SqlParameter("@idindex", objPickuplocModel.idindex)
}));
}
catch (Exception ex)
{
throw ex;
}
}
public int getPickuplocation(PickuplocModel objPickuplocModel)
{
try
{
return(Execution.ExecuteNonQuery_with_result("sp_pickuplocation", new SqlParameter[]
{
new SqlParameter("@Command", "INSERT"),
new SqlParameter("@pickuplat", objPickuplocModel.pickuplat),
new SqlParameter("@pickuplong", objPickuplocModel.pickuplong),
new SqlParameter("@pickupaddress", objPickuplocModel.pickupaddress),
new SqlParameter("@placename", objPickuplocModel.placename),
new SqlParameter("@userid", objPickuplocModel.userid),
new SqlParameter("@idindex", objPickuplocModel.idindex),
new SqlParameter("@status", 1)
}));
}
catch (Exception ex)
{
throw ex;
}
}
