private void SetValue() { _objVisitRequest = new VisitRequest(); _objVisitRequestBiz = new VisitRequestBiz(); _objVisitRequest = _objVisitRequestBiz.GetVisitRequestDetail(Convert.ToInt32(Request.QueryString["ReqId"]), Request.QueryString["lId"].Trim()); if (_objVisitRequest != null) { PropertyName = CommonBiz.GetSingleString("ams.Properties", "PropertyName", "PropertyId=" + _objVisitRequest.PropertyId); apartmentNo = CommonBiz.GetSingleString("ams.Apartment", "ApartmentNoOrName", "PropertyId=" + _objVisitRequest.PropertyId + " and ApartmentId=" + _objVisitRequest.ApartmentId); lblRequrstedBy.Text = string.IsNullOrEmpty(_objVisitRequest.ClientName) ? "Not Defined" : _objVisitRequest.ClientName; lblClientEmail.Text = string.IsNullOrEmpty(_objVisitRequest.ClientEmail) ? "Not Defined" : _objVisitRequest.ClientEmail; lblClientMobileNo.Text = string.IsNullOrEmpty(_objVisitRequest.ClientMobileNo) ? "Not Defined" : _objVisitRequest.ClientMobileNo; lblRequestedFor.Text = string.IsNullOrEmpty(PropertyName) ? "Not Defined" : PropertyName + " (" + apartmentNo + ")"; txtClientMessage.Text = _objVisitRequest.MessageToLandlord; ViewState["objVisitRequest"] = _objVisitRequest; } else { MessageBox("You already respond this Request!"); HtmlMeta meta = new HtmlMeta(); meta.HttpEquiv = "Refresh"; meta.Content = "3;url=WelcomeUI.aspx"; this.Page.Controls.Add(meta); } }
public bool GetIsAlreadyRequestedForVisit(VisitRequest objVisitRequest) { bool IsAlreadyRequested; objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable); // objDbCommand.AddInOutParameter("ApplicantId", objApplicant.ApplicantId, ParameterDirection.InputOutput, DbType.Int32, 16); objDbCommand.AddInParameter("LandlordId", objVisitRequest.LandlordId); objDbCommand.AddInParameter("PropertyId", objVisitRequest.PropertyId); objDbCommand.AddInParameter("ApartmentId", objVisitRequest.ApartmentId); objDbCommand.AddInParameter("ClientEmail", objVisitRequest.ClientEmail); objDbCommand.AddInParameter("ClientMobileNo", objVisitRequest.ClientMobileNo); try { IsAlreadyRequested = (bool)objDataAccess.ExecuteScalar(objDbCommand, "ams.uspIsAlreadyRequestedForVisit", CommandType.StoredProcedure); } catch (Exception ex) { objDbCommand.Transaction.Rollback(); throw new Exception("Database Error Occured", ex); } finally { objDataAccess.Dispose(objDbCommand); } return IsAlreadyRequested; }
public async Task <IActionResult> PutVisitRequest([FromRoute] int id, [FromBody] VisitRequest visitRequest) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != visitRequest.VisitId) { return(BadRequest()); } _context.Entry(visitRequest).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!VisitRequestExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult> Create(int petId, [FromBody] VisitRequest visitRequest, CancellationToken cancellationToken) { _logger.LogInformation($"Received {visitRequest}"); var visit = new Visit(petId, visitRequest.VisitDate, visitRequest.Description); var newVisit = await _visitsRepo.SaveAsync(petId, visit, cancellationToken); return(Created($"owners/pets/{petId}/visits", VisitDetails.FromVisit(newVisit))); }
public async Task <IActionResult> PostVisitRequest([FromBody] VisitRequest visitRequest) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.VisitRequest.Add(visitRequest); await _context.SaveChangesAsync(); return(CreatedAtAction("GetVisitRequest", new { id = visitRequest.VisitId }, visitRequest)); }
public void SendVisitRequest(VisitRequestDto visitRequest) { var request = new VisitRequest { Comment = visitRequest.Comment, DoctorId = visitRequest.Doctor.Id, PatientId = visitRequest.Patient.Id, IsApproved = visitRequest.IsApproved, VisitTime = visitRequest.VisitTime }; _visitRequestRepository.Add(request); ReceiveVisitRequest(visitRequest.Doctor, visitRequest); }
public async Task <ActionResult <string> > Create([FromBody] VisitRequest request) { var user = await DataAccess.Get <User, int>(request.UserId); var entity = await request.ToPersistedData(); entity.AtRisk = user.AtRisk; await entity.Insert(); var riskyVisits = await RiskAccess.GetRiskyVisitsFor(entity); var response = JsonConvert.SerializeObject(riskyVisits); return(new OkObjectResult(response)); }
public int SaveVisitRequest(VisitRequest _objVisitRequest, out int VisitReqId) { var noOfAffacted = 0; objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable); objDbCommand.AddInOutParameter("VisitReqId", _objVisitRequest.VisitReqId, ParameterDirection.InputOutput, DbType.Int32, 16); objDbCommand.AddInParameter("LandlordId", _objVisitRequest.LandlordId); objDbCommand.AddInParameter("PropertyId", _objVisitRequest.PropertyId); objDbCommand.AddInParameter("ApartmentId", _objVisitRequest.ApartmentId); objDbCommand.AddInParameter("ClientName", _objVisitRequest.ClientName); objDbCommand.AddInParameter("ClientEmail", _objVisitRequest.ClientEmail); objDbCommand.AddInParameter("ClientMobileNo", _objVisitRequest.ClientMobileNo); objDbCommand.AddInParameter("MessageToLandlord", _objVisitRequest.MessageToLandlord); objDbCommand.AddInParameter("RequestDate", _objVisitRequest.RequestDate); try { noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "ams.uspInsertVisitRequest", CommandType.StoredProcedure); VisitReqId = Convert.ToInt32(objDbCommand.Parameters["VisitReqId"].Value.ToString()); if (noOfAffacted > 0) { objDbCommand.Transaction.Commit(); return noOfAffacted; } else { objDbCommand.Transaction.Rollback(); return noOfAffacted; } } catch (Exception ex) { objDbCommand.Transaction.Rollback(); throw new Exception("Database Error Occured", ex); } finally { objDataAccess.Dispose(objDbCommand); } }
public Trip AddDestinationToTrip(VisitRequest visitRequest) { var client = new RestClient(baseUrl + $"trips/{visitRequest.TripId}/Visits"); var request = new RestRequest(Method.POST); request.AddHeader("content-type", "application/json"); request.AddJsonBody(visitRequest); var response = client.Execute(request); if (!response.StatusCode.Equals(System.Net.HttpStatusCode.OK)) { //throw new TripAdvisorApiException($"Could not retrieve information from TripAdvisor. Response code: {response.StatusCode}"); } var trip = JsonConvert.DeserializeObject <Trip>(response.Content); return(trip); }
protected void btnAccept_Click(object sender, EventArgs e) { objUserDetail = (UserDetail)SessionUtility.SessionUtility.AmsSessionContainer.OBJ_USER_CLASS; _objVisitRequest = (VisitRequest)ViewState["objVisitRequest"]; _objVisitRequestBiz = new VisitRequestBiz(); int result = 0; if (chkToViewMessageBox.Checked && !string.IsNullOrEmpty(txtMessageToClient.Text.Trim())) { messageToClient = txtMessageToClient.Text.Trim(); } else { messageToClient = "Dear MR. " + _objVisitRequest.ClientName + ", <br/>Thanks for your interest. You are welcome to visit as your request.<br/> Thanks,<br/>" + objUserDetail.FullName; } _objVisitRequest.MessageToClient = messageToClient; _objVisitRequest.IsAccepted = Request.QueryString["isAccept"] == "1" ? true : false; _objVisitRequest.ResponseDate = DateTime.Today; result = _objVisitRequestBiz.UpdateResposeOnVisitRequest(_objVisitRequest); if (result > 0) { _objMessages = new NotificationMessages(); _objMessages.ClassificationID = 5; _objMessages.NotificationTypeID = 1; //Request.Url.GetLeftPart(UriPartial.Authority); _objNotificationBiz = new NotificationBiz(); string body = messageToClient; _objNotificationBiz.SendEmail(_objMessages, _objVisitRequest.ClientEmail, body); ltrlEmailSmsNotificationA.Text = "<span style=\"color: green; font - size: 10pt \">Operation Successful</span>"; } else { ltrlEmailSmsNotificationA.Text = "<span style=\"color: Red; font - size: 10pt \">Operation Failed</span>"; } }
public async Task Save() { var petId = Fill.Visits.First().PetId; var visitRequest = new VisitRequest() { Description = "Another one", VisitDate = DateTime.Now }; var resp = await _client.PostAsJsonAsync($"owners/pets/{petId}/visits", visitRequest); Assert.True(resp.IsSuccessStatusCode); var vist = await resp.Content.ReadFromJsonAsync <VisitDetails>(); Assert.NotNull(vist); Assert.Equal(visitRequest.Description, vist.description); }
public int UpdateResposeOnVisitRequest(VisitRequest _objVisitRequest) { var noOfAffacted = 0; objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable); objDbCommand.AddInParameter("VisitReqId", _objVisitRequest.VisitReqId); objDbCommand.AddInParameter("LandlordId", _objVisitRequest.LandlordId); objDbCommand.AddInParameter("PropertyId", _objVisitRequest.PropertyId); objDbCommand.AddInParameter("ApartmentId", _objVisitRequest.ApartmentId); objDbCommand.AddInParameter("IsAccepted", _objVisitRequest.IsAccepted); objDbCommand.AddInParameter("MessageToClient", _objVisitRequest.MessageToClient); objDbCommand.AddInParameter("ResponseDate", _objVisitRequest.ResponseDate); try { noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "ams.uspUpdateResposeOnVisitRequest", CommandType.StoredProcedure); if (noOfAffacted > 0) { objDbCommand.Transaction.Commit(); return noOfAffacted; } else { objDbCommand.Transaction.Rollback(); return noOfAffacted; } } catch (Exception ex) { objDbCommand.Transaction.Rollback(); throw new Exception("Database Error Occured", ex); } finally { objDataAccess.Dispose(objDbCommand); } }
public VisitRequest GetVisitRequestDetail(int visitReqId, string landlordId) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; VisitRequest objVisitRequest = null; objDbCommand.AddInParameter("VisitReqId", visitReqId); objDbCommand.AddInParameter("LandlordId", landlordId); try { objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "ams.uspGetVisitRequestDetail", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { //DocumentBiz.GetApplicantDocuments(applicantId); while (objDbDataReader.Read()) { objVisitRequest = new VisitRequest(); BuildModel(objDbDataReader, objVisitRequest); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return objVisitRequest; }
private void BuildModel(DbDataReader objDataReader, VisitRequest objVisitRequest) { var objDataTable = objDataReader.GetSchemaTable(); foreach (DataRow dr in objDataTable.Rows) { var column = dr.ItemArray[0].ToString(); switch (column) { case "VisitReqId": if (!Convert.IsDBNull(objDataReader["VisitReqId"])) { objVisitRequest.VisitReqId = Convert.ToInt32(objDataReader["VisitReqId"].ToString()); } break; case "PropertyId": if (!Convert.IsDBNull(objDataReader["PropertyId"])) { objVisitRequest.PropertyId = Convert.ToInt32(objDataReader["PropertyId"].ToString()); } break; case "LandlordId": if (!Convert.IsDBNull(objDataReader["LandlordId"])) { objVisitRequest.LandlordId = objDataReader["LandlordId"].ToString(); } break; case "ApartmentId": if (!Convert.IsDBNull(objDataReader["ApartmentId"])) { objVisitRequest.ApartmentId = Convert.ToInt32(objDataReader["ApartmentId"].ToString()); } break; case "ClientName": if (!Convert.IsDBNull(objDataReader["ClientName"])) { objVisitRequest.ClientName = objDataReader["ClientName"].ToString(); } break; case "ClientEmail": if (!Convert.IsDBNull(objDataReader["ClientEmail"])) { objVisitRequest.ClientEmail = objDataReader["ClientEmail"].ToString(); } break; case "ClientMobileNo": if (!Convert.IsDBNull(objDataReader["ClientMobileNo"])) { objVisitRequest.ClientMobileNo = objDataReader["ClientMobileNo"].ToString(); } break; case "MessageToLandlord": if (!Convert.IsDBNull(objDataReader["MessageToLandlord"])) { objVisitRequest.MessageToLandlord = objDataReader["MessageToLandlord"].ToString(); } break; case "MessageToClient": if (!Convert.IsDBNull(objDataReader["MessageToClient"])) { objVisitRequest.MessageToClient = objDataReader["MessageToClient"].ToString(); } break; case "RequestDate": if (!Convert.IsDBNull(objDataReader["RequestDate"])) { objVisitRequest.RequestDate = Convert.ToDateTime(objDataReader["RequestDate"]); } break; case "ResponseDate": if (!Convert.IsDBNull(objDataReader["ResponseDate"])) { objVisitRequest.ResponseDate = Convert.ToDateTime(objDataReader["ResponseDate"]); } break; case "EntryDate": if (!Convert.IsDBNull(objDataReader["EntryDate"])) { objVisitRequest.EntryDate = Convert.ToDateTime(objDataReader["EntryDate"]); } break; case "EntryBy": if (!Convert.IsDBNull(objDataReader["EntryBy"])) { objVisitRequest.EntryBy = objDataReader["EntryBy"].ToString(); } break; case "UpdateDate": if (!Convert.IsDBNull(objDataReader["UpdateDate"])) { objVisitRequest.UpdateDate = Convert.ToDateTime(objDataReader["UpdateDate"]); } break; case "UpdateBy": if (!Convert.IsDBNull(objDataReader["UpdateBy"])) { objVisitRequest.UpdateBy = objDataReader["UpdateBy"].ToString(); } break; default: break; } } objVisitRequest.IsNew = false; objVisitRequest.IsDirty = true; objVisitRequest.IsDelete = false; }
protected void btnSendVisitReq_Click(object sender, EventArgs e) { string landloardEmail; int result = 0, VisitReqId; bool isAlreadyRequestedForVisit; _objVisitRequestBiz = new VisitRequestBiz(); if (Request.QueryString["lId"] != null && Request.QueryString["apId"] != null && Request.QueryString["ppId"] != null) { _objVisitRequest = new VisitRequest(); landloardEmail = GetLandloardEmail(Request.QueryString["lId"]); _objVisitRequest.PropertyId = Convert.ToInt32(Request.QueryString["ppId"]); _objVisitRequest.LandlordId = Request.QueryString["lId"].Trim(); _objVisitRequest.ApartmentId = Convert.ToInt32(Request.QueryString["apId"]); _objVisitRequest.ClientEmail = txtClientEmail.Text.Trim(); _objVisitRequest.ClientMobileNo = txtClientMobileNo.Text.Trim(); _objVisitRequest.ClientName = txtClientName.Text.Trim(); _objVisitRequest.MessageToLandlord = txtVisitReqMessage.Text.Trim(); _objVisitRequest.RequestDate = DateTime.Today; isAlreadyRequestedForVisit = _objVisitRequestBiz.GetIsAlreadyRequestedForVisit(_objVisitRequest); if (!isAlreadyRequestedForVisit) { result = _objVisitRequestBiz.SaveVisitRequest(_objVisitRequest, out VisitReqId); if (result > 0) { string PropertyName, apartmentNo; PropertyName = CommonBiz.GetSingleString("ams.Properties", "PropertyName", "PropertyId=" + _objVisitRequest.PropertyId); apartmentNo = CommonBiz.GetSingleString("ams.Apartment", "ApartmentNoOrName", "PropertyId=" + _objVisitRequest.PropertyId + " and ApartmentId=" + _objVisitRequest.ApartmentId); _objMessages = new NotificationMessages(); _objMessages.ClassificationID = 4; _objMessages.NotificationTypeID = 1; string path = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/" + "UserUI/ResponseVisitRequest.aspx"; //Request.Url.GetLeftPart(UriPartial.Authority); _objNotificationBiz = new NotificationBiz(); objUser = (UserDetail)ViewState["UserDetailVwState"]; string body = "Hello <br/> " + objUser.FullName + ","; body += "<br /><br /> " + _objVisitRequest.ClientName + " wants to visit your apartment " + apartmentNo + " of " + PropertyName + "<br/>"; body += "<span style=\"font-size: 11pt;font-weight: bold\">Messege from Client:</span><br/>" + _objVisitRequest.MessageToLandlord + "<br/>"; body += "<br /> If you want to accept this visit Request please click <a href='" + path + "?isAccept=1&lId=" + _objVisitRequest.LandlordId + "&ReqId=" + VisitReqId + "' > accept </a> <br /><br /> Or To deny click <a href='" + path + "?isAccept=0&lId=" + _objVisitRequest.LandlordId + "&ReqId=" + VisitReqId + "'> deny </a> <br /><br />"; _objNotificationBiz.SendEmail(_objMessages, landloardEmail, body); ltrlEmailSmsNotification.Text = "<span style=\"color: green; font - size: 10pt \">Request Successful</span>"; } else { ltrlEmailSmsNotification.Text = "<span style=\"color: Red; font - size: 10pt \">Request Failed</span>"; } } else { ltrlEmailSmsNotification.Text = "<span style=\"color: Red; font - size: 10pt \">You have already a pending Request. Thanks..</span>"; } } else { MessageBox("Request Failed!"); } }
public async Task <VisitRequest> CreateVisitRequest([Body] VisitRequest visitRequest) { return(await _client.CreateVisitRequest(visitRequest, token)); }