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