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