protected void btnSubmit_Click(object sender, EventArgs e)
{
using (var context = new COVID19Entities())
{
var getLocationID = (from x in context.Locations
where x.LocationName == ddlLocationName.SelectedValue
select x.ID).FirstOrDefault();
var getLatestID = (from x in context.ContactTracings
orderby x.ID descending
select x.ID).FirstOrDefault() + 1;
if (Decimal.Parse(tbTemp.Text) > 38)
{
MessageBox.Show("Your Temperature is above the 38 degrees celsius threshold", "Temperature", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
context.ContactTracings.Add(new ContactTracing()
{
ID = getLatestID,
Contact = tbContact.Text,
Email = tbEmail.Text,
FullName = tbFullName.Text,
LocationID = getLocationID,
Temp = Decimal.Parse(tbTemp.Text),
RegisterDateTime = DateTime.Now
});
context.SaveChanges();
MessageBox.Show("Record submitted successfully", "Submit", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearEntries();
}
}
private void loadDDL()
{
using (var context = new COVID19Entities())
{
foreach (var item in context.Locations.Select(x => x.LocationFloor).Distinct())
{
ddlLocationLevel.Items.Add(item.ToString());
}
}
}
protected void ddlLocationLevel_SelectedIndexChanged(object sender, EventArgs e)
{
ddlLocationName.Items.Clear();
using (var context = new COVID19Entities())
{
var selectedLevel = Byte.Parse(ddlLocationLevel.SelectedValue);
var rooms = context.Locations.Where(x => x.LocationFloor == selectedLevel).Select(x => x.LocationName);
foreach (var item in rooms)
{
ddlLocationName.Items.Add(item);
}
}
}