protected void Button1_Click(object sender, EventArgs e) { string Leader = TextBox5.Text; int n; bool isNumeric = int.TryParse(Leader, out n); if (isNumeric) { obj = (ObjectDataSource)Session["obj"]; obj.TypeName = "Student"; obj.InsertMethod = "InsertStudent"; obj.InsertParameters.Clear(); obj.InsertParameters.Add("F_Name", TextBox1.Text); obj.InsertParameters.Add("L_Name", TextBox2.Text); obj.InsertParameters.Add("Address", TextBox3.Text); obj.InsertParameters.Add("Age", TextBox4.Text); obj.InsertParameters.Add("Dept_No", DropDownList1.SelectedValue); obj.InsertParameters.Add("Leader", TextBox5.Text); obj.InsertParameters.Add("password", TextBox6.Text); obj.InsertParameters.Add("UserName", TextBox7.Text); obj.Insert(); TextBox1.Text = TextBox2.Text = TextBox3.Text = TextBox4.Text = TextBox5.Text = TextBox6.Text = TextBox7.Text = ""; Label1.Text = "student Added Successfully :)"; Label1.Visible = true; GridView1.DataSource = obj; GridView1.DataBind(); Session["obj"] = obj; } else { Label1.Text = "Please enter Id of Leader"; Label1.Visible = true; } }
/// <summary> /// Called when insert/update/edit/cancel link buttons are clicked on GridView /// This method calls the insert method on ObjectDataSource and /// enables button control after insert operation is completed /// </summary> /// <param name="sender">Sender</param> /// <param name="e">GridView Command Event Arguments</param> protected void GridView_RowCommand(object sender, GridViewCommandEventArgs e) { rowIndex = e.CommandSource is GridView ? -1 : ((GridViewRow)((Control)e.CommandSource).Parent.Parent).RowIndex; ObjectDataSource dataSource = (ObjectDataSource)this.Parent.FindControl(this.DataSourceID); if (dataSource != null) { if (e.CommandName == "Insert" && Page.IsValid) { try { //Following block of code is chekced for Exceptions //because Insert() will throw an exception if insert ito DB fails dataSource.Insert(); showButtons(); } catch (Exception ex) { //Object Data Source throws this exception on Primary Key, Unique Key and Foriegn Key Voilations //No Action is required here. //This exception ensures that gridview footer row is displayed and and typed in data is not lost. } } } GetUpdatePanel.Update(); }
protected void Button1_Click(object sender, EventArgs e) { string SuperVisor = TextBox2.Text,Salary=TextBox3.Text; int n; bool isNumeric = int.TryParse(SuperVisor, out n); bool isNumericc = int.TryParse(Salary, out n); if (isNumeric && isNumericc) { obj = (ObjectDataSource)Session["obj"]; obj.InsertMethod = "insert"; obj.InsertParameters.Clear(); obj.InsertParameters.Add("ins_name", TextBox1.Text); obj.InsertParameters.Add("Supins", TextBox2.Text); obj.InsertParameters.Add("salary", TextBox3.Text); obj.InsertParameters.Add("password", TextBox4.Text); obj.Insert(); TextBox1.Text = TextBox2.Text = TextBox3.Text = TextBox4.Text = ""; Label1.Text = "instructor Added Successfully :)"; Label1.Visible = true; GridView1.DataSource = obj; GridView1.DataBind(); Session["obj"] = obj; } else { Label1.Text = "Salary and SuperVisor Must be Numbers"; Label1.Visible = true; } }
protected void Button1_Click(object sender, EventArgs e) { obj.TypeName = "BussniessLayerQuestion"; obj.InsertMethod = "InsertQuestion"; obj.InsertParameters.Add("Q_id", TextBox4.Text); obj.InsertParameters.Add("Q_body", TextBox5.Text); obj.InsertParameters.Add("Q_type", TextBox6.Text); obj.InsertParameters.Add("Q_Answer", TextBox7.Text); obj.InsertParameters.Add("Q_Grade", TextBox8.Text); obj.InsertParameters.Add("Crs_id", DropDownList2.SelectedValue); obj.Insert(); }
protected void Button1_Click(object sender, EventArgs e) { obj = (ObjectDataSource)Session["obj"]; obj.InsertMethod = "InsertCourse"; obj.InsertParameters.Clear(); obj.InsertParameters.Add("C_Name", TextBox1.Text); obj.Insert(); TextBox1.Text = ""; Label1.Text = "Departement Added Successfully :)"; Label1.Visible = true; GridView1.DataSource = obj; GridView1.DataBind(); Session["obj"] = obj; }
protected void btn_generate_Click(object sender, EventArgs e) { obj.TypeName = "BussniessLayerStudents"; obj.InsertMethod = "GenerateExam"; obj.InsertParameters.Add("Crs_name", DropDownListCRsName.SelectedValue); obj.InsertParameters.Add("MCQ", TextMCq.Text); obj.InsertParameters.Add("TF", TextTF.Text); obj.Insert(); LabelMsg.Text += "Exam Generated"; LabelMsg.Text += Environment.NewLine; Session.Add("CourseName", DropDownListCRsName.SelectedValue); Session.Add("MCQNumber", int.Parse(TextMCq.Text)); Session.Add("TFNumber", int.Parse(TextTF.Text)); }
protected void Button1_Click(object sender, EventArgs e) { int userID = (int)Session["UserId"]; obj.TypeName = "BussniessLayerStudents"; obj.InsertMethod = "InsertStudent"; obj.InsertParameters.Add("St_id", "22"); obj.InsertParameters.Add("St_Fname", TextBox1.Text); obj.InsertParameters.Add("St_Lname", TextBox2.Text); obj.InsertParameters.Add("St_phone", TextBox3.Text); obj.InsertParameters.Add("St_Address", TextBox4.Text); obj.InsertParameters.Add("dept_id", DropDownList1.SelectedValue); obj.InsertParameters.Add("User_id", userID.ToString()); obj.Insert(); }
protected void Button1_Click(object sender, EventArgs e) { int userID = (int)Session["UserId"]; obj.TypeName = "BussniessLayerStudents"; obj.InsertMethod = "InsertAdmin"; obj.InsertParameters.Add("Admin_name", TextBox1.Text); obj.InsertParameters.Add("Admin_Phone", TextBox3.Text); obj.InsertParameters.Add("Admin_address", TextBox4.Text); obj.InsertParameters.Add("Admin_birthdate", TextBox2.Text); obj.InsertParameters.Add("User_id", userID.ToString()); obj.Insert(); string message = "Admin Information Inserted"; ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true); }