public ActionResult listtickets(string Email_ID) { try { incidentlist incidents = new incidentlist(); DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand("listincidents", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@employee_mail_id", Email_ID); SqlDataAdapter da = new SqlDataAdapter(cmd); connection.Open(); da.Fill(ds); List <incidentlist> incidentlists = new List <incidentlist>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { incidentlist incidentlist = new incidentlist(); incidentlist.incidentID = Convert.ToInt32(ds.Tables[0].Rows[i]["incident_id"]); incidentlist.title = ds.Tables[0].Rows[i]["incident_title"].ToString(); incidentlists.Add(incidentlist); } incidents.incidentarray = incidentlists; return(View(incidents)); } catch (SqlException ex) { throw ex; } catch (Exception e) { throw e; } finally { connection.Close(); } }
public ActionResult OnSubmit(string Email_ID) { incidentlist incidents = new incidentlist(); DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand("listincidents", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@employee_mail_id", Email_ID); SqlDataAdapter da = new SqlDataAdapter(cmd); connection.Open(); da.Fill(ds); List <incidentlist> incidentlists = new List <incidentlist>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { incidentlist incidentlist = new incidentlist(); incidentlist.incidentID = Convert.ToInt32(ds.Tables[0].Rows[i]["incident_id"]); incidentlist.title = ds.Tables[0].Rows[i]["incident_title"].ToString(); incidentlist.incident_description = ds.Tables[0].Rows[i]["incident_descripton"].ToString(); incidentlist.raised_by = ds.Tables[0].Rows[i]["raised_by"].ToString(); incidentlist.status = ds.Tables[0].Rows[i]["stage"].ToString(); incidentlist.SupportedBy = ds.Tables[0].Rows[i]["handler_name"].ToString(); if (!Convert.IsDBNull(ds.Tables[0].Rows[i]["created_on"])) { incidentlist.created_on = Convert.ToDateTime(ds.Tables[0].Rows[i]["created_on"]); } if (!Convert.IsDBNull(ds.Tables[0].Rows[i]["altered_on"])) { incidentlist.altered_on = Convert.ToDateTime(ds.Tables[0].Rows[i]["altered_on"]); } incidentlists.Add(incidentlist); } incidents.incidentarray = incidentlists; return(View(incidents)); }