/// <summary>
/// Gets an IList with all instances of Survey.
/// </summary>
public static List <Survey> GetAll(Guid siteGuid)
{
List <Survey> surveyList = new List <Survey>();
using (IDataReader reader = DBSurvey.GetAll(siteGuid))
{
while (reader.Read())
{
Survey survey = new Survey
{
SurveyGuid = new Guid(reader["SurveyGuid"].ToString()),
SiteGuid = new Guid(reader["SiteGuid"].ToString()),
SurveyName = reader["SurveyName"].ToString(),
CreationDate = Convert.ToDateTime(reader["CreationDate"]),
StartPageText = reader["StartPageText"].ToString(),
EndPageText = reader["EndPageText"].ToString(),
SubmissionLimit = Convert.ToInt32(reader["SubmissionLimit"]),
PageCount = Convert.ToInt32(reader["PageCount"]),
ResponseCount = Convert.ToInt32(reader["ResponseCount"])
};
surveyList.Add(survey);
}
}
return(surveyList);
}
/// <summary>
/// Updates this instance of Survey. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return(DBSurvey.Update(
this.surveyGuid,
this.siteGuid,
this.surveyName,
this.creationDate,
this.startPageText,
this.endPageText));
}
/// <summary>
/// Updates this instance of Survey. Returns true on success.
/// </summary>
/// <returns>bool</returns>
private bool Update()
{
return(DBSurvey.Update(
SurveyGuid,
SiteGuid,
SurveyName,
CreationDate,
StartPageText,
EndPageText,
SubmissionLimit
));
}
/// <summary>
/// Persists a new instance of Survey. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
Guid newID = Guid.NewGuid();
this.surveyGuid = newID;
int rowsAffected = DBSurvey.Add(
this.surveyGuid,
this.siteGuid,
this.surveyName,
DateTime.Now,
this.startPageText,
this.endPageText);
return(rowsAffected > 0);
}
/// <summary>
/// Persists a new instance of Survey. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
Guid newID = Guid.NewGuid();
SurveyGuid = newID;
int rowsAffected = DBSurvey.Add(
SurveyGuid,
SiteGuid,
SurveyName,
DateTime.Now,
StartPageText,
EndPageText,
SubmissionLimit
);
return(rowsAffected > 0);
}
/// <summary>
/// Gets an instance of Survey.
/// </summary>
/// <param name="surveyGuid"> surveyGuid </param>
private void GetSurvey(Guid guidSurveyGuid)
{
using (IDataReader reader = DBSurvey.GetOne(guidSurveyGuid))
{
if (reader.Read())
{
this.surveyGuid = new Guid(reader["SurveyGuid"].ToString());
this.siteGuid = new Guid(reader["SiteGuid"].ToString());
this.surveyName = reader["SurveyName"].ToString();
this.creationDate = Convert.ToDateTime(reader["CreationDate"], CultureInfo.CurrentCulture);
this.startPageText = reader["StartPageText"].ToString();
this.endPageText = reader["EndPageText"].ToString();
this.pageCount = Convert.ToInt32(reader["PageCount"]);
this.responseCount = Convert.ToInt32(reader["ResponseCount"]);
}
}
}
public static List <Result> GetResults(Guid responseGuid)
{
List <Result> results = new List <Result>();
Result result;
using (IDataReader reader = DBSurvey.GetOneResult(responseGuid))
{
while (reader.Read())
{
string pageTitle = reader["PageTitle"].ToString();
string answer = reader["Answer"].ToString();
string questionText = reader["QuestionText"].ToString();
Guid questionGuid = new Guid(reader["QuestionGuid"].ToString());
result = new Result(questionGuid, responseGuid, answer, pageTitle, questionText);
results.Add(result);
}
}
return(results);
}
//public static int ResponseCount(Guid surveyGuid)
//{
// return DB.SurveyGetResponseCount(surveyGuid);
//}
public static DataTable GetResultsTable(Guid surveyGuid)
{
IDataReader reader = DBSurvey.GetResults(surveyGuid);
return(DatabaseHelper.GetTableFromDataReader(reader));
}
public static Guid GetModulesCurrentSurvey(int moduleId)
{
return(DBSurvey.GetModulesCurrentSurvey(moduleId));
}
public static void DeleteFromModule(int moduleId)
{
DBSurvey.RemoveFromModule(moduleId);
}
public static bool DeleteBySite(int siteId)
{
return(DBSurvey.DeleteBySite(siteId));
}
/// <summary>
/// Deletes an instance of Survey. Returns true on success.
/// </summary>
/// <param name="surveyGuid"> surveyGuid </param>
/// <returns>bool</returns>
public static void Delete(Guid surveyGuid)
{
DBSurvey.Delete(surveyGuid);
}
public void RemoveFromModule(int moduleId)
{
DBSurvey.RemoveFromModule(surveyGuid, moduleId);
}
public void AddToModule(int moduleId)
{
DBSurvey.AddToModule(surveyGuid, moduleId);
}
public Guid GetNextSurveyPageGuid(Guid pageGuid)
{
return(DBSurvey.GetNextPageGuid(pageGuid));
}
public Guid GetPreviousSurveyPageGuid(Guid pageGuid)
{
return(DBSurvey.GetPreviousPageGuid(pageGuid));
}
public Guid GetSurveyFirstSurveyPageGuid(Guid surveyGuid)
{
return(DBSurvey.GetFirstPageGuid(surveyGuid));
}
