public int SaveAnswer(AuditAnswers answer)
{
using (var database = new SQLiteConnection(_helper.WritableDatabase.Path))
{
return(database.Insert(answer));
}
}
private void SaveQuestion_Click(object sender, System.EventArgs e)
{
EditText Answer1 = FindViewById <EditText>(Resource.Id.Answer1);
RadioGroup radioGroup = FindViewById <RadioGroup>(Resource.Id.rdoQuestion2);
RadioButton radioButton = FindViewById <RadioButton>(radioGroup.CheckedRadioButtonId);
var sp = FindViewById <Spinner>(Resource.Id.spinnerAnswer4);
CheckBox checkbox = FindViewById <CheckBox>(Resource.Id.chkAnswer3);
//List<AuditDetails> auditTest = manageTemplate.GetAllAudit();
//int id ;
//if (auditTest.Count == 0)
//{
// id = manageTemplate.SaveDefaultAudit();
//}
//else
//{
// id = 1;
//}
//auditTest = manageTemplate.GetAllAudit();
List <AuditAnswers> userAnswers = new List <AuditAnswers>();
AuditAnswers answer1 = new AuditAnswers();
answer1.AuditId = Convert.ToInt32(auditID);
answer1.Answer = Answer1.Text;
answer1.QuestionId = 1;
answer1.ImagePath = "";// App._dir.ToString() + " " + fileQuestion1.Text;
userAnswers.Add(answer1);
AuditAnswers answer2 = new AuditAnswers();
answer2.AuditId = Convert.ToInt32(auditID);
answer2.Answer = radioButton.Text;
answer2.QuestionId = 2;
answer2.ImagePath = ""; // App._dir.ToString() + " " + fileQuestion2.Text;
userAnswers.Add(answer2);
AuditAnswers answer3 = new AuditAnswers();
answer3.AuditId = Convert.ToInt32(auditID);
answer3.Answer = checkbox.Checked.ToString();
answer3.QuestionId = 3;
answer3.ImagePath = ""; // App._dir.ToString() + " " + fileQuestion3.Text;
userAnswers.Add(answer3);
AuditAnswers answer4 = new AuditAnswers();
answer4.AuditId = Convert.ToInt32(auditID);
answer4.Answer = sp.SelectedItem.ToString();
answer4.QuestionId = 4;
answer4.ImagePath = ""; // App._dir.ToString() + " " + fileQuestion4.Text;
userAnswers.Add(answer4);
manageTemplate.SaveAnswers(userAnswers);
Toast.MakeText(this, "Answers saved successfully", ToastLength.Long);
var intentmain = new Intent(this, typeof(MainActivity));
StartActivity(intentmain);
}
public int SaveAnswer(AuditAnswers answer)
{
using (var database = new SQLiteConnection(_helper.WritableDatabase.Path))
{
try
{
return(database.Insert(answer));
}
catch (Exception ex)
{
throw;
}
}
}
public void SaveAudit(string[] answers)
{
AuditDetails audit = new AuditDetails();
//audit.Id = 1;
audit.TemplateId = 1;
audit.Location = "CGI Mumbai";
audit.UserId = "CGI Admin";
audit.GPSCoordinate = "10,20";
int auditid = SaveAuditDetail(audit);
for (int i = 0; i < answers.Length; i++)
{
AuditAnswers answer = new AuditAnswers();
answer.AuditId = auditid;
answer.Answer = answers[i];
answer.QuestionId = i + 1;
SaveAnswer(answer);
}
}
