public Int64 SubmitMailroomPickUpOnDB(SubmitMailroomPickupRequestDto dto) { try { Logger.Info("Just entered SubmitMailroomPickUpOnDB function " + dto.MailRoomName); var dateRegistered = DateTime.Now.ToString(); using (var db = new EOneContext()) { Int64 a = 0; Logger.Info("***About to call stored procedure dbo.submit_mailroom_pickup_request, with values Email Address " + dto.MailRoomName + " QRCode " + dto.QrCode); var cmd = db.Database.Connection.CreateCommand(); cmd.CommandText = "dbo.submit_mailroom_pickup_request"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@qrCode", dto.QrCode.Trim())); cmd.Parameters.Add(new SqlParameter("@mailRoomName", dto.MailRoomName.Trim())); try { Logger.Info("Opening the connection, for mailroom officer" + dto.MailRoomName); ((IObjectContextAdapter)db).ObjectContext.Connection.Open(); a = Convert.ToInt64(cmd.ExecuteNonQuery()); Logger.Info(dto.MailRoomName + " Mailroom 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_mailroom_pickup_request " + dto.MailRoomName); Logger.Error(ex); return(-1); } finally { Logger.Info("Closing the connection to the EOne DB after insertion " + dto.MailRoomName); db.Database.Connection.Close(); } Logger.Info("About to return Id afer submitting Mailroom officer pickup request " + dto.MailRoomName); return(a); } } catch (Exception ex) { Logger.Error("SubmitMailroomPickUpOnDB function entered an exception " + dto.MailRoomName); Logger.Error(ex); return(-1); } }
public ResponseDto SubmitMailroomPickUp(SubmitMailroomPickupRequestDto dto) { try { Logger.Info("Just entered SubmitMailroomPickUp Function " + dto.MailRoomName); 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.MailRoomName)) { ResponseDto.StatusCode = 1006; ResponseDto.Error = "Mailroom officer name cannot be empty"; ResponseDto.Message = ""; return(ResponseDto); } Logger.Info("About to call SubmitMailroomPickUpOnDB Function " + dto.MailRoomName); var resp = SubmitMailroomPickUpOnDB(dto); if (resp > 0) { ResponseDto.StatusCode = 1000; ResponseDto.Error = ""; ResponseDto.Message = "Mailroom pickup request was submitted successfully"; return(ResponseDto); } else { ResponseDto.StatusCode = 1001; ResponseDto.Error = "Sorry, Mailroom pickup request could not be submitted at the moment"; ResponseDto.Message = ""; return(ResponseDto); } } catch (Exception ex) { Logger.Error(ex); Logger.Info("SubmitMailroomPickUp function entered an exception " + dto.MailRoomName); return(null); } }
public HttpResponseMessage SubmitMailroomPickupRequest(SubmitMailroomPickupRequestDto 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.SubmitMailroomPickUp(dto); if (resp == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest) { RequestMessage = Request, ReasonPhrase = "" }); } return(Request.CreateResponse(HttpStatusCode.OK, resp, "application/json")); }