protected void btnGetIncidents_Click(object sender, EventArgs e) { lstIncidents.Items.Clear(); DataView incidentsTable = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); incidentsTable.RowFilter = string.Format("CustomerID = '{0}' And DateClosed Is Not Null", txtCustomerID.Text); if (incidentsTable.Count == 0) { lblNoIncidents.Text = "No closed incidents found for that customer ID."; lblNoIncidents.Visible = true; DisableSurveyFields(); } else { lstIncidents.Items.Add(new ListItem("--Select an incident--", "None")); foreach (DataRowView row in incidentsTable) { Models.Incident i = new Models.Incident(); i.IncidentID = (int)row["IncidentID"]; i.CustomerID = (int)row["CustomerID"]; i.ProductCode = row["ProductCode"].ToString(); i.TechID = (int)row["TechID"]; i.DateOpened = (DateTime)row["DateOpened"]; i.DateClosed = (DateTime)row["DateClosed"]; i.Title = row["Title"].ToString(); lstIncidents.Items.Add(new ListItem(i.CustomerIncidentDisplay(), i.IncidentID.ToString())); } lstIncidents.Focus(); //lstIncidents.Items[0].Selected = true; // Commented to let validator trigger on no selection EnableSurveyFields(); } }
public int addIncident(Incident incident) { entities.Incidents.Add(incident); return(entities.SaveChanges()); }