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