private void DisplayClosedIncidents() { // To format date DateTime myDateTime; String output; lstIncidents.Items.Add(new ListItem("--Select an incident--", "None")); foreach (DataRowView row in incidentsTable) { //create a new product object and load with data from row Incident i = new Incident(); this.Title = Title; i.IncidentID = (int)row["IncidentID"]; i.CustomerID = (int)row["CustomerID"]; i.ProductCode = row["ProductCode"].ToString(); i.TechID = (int)row["TechID"]; i.DateOpened = row["DateOpened"].ToString(); myDateTime = DateTime.Parse(i.DateOpened); output = myDateTime.ToShortDateString(); i.DateOpened = output; i.DateClosed = row["DateClosed"].ToString(); myDateTime = DateTime.Parse(i.DateClosed); output = myDateTime.ToShortDateString(); i.DateClosed = output; i.Title = row["Title"].ToString(); String text = i.CustomerIncidentDisplay(); String value = i.IncidentID.ToString(); lstIncidents.Items.Add(new ListItem(text, value)); } lstIncidents.SelectedIndex = 0; lblError.Text = ""; }
private void DisplayClosedIncidents() { lstIncidents.Items.Add(new ListItem("--Select an incident--", "")); foreach (DataRowView row in incidentsTable) { Incident incident = new Incident(); incident.IncidentID = Convert.ToInt32(row["IncidentID"]); incident.ProductCode = row["ProductCode"].ToString(); incident.DateClosed = Convert.ToDateTime(row["DateClosed"]); incident.Title = row["Title"].ToString(); lstIncidents.Items.Add(new ListItem( incident.CustomerIncidentDisplay(), incident.IncidentID.ToString())); } lstIncidents.SelectedIndex = 0; lblNoIncidents.Text = ""; }
private void getSelectedCustomer() { DataView incidentTable = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); incidentTable.RowFilter = "DateClosed is not NULL AND CustomerID = '" + int.Parse(txtCustId.Text) + "'"; Incident inc = new Incident(); int rowIndex = 0; lstIncidents.Items.Add(new ListItem("--Select an Incident--", null)); foreach (DataRowView iRows in incidentTable) { DataRowView incRow = incidentTable[0]; inc.CustomerID = (int)iRows["CustomerID"]; inc.IncidentId = (int)iRows["IncidentID"]; inc.ProductCode = iRows["ProductCode"].ToString(); inc.TechID = (int)iRows["TechID"]; inc.Title = (string)iRows["Title"]; inc.DateOpened = (DateTime)iRows["DateOpened"]; inc.DateClosed = (DateTime)iRows["DateClosed"]; rowIndex = rowIndex + 1; lstIncidents.Items.Add(inc.CustomerIncidentDisplay()); } }