public List<FormSubmissionAnswer> GetAllByFormSubmissionId(int FormSubmissionId)
{
FormSubmissionAnswerDAC _formSubmissionAnswerComponent = new FormSubmissionAnswerDAC();
IDataReader reader = _formSubmissionAnswerComponent.GetAllFormSubmissionAnswer("FormSubmissionId = " + FormSubmissionId).CreateDataReader();
List<FormSubmissionAnswer> _formSubmissionAnswerList = new List<FormSubmissionAnswer>();
while (reader.Read())
{
if (_formSubmissionAnswerList == null)
_formSubmissionAnswerList = new List<FormSubmissionAnswer>();
FormSubmissionAnswer _formSubmissionAnswer = new FormSubmissionAnswer();
if (reader["FormSubmissionAnswerId"] != DBNull.Value)
_formSubmissionAnswer.FormSubmissionAnswerId = Convert.ToInt32(reader["FormSubmissionAnswerId"]);
if (reader["FormSubmissionId"] != DBNull.Value)
_formSubmissionAnswer.FormSubmissionId = Convert.ToInt32(reader["FormSubmissionId"]);
if (reader["FormFieldId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
if (reader["Answer"] != DBNull.Value)
_formSubmissionAnswer.Answer = Convert.ToString(reader["Answer"]);
if (reader["FormFieldColumnId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldColumnId = Convert.ToInt32(reader["FormFieldColumnId"]);
if (reader["FormFieldValueId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldValueId = Convert.ToInt32(reader["FormFieldValueId"]);
if (reader["Grade"] != DBNull.Value)
_formSubmissionAnswer.Grade = Convert.ToInt32(reader["Grade"]);
_formSubmissionAnswer.NewRecord = false;
_formSubmissionAnswerList.Add(_formSubmissionAnswer);
} reader.Close();
return _formSubmissionAnswerList;
}
public bool Vote(int FormFieldValueId, int FormFieldId)
{
BusinessLogicLayer.Entities.FormBuilder.FormField field = BusinessLogicLayer.Common.FormFieldLogic.GetByID(FormFieldId);
BusinessLogicLayer.Entities.FormBuilder.FormFieldValue value = BusinessLogicLayer.Common.FormFieldValueLogic.GetByID(FormFieldValueId);
if (field == null)
return false;
FormSubmission sub = new FormSubmission();
sub.FormDocumentID = field.FormDocumentId;
sub.UserId = 0;
sub.SubmissionDate = DateTime.Now;
sub.IsValid = true;
BusinessLogicLayer.Common.FormSubmissionLogic.Insert(sub);
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormSubmissionId = sub.FormSubmissionId;
ua.Answer = value.FieldValue;
ua.FormFieldId = FormFieldId;
ua.FormFieldValueId = FormFieldValueId;
BusinessLogicLayer.Common.FormSubmissionAnswerLogic.Insert(ua);
return true;
}
public FormSubmissionAnswer GetByID(int _formSubmissionAnswerId)
{
FormSubmissionAnswerDAC _formSubmissionAnswerComponent = new FormSubmissionAnswerDAC();
IDataReader reader = _formSubmissionAnswerComponent.GetByIDFormSubmissionAnswer(_formSubmissionAnswerId);
FormSubmissionAnswer _formSubmissionAnswer = null;
while(reader.Read())
{
_formSubmissionAnswer = new FormSubmissionAnswer();
if(reader["FormSubmissionAnswerId"] != DBNull.Value)
_formSubmissionAnswer.FormSubmissionAnswerId = Convert.ToInt32(reader["FormSubmissionAnswerId"]);
if(reader["FormSubmissionId"] != DBNull.Value)
_formSubmissionAnswer.FormSubmissionId = Convert.ToInt32(reader["FormSubmissionId"]);
if(reader["FormFieldId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
if(reader["Answer"] != DBNull.Value)
_formSubmissionAnswer.Answer = Convert.ToString(reader["Answer"]);
if(reader["FormFieldColumnId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldColumnId = Convert.ToInt32(reader["FormFieldColumnId"]);
if(reader["FormFieldValueId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldValueId = Convert.ToInt32(reader["FormFieldValueId"]);
if(reader["Grade"] != DBNull.Value)
_formSubmissionAnswer.Grade = Convert.ToInt32(reader["Grade"]);
_formSubmissionAnswer.NewRecord = false; } reader.Close();
return _formSubmissionAnswer;
}
public List<FormSubmissionAnswer> ViewSubmissionAnswers(int FormDocumentID)
{
FormSubmissionAnswerDAC _formSubmissionAnswerComponent = new FormSubmissionAnswerDAC();
IDataReader reader = _formSubmissionAnswerComponent.ViewSubmissionAnswers("FormDocumentID = " + FormDocumentID).CreateDataReader();
List<FormSubmissionAnswer> _formSubmissionAnswerList = new List<FormSubmissionAnswer>();
while (reader.Read())
{
if (_formSubmissionAnswerList == null)
_formSubmissionAnswerList = new List<FormSubmissionAnswer>();
FormSubmissionAnswer _formSubmissionAnswer = new FormSubmissionAnswer();
#region FormSubmissionAnswer Fields
if (reader["FormSubmissionAnswerId"] != DBNull.Value)
_formSubmissionAnswer.FormSubmissionAnswerId = Convert.ToInt32(reader["FormSubmissionAnswerId"]);
if (reader["FormSubmissionId"] != DBNull.Value)
_formSubmissionAnswer.FormSubmissionId = Convert.ToInt32(reader["FormSubmissionId"]);
if (reader["FormFieldId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldId = Convert.ToInt32(reader["FormFieldId"]);
if (reader["Answer"] != DBNull.Value)
_formSubmissionAnswer.Answer = Convert.ToString(reader["Answer"]);
if (reader["FormFieldColumnId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldColumnId = Convert.ToInt32(reader["FormFieldColumnId"]);
if (reader["FormFieldValueId"] != DBNull.Value)
_formSubmissionAnswer.FormFieldValueId = Convert.ToInt32(reader["FormFieldValueId"]);
if (reader["Grade"] != DBNull.Value)
_formSubmissionAnswer.Grade = Convert.ToInt32(reader["Grade"]);
#endregion
#region FormSubmission Fields
FormSubmission _formSubmission = new FormSubmission();
if (reader["FormSubmissionId"] != DBNull.Value)
_formSubmission.FormSubmissionId = Convert.ToInt32(reader["FormSubmissionId"]);
if (reader["UserId"] != DBNull.Value)
_formSubmission.UserId = Convert.ToInt32(reader["UserId"]);
if (reader["IsAnonymous"] != DBNull.Value)
_formSubmission.IsAnonymous = Convert.ToBoolean(reader["IsAnonymous"]);
if (reader["SubmissionDate"] != DBNull.Value)
_formSubmission.SubmissionDate = Convert.ToDateTime(reader["SubmissionDate"]);
if (reader["IPAddress"] != DBNull.Value)
_formSubmission.IPAddress = Convert.ToString(reader["IPAddress"]);
if (reader["IsValid"] != DBNull.Value)
_formSubmission.IsValid = Convert.ToBoolean(reader["IsValid"]);
if (reader["EmailSent"] != DBNull.Value)
_formSubmission.EmailSent = Convert.ToBoolean(reader["EmailSent"]);
if (reader["SMSSent"] != DBNull.Value)
_formSubmission.SMSSent = Convert.ToBoolean(reader["SMSSent"]);
if (reader["FormDocumentID"] != DBNull.Value)
_formSubmission.FormDocumentID = Convert.ToInt32(reader["FormDocumentID"]);
_formSubmission.NewRecord = false;
BusinessLogicLayer.Entities.Persons.Credential _credential = new Entities.Persons.Credential();
if (reader["UserId"] != DBNull.Value)
_credential.BusinessEntityId = Convert.ToInt32(reader["UserId"]);
if (reader["Username"] != DBNull.Value)
_credential.Username = Convert.ToString(reader["Username"]);
_formSubmission.User = _credential;
_formSubmissionAnswer.FormSubmission = _formSubmission;
#endregion
_formSubmissionAnswer.NewRecord = false;
_formSubmissionAnswerList.Add(_formSubmissionAnswer);
} reader.Close();
return _formSubmissionAnswerList;
}
public bool Update(FormSubmissionAnswer formsubmissionanswer ,int old_formSubmissionAnswerId)
{
FormSubmissionAnswerDAC formsubmissionanswerComponent = new FormSubmissionAnswerDAC();
return formsubmissionanswerComponent.UpdateFormSubmissionAnswer( formsubmissionanswer.FormSubmissionId, formsubmissionanswer.FormFieldId, formsubmissionanswer.Answer, formsubmissionanswer.FormFieldColumnId, formsubmissionanswer.FormFieldValueId, formsubmissionanswer.Grade, old_formSubmissionAnswerId);
}
public bool Insert(FormSubmissionAnswer formsubmissionanswer)
{
int autonumber = 0;
FormSubmissionAnswerDAC formsubmissionanswerComponent = new FormSubmissionAnswerDAC();
bool endedSuccessfuly = formsubmissionanswerComponent.InsertNewFormSubmissionAnswer( ref autonumber, formsubmissionanswer.FormSubmissionId, formsubmissionanswer.FormFieldId, formsubmissionanswer.Answer, formsubmissionanswer.FormFieldColumnId, formsubmissionanswer.FormFieldValueId, formsubmissionanswer.Grade);
if(endedSuccessfuly)
{
formsubmissionanswer.FormSubmissionAnswerId = autonumber;
}
return endedSuccessfuly;
}
private static void CollectChoiceAnswer(ref List<BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer> SurveyUserAnswers, HtmlGenericControl p, BusinessLogicLayer.Entities.FormBuilder.FormField q)
{
HtmlGenericControl answersArea = p.Controls[5] as HtmlGenericControl;
//HtmlGenericControl AnswerArea = new HtmlGenericControl("div");
if (answersArea == null) return;
foreach (HtmlGenericControl li in answersArea.Controls)
{
RadioButton answer = li.Controls[0] as RadioButton;
if (answer != null && answer.Checked)
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldId = q.FormFieldId;
ua.FormFieldValueId = Int32.Parse(answer.ID.ToString().Replace("CheckAnswer", ""));
ua.Answer = answer.Text;
SurveyUserAnswers.Add(ua);
//break;
}
}
}
public static string ValidateUserAnswers(HtmlGenericControl ResultsArea)
{
SurveyUserAnswers = new List<BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer>();
string result="";
List<Panel> Panels = new List<Panel>();
foreach (Control c in ResultsArea.Controls)
{
try
{
Panel p = (Panel)c;
Panels.Add(p);
}
catch
{
}
}
foreach (Panel p in Panels)
{
BusinessLogicLayer.Entities.FormBuilder.FormField q = BusinessLogicLayer.Common.FormFieldLogic.GetByID(int.Parse(p.ID.Replace("Panel", "")));
if (q.FormFieldType.Name == "Text")
{
if (((TextBox)p.Controls[7]).Text.Length == 0 && q.IsRequired)
{
result += String.Format("Required question: {0}<br/>", q.Title);
break;
}
else
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldValueId = int.Parse(((TextBox)p.Controls[7]).ID.Replace("Answer", ""));
ua.Answer = ((TextBox)p.Controls[7]).Text;
SurveyUserAnswers.Add(ua);
}
}
else if (q.FormFieldType.Name == "Paragraph")
{
if (((TextBox)p.Controls[7]).Text.Length == 0 && q.IsRequired)
{
result += "Required question: " + q.Title + "<br/>";
break;
}
else
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldValueId = int.Parse(((TextBox)p.Controls[7]).ID.Replace("Answer", ""));
ua.Answer = ((TextBox)p.Controls[7]).Text;
SurveyUserAnswers.Add(ua);
}
}
else if (q.FormFieldType.Name == "Check")
{
Panel answersArea = ((Panel)p.Controls[7]);
List<CheckBox> checkboxes = new List<CheckBox>();
foreach (Control ctrl in answersArea.Controls)
{
try
{
CheckBox cb = (CheckBox)ctrl;
checkboxes.Add(cb);
}
catch { }
}
bool Ischecked = false;
foreach (CheckBox cb in checkboxes)
{
if (cb.Checked)
{
Ischecked = true;
break;
}
}
if (!Ischecked && q.IsRequired)
{
result += "Required question: " + q.Title + "<br/>";
break;
}
else if (Ischecked)
{
foreach(CheckBox cb in checkboxes )
{
if (cb.Checked)
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldValueId = int.Parse(cb.ID.Replace("CheckAnswer","")) ;
ua.Answer = cb.Text;
SurveyUserAnswers.Add(ua);
}
}
}
}
else if (q.FormFieldType.Name == "Choice")
{
RadioButtonList answersArea = ((RadioButtonList)p.Controls[7]);
ListItem answer=null ;
foreach (ListItem li in answersArea.Items)
{
if (li.Selected)
{
answer= li;
break;
}
}
if (answer==null && q.IsRequired)
{
result += "Required question: " + q.Title + "<br/>";
break;
}
else if (answer!=null)
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldValueId = int.Parse(answer.Value);
ua.Answer = answer.Text;
SurveyUserAnswers.Add(ua);
}
}
}
return result;
}
public static void CollectTextAnswer(ref List<BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer> SurveyUserAnswers, Panel p, BusinessLogicLayer.Entities.FormBuilder.FormField q)
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldId = q.FormFieldId;
ua.FormFieldValueId = int.Parse(((ASPxTextBox)p.Controls[7]).ID.Replace("Answer", ""));
ua.Answer = ((ASPxTextBox)p.Controls[7]).Text.Trim();
SurveyUserAnswers.Add(ua);
}
public static void CollectGridAnswer(ref List<BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer> SurveyUserAnswers, Panel p, BusinessLogicLayer.Entities.FormBuilder.FormField q)
{
HtmlTable table = ((HtmlTable)p.Controls[7]);
for (int i = 1; i < table.Rows.Count; i++)
{
ASPxRadioButtonList answersArea = table.Rows[i].Cells[1].Controls[0] as ASPxRadioButtonList;
if (answersArea != null)
{
ListEditItem answer = null;
foreach (ListEditItem li in answersArea.Items)
{
if (li.Selected)
{
answer = li;
break;
}
}
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldId = q.FormFieldId;
if (answer != null)
{
string[] sps = answer.Value.ToString().Split('_');
ua.FormFieldValueId = Int32.Parse(sps[1]);
BusinessLogicLayer.Entities.FormBuilder.FormFieldColumn column = BusinessLogicLayer.Common.FormFieldColumnLogic.GetByID(Convert.ToInt32(sps[0]));
if(column != null)
ua.Answer = column.FieldColumnValue;
}
SurveyUserAnswers.Add(ua);
}
}
}
public static void CollectDropDownAnswer(ref List<BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer> SurveyUserAnswers, Panel p, BusinessLogicLayer.Entities.FormBuilder.FormField q)
{
ASPxComboBox answersArea = ((ASPxComboBox)p.Controls[7]);
if (answersArea.SelectedIndex >= 0)
{
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldId = q.FormFieldId;
if (answersArea.SelectedItem != null)
{
ua.FormFieldValueId = Int32.Parse(answersArea.SelectedItem.Value.ToString());
ua.Answer = answersArea.Text;
}
SurveyUserAnswers.Add(ua);
}
}
public static void CollectChoiceAnswer(ref List<BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer> SurveyUserAnswers, Panel p, BusinessLogicLayer.Entities.FormBuilder.FormField q)
{
ASPxRadioButtonList answersArea = ((ASPxRadioButtonList)p.Controls[7]);
ListEditItem answer = null;
foreach (ListEditItem li in answersArea.Items)
{
if (li.Selected)
{
answer = li;
break;
}
}
BusinessLogicLayer.Entities.FormBuilder.FormSubmissionAnswer ua = new FormSubmissionAnswer();
ua.FormFieldId = q.FormFieldId;
if (answer != null)
{
ua.FormFieldValueId = Int32.Parse(answer.Value.ToString());
ua.Answer = answer.Text;
}
SurveyUserAnswers.Add(ua);
}
