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