protected void ShowRecords2(object sender, EventArgs e)
{
SqlDataSource10.DataBind();
GridView1.DataBind();
UpdatePanel2.Update();
Button3.Visible = true;
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateGrade')", true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["activeView"] != null)
{
int activeViewIndexVal = Convert.ToInt32(Request.QueryString["activeView"]);
string activeViewIndex = (String)Request.QueryString["activeView"];
switch (activeViewIndex)
{
case "0": MultiView1.ActiveViewIndex = activeViewIndexVal;
break;
case "1":
MultiView1.ActiveViewIndex = activeViewIndexVal;
DetailsView2.Visible = false;
break;
case "2":
MultiView1.ActiveViewIndex = activeViewIndexVal;
break;
}
}
else if (Request.QueryString["courseID"] != null)
{
Session["courseID"] = Request.QueryString["courseID"].ToString();
MultiView1.ActiveViewIndex = 0;
// DropDownList1.SelectedValue = Session["courseID"].ToString();
DropDownList1.DataBind();
DropDownList1.SelectedIndex = DropDownList1.Items.IndexOf(DropDownList1.Items.FindByValue(Session["courseID"].ToString()));
// sqldatasource11.selectparameters["courseid"].defaultvalue = session["courseid"].tostring();
//sqldatasource11.databind();
SqlDataSource10.DataBind();
DetailsView1.DataSource = SqlDataSource10;
DetailsView1.DataBind();
//DetailsView1.DataSource = SqlDataSource11;
//DetailsView1.DataBind();
loadGridviewSemester();
setBsicStudentInfo();
}
else
{
DetailsView2.Visible = false;
MultiView1.ActiveViewIndex = 0;
}
}
else if (GridView1.SelectedIndex < 0)
{
DetailsView2.Visible = false;
}
}
protected void Button8_Click(object sender, EventArgs e)
{
try
{
if (TextBox8.Text != "")
{
SqlDataSource10.InsertParameters["SubCategoria"].DefaultValue = TextBox8.Text;
SqlDataSource10.InsertParameters["ID_Categoria"].DefaultValue = DropDownList3.SelectedValue;
SqlDataSource10.Insert();
SqlDataSource10.SelectCommand = "SELECT SubCategoria.ID_SubCategoria, SubCategoria.SubCategoria, Categoria.Categoria FROM Categoria INNER JOIN SubCategoria ON Categoria.ID_Categoria = SubCategoria.ID_Categoria WHERE(Categoria.Estado = 1)";
SqlDataSource10.DataBind();
borrar();
}
else
{
Response.Write("<script>alert('Error, resive los datos')</script>");
}
}
catch
{
Response.Write("<script>alert('Error, resive los datos')</script>");
}
}
protected void Button1_Click(object sender, EventArgs e)//insert
{
string constr = "";
constr = ConfigurationManager.ConnectionStrings["infoConnectionString"].ToString();
SqlConnection obj1 = new SqlConnection(constr);
{
try
{
obj1.Open();
SqlCommand cmd = new SqlCommand("RegisterInsertOrEdit", obj1);
cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@UserID", Convert.ToInt32(hfUserID.Value == "" ? "0" : hfUserID.Value));
cmd.Parameters.Add("@Fname", SqlDbType.VarChar).Value = TextBox1.Text;
cmd.Parameters.Add("@Lname", SqlDbType.VarChar).Value = TextBox2.Text;
cmd.Parameters.Add("@dob", SqlDbType.Date).Value = txtDob.Text;
cmd.Parameters.Add("@MStatus", SqlDbType.VarChar).Value = DropDownList1.SelectedItem.Text;
cmd.Parameters.Add("@Marital_ID", SqlDbType.Int).Value = DropDownList1.SelectedValue;
cmd.Parameters.Add("@Gender", SqlDbType.VarChar).Value = DropDownList2.SelectedItem.Text;
cmd.Parameters.Add("@Gender_ID", SqlDbType.Int).Value = DropDownList2.SelectedValue;
cmd.Parameters.Add("@Country", SqlDbType.VarChar).Value = DropDownList3.SelectedItem.Text;
cmd.Parameters.Add("@Country_ID", SqlDbType.Int).Value = DropDownList3.SelectedValue;
cmd.Parameters.Add("@State", SqlDbType.VarChar).Value = DropDownList4.SelectedItem.Text;
cmd.Parameters.Add("@State_ID", SqlDbType.Int).Value = DropDownList4.SelectedValue;
cmd.Parameters.Add("@City", SqlDbType.VarChar).Value = DropDownList5.SelectedItem.Text;
cmd.Parameters.Add("@City_ID", SqlDbType.Int).Value = DropDownList5.SelectedValue;
cmd.Parameters.Add("@Pincode", SqlDbType.VarChar).Value = TextBox9.Text;
cmd.Parameters.Add("@add", SqlDbType.VarChar).Value = TextBox8.Text;
cmd.Parameters.Add("@PersonalEmail", SqlDbType.VarChar).Value = TextBox7.Text;
cmd.Parameters.Add("@OfficialEmail", SqlDbType.VarChar).Value = TextBox5.Text;
//cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = txtPassword.Text;
cmd.Parameters.Add("@Contact1", SqlDbType.VarChar).Value = TextBox6.Text;
cmd.Parameters.Add("@Contact2", SqlDbType.VarChar).Value = TextBox3.Text;
cmd.Parameters.Add("@DOJ", SqlDbType.Date).Value = txtDoj.Text;
cmd.Parameters.AddWithValue("@MotherName", TextBox10.Text);
cmd.Parameters.Add("@FatherName", SqlDbType.VarChar).Value = TextBox11.Text;
cmd.Parameters.Add("@BldGrp", SqlDbType.VarChar).Value = DropDownList9.SelectedItem.Text;
cmd.Parameters.Add("@BloodGroup_ID", SqlDbType.Int).Value = DropDownList9.SelectedValue;
cmd.Parameters.Add("@Dept", SqlDbType.VarChar).Value = DropDownList6.SelectedItem.Text;
cmd.Parameters.Add("@Department_ID", SqlDbType.Int).Value = DropDownList6.SelectedValue;
cmd.Parameters.Add("@Desig", SqlDbType.VarChar).Value = DropDownList7.SelectedItem.Text;
cmd.Parameters.Add("@Designation_ID", SqlDbType.Int).Value = DropDownList7.SelectedValue;
cmd.Parameters.Add("@Grade", SqlDbType.VarChar).Value = DropDownList8.SelectedItem.Text;
cmd.Parameters.Add("@Grade_ID", SqlDbType.Int).Value = DropDownList8.SelectedValue;
cmd.Parameters.Add("@CardNum", SqlDbType.VarChar).Value = TextBox4.Text;
cmd.Parameters.Add("@ReportingManager", SqlDbType.VarChar).Value = DropDownList10.SelectedItem.Text;
cmd.Parameters.Add("@Manager_ID", SqlDbType.Int).Value = DropDownList10.SelectedValue;
cmd.ExecuteNonQuery();
SqlDataSource10.DataBind();
GridView1.DataSource = null;
GridView1.DataSourceID = "SqlDataSource10";
//con.Close();
GridView1.SelectedIndex = -1;
// Response.Redirect(Request.Url.AbsoluteUri);
Clear();
Label2.Text = "Details inserted successfully";
// Label1.Text = "Total Regitrations";
// Label1.Text = counter.ToString();
// counter++;
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
lblOutput.Text = "";
}
finally
{
obj1.Close();
}
}
}
