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