//To Update Problem public void UpdateProblem(ProblemInfo pro) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SP_UpdateProblem", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", pro.Name); cmd.Parameters.AddWithValue("@Detial", pro.Detial); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } }
// Get problem by ID public ProblemInfo GetProblemById(int proId) { ProblemInfo pro = new ProblemInfo(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SP_GetProblemById", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProId", proId); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { pro.ID = Convert.ToInt32(dr["ID"].ToString()); pro.Name = dr["Name"].ToString(); pro.Detial = dr["Detial"].ToString(); } con.Close(); } return(pro); }
//Get All public IEnumerable <ProblemInfo> GetAllProblem() { List <ProblemInfo> proList = new List <ProblemInfo>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SP_GetAllProblem", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ProblemInfo pro = new ProblemInfo(); pro.ID = Convert.ToInt32(dr["ID"].ToString()); pro.Name = dr["Name"].ToString(); pro.Detial = dr["Detial"].ToString(); proList.Add(pro); } con.Close(); } return(proList); }