public List <Feedbacksc> GetBusFeedbacks() { List <Feedbacksc> studetails = new List <Feedbacksc>(); try { cmd.CommandText = "SELECT id AS 'Explorer',modcode AS 'Module Code',feedback AS 'Feedback' FROM feedbacks WHERE fac='Business'"; cmd.CommandType = CommandType.Text; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Feedbacksc lecgv = new Feedbacksc() { Id = reader[0].ToString(), Modcode = reader[1].ToString(), Feedback = reader[2].ToString(), }; studetails.Add(lecgv); } return(studetails); } catch (Exception) { throw; } finally { if (con != null) { con.Close(); } } }
public int AddFeedback(Feedbacksc fbd) { try { cmd.CommandText = "INSERT INTO feedbacks(username,fac,modcode,feedback) VALUES (@u,@fc,@mc,@fb)"; cmd.Parameters.AddWithValue("u", fbd.Username); cmd.Parameters.AddWithValue("fc", fbd.Faculty); cmd.Parameters.AddWithValue("mc", fbd.Modcode); cmd.Parameters.AddWithValue("fb", fbd.Feedback); con.Open(); cmd.CommandType = CommandType.Text; return(cmd.ExecuteNonQuery()); } catch (Exception) { throw; } finally { con.Close(); } }