public Int64 SubmitRiderPickUpOnDB(SubmitRiderPickupRequestDto dto) { try { Logger.Info("Just entered SubmitRiderPickUpOnDB function " + dto.RiderName); var dateRegistered = DateTime.Now.ToString(); using (var db = new EOneContext()) { Int64 a = 0; Logger.Info("***About to call stored procedure dbo.submit_rider_pickup_request, with values Email Address " + dto.RiderName + " QRCode " + dto.QrCode); var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "dbo.submit_rider_pickup_request"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@qrCode", dto.QrCode.Trim())); cmd.Parameters.Add(new SqlParameter("@riderName", dto.RiderName.Trim())); try { Logger.Info("Opening the connection, for rider" + dto.RiderName); ((IObjectContextAdapter)db).ObjectContext.Connection.Open(); a = Convert.ToInt64(cmd.ExecuteNonQuery()); Logger.Info(dto.RiderName + " Rider pickup request was successfully submitted, Number of Rows Affected is " + a); } catch (Exception ex) { Logger.Info("Entered an exeption code block when calling stored procedure dbo.submit_rider_pickup_request " + dto.RiderName); Logger.Error(ex); return(-1); } finally { Logger.Info("Closing the connection to the EOne DB after insertion " + dto.RiderName); db.Database.Connection.Close(); } Logger.Info("About to return Id afer submitting Rider pickup request " + dto.RiderName); return(a); } } catch (Exception ex) { Logger.Error("SubmitRiderPickUpOnDB function entered an exception " + dto.RiderName); Logger.Error(ex); return(-1); } }
public ResponseDto SubmitRiderPickUp(SubmitRiderPickupRequestDto dto) { try { Logger.Info("Just entered SubmitRiderPickUp Function " + dto.RiderName); var ResponseDto = new ResponseDto(); if (string.IsNullOrEmpty(dto.QrCode)) { ResponseDto.StatusCode = 1006; ResponseDto.Error = "QRCode value cannot be empty"; ResponseDto.Message = ""; return(ResponseDto); } if (string.IsNullOrEmpty(dto.RiderName)) { ResponseDto.StatusCode = 1006; ResponseDto.Error = "Rider name cannot be empty"; ResponseDto.Message = ""; return(ResponseDto); } Logger.Info("About to call SubmitRiderPickUpOnDB Function " + dto.RiderName); var resp = SubmitRiderPickUpOnDB(dto); if (resp > 0) { ResponseDto.StatusCode = 1000; ResponseDto.Error = ""; ResponseDto.Message = "Rider pickup request was submitted successfully"; return(ResponseDto); } else { ResponseDto.StatusCode = 1001; ResponseDto.Error = "Sorry, Rider pickup request could not be submitted at the moment"; ResponseDto.Message = ""; return(ResponseDto); } } catch (Exception ex) { Logger.Error(ex); Logger.Info("SubmitRiderPickUp function entered an exception " + dto.RiderName); return(null); } }
public HttpResponseMessage SubmitRiderPickupRequest(SubmitRiderPickupRequestDto dto) { if (!ModelState.IsValid) { var errorList = (from item in ModelState.Values from error in item.Errors select error.ErrorMessage).ToArray(); return(new HttpResponseMessage(HttpStatusCode.BadRequest) { RequestMessage = Request, ReasonPhrase = JsonConvert.SerializeObject(errorList) }); } var resp = courierService.SubmitRiderPickUp(dto); if (resp == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest) { RequestMessage = Request, ReasonPhrase = "" }); } return(Request.CreateResponse(HttpStatusCode.OK, resp, "application/json")); }