public int GetMaxClassId()
{
datasethasTableAdapters.classTableAdapter classTableAdapter = new datasethasTableAdapters.classTableAdapter();
datasethas hasData = new datasethas();
return(int.Parse(classTableAdapter.GetMaxId().ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
dataaccess da = new dataaccess();
datasethas dshClass = new datasethas();
int pid, cid;
bool cancel = new tools().SessionCheck(Session);
if (cancel)
{
Response.Redirect("Default.aspx");
}
pid = int.Parse(Session[constants.SESSION_PID].ToString());
cid = int.Parse(Session[constants.SESSION_MODE_EDIT_CID].ToString());
dshClass = da.GetClassByPidAndCid(pid, cid);
this.labelClassId.Text = cid.ToString();
this.labelClassnumber.Text = dshClass._class[0].classnumber;
this.SqlDataSourceRepeaterAlerts.SelectParameters.Clear(); //remove all without selection
this.SqlDataSourceRepeaterAlerts.SelectParameters.Add("pid", Session[constants.SESSION_PID].ToString());
this.SqlDataSourceRepeaterAlerts.SelectParameters.Add("cid", Session[constants.SESSION_MODE_EDIT_CID].ToString());
this.RepeaterAlerts.DataBind();
}
public int GetMaxStudentId()
{
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethas hasData = new datasethas();
return(int.Parse(studentTableAdapter.GetMaxId().ToString()));
}
private void SendAlert()
{
dataaccess da = new dataaccess();
datasethas hasData = da.GetAlert(int.Parse(this._aid));
this.SendMail(da.GetStudentMail(int.Parse(this._sid)), hasData.alert[0].subject, hasData.alert[0].message);
}
protected void Page_Load(object sender, EventArgs e)
{
dataaccess da = new dataaccess();
bool cancel = new tools().SessionCheck(Session);
if (cancel)
{
Response.Redirect("Default.aspx");
}
this.SqlDataSourceRepeaterClasses.SelectParameters.Add("id", Session[constants.SESSION_PID].ToString());
_dataSetClasses = da.GetAllClasses(int.Parse(Session[constants.SESSION_PID].ToString()));
switch (Session[constants.SESSION_MODE].ToString())
{
case constants.SESSION_MODE_EDIT_CLASS:
this.FormViewClass.ChangeMode(FormViewMode.Edit);
_currentClassId = Session[constants.SESSION_MODE_EDIT_CID].ToString();
this.SqlDataSourceClass.UpdateParameters.Add("cid", _currentClassId);
break;
case constants.SESSION_MODE_VIEW:
this.FormViewClass.ChangeMode(FormViewMode.ReadOnly);
_currentClassId = Session[constants.SESSION_MODE_VIEW_ID].ToString();
break;
default:
case constants.SESSION_MODE_ADD:
this.FormViewClass.ChangeMode(FormViewMode.Insert);
break;
}
this.SqlDataSourceClass.SelectParameters.Add("cid", _currentClassId);
}
public datasethas GetClassByPidAndCid(int pid, int cid)
{
datasethasTableAdapters.classTableAdapter classTableAdapter = new datasethasTableAdapters.classTableAdapter();
datasethas hasData = new datasethas();
classTableAdapter.FillClassByPidAndCid(hasData._class, pid, cid);
return(hasData);
}
public datasethas GetStudentsByPidAndCid(int pid, int cid)
{
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethas hasData = new datasethas();
studentTableAdapter.FillStudentsByByPidAndCid(hasData.student, pid, cid);
return(hasData);
}
public datasethas GetAllClasses(int pid)
{
datasethasTableAdapters.classTableAdapter classTableAdapter = new datasethasTableAdapters.classTableAdapter();
datasethas hasData = new datasethas();
classTableAdapter.FillClassByPid(hasData._class, pid); //this is weird lol.. why _?
return(hasData);
}
public string GetStudentMail(int sid)
{
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethas hasData = new datasethas();
studentTableAdapter.FillStudentByStudentId(hasData.student, sid);
return(hasData.student[0].email);
}
public datasethas GetAlert(int aid)
{
datasethasTableAdapters.alertTableAdapter alertTableAdapter = new datasethasTableAdapters.alertTableAdapter();
datasethas hasData = new datasethas();
alertTableAdapter.FillAlertById(hasData.alert, aid);
return(hasData);
}
public alertprogress CreateSendingOrderIdList(datasethas hasData)
{
alertprogress ap = new alertprogress(new List <string>(), new List <string>());
foreach (System.Data.DataRow dr in hasData.student.Rows)
{
ap.unsent.Add(dr["id"].ToString());
}
return(ap);
}
protected void Page_Load(object sender, EventArgs e)
{
bool cancel = new tools().SessionCheck(Session);
if (cancel)
{
Response.Redirect("Default.aspx");
}
int aid = int.Parse(Session[constants.SESSION_MODE_SEND_AID].ToString());
dataaccess da = new dataaccess();
_hasData = da.GetAlertClassAndStudentsByAlertId(aid);
labelClassId.Text = _hasData._class[0].id.ToString();
labelClassnumber.Text = _hasData._class[0].classnumber.ToString();
this.RepeaterStudents.DataSource = _hasData.student;
this.RepeaterStudents.DataBind();
this.imageButtonSend.ToolTip = "Start Sending Alerts";
if (Session[constants.SESSION_MODE].ToString() == constants.SESSION_MODE_SENDING)
{
tools t = new tools();
alertprogress ap = (alertprogress)Session[constants.SESSION_MODE_SENDING_PROGRESS];
this.imageButtonSend.ImageUrl = "~/img/sending.gif";
this.imageButtonSend.ToolTip = "Sending Alerts~ (Please Wait)";
this.SetRepeaterStatuses(ap);
//Verify script isn't already registered
if (!ClientScript.IsClientScriptBlockRegistered("waitScript"))
{
string js = "\n<script type=\"text/javascript\" language=\"Javascript\" id=\"waitScript\">\n";
js += "wait(2000);";
js += "\n\n </script>";
ClientScript.RegisterClientScriptBlock(this.GetType(), "waitScript", js);
}
t.Alerting(Session, ap);
}
if (Session[constants.SESSION_MODE].ToString() == constants.SESSION_MODE_SENDING_FINISHED)
{
alertprogress ap = (alertprogress)Session[constants.SESSION_MODE_SENDING_PROGRESS];
this.imageButtonSend.ImageUrl = "~/img/ok.png";
this.imageButtonSend.ToolTip = "Finished Sending! Click to return to class~ ^^";
this.SetRepeaterStatuses(ap);
da.UpdateAlertStatus(aid);
}
}
public datasethas GetAlertClassAndStudentsByAlertId(int aid)
{
datasethasTableAdapters.alertTableAdapter alertTableAdapter = new datasethasTableAdapters.alertTableAdapter();
datasethasTableAdapters.studentTableAdapter studentTableAdapter = new datasethasTableAdapters.studentTableAdapter();
datasethasTableAdapters.classTableAdapter classTableAdapter = new datasethasTableAdapters.classTableAdapter();
datasethas hasData = new datasethas();
alertTableAdapter.FillAlertById(hasData.alert, aid);
classTableAdapter.FillByClassId(hasData._class, hasData.alert[0].classid);
studentTableAdapter.FillStudentsByAlertId(hasData.student, aid);
return(hasData);
}
protected void Page_Load(object sender, EventArgs e)
{
dataaccess da = new dataaccess();
bool cancel = new tools().SessionCheck(Session);
if (cancel)
{
Response.Redirect("Default.aspx");
}
this.SqlDataSourceRepeaterClasses.SelectParameters.Add("id", Session[constants.SESSION_PID].ToString());
_dataSetClasses = da.GetAllClasses(int.Parse(Session[constants.SESSION_PID].ToString()));
}
protected void Page_Load(object sender, EventArgs e)
{
dataaccess da = new dataaccess();
datasethas dshClass = new datasethas();
int pid, cid;
bool cancel = new tools().SessionCheck(Session);
if (cancel)
{
Response.Redirect("Default.aspx");
}
pid = int.Parse(Session[constants.SESSION_PID].ToString());
cid = int.Parse(Session[constants.SESSION_MODE_EDIT_CID].ToString());
dshClass = da.GetClassByPidAndCid(pid, cid);
this.labelClassId.Text = cid.ToString();
this.labelClassnumber.Text = dshClass._class[0].classnumber;
switch (Session[constants.SESSION_MODE].ToString())
{
case constants.SESSION_MODE_ADD:
this.FormViewAlert.ChangeMode(FormViewMode.Insert);
break;
case constants.SESSION_MODE_EDIT_ALERT:
//removing existing parameters because of postback
this.SqlDataSourceFormViewAlert.SelectParameters.Clear();
foreach (Parameter p in this.SqlDataSourceFormViewAlert.UpdateParameters)
{
if (p.Name == "cid" || p.Name == "pid" || p.Name == "aid")
{
this.SqlDataSourceFormViewAlert.UpdateParameters.Remove(p);
}
}
this.SqlDataSourceFormViewAlert.SelectParameters.Add("cid", Session[constants.SESSION_MODE_EDIT_CID].ToString());
this.SqlDataSourceFormViewAlert.SelectParameters.Add("pid", Session[constants.SESSION_PID].ToString());
this.SqlDataSourceFormViewAlert.SelectParameters.Add("aid", Session[constants.SESSION_MODE_EDIT_AID].ToString());
this.SqlDataSourceFormViewAlert.UpdateParameters.Add("cid", Session[constants.SESSION_MODE_EDIT_CID].ToString());
this.SqlDataSourceFormViewAlert.UpdateParameters.Add("pid", Session[constants.SESSION_PID].ToString());
this.SqlDataSourceFormViewAlert.UpdateParameters.Add("aid", Session[constants.SESSION_MODE_EDIT_AID].ToString());
this.FormViewAlert.ChangeMode(FormViewMode.Edit);
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
dataaccess da = new dataaccess();
datasethas dshClass = new datasethas();
int pid, cid;
bool cancel = new tools().SessionCheck(Session);
if (cancel)
{
Response.Redirect("Default.aspx");
}
pid = int.Parse(Session[constants.SESSION_PID].ToString());
cid = int.Parse(Session[constants.SESSION_MODE_EDIT_CID].ToString());
dshClass = da.GetClassByPidAndCid(pid, cid);
_dataSetStudents = da.GetStudentsByPidAndCid(pid, cid);
this.labelClassId.Text = cid.ToString();
this.labelClassnumber.Text = dshClass._class[0].classnumber;
switch (Session[constants.SESSION_MODE].ToString())
{
case constants.SESSION_MODE_ADD:
this.FormViewStudents.Visible = true;
this.FormViewStudents.ChangeMode(FormViewMode.Insert);
break;
case constants.SESSION_MODE_EDIT_STUDENT:
this.FormViewStudents.Visible = true;
//removing existing parameters because of postback
for (int i = 0; i < this.SqlDataSourceFormViewStudents.SelectParameters.Count; i++)
{
if (this.SqlDataSourceFormViewStudents.SelectParameters[i].Name == "sid")
{
this.SqlDataSourceFormViewStudents.SelectParameters.Remove(this.SqlDataSourceFormViewStudents.SelectParameters[i]);
}
}
for (int i = 0; i < this.SqlDataSourceFormViewStudents.UpdateParameters.Count; i++)
{
if (this.SqlDataSourceFormViewStudents.UpdateParameters[i].Name == "sid")
{
this.SqlDataSourceFormViewStudents.UpdateParameters.Remove(this.SqlDataSourceFormViewStudents.SelectParameters[i]);
}
}
this.SqlDataSourceFormViewStudents.SelectParameters.Add("sid", Session[constants.SESSION_MODE_EDIT_SID].ToString());
this.SqlDataSourceFormViewStudents.UpdateParameters.Add("sid", Session[constants.SESSION_MODE_EDIT_SID].ToString());
this.FormViewStudents.ChangeMode(FormViewMode.Edit);
break;
default:
this.FormViewStudents.Visible = false;
break;
}
this.SqlDataSourceRepeaterStudents.SelectParameters.Clear(); //remove all without selection
this.SqlDataSourceRepeaterStudents.SelectParameters.Add("pid", Session[constants.SESSION_PID].ToString());
this.SqlDataSourceRepeaterStudents.SelectParameters.Add("cid", Session[constants.SESSION_MODE_EDIT_CID].ToString());
this.RepeaterStudents.DataBind();
}
