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