protected void Page_Load(object sender, EventArgs e)
{
SessionManager = new USTTISessionManager(Session);
try
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
string Country = loadRequest(SessionList, "Country");
string Year = loadRequest(SessionList, "Year");
string First = loadRequest(SessionList, "First");
string Last = loadRequest(SessionList, "Last");
string Years = loadRequest(SessionList, "Years");
string StartYear = String.Empty;
string EndYear = String.Empty;
if (Years.Length > 0)
{
StartYear = Years.Split(',')[0];
EndYear = Years.Split(',')[1];
}
if (!Page.IsPostBack)
{
loadReport(Country, Year, First, Last, StartYear, EndYear);
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
SessionManager = new USTTISessionManager(Session);
try
{
USTTISessionCollection SessionList = SessionManager.getSessionList();
string Country = loadRequest(SessionList, "Country");
string Year = loadRequest(SessionList, "Year");
string First = loadRequest(SessionList, "First");
string Last = loadRequest(SessionList, "Last");
string CourseNum = loadRequest(SessionList, "Course Num");
string Title = loadRequest(SessionList, "Title");
string Years = loadRequest(SessionList, "Years");
string StartYear = String.Empty;
string EndYear = String.Empty;
if (Years.Length > 0)
{
StartYear = Years.Split(',')[0];
EndYear = Years.Split(',')[1];
}
string Participant = loadRequest(SessionList, "Participat");
Participant = Participant == "Y" ? "Yes" : "No";
if (!Page.IsPostBack)
{
loadReport(Country, Year, First, Last, CourseNum, Title, StartYear, EndYear, Participant);
}
}
catch (Exception ex)
{
}
}
public void loadRequest(HttpRequest request, USTTISessionManager SessionManager, string key)
{
try
{
string keyValue = request[key].ToString().Trim();
SessionManager.addSessionData(key, keyValue);
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
Session.Add("CurrentPage", "STATUS");
SessionManager = new USTTISessionManager(Session);
UtilManager = new USTTIUtil();
if (!Page.IsPostBack)
{
Session.Remove("SortExpression");
Session["OrderExpression"] = "DESC";
loadRequestData();
SessionManager.saveList(Session);
BindData();
}
loadConstraintData();
}
protected void Page_Load(object sender, EventArgs e)
{
string key = Request["key"].ToString();
string returnPage = Request["return"].ToString();
SessionManager = new USTTISessionManager(Session);
USTTISessionCollection SessionList = SessionManager.getSessionList();
for (int i = 0; i < SessionList.Count; i++)
{
USTTISession app = (USTTISession)SessionList[i];
if (app.key == key)
{
SessionList.RemoveAt(i);
}
}
SessionManager.saveList(Session);
Response.Redirect(returnPage + ".aspx");
}
protected DataTable GetLabelData()
{
SessionManager = new USTTISessionManager(Session);
USTTISessionCollection SessionList = SessionManager.getSessionList();
string Country = loadRequest(SessionList, "Country");
string Year = loadRequest(SessionList, "Year");
string First = loadRequest(SessionList, "First");
string Last = loadRequest(SessionList, "Last");
string Years = loadRequest(SessionList, "Years");
string CourseNum = loadRequest(SessionList, "Course Num");
string Title = loadRequest(SessionList, "Title");
string StartYear = String.Empty;
string EndYear = String.Empty;
if (Years.Length > 0)
{
StartYear = Years.Split(',')[0];
EndYear = Years.Split(',')[1];
}
string Participant = loadRequest(SessionList, "Participat");
Participant = Participant == "Y" ? "Yes" : "No";
SqlConnection thisConnection = new SqlConnection();
SqlParameter[] SearchValue = new SqlParameter[1];
SqlDataReader reader;
thisConnection.ConnectionString = ConfigurationManager.ConnectionStrings["usttiConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_MultiBioSheetStatus";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = thisConnection;
cmd.Parameters.Add(new SqlParameter("@Year", SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@First", SqlDbType.NVarChar, 30));
cmd.Parameters.Add(new SqlParameter("@Last", SqlDbType.NVarChar, 30));
cmd.Parameters.Add(new SqlParameter("@CourseNum", SqlDbType.NVarChar, 30));
cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.NVarChar, 100));
cmd.Parameters.Add(new SqlParameter("@StartYear", SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@EndYear", SqlDbType.NVarChar, 10));
cmd.Parameters.Add(new SqlParameter("@Participant", SqlDbType.NVarChar, 10));
if (Year.Length > 0)
{
cmd.Parameters["@Year"].Value = Year;
}
else
{
cmd.Parameters["@Year"].Value = System.DBNull.Value;
}
if (Country.Length > 0)
{
cmd.Parameters["@Country"].Value = Country;
}
else
{
cmd.Parameters["@Country"].Value = System.DBNull.Value;
}
if (First.Length > 0)
{
cmd.Parameters["@First"].Value = First;
}
else
{
cmd.Parameters["@First"].Value = System.DBNull.Value;
}
if (Last.Length > 0)
{
cmd.Parameters["@Last"].Value = Last;
}
else
{
cmd.Parameters["@Last"].Value = System.DBNull.Value;
}
if (CourseNum.Length > 0)
{
cmd.Parameters["@CourseNum"].Value = CourseNum;
}
else
{
cmd.Parameters["@CourseNum"].Value = System.DBNull.Value;
}
if (Title.Length > 0)
{
cmd.Parameters["@Title"].Value = Title;
}
else
{
cmd.Parameters["@Title"].Value = System.DBNull.Value;
}
if (StartYear.Length > 0)
{
cmd.Parameters["@StartYear"].Value = StartYear;
}
else
{
cmd.Parameters["@StartYear"].Value = System.DBNull.Value;
}
if (EndYear.Length > 0)
{
cmd.Parameters["@EndYear"].Value = EndYear;
}
else
{
cmd.Parameters["@EndYear"].Value = System.DBNull.Value;
}
if (Participant.Length > 0)
{
cmd.Parameters["@Participant"].Value = Participant;
}
else
{
cmd.Parameters["@Participant"].Value = System.DBNull.Value;
}
thisConnection.Open();
reader = cmd.ExecuteReader();
DataSet thisDataSet = new DataSet();
DataTable dt = new DataTable();
thisDataSet.Tables.Add(dt);
thisDataSet.Load(reader, LoadOption.PreserveChanges, thisDataSet.Tables[0]);
return(thisDataSet.Tables[0]);
}
