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