public void AddCommentReport(CommentsReport coRe) { try { this.conn.Open(); string cmdString = "INSERT INTO CommentsReport(CoReUsID, ReID, CoReTitle, CoReContent, CoReCreateDate)"; // Columns Value cmdString += " VALUES(@CoReUsIDN, @ReIDN, @CoReTitleN,@CoReContentN, @CoReCreateDateN)"; this.command = new SqlCommand(cmdString, conn); // Add Values this.command.Parameters.AddWithValue("@CoReUsIDN", coRe.coReUsID); this.command.Parameters.AddWithValue("@ReIDN", coRe.reID); this.command.Parameters.AddWithValue("@CoReTitleN", coRe.coReTitle); this.command.Parameters.AddWithValue("@CoReContentN", coRe.coReContent); this.command.Parameters.AddWithValue("@CoReCreateDateN", coRe.coReCreateTime); this.command.ExecuteNonQuery(); } catch (Exception) { throw; } finally { this.conn.Close(); } }
protected void commentReport_Click(object sender, EventArgs e) { string currentUserID = HttpContext.Current.Session["UsID"].ToString(); CommentsReport coRe = new CommentsReport(Int32.Parse(currentUserID), Int32.Parse(currentReportID), titleComment.Value, contentComment.Value, DateTime.Now); this.dbm.AddCommentReport(coRe); Response.Redirect("DLT-CommentsReport.aspx"); }
public List<CommentsReport> ListCommentDetailsForPVC(string pvcID) { DataTable dt; List<CommentsReport> coReList = new List<CommentsReport>(); try { dt = new DataTable(); this.conn.Open(); string cmdString = "SELECT coRe.*, re.UsCreateID, c.CoCM"; cmdString += " FROM CommentsReport coRe"; cmdString += " LEFT JOIN Reports re ON coRe.ReID = re.ReID"; cmdString += " LEFT JOIN Courses c ON re.CoID = c.CoID"; cmdString += " LEFT JOIN Faculties f ON f.FaID = c.FaID"; cmdString += " WHERE f.FaPVC ='" + pvcID + "' "; this.command = new SqlCommand(cmdString, conn); dt.Load(this.command.ExecuteReader()); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int coReID = Convert.ToInt32(dt.Rows[i]["CoReID"]); int coReUsID = Convert.ToInt32(dt.Rows[i]["CoReUsID"]); int reID = Convert.ToInt32(dt.Rows[i]["ReID"]); string coReTitle = dt.Rows[i]["CoReTitle"].ToString(); string coReContent = dt.Rows[i]["CoReContent"].ToString(); DateTime coReCreateDate; DateTime.TryParse(dt.Rows[i]["CoReCreateDate"].ToString(), out coReCreateDate); CommentsReport coRe = new CommentsReport(coReID, coReUsID, reID, coReTitle, coReContent, coReCreateDate); coReList.Add(coRe); } } return coReList; } catch (Exception) { return null; throw; } finally { this.conn.Close(); } }
public List<CommentsReport> ListCommentDetailsForDLT(string dltID) { DataTable dt; List<CommentsReport> coReList = new List<CommentsReport>(); try { dt = new DataTable(); this.conn.Open(); string cmdString = "SELECT *"; cmdString += " FROM CommentsReport"; cmdString += " WHERE CoReUsID ='" + dltID + "' "; this.command = new SqlCommand(cmdString, conn); dt.Load(this.command.ExecuteReader()); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { int coReID = Convert.ToInt32(dt.Rows[i]["CoReID"]); int coReUsID = Convert.ToInt32(dt.Rows[i]["CoReUsID"]); int reID = Convert.ToInt32(dt.Rows[i]["ReID"]); string coReTitle = dt.Rows[i]["CoReTitle"].ToString(); string coReContent = dt.Rows[i]["CoReContent"].ToString(); DateTime coReCreateDate; DateTime.TryParse(dt.Rows[i]["CoReCreateDate"].ToString(), out coReCreateDate); CommentsReport coRe = new CommentsReport(coReID, coReUsID, reID, coReTitle, coReContent, coReCreateDate); coReList.Add(coRe); } } return coReList; } catch (Exception) { return null; throw; } finally { this.conn.Close(); } }