public int ConsentView()
{
if (Request.Method == "POST")
{
var body = new StreamReader(Request.Body).ReadToEnd();
ConsentData consent = new ConsentData(GetCourseID(), GetUserID(), GetUserName(), (int)JObject.Parse(body)["granted"]);
DatabaseManager.Instance.SetConsent(consent);
return(consent.Granted);
}
else
{
return(DatabaseManager.Instance.GetConsent(GetCourseID(), GetUserID()));
}
}
public async Task CreateConsent()
{
consentData = new CdipData();
service = new GrowerConsentService(consentData, confirmationTokenService);
var id = Guid.NewGuid().ToString();
var consent = new GrowerConsentFormModel
{
GrowerConsentCommonId = id,
ContactName = "TestConsent",
Email = "*****@*****.**",
};
await service.CreateGrowerConsent(consent);
var insertedConsent = await consentData.GetConsent(id);
Assert.AreEqual(consent.ContactName, insertedConsent.ContactName);
Assert.AreEqual(consent.Email, insertedConsent.Email);
}
public async Task CreateConsentCropAcres()
{
consentData = new CdipData();
service = new GrowerConsentService(consentData, confirmationTokenService);
var consent = new GrowerConsentFormModel
{
GrowerConsentCommonId = Guid.NewGuid().ToString(),
ContactName = "TestConsent1",
Email = "*****@*****.**",
CropAcres = new List <CropAcresModel>()
{
new CropAcresModel
{
CropId = Guid.NewGuid().ToString(),
CropName = "Rubbish",
CropAcres = 100500
},
new CropAcresModel
{
CropId = Guid.NewGuid().ToString(),
CropName = "Garbage",
CropAcres = 1050
},
}
};
await service.CreateGrowerConsent(consent);
var insertedConsent = await consentData.GetConsent(consent.GrowerConsentCommonId);
Assert.AreEqual(consent.ContactName, insertedConsent.ContactName);
foreach (var crop in consent.CropAcres)
{
var insertedCrop = await consentData.GetCropAcres(crop.CropId);
Assert.AreEqual(insertedCrop.CropName, crop.CropName);
Assert.AreEqual(insertedCrop.CropAcres, crop.CropAcres);
}
}
public void SetConsent(ConsentData data)
{
Console.WriteLine("consent");
Console.WriteLine(GetConsent(data.CourseID, data.UserID));
if (GetConsent(data.CourseID, data.UserID) == -1)
{
command = connection.CreateCommand();
command.CommandText = String.Format(
"INSERT INTO consent (course_id, user_id, user_name, granted) VALUES('{0}', '{1}', '{2}', '{3}');",
data.CourseID, data.UserID, data.UserName, data.Granted
);
command.ExecuteNonQuery();
}
else
{
command = connection.CreateCommand();
command.CommandText = String.Format(
"UPDATE consent SET `granted` = {0} WHERE `course_id` = {1} AND `user_id` = {2};",
data.Granted, data.CourseID, data.UserID
);
command.ExecuteNonQuery();
}
}
