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