protected void Page_Load(object sender, EventArgs e) { Page.Title = "Report Details - eCMR"; if (HttpContext.Current.Session["RoAccessLevel"] != null && HttpContext.Current.Session["RoAccessLevel"].ToString() == "5") { currentReportID = Request.QueryString["ReportID"]; this.dbm = new DatabaseMgmt(); rdCL = this.dbm.ReporDetailstforCL(currentReportID); if (rdCL != null) { currentCourseCode = rdCL.coCode; currentCourseName = rdCL.coName; reportCreateDate = String.Format("{0:dd MMM yyyy hh:mm:ss}", rdCL.reCreateDate); userCreateID = rdCL.usCreateID.ToString(); retypeName = rdCL.reTyName; loadReportRepeater(); } else { Response.Redirect("CL-Reports.aspx"); } } else { Response.Redirect("Login.aspx"); } }
public ReportDetailsForCL ReporDetailstforCL(string reID) { DataTable dt; ReportDetailsForCL rdCL = null; try { dt = new DataTable(); this.conn.Open(); string cmdString = "SELECT r.*, c.CoCode, c.CoName, rt.* "; cmdString += " FROM Reports r"; cmdString += " LEFT JOIN Courses c ON r.CoID = c.CoID"; cmdString += " LEFT JOIN ReportTypes rt ON r.ReTyID = rt.ReTyID"; cmdString += " WHERE r.ReID ='" + reID + "' "; this.command = new SqlCommand(cmdString, conn); dt.Load(this.command.ExecuteReader()); if (dt.Rows.Count > 0) { int usCreateID = Convert.ToInt32(dt.Rows[0]["UsCreateID"]); DateTime reCreateDate; DateTime.TryParse(dt.Rows[0]["ReCreateDate"].ToString(), out reCreateDate); string coCode = dt.Rows[0]["CoCode"].ToString(); string coName = dt.Rows[0]["CoName"].ToString(); string reTyName = dt.Rows[0]["ReTyName"].ToString(); int numberOFField = Convert.ToInt32(dt.Rows[0]["ReTyNumberOfField"]); List<string> reContent = new List<string>(); for (int j = 1; j <= numberOFField; j++) { string currentContent = dt.Rows[0]["ReContent" + (j)].ToString(); reContent.Add(currentContent); } List<string> reTyFieldName = new List<string>(); for (int k = 1; k <= numberOFField; k++) { string currentFieldName = dt.Rows[0]["ReTyFieldName" + (k)].ToString(); reTyFieldName.Add(currentFieldName); } rdCL = new ReportDetailsForCL(Convert.ToInt32(reID), usCreateID, reCreateDate, coCode, coName, reTyName, numberOFField, reContent.ToArray(), reTyFieldName.ToArray()); } return rdCL; } catch (Exception) { return null; throw; } finally { this.conn.Close(); } }