/// <summary>
/// Updates a SurveyResponse.
/// </summary>
/// <param name="SurveyResponse">SurveyResponse.</param>
public void UpdateSurveyResponse(SurveyResponseBO SurveyResponse)
{
try{
Guid Id = new Guid(SurveyResponse.ResponseId);
//Update Survey
using (var Context = DataObjectFactory.CreateContext())
{
var Query = from response in Context.SurveyResponses
where response.ResponseId == Id
select response;
var DataRow = Query.Single();
if (!string.IsNullOrEmpty(SurveyResponse.RelateParentId) && SurveyResponse.RelateParentId != Guid.Empty.ToString())
{
DataRow.RelateParentId = new Guid(SurveyResponse.RelateParentId);
}
DataRow.ResponseXML = SurveyResponse.XML;
//DataRow.DateCompleted = DateTime.Now;
DataRow.DateCompleted = SurveyResponse.DateCompleted;
DataRow.StatusId = SurveyResponse.Status;
DataRow.DateUpdated = DateTime.Now;
// DataRow.ResponsePasscode = SurveyResponse.ResponsePassCode;
DataRow.IsDraftMode = SurveyResponse.IsDraftMode;
DataRow.ResponseXMLSize = RemoveWhitespace(SurveyResponse.XML).Length;
Context.SaveChanges();
}
}
catch (Exception ex)
{
throw (ex);
}
}
public static ResponseContext ToResponseContext(this SurveyResponseBO surveyResponseBO)
{
MetadataAccessor metadataAccessor = new MetadataAccessor();
var formId = surveyResponseBO.FormId ?? surveyResponseBO.FormId;
var formName = surveyResponseBO.FormName ?? metadataAccessor.GetFormName(formId);
var parentFormId = surveyResponseBO.ParentFormId ?? metadataAccessor.GetParentFormId(formId);
var parentFormName = surveyResponseBO.ParentFormName ?? metadataAccessor.GetParentFormName(formId);
var rootFormId = surveyResponseBO.RootFormId ?? formId;
var rootFormName = surveyResponseBO.RootFormName ?? formName;
var responseContext = new ResponseContext
{
ResponseId = surveyResponseBO.ResponseId,
ParentResponseId = surveyResponseBO.ParentResponseId,
RootResponseId = surveyResponseBO.RootResponseId,
FormId = formId,
FormName = formName,
ParentFormId = parentFormId,
ParentFormName = parentFormName,
RootFormId = rootFormId,
RootFormName = rootFormName,
IsNewRecord = surveyResponseBO.IsNewRecord,
UserOrgId = surveyResponseBO.UserOrgId,
UserId = surveyResponseBO.UserId,
UserName = surveyResponseBO.UserName
};
//if (responseContext.FormId != metadataAccessor.GetFormIdByViewId(surveyResponseBO.ViewId))
// throw new ArgumentException("ViewId not in agreement with FormId", string.Format("FormId={0}, ViewId=>{1}",
// responseContext.FormId, metadataAccessor.GetFormIdByViewId(surveyResponseBO.ViewId)));
return(responseContext);
}
public void UpdateRecordStatus(SurveyResponseBO SurveyResponseBO)
{
try
{
Guid Id = new Guid(SurveyResponseBO.ResponseId);
using (var Context = DataObjectFactory.CreateContext())
{
var Query = from response in Context.SurveyResponses
where response.ResponseId == Id
select response;
var DataRow = Query.Single();
if (DataRow.StatusId == 3 && SurveyResponseBO.Status == 4)
{
DataRow.StatusId = SurveyResponseBO.Status;
}
if (SurveyResponseBO.Status != 4)
{
DataRow.StatusId = SurveyResponseBO.Status;
}
Context.SaveChanges();
}
}
catch (Exception ex)
{
throw (ex);
}
}
public static SurveyResponseBO MergeIntoSurveyResponseBO(this SurveyResponseBO surveyResponseBO, SurveyInfoBO parentSurveyInfoBO, string parentResponseId)
{
surveyResponseBO.ParentFormId = parentSurveyInfoBO.ParentFormId;
surveyResponseBO.ParentResponseId = parentResponseId;
surveyResponseBO.IsDraftMode = parentSurveyInfoBO.IsDraftMode;
var responseDetail = surveyResponseBO.ResponseDetail;
responseDetail.ParentFormId = parentSurveyInfoBO.ParentFormId;
responseDetail.ParentResponseId = parentResponseId;
responseDetail.IsRelatedView = surveyResponseBO.ParentFormId != null;
responseDetail.IsDraftMode = parentSurveyInfoBO.IsDraftMode;
responseDetail.IsNewRecord = surveyResponseBO.IsNewRecord;
responseDetail.RecStatus = surveyResponseBO.RecStatus;
responseDetail.ResponseId = surveyResponseBO.ResponseId;
responseDetail.ResolveMetadataDependencies();
surveyResponseBO.RootFormId = responseDetail.RootFormId;
surveyResponseBO.RootFormName = responseDetail.RootFormName;
surveyResponseBO.RootResponseId = responseDetail.RootResponseId;
surveyResponseBO.ParentFormName = responseDetail.ParentFormName;
surveyResponseBO.FormName = responseDetail.FormName;
surveyResponseBO.UserId = responseDetail.UserId;
surveyResponseBO.LastActiveUserId = responseDetail.UserId;
surveyResponseBO.CurrentOrgId = responseDetail.UserOrgId;
surveyResponseBO.UserOrgId = responseDetail.UserOrgId;
surveyResponseBO.LastActiveOrgId = responseDetail.UserOrgId;
return(surveyResponseBO);
}
public SurveyResponseBO UpdateSurveyResponse(SurveyResponseBO pValue)
{
SurveyResponseBO result = pValue;
this.SurveyResponseDao.UpdateSurveyResponse(pValue);
return(result);
}
public SurveyResponseBO InsertSurveyResponse(SurveyResponseBO pValue)
{
SurveyResponseBO result = pValue;
this.SurveyResponseDao.InsertSurveyResponse(pValue);
return(result);
}
public bool DeleteSurveyResponseInEditMode(SurveyResponseBO pValue, int Status = -1)
{
bool result = false;
List <SurveyResponseBO> Children = this.GetResponsesHierarchyIdsByRootId(pValue.ResponseId);
foreach (var child in Children)
{
//Get the original copy of the xml
SurveyResponseBO ResponseXml = this.SurveyResponseDao.GetResponseXml(child.ResponseId);
if (!ResponseXml.IsNewRecord)
{
child.XML = ResponseXml.XML;
this.SurveyResponseDao.UpdateSurveyResponse(child);
}
else
{
child.UserId = pValue.UserId;
this.SurveyResponseDao.DeleteSurveyResponse(child);
}
// delete record from ResponseXml Table
ResponseXmlBO ResponseXmlBO = new ResponseXmlBO();
ResponseXmlBO.ResponseId = child.ResponseId;
this.SurveyResponseDao.DeleteResponseXml(ResponseXmlBO);
if (Status > -1)
{
this.SurveyResponseDao.UpdateRecordStatus(ResponseXmlBO.ResponseId, Status);
}
}
result = true;
return(result);
}
public bool DeleteSurveyResponseInEditMode(SurveyResponseBO surveyResponseBO, int status = -1)
{
var responseContext = surveyResponseBO.ToResponseContext();
_surveyResponseDao.UpdateRecordStatus(responseContext, status, RecordStatusChangeReason.DeleteInEditMode);
return(true);
}
public void UpdateResponseStatus(SurveyAnswerRequest request)
{
try
{
Epi.Web.Interfaces.DataInterfaces.ISurveyResponseDao SurveyResponseDao = new EF.EntitySurveyResponseDao();
Epi.Web.Interfaces.DataInterfaces.ISurveyInfoDao ISurveyInfoDao = new EF.EntitySurveyInfoDao();
Epi.Web.BLL.SurveyResponse Implementation = new Epi.Web.BLL.SurveyResponse(SurveyResponseDao, ISurveyInfoDao);
//SurveyAnswerResponse response = new SurveyAnswerResponse(request.RequestId);
SurveyResponseBO SurveyResponse = Mapper.ToSurveyResponseBOList(request.SurveyAnswerList, request.Criteria.UserId)[0];
List <SurveyResponseBO> SurveyResponseBOList = Implementation.GetSurveyResponseById(request.Criteria.SurveyAnswerIdList, Guid.Empty);
SurveyResponseBO ResultList = Implementation.UpdateSurveyResponse(SurveyResponse);
}
catch (Exception ex)
{
CustomFaultException customFaultException = new CustomFaultException();
customFaultException.CustomMessage = ex.Message;
customFaultException.Source = ex.Source;
customFaultException.StackTrace = ex.StackTrace;
customFaultException.HelpLink = ex.HelpLink;
throw new FaultException <CustomFaultException>(customFaultException);
}
}
public bool InsertChildSurveyResponse(SurveyResponseBO surveyResponseBO, SurveyInfoBO parentSurveyInfoBO, string parentResponseId)
{
surveyResponseBO = surveyResponseBO.MergeIntoSurveyResponseBO(parentSurveyInfoBO, parentResponseId);
((IResponseContext)surveyResponseBO).ResolveMetadataDependencies();
_surveyResponseDao.InsertSurveyResponse(surveyResponseBO);
return(true);
}
/// <summary>
/// Maps SurveyInfoBO business object to SurveyInfoDTO entity.
/// </summary>
/// <param name="SurveyInfo">A SurveyInfoBO business object.</param>
/// <returns>A SurveyInfoDTO.</returns>
public static SurveyAnswerDTO ToDataTransferObject(SurveyResponseBO pBO)
{
SurveyAnswerDTO SurveyAnswerDTO = new SurveyAnswerDTO();
SurveyAnswerDTO.SurveyId = pBO.SurveyId;
SurveyAnswerDTO.ResponseId = pBO.ResponseId;
SurveyAnswerDTO.DateUpdated = pBO.DateUpdated;
SurveyAnswerDTO.XML = pBO.XML;
SurveyAnswerDTO.DateCompleted = pBO.DateCompleted;
SurveyAnswerDTO.DateCreated = pBO.DateCreated;
SurveyAnswerDTO.Status = pBO.Status;
SurveyAnswerDTO.IsDraftMode = pBO.IsDraftMode;
SurveyAnswerDTO.IsLocked = pBO.IsLocked;
SurveyAnswerDTO.ParentRecordId = pBO.ParentRecordId;
SurveyAnswerDTO.UserEmail = pBO.UserEmail;
SurveyAnswerDTO.ViewId = pBO.ViewId;
SurveyAnswerDTO.RelateParentId = pBO.RelateParentId;
SurveyAnswerDTO.SqlData = pBO.SqlData;
SurveyAnswerDTO.LastActiveUserId = pBO.LastActiveUserId;
if (pBO.ResponseHierarchyIds != null)
{
SurveyAnswerDTO.ResponseHierarchyIds = ToDataTransferObject(pBO.ResponseHierarchyIds);
}
return(SurveyAnswerDTO);
}
public SurveyResponseBO GetFormResponseByParentRecordId(string ParentRecordId)
{
SurveyResponseBO SurveyResponseBO = new SurveyResponseBO();
SurveyResponseBO = this.SurveyResponseDao.GetFormResponseByParentRecordId(ParentRecordId);
return(SurveyResponseBO);
}
/// <summary>
/// Maps SurveyMetaData entity to SurveyInfoBO business object.
/// </summary>
/// <param name="entity">A SurveyMetaData entity to be transformed.</param>
/// <returns>A SurveyInfoBO business object.</returns>
internal static SurveyResponseBO Map(SurveyResponse entity, User User = null, int LastActiveUseerId = -1)
{
SurveyResponseBO SurveyResponseBO = new SurveyResponseBO();
SurveyResponseBO.SurveyId = entity.SurveyId.ToString();
SurveyResponseBO.ResponseId = entity.ResponseId.ToString();
SurveyResponseBO.XML = entity.ResponseXML;
SurveyResponseBO.Status = entity.StatusId;
SurveyResponseBO.DateUpdated = entity.DateUpdated;
SurveyResponseBO.DateCompleted = entity.DateCompleted;
SurveyResponseBO.TemplateXMLSize = (long)entity.ResponseXMLSize;
SurveyResponseBO.DateCreated = entity.DateCreated;
SurveyResponseBO.IsDraftMode = entity.IsDraftMode;
SurveyResponseBO.IsLocked = entity.IsLocked;
SurveyResponseBO.LastActiveUserId = LastActiveUseerId;
if (entity.SurveyMetaData != null)
{
SurveyResponseBO.ViewId = (int)entity.SurveyMetaData.ViewId;
}
if (entity.ParentRecordId != null)
{
SurveyResponseBO.ParentRecordId = entity.ParentRecordId.ToString();
}
if (entity.RelateParentId != null)
{
SurveyResponseBO.RelateParentId = entity.RelateParentId.ToString();
}
if (User != null)
{
SurveyResponseBO.UserEmail = User.EmailAddress;
}
return(SurveyResponseBO);
}
public void SurveyResponseBOCount()
{
SurveyResponseBO objSurveyResponseBO = new SurveyResponseBO();
int numberOfPublicPropertiesofSurveyResponseBO = objSurveyResponseBO.GetType().GetProperties().Count();
Assert.AreEqual(numberOfPublicPropertiesofSurveyResponseBO, SurveyResponseBOPropertyCount, "SurveyResponseBO properties has been changed");
}
/// <summary>
/// Maps SurveyMetaData entity to SurveyInfoBO business object.
/// </summary>
/// <param name="entity">A SurveyMetaData entity to be transformed.</param>
/// <returns>A SurveyInfoBO business object.</returns>
internal static SurveyResponseBO Map(SurveyResponse entity)
{
/* return new SurveyResponseBO
* {
* SurveyId = entity.SurveyId.ToString(),
* ResponseId = entity.ResponseId.ToString(),
* XML = entity.ResponseXML,
* Status = entity.StatusId,
* DateUpdated = entity.DateUpdated,
* DateCompleted = entity.DateCompleted,
* TemplateXMLSize = (long)entity.ResponseXMLSize,
* DateCreated = entity.DateCreated,
* IsDraftMode = entity.IsDraftMode ,
* RecordSourceId=(int)entity.RecordSourceId
*
* };*/
SurveyResponseBO SurveyResponseBO = new SurveyResponseBO();
SurveyResponseBO.SurveyId = entity.SurveyId.ToString();
SurveyResponseBO.ResponseId = entity.ResponseId.ToString();
SurveyResponseBO.XML = entity.ResponseXML;
SurveyResponseBO.Status = entity.StatusId;
SurveyResponseBO.DateUpdated = entity.DateUpdated;
SurveyResponseBO.DateCompleted = entity.DateCompleted;
SurveyResponseBO.TemplateXMLSize = (long)entity.ResponseXMLSize;
SurveyResponseBO.DateCreated = entity.DateCreated;
SurveyResponseBO.IsDraftMode = entity.IsDraftMode;
SurveyResponseBO.RecordSourceId = (int)entity.RecordSourceId;
if (entity.RelateParentId != null)
{
SurveyResponseBO.RelateParentId = entity.RelateParentId.ToString();
}
return(SurveyResponseBO);
}
public static SurveyResponseBO ToSurveyResponseBO(this FormResponseDetail formResponseDetail)
{
var surveyResponseBO = new SurveyResponseBO();
surveyResponseBO.ResponseDetail = formResponseDetail;
surveyResponseBO.ViewId = new Common.Metadata.MetadataAccessor().GetFormDigest(formResponseDetail.FormId).ViewId;
return(surveyResponseBO);
}
public SurveyResponseBO GetSurveyResponseStateById(IResponseContext responseContext)
{
responseContext.ResolveMetadataDependencies();
SurveyResponseBO result = _surveyResponseDao.GetSurveyResponseState(responseContext);
return(result);
}
public SurveyResponseBO GetResponseXml(string ResponseId)
{
SurveyResponseBO SurveyResponseBO = new SurveyResponseBO();
SurveyResponseBO = this.SurveyResponseDao.GetResponseXml(ResponseId);
return(SurveyResponseBO);
}
public SurveyResponseBO UpdateSurveyResponse(SurveyResponseBO pValue)
{
SurveyResponseBO result = pValue;
//Check if this respose has prent
string ParentId = SurveyResponseDao.GetResponseParentId(pValue.ResponseId);
Guid ParentIdGuid = Guid.Empty;
if (!string.IsNullOrEmpty(ParentId))
{
ParentIdGuid = new Guid(ParentId);
}
Epi.Web.Interfaces.DataInterfaces.ISurveyInfoDao ISurveyInfoDao = new EF.EntitySurveyInfoDao();
Epi.Web.BLL.SurveyInfo Implementation = new Epi.Web.BLL.SurveyInfo(ISurveyInfoDao);
var List = Implementation.GetSurveyControlList(pValue.SurveyId);
SurveyResponseJson SurveyResponseJson = new SurveyResponseJson();
var json = SurveyResponseJson.GetSurveyResponseJson(pValue, List);
pValue.Json = json;
//if ( pValue.Status == 2 && ParentIdGuid!= Guid.Empty )
//{
//if (!string.IsNullOrEmpty(ParentId) && ParentId != Guid.Empty.ToString() && pValue.Status == 2)
// {
// //read the child
// SurveyResponseBO Child = this.SurveyResponseDao.GetSingleResponse(pValue.ResponseId);
// // read the parent
// SurveyResponseBO Parent = this.SurveyResponseDao.GetSingleResponse(ParentId);
// //copy and update
// Parent.XML = Child.XML;
// this.SurveyResponseDao.UpdateSurveyResponse(Parent);
// result = Parent;
// //Check if this child has a related form (subchild)
// List<SurveyResponseBO> Children = this.GetResponsesHierarchyIdsByRootId(Child.ResponseId);
// if (Children.Count() > 1)
// {
// SurveyResponseBO NewChild = Children[1];
// NewChild.RelateParentId = Parent.ResponseId;
// this.SurveyResponseDao.UpdateSurveyResponse(NewChild);
// }
// // Set child recod UserId
// Child.UserId = pValue.UserId;
// // delete the child
// this.DeleteSingleSurveyResponse(Child);
//}
//else
//{
//Check if the record existes.If it does update otherwise insert new
this.SurveyResponseDao.UpdateSurveyResponse(pValue);
SurveyResponseBO SurveyResponseBO = SurveyResponseDao.GetResponseXml(pValue.ResponseId);
// }
return(result);
}
public void UpdateRecordStatus(SurveyResponseBO SurveyResponseBO)
{
if (SurveyResponseBO.Status == 1)//TODO item for WebSurveyIntegration [RecordSourceID=4 and StatusID=3]
{
SurveyResponseBO.Status = 2;
}
this.SurveyResponseDao.UpdateRecordStatus(SurveyResponseBO);
}
public SurveyResponseBO InsertChildSurveyResponse(SurveyResponseBO pValue, SurveyInfoBO ParentSurveyInfo, string RelateParentId)
{
SurveyResponseBO result = pValue;
pValue.ParentId = ParentSurveyInfo.ParentId;
pValue.RelateParentId = RelateParentId;
this.SurveyResponseDao.InsertChildSurveyResponse(pValue);
return(result);
}
public bool DeleteSingleSurveyResponse(SurveyResponseBO pValue)
{
bool result = false;
this.SurveyResponseDao.DeleteSingleSurveyResponse(pValue);
result = true;
return(result);
}
public void UpdateRecordStatus(SurveyResponseBO SurveyResponseBO)
{
if (SurveyResponseBO.Status == 1)
{
SurveyResponseBO.Status = 2;
}
this.SurveyResponseDao.UpdateRecordStatus(SurveyResponseBO);
}
public bool DeleteSurveyResponse(SurveyResponseBO surveyResponseBO)
{
bool result = false;
var responseContext = surveyResponseBO.ToResponseContext();
_surveyResponseDao.UpdateRecordStatus(responseContext, RecordStatus.Deleted, RecordStatusChangeReason.DeleteResponse);
result = true;
return(result);
}
/// <summary>
/// Updates SurveyResponse
/// </summary>
/// <param name="id"></param>
public void Remove(string id)
{
Interfaces.DataInterfaces.ISurveyResponseDao SurveyResponseDao = new EntitySurveyResponseDao();
BLL.SurveyResponse Implementation = new BLL.SurveyResponse(SurveyResponseDao);
SurveyResponseBO surveyresponseBO = new SurveyResponseBO();
surveyresponseBO.ResponseId = id;
surveyresponseBO.Status = 0;
Implementation.UpdateRecordStatus(surveyresponseBO);
}
internal static SurveyResponseBO Map(ResponseXml ResponseXml)
{
SurveyResponseBO SurveyResponseBO = new SurveyResponseBO();
SurveyResponseBO.ResponseId = ResponseXml.ResponseId.ToString();
SurveyResponseBO.XML = ResponseXml.Xml;
SurveyResponseBO.UserId = (int)ResponseXml.UserId;
SurveyResponseBO.IsNewRecord = (bool)ResponseXml.IsNewRecord;
return(SurveyResponseBO);
}
public static List <SurveyResponseBO> ToSurveyResponseBOList(List <SurveyAnswerDTO> surveyAnswerList, int userId = 0)
{
List <SurveyResponseBO> BOList = new List <SurveyResponseBO>();
foreach (var item in surveyAnswerList)
{
SurveyResponseBO SurveyResponseBO = new SurveyResponseBO();
SurveyResponseBO = Mapper.ToSurveyResponseBO(item, userId);
BOList.Add(SurveyResponseBO);
}
return(BOList);
}
public static SurveyAnswerStateDTO ToSurveyAnswerStateDTO(this SurveyResponseBO surveyResponseBO, int?loggedInUserId = null)
{
return(new SurveyAnswerStateDTO
{
ResponseId = surveyResponseBO.ResponseId,
LoggedInUserId = loggedInUserId.HasValue ? loggedInUserId.Value : 0,
LastActiveUserId = surveyResponseBO.UserId,
Status = surveyResponseBO.RecStatus,
DateUpdated = surveyResponseBO.DateUpdated,
ResponseContext = surveyResponseBO.ResponseDetail.CloneResponseContext()
});
}
/// <summary>
/// Maps SurveyInfoBO business object to SurveyMetaData entity.
/// </summary>
/// <param name="businessobject">A SurveyInfoBO business object.</param>
/// <returns>A SurveyMetaData entity.</returns>
internal static SurveyAnswerDTO Map(SurveyResponseBO businessobject)
{
return(new SurveyAnswerDTO
{
SurveyId = businessobject.SurveyId,
ResponseId = businessobject.ResponseId,
XML = businessobject.XML,
Status = businessobject.Status,
UserPublishKey = businessobject.UserPublishKey,
DateUpdated = businessobject.DateUpdated,
DateCompleted = businessobject.DateCompleted
});
}
public SurveyResponseBO UpdateSurveyResponse(SurveyResponseBO pValue)
{
SurveyResponseBO result = pValue;
//Check if this respose has prent
string ParentId = SurveyResponseDao.GetResponseParentId(pValue.ResponseId);
Guid ParentIdGuid = Guid.Empty;
if (!string.IsNullOrEmpty(ParentId))
{
ParentIdGuid = new Guid(ParentId);
}
//if ( pValue.Status == 2 && ParentIdGuid!= Guid.Empty )
//{
//if (!string.IsNullOrEmpty(ParentId) && ParentId != Guid.Empty.ToString() && pValue.Status == 2)
// {
// //read the child
// SurveyResponseBO Child = this.SurveyResponseDao.GetSingleResponse(pValue.ResponseId);
// // read the parent
// SurveyResponseBO Parent = this.SurveyResponseDao.GetSingleResponse(ParentId);
// //copy and update
// Parent.XML = Child.XML;
// this.SurveyResponseDao.UpdateSurveyResponse(Parent);
// result = Parent;
// //Check if this child has a related form (subchild)
// List<SurveyResponseBO> Children = this.GetResponsesHierarchyIdsByRootId(Child.ResponseId);
// if (Children.Count() > 1)
// {
// SurveyResponseBO NewChild = Children[1];
// NewChild.RelateParentId = Parent.ResponseId;
// this.SurveyResponseDao.UpdateSurveyResponse(NewChild);
// }
// // Set child recod UserId
// Child.UserId = pValue.UserId;
// // delete the child
// this.DeleteSingleSurveyResponse(Child);
//}
//else
//{
//Check if the record existes.If it does update otherwise insert new
this.SurveyResponseDao.UpdateSurveyResponse(pValue);
SurveyResponseBO SurveyResponseBO = SurveyResponseDao.GetResponseXml(pValue.ResponseId);
// }
return(result);
}
