//-------------------------------------------------------------------- // Build the Insert command String //-------------------------------------------------------------------- private String BuildInsertCommand(AdsFeedback mngcom) { String command; command = "update feedbackstudenttoads_P3 set managercomment ='" + mngcom.Managercomment + "' where feedbackstudenttoads_P3.fbAdsNum=" + mngcom.FbAdsNum; return(command); }
public HttpResponseMessage Insertcomment([FromBody] AdsFeedback addmngcom) { try { addmngcom.Insertcomment(); return(Request.CreateResponse(HttpStatusCode.OK, "Comment added successfully")); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }
public List <AdsFeedback> GetFBad(int adCode) { SqlConnection con = null; List <AdsFeedback> FBList = new List <AdsFeedback>(); try { con = connect1("DBConnectionString"); String selectSTR = "select * from feedbackstudenttoads_P3 inner join student_P on student_P.mail=feedbackstudenttoads_P3.studentmail where feedbackstudenttoads_P3.adCode=" + adCode; SqlCommand cmd = new SqlCommand(selectSTR, con); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { // Read till the end of the data into a row AdsFeedback FB = new AdsFeedback(); FB.FbAdsNum = Convert.ToInt16(dr["fbAdsNum"]); FB.Student = (new Student { Fname = (string)dr["firstName"] }); FB.Student.Mail = (string)dr["mail"]; FB.CommentText = (string)dr["commenttext"]; FB.CommentDate = Convert.ToDateTime(dr["commentdate"]); FB.Managercomment = Convert.ToString(dr["managercomment"]); FBList.Add(FB); } return(FBList); } catch (Exception ex) { // write to log throw (ex); } finally { if (con != null) { con.Close(); } } }
public int Insertcomment(AdsFeedback mngcom) { SqlConnection con; SqlCommand cmd; try { con = connect1("DBConnectionString"); // create the connection } catch (Exception ex) { // write to log throw (ex); } String cStr = BuildInsertCommand(mngcom); // helper method to build the insert string cmd = CreateCommand1(cStr, con); // create the command try { int numEffected = cmd.ExecuteNonQuery(); // execute the command return(numEffected); } catch (Exception ex) { // write to log throw (ex); } finally { if (con != null) { // close the db connection con.Close(); } } }