public bool Insert(int FormSubmissionId, int FormFieldId, string Answer, int FormFieldColumnId, int FormFieldValueId, int Grade)
{
FormSubmissionAnswerDAC formsubmissionanswerComponent = new FormSubmissionAnswerDAC();
int FormSubmissionAnswerId = 0;
return(formsubmissionanswerComponent.InsertNewFormSubmissionAnswer(ref FormSubmissionAnswerId, FormSubmissionId, FormFieldId, Answer, FormFieldColumnId, FormFieldValueId, Grade));
}
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);
}
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 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 int UpdateDataset(System.Data.DataSet dataset)
{
FormSubmissionAnswerDAC formsubmissionanswercomponent = new FormSubmissionAnswerDAC();
return(formsubmissionanswercomponent.UpdateDataset(dataset));
}
public void Delete(int Original_FormSubmissionAnswerId)
{
FormSubmissionAnswerDAC formsubmissionanswerComponent = new FormSubmissionAnswerDAC();
formsubmissionanswerComponent.DeleteFormSubmissionAnswer(Original_FormSubmissionAnswerId);
}
public bool Update(int FormSubmissionId, int FormFieldId, string Answer, int FormFieldColumnId, int FormFieldValueId, int Grade, int Original_FormSubmissionAnswerId)
{
FormSubmissionAnswerDAC formsubmissionanswerComponent = new FormSubmissionAnswerDAC();
return(formsubmissionanswerComponent.UpdateFormSubmissionAnswer(FormSubmissionId, FormFieldId, Answer, FormFieldColumnId, FormFieldValueId, Grade, Original_FormSubmissionAnswerId));
}
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 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);
}
