protected void Button1_Click(object sender, EventArgs e)
{
string msg = TextBox1.Text;
int j = db.exenonquery("insert into chat values('" + msg + "','','" + Session["login_id"] + "','" + DropDownList1.SelectedItem.Value + "')");
if (j > 0)
{
Response.Write("<script>alert(' Success')</script>");
}
else
{
Response.Write("<script>alert(' Failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = TextBox_name.Text;
string gender = RadioButtonList1.SelectedItem.Value;
string department = DropDownList_department.SelectedItem.Value;
string image = FileUpload_photo.FileName;
string role = "";
string dob = TextBox_dob.Text;
string email = TextBox_email.Text;
string contact = TextBox_contact.Text;
string addr = TextBox_address.Text;;
string uname = TextBox_uname.Text;
string pass = TextBox_password.Text;
if (RadioButtonList_Role.Items[0].Selected == true)
{
role = "teacher";
string q1 = "insert into logintable values('" + uname + "','" + pass + "','" + role + "',1)select @@IDENTITY";
object ob = db.execalar(q1);
string q2 = "insert into teacher values('" + name + "'," + gender + ",'" + image + "','" + dob + "','" + email + "','" + contact + "','" + addr + "','" + role + "'," + ob + "," + department + ")";
int j = db.exenonquery(q2);
if (j > 0)
{
Response.Write("<script>alert('Teacher insertion success')</script>");
}
else
{
Response.Write("<script>alert('Teacher insertion failure')</script>");
}
}
else if (RadioButtonList_Role.Items[1].Selected == true)
{
role = "hod";
string q1 = "insert into logintable values('" + uname + "','" + pass + "','" + role + "',1)select @@IDENTITY";
object ob = db.execalar(q1);
string q2 = "insert into teacher values('" + name + "'," + gender + ",'" + image + "','" + dob + "','" + email + "','" + contact + "','" + addr + "','" + role + "'," + ob + "," + department + ")";
int j = db.exenonquery(q2);
if (j > 0)
{
Response.Write("<script>alert('HOD insertion success')</script>");
Response.Redirect(Request.Url.AbsoluteUri);
}
else
{
Response.Write("<script>alert('HOD insertion failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
TextBox txttext;
Button btn;
LinkButton lkbtn;
DataListItem dtl = (DataListItem)(((Button)sender).NamingContainer);
btn = (Button)dtl.FindControl("Button2");
txttext = (TextBox)dtl.FindControl("TextBox2");
lkbtn = (LinkButton)dtl.FindControl("LinkButton1");
db.exenonquery("update chat set replay='" + txttext.Text + "' where messid=" + lkbtn.CommandArgument);
db.filldlist("SELECT * FROM CHAT where toid=" + DropDownList1.SelectedItem.Value, DataList1);
}
protected void Button1_Click(object sender, EventArgs e)
{
string department = DropDownList_dep.SelectedItem.Value;
string batch = RadioButtonList1.SelectedItem.Value;
string sem = TextBox_sem.Text;
string sql1 = "select * from semester where sem='" + sem + "'";
DataTable dt = db.exetable(sql1);
if (dt.Rows.Count > 0)
{
Response.Write("<script>slert('Data Exist')</script>");
}
else
{
string sql = "insert into semester values(" + batch + ",'" + sem + "')";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
Response.Redirect(Request.Url.AbsoluteUri);
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string year = TextBox1.Text;
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.ContentLength > 0)
{
UpLoadAndDisplay();
}
// string sql;
string sql1 = "select * from callender where filename='" + FileUpload1.FileName + "'";
DataTable dt = db.exetable(sql1);
if (dt.Rows.Count > 0)
{
Response.Write("<script>slert('Data Exist')</script>");
}
else
{
int i = db.exenonquery("insert into callender values('" + FileUpload1.FileName + "','" + year + "')");
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion failure')</script>");
}
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string hr = TextBox_hour.Text;
string sql = "insert into hour values('" + hr + "')";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
int i = 0;
foreach (GridViewRow gvr in GridView1.Rows)
{
int sid = Convert.ToInt32(GridView1.DataKeys[gvr.RowIndex].Value);
RadioButtonList rbl1 = (RadioButtonList)gvr.FindControl("RadioButtonList1");
if (rbl1.Items[0].Selected == true)
{
RadioButtonList rbl2 = (RadioButtonList)gvr.FindControl("RadioButtonList3");
string val = rbl2.SelectedItem.Value;
string sq = "Update student set sem= '" + val + "' where sid=" + sid;
i = db.exenonquery(sq);
}
}
if (i > 0)
{
Response.Write("<script>alert('Insertion success')</script>");
}
else
{
Response.Write("<script>alert('Insertion failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = TextBox_name.Text;
string gender = RadioButtonList_gender.SelectedItem.Value;
string image = FileUpload_photo.FileName;
//FileUpload_photo.SaveAs(Server.MapPath("~/Admin/image/" + FileUpload_photo.FileName));
string dob = TextBox_dob.Text;
string email = TextBox_email.Text;
string contact = TextBox_contact.Text;
string uname = TextBox_uname.Text;
string pass = TextBox_password.Text;
string q1 = "insert into logintable values('" + uname + "','" + pass + "','principal',1)select @@IDENTITY";
object ob = db.execalar(q1);
string q2 = "insert into principal values('" + name + "'," + gender + ",'" + image + "','" + dob + "','" + email + "','" + contact + "'," + ob + ")";
int i = db.exenonquery(q2);
if (i > 0)
{
Response.Write("<script>alert('Principal insertion success')</script>");
}
else
{
Response.Write("<script>alert('Principal insertion failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string a = DropDownList5.SelectedItem.Value;
string b = DropDownList2.SelectedItem.Value;
string c = DropDownList3.SelectedItem.Value;
string d = DropDownList4.SelectedItem.Value;
string ef = DropDownList8.SelectedItem.Value;
int mrk1 = Convert.ToInt32(TextBox1.Text);
string lid = Session["login_id"].ToString();
string q2 = "insert into internal_mark values(" + ef + "," + b + "," + mrk1 + "," + lid + "," + c + "," + d + ")";
int i = db.exenonquery(q2);
if (i > 0)
{
Response.Write("<script>alert('insertion success')</script>");
}
else
{
Response.Write("<script>alert('insertion failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string exname = TextBox1.Text;
int mxmrk = Convert.ToInt32(TextBox2.Text);
string sql11 = "select * from internal_exam_name where sem='" + exname + "'";
DataTable dt = db.exetable(sql11);
if (dt.Rows.Count > 0)
{
Response.Write("<script>slert('Data Exist')</script>");
}
else
{
string sql1 = "insert into internal_exam_name values('" + exname + "')";
int j = db.exenonquery(sql1);
if (j > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
string sql2 = "insert into max_mark values(" + mxmrk + ")";
int i = db.exenonquery(sql2);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string dname = TextBox_dname.Text;
string q1 = "insert into department values('" + dname + "')";
int i = db.exenonquery(q1);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string date = TextBox_date.Text;
string message = TextBox_message.Text;
string sql = "insert into message values('" + date + "','" + message + "'," + lid + ")";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Success')</script>");
}
else
{
Response.Write("<script>alert('Failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = TextBox_name.Text;
string gender = RadioButtonList1.SelectedItem.Value;
string admno = TextBox_adno.Text;
//string batch = RadioButtonList_batch.SelectedItem.Value;
string department = DropDownList1.SelectedItem.Value;
string image = FileUpload_photo.FileName;
//FileUpload_photo.SaveAs(Server.MapPath("~/Admin/image/" + FileUpload_photo.FileName));
string dob = TextBox1.Text;
string email = TextBox_email.Text;
string cs = TextBox_contact_student.Text;
string cp = TextBox_contact_parent.Text;
string mailp = TextBox_parents_email.Text;
string addr = TextBox_address.Text;
string uname = TextBox_username.Text;
string pass = TextBox_password.Text;
string q1 = "insert into logintable values('" + uname + "','" + pass + "','student',1)select @@IDENTITY";
object ob = db.execalar(q1);
string q2 = "insert into student values('" + admno + "','" + name + "'," + gender + ",'I SEM','" + image + "','" + dob + "','" + email + "','" + cs + "','" + cp + "','" + addr + "'," + ob + "," + department + ",'" + mailp + "')";
int i = db.exenonquery(q2);
if (i > 0)
{
Response.Write("<script>alert('Student insertion success')</script>");
// MailMessage msg = new MailMessage("sender mail"," recever mail");
// msg.Subject = "Student username and Password";
// msg.Body = "USER NAME =" + TextBox_username.Text + " PASSWORD ="******"smtp.gmail.com";
// s.EnableSsl = true;
// NetworkCredential Networkcred = new NetworkCredential("sender mail", "password");
// s.UseDefaultCredentials = true;
// s.Credentials = Networkcred;
// s.Port = 587;
// s.Send(msg);
// ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Email sent.');", true);
}
else
{
Response.Write("<script>alert('Student insertion failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string sub = DropDownList_subject.SelectedItem.Value;
string question = TextBox_question.Text;
string sql = "insert into assignment values('" + question + "'," + sub + "," + lid + ")";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string date = DateTime.Now.ToString();
string day = TextBox_days.Text;
string reson = TextBox_reason.Text;
string sql = "insert into leave values('" + reson + "'," + day + ",'" + date + "'," + lid + ",0)";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string subject = DropDownList_subject.SelectedItem.Value;
string id = DropDownList_topic.SelectedItem.Value;
string path = "~/UplodedContents/Assignments/" + FileUpload_assignment.FileName;
string sql = "insert into assignment_submitted values(" + id + "," + lid + ",'" + path + "',0)";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string date = TextBox_date.Text;
string reason = TextBox_notification.Text;
string sql = "insert into notification values('" + date + "','" + reason + "'," + lid + ")";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Success')</script>");
}
else
{
Response.Write("<script>alert('Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string a = GridView1.DataKeys[e.RowIndex].Value.ToString();
string sql = "update leave set status = 1 where tlid=" + a;
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Confirmed')</script>");
}
else
{
Response.Write("<script>alert('Failure')</script>");
}
if (!IsPostBack)
{
db.fillgrid("select * from leave inner join teacher on leave.lid=teacher.lid where status =" + 0, GridView1);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string dep = DropDownList_dep.SelectedItem.Value;
string b = RadioButtonList1.SelectedValue;
string sem = DropDownList_sem.SelectedItem.Value;
string subject = TextBox_subject.Text;
string sql = "insert into subject values('" + subject + "'," + Convert.ToInt32(sem) + "," + Convert.ToInt32(lid) + "," + Convert.ToInt32(dep) + ")";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
TextBox mark = new TextBox();
mark = (TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0];
int i = db.exenonquery("update assignment_submitted set mark = " + mark.Text + " where submitid=" + id + "");
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
string sql = "select * from assignment inner join assignment_submitted on assignment_submitted.aid=assignment.aid inner join student on student.lid=assignment_submitted.lid";
db.fillgrid(sql, GridView1);
GridView1.EditIndex = -1;
}
protected void Button1_Click(object sender, EventArgs e)
{
string dep = DropDownList_dep.SelectedItem.Value;
string bat = RadioButtonList_batch.SelectedValue;
string sem = DropDownList_sem.SelectedItem.Value;
string hor = DropDownList_hour.SelectedItem.Value;
string day = DropDownList_day.SelectedItem.Value;
string teacher = DropDownList_teacher.SelectedItem.Value;
string sub = DropDownList_sub.SelectedItem.Value;
string sql = "insert into timetable values(" + hor + "," + day + "," + sub + "," + teacher + "," + dep + "," + sem + ")";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string dep = DropDownList_dep.SelectedItem.Value;
string b = RadioButtonList_batch.SelectedValue;
string sem = DropDownList_sem.SelectedItem.Value;
string time = RadioButtonList_time.SelectedItem.Value;
string subject = DropDownList_subject.SelectedItem.Value;
string dur = RadioButtonList_duration.SelectedItem.Value;
string date = TextBox_date.Text;
string sql = "insert into examtimetable values('" + date + "'," + dep + "," + sem + "," + subject + ",'" + time + "'," + dur + ")";
int i = db.exenonquery(sql);
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion Failure')</script>");
}
Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string a = DropDownList1.SelectedItem.Value;
string b = DropDownList2.SelectedItem.Value;
string c = DropDownList3.SelectedItem.Value;
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.ContentLength > 0)
{
UpLoadAndDisplay();
}
int i = db.exenonquery("insert into notes values(" + c + "," + b + ",'" + FileUpload1.FileName + "'," + lid + ")");
if (i > 0)
{
Response.Write("<script>alert('Insertion Success')</script>");
}
else
{
Response.Write("<script>alert('Insertion failure')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string lid = Session["login_id"].ToString();
string date = DateTime.Today.ToString();
string batch = RadioButtonList_batch.SelectedItem.Value;
string sem = DropDownList_sem.SelectedItem.Text;
string dep = DropDownList_dep.SelectedItem.Value;
string sub = DropDownList_subject.SelectedItem.Value;
string sql = "insert into attendance values(" + lid + ",'" + sem + "'," + sub + ",'" + date + "'," + dep + ")SELECT @@IDENTITY";
object ob = db.execalar(sql);
foreach (GridViewRow gvr in GridView_attendance.Rows)
{
int sid = Convert.ToInt32(GridView_attendance.DataKeys[gvr.RowIndex].Value);
RadioButtonList rbl = (RadioButtonList)gvr.FindControl("RadioButtonList1");
if (rbl.Items[1].Selected == true)
{
string sq = "insert into absent values(" + ob + "," + sid + ")";
i = db.exenonquery(sq);
}
}
Response.Write("<script>alert('Insertion Success')</script>");
}
