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