public bool AddQuestionaires(IList <Questionaires> Questionaire, Guid contractGuid, DateTime CreatedOn, Guid CreatedBy, DateTime UpdatedOn, Guid UpdatedBy)
{
foreach (var resource in Questionaire)
{
List <string> list = new List <string>();
if (resource.QuestionType == "multi")
{
if (resource.MultiSelectAnswer != null)
{
foreach (var data in resource.MultiSelectAnswer)
{
if (data.IsSelected)
{
list.Add(data.Name);
}
}
}
resource.CheckBoxAnswer = string.Join("|", list.ToArray());
}
}
List <Questionaires> FilteredQuestionaire = new List <Questionaires>();
foreach (Questionaires quest in Questionaire)
{
Questionaires filteredquestions = new Questionaires();
if (quest.YesNoAnswer != null || !string.IsNullOrEmpty(quest.YesNoAnswer) || !string.IsNullOrEmpty(quest.CheckBoxAnswer) || quest.Textanswer != null)
{
FilteredQuestionaire.Add(quest);
}
}
return(_contractQuestionariesRepository.AddQuestionaires(FilteredQuestionaire, contractGuid, CreatedOn, CreatedBy, UpdatedOn, UpdatedBy));
}
public Questionaires GetCategoryQuestionaires(string category_id)
{
Questionaires questionaires = new Questionaires();
try
{
string query = $"select * from dsto_questionaire where [yref_categor]='{category_id}'";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Questionaire questionaire = new Questionaire(null);
InitQuestionaire(questionaire, row);
questionaires.Add(questionaire);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(questionaires);
}
public object GetReviewQuestionaires(string id)
{
Questionaires questionaires = new Questionaires();
try
{
string query = $"select *, RIGHT('000000' + CAST(code AS varchar(6)) , 6) as qcode from dsto_questionaire where (status=2 or status=3) and yref_template='{id}' order by created_on desc";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Questionaire questionaire = new Questionaire(null);
InitQuestionaire(questionaire, row);
questionaire.CreatedBy = new UserProvider(DbInfo).GetCreatedByUser(row["created_by"].ToString());
questionaires.Add(questionaire);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(questionaires);
}
public Questionaires GetQuestionairesByConfig(int id)
{
Questionaires questionaires = new Questionaires();
try
{
string query = $"select * from dsto_questionaire where configuration_id='{id}' and Deleted=0";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Questionaire questionaire = new Questionaire(null);
InitQuestionaire(questionaire, row);
questionaires.Add(questionaire);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(questionaires);
}
public Questionaires GetTrainees(int id)
{
Questionaires trainees = new Questionaires();
try
{
string query = $"select dsto_questionaire.* from dsto_questionaire inner join dsto_Trainee " +
$"on dsto_questionaire.guid = dsto_trainee.yref_questionaire " +
$"where dsto_Trainee.yref_training ='{id}'";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Questionaire trainee = trainees.Add();
InitTrainee(trainee, row);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(trainees);
}
public IEnumerable <Questionaires> GetContractQuestionaries(string resourceType, string Action, Guid ContractGuid)
{
var questionniareMaster = _contractQuestionariesRepository.GetContractQuestionaries(resourceType, Action, ContractGuid);
List <Questionaires> listQuestionaire = new List <Questionaires>();
foreach (var data in questionniareMaster)
{
Questionaires questionaire = new Questionaires();
questionaire.Question = data.Questions;
questionaire.QuestionType = data.QuestionType;
questionaire.Textanswer = data.Textanswer;
questionaire.Id = data.Id;
List <string> multiSelectOptions = data.MultiSelectoption?.Split('|').ToList();
List <string> checkboxAnswer = data.CheckBoxAnswer?.Split('|').ToList();
List <MultiSelectOption> option = new List <MultiSelectOption>();
if (multiSelectOptions != null)
{
foreach (var resource in multiSelectOptions)
{
MultiSelectOption opt = new MultiSelectOption();
opt.Name = resource;
if (checkboxAnswer != null)
{
if (checkboxAnswer.Contains(resource))
{
opt.IsSelected = true;
}
else
{
opt.IsSelected = false;
}
opt.Id = Guid.NewGuid();
}
else
{
opt.IsSelected = false;
}
option.Add(opt);
}
}
questionaire.MultiSelectAnswer = option;
questionaire.YesNoAnswer = data.Answer;
questionaire.QuestionGuid = data.QuestionaireMasterGuid;
questionaire.ReportLastReportDate = data.DateOfLastReport;
questionaire.ReportNextReportDate = data.DateOfNextReport;
questionaire.ControlClass = data.Class;
questionaire.ChildId = data.ChildId;
questionaire.ChildYesNoAnswer = data.ChildYesNoAnswer;
questionaire.CheckBoxAnswer = data.CheckBoxAnswer;
questionaire.Updatedon = data.UpdatedOn;
questionaire.UpdatedBy = _userService.GetUserByUserGuid(data.UpdatedBy)?.DisplayName;
// questionaire.Checkedoption = data.CheckBoxAnswer;
listQuestionaire.Add(questionaire);
}
return(listQuestionaire);
}
public Questionaires ConfigurationQuestionaires(int id)
{
Questionaires questionaires = new Questionaires();
try
{
string query = $"select * from dsto_questionaire where status=0 and configuration_id='{id}' and yref_template is null and Deleted=0";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Questionaire questionaire = new Questionaire(null);
questionaire.Key = row["guid"].ToString();
questionaire.OID = int.Parse(row["OID"].ToString());
questionaire.Name = row["Name"].ToString();
questionaire.CreatedBy = row["created_by"].ToString();
questionaire.Status = (Statuses)Enum.Parse(typeof(Statuses), row["Status"].ToString());
questionaire.Deleted = bool.Parse(row["deleted"].ToString());
questionaire.Latitude = Convert.ToDouble(row["Latitude"].ToString());
questionaire.Longitude = Convert.ToDouble(row["Longitude"].ToString());
if (row["yref_category"] != null && row["yref_category"] != DBNull.Value)
{
questionaire.Category = new CategoryProvider(DbInfo).RetrieveCategory(Convert.ToString(row["yref_template"]));
}
questionaires.Add(questionaire);
}
}
return(questionaires);
}
catch (Exception ex)
{
throw ex;
}
}
