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(); } }