protected void btnSend_Click1(object sender, EventArgs e)
{
if (Session["getme"] != null)
{
if (isFormGood2())
{
Composer su = new Composer();
ComposeDAL ldal = new ComposeDAL();
su.subject = txtSubject.Text;
su.message = txtMessage.Text;
su.sender = Session["User"].ToString();
su.reciever = Session["getme"].ToString();
ldal.addMessage(su);
Session["getme"] = null;
lbldd.Visible = false;
lblMessage.Visible = false;
lblSubject.Visible = false;
ddPerson.Visible = false;
ddReciever.Visible = false;
Label2.Visible = false;
Label3.Visible = false;
txtMessage.Visible = false;
txtSubject.Visible = false;
btnBack.Visible = false;
btnSend.Visible = false;
Label1.Visible = false;
lblSent.Visible = true;
}
}
else if (isFormGood())
{
doSignup();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this.Master.name.Text = Session["User"].ToString();
}
catch (Exception ex)
{
Response.Redirect("index.aspx");
}
ComposeDAL cdal = new ComposeDAL();
btnDelete.Visible = true;
btnDelete2.Visible = false;
DataSet ds = cdal.GetMessage(Session["User"].ToString());
gvMessage.DataSource = ds;
gvMessage.DataBind();
lblEmpty.Visible = false;
if (ds.Tables[0].Rows.Count == 0)
{
lblEmpty.Visible = true;
}
}
public void doSignup()
{
Composer su = new Composer();
ComposeDAL ldal = new ComposeDAL();
su.subject = txtSubject.Text;
su.message = txtMessage.Text;
su.sender = Session["User"].ToString();
if (ddReciever.Enabled == false)
{
su.reciever = ddPerson.SelectedValue;
}
else
{
su.reciever = ddReciever.SelectedValue;
}
ldal.addMessage(su);
lbldd.Visible = false;
lblMessage.Visible = false;
lblSubject.Visible = false;
ddPerson.Visible = false;
ddReciever.Visible = false;
Label2.Visible = false;
Label3.Visible = false;
txtMessage.Visible = false;
txtSubject.Visible = false;
btnBack.Visible = false;
btnSend.Visible = false;
Label1.Visible = false;
lblSent.Visible = true;
}
protected void ddPerson_SelectedIndexChanged(object sender, EventArgs e)
{
ComposeDAL sdal = new ComposeDAL();
if (ddPerson.SelectedValue == "-1")
{
ddReciever.Items.Clear();
}
else if (ddPerson.SelectedValue == "Admin")
{
ddReciever.Items.Clear();
ddReciever.Enabled = false;
}
else if (ddPerson.SelectedValue == "-3")
{
int id = Convert.ToInt32(Session["Marks_Key"]);
ddReciever.DataSource = sdal.GetStudentNameByCourse(id);
ddReciever.DataTextField = "Student Name";
ddReciever.DataValueField = "Student Name";
ddReciever.DataBind();
}
else
{
//label error here
}
}
protected void ddPerson_SelectedIndexChanged(object sender, EventArgs e)
{
ComposeDAL sdal = new ComposeDAL();
if (ddPerson.SelectedValue == "-1")
{
ddReciever.Items.Clear();
}
else if (ddPerson.SelectedValue == "-2")
{
ddReciever.DataSource = sdal.GetInstructorName();
ddReciever.DataTextField = "Instructor Name";
ddReciever.DataValueField = "Instructor Name";
ddReciever.DataBind();
}
else if (ddPerson.SelectedValue == "-3")
{
ddReciever.DataSource = sdal.GetStudentName();
ddReciever.DataTextField = "Student Name";
ddReciever.DataValueField = "Student Name";
ddReciever.DataBind();
}
else
{
//label error here
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this.Master.name.Text = Session["User"].ToString();
}
catch (Exception ex)
{
Response.Redirect("index.aspx");
}
int sid = Convert.ToInt32(Session["Feedback_Key"]);
// DataSet ds = cd.getOfferedCourse(sid);
ComposeDAL sdal = new ComposeDAL();
ListItemCollection lic = new ListItemCollection();
int id = Convert.ToInt32(Session["Feedback_Key"]);
int count = sdal.getMultiple(id);
DataTable dt2 = new DataTable();
dt2.Columns.Add(new DataColumn("Course Id", typeof(int)));
dt2.Columns.Add(new DataColumn("Course", typeof(string)));
dt2.Columns.Add(new DataColumn("Instructor Name", typeof(string)));
if (count > 0)
{
for (int i = 1; i < 1000; i++)
{
DataSet ds = cd.getOfferedCourse(id, i);
DataTable dt = ds.Tables[0];
try
{
DataRow dr = dt.Rows[0];
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr3 = dt2.NewRow();
dr3["Course id"] = Convert.ToInt32(dr["Course id"]);
dr3["Course"] = dr["Course"].ToString();
dr3["Instructor Name"] = dr["Instructor Name"].ToString();
dt2.Rows.Add(dr3);
}
}
catch (Exception ex)
{
continue;
}
}
}
gvCourse.DataSource = dt2;
gvCourse.DataBind();
}
public void doSignup()
{
Composer su = new Composer();
ComposeDAL ldal = new ComposeDAL();
su.subject = txtSubject.Text;
su.message = txtMessage.Text;
su.sender = Session["User"].ToString();
su.reciever = ddReciever.SelectedValue;
ldal.addMessage(su);
}
protected void btnInbox_Click(object sender, EventArgs e)
{
gvMessage.Columns[1].Visible = true;
gvMessage.Columns[0].Visible = true;
ComposeDAL cdal = new ComposeDAL();
btnDelete.Visible = true;
btnDelete2.Visible = false;
DataSet ds = cdal.GetMessage(Session["User"].ToString());
gvMessage.DataSource = ds;
gvMessage.DataBind();
lblEmpty.Visible = false;
if (ds.Tables[0].Rows.Count == 0)
{
lblEmpty.Visible = true;
}
}
protected void btnSend_Click1(object sender, EventArgs e)
{
if (Session["getme"] != null)
{
if (isFormGood2())
{
Composer su = new Composer();
ComposeDAL ldal = new ComposeDAL();
su.subject = txtSubject.Text;
su.message = txtMessage.Text;
su.sender = Session["User"].ToString();
su.reciever = Session["getme"].ToString();
ldal.addMessage(su);
Session["getme"] = null;
}
}
else if (isFormGood())
{
doSignup();
}
}
protected void btnSentMails_Click(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.Append("<br/><br/>");
DBDataPlaceHolder.Controls.Add(new Literal {
Text = sb.ToString()
});
btnDelete.Visible = false;
btnDelete2.Visible = false;
ComposeDAL cdal = new ComposeDAL();
DataSet ds = cdal.GetSentMessage(Session["User"].ToString());
gvMessage.DataSource = ds;
gvMessage.DataBind();
gvMessage.Columns[1].Visible = false;
gvMessage.Columns[0].Visible = false;
lblEmpty.Visible = false;
if (ds.Tables[0].Rows.Count == 0)
{
lblEmpty.Visible = true;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in gvMessage.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("DeleteSelector");
if (cb != null && cb.Checked)
{
int id = Convert.ToInt32(gvMessage.DataKeys[row.RowIndex].Value);
ComposeDAL cdal = new ComposeDAL();
cdal.DeleteMessage(id);
}
}
ComposeDAL cdall = new ComposeDAL();
DataSet ds = cdall.GetMessage(Session["User"].ToString());
gvMessage.DataSource = ds;
gvMessage.DataBind();
lblEmpty.Visible = false;
if (ds.Tables[0].Rows.Count == 0)
{
lblEmpty.Visible = true;
}
}
protected void ddPerson_SelectedIndexChanged(object sender, EventArgs e)
{
ComposeDAL sdal = new ComposeDAL();
if (ddPerson.SelectedValue == "-1")
{
ddReciever.Items.Clear();
}
else if (ddPerson.SelectedValue == "-2")
{
ListItemCollection lic = new ListItemCollection();
int id = Convert.ToInt32(Session["Feedback_Key"]);
int count = sdal.getMultiple(id);
if (count > 1)
{
int j = 0;
int k = -1;
for (int i = 1; i < 1000; i++)
{
DataSet ds = sdal.Check(id, i);
DataTable dt = ds.Tables[0];
try
{
DataRow dr = dt.Rows[0];
if (ds.Tables[0].Rows.Count > 0)
{
int course_id = Convert.ToInt32(dr["course_id"]);
DataSet ds2 = sdal.GetInstructorName(course_id);
DataTable dt2 = ds2.Tables[0];
DataRow dr2 = dt2.Rows[0];
string name = dr2["Instructor Name"].ToString();
string temp = k.ToString();
lic.Insert(j, new ListItem(name, temp));
j++;
k--;
}
}
catch (Exception ex)
{
continue;
}
}
ddReciever.DataSource = lic;
ddReciever.DataTextField = "Text";
ddReciever.DataValueField = "Text";
ddReciever.DataBind();
}
else
{
ddReciever.DataSource = sdal.GetInstructorName();
ddReciever.DataTextField = "Instructor Name";
ddReciever.DataValueField = "Instructor Name";
ddReciever.DataBind();
}
}
else if (ddPerson.SelectedValue == "-3")
{
ddReciever.DataSource = sdal.GetStudentName();
ddReciever.DataTextField = "Student Name";
ddReciever.DataValueField = "Student Name";
ddReciever.DataBind();
}
else
{
//label error here
}
}
