protected void AssignStudent(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignStudentClass')", true); if (Page.IsValid) { DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.personalInfo t1 = new Entities.personalInfo() { pKId = Session["School"].ToString(), }; Entities.StudentSubject t2 = new Entities.StudentSubject() { pKId = SchoolID.Value, year = Year.Text, }; Entities.Class c1 = new Entities.Class() { className = DropDownList1.SelectedValue, }; Entities.Section s1 = new Entities.Section() { sectionName = DropDownList2.SelectedValue, }; db.AssignStudentClass(t1, t2, c1, s1); SqlDataSource6.DataBind(); GridView1.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { //SqlDataSource2.DataBind(); //SqlDataSource4.DataBind(); //SqlDataSource7.DataBind(); SqlDataSource6.DataBind(); SqlDataSource5.DataBind(); //GridView1.DataBind(); GridView2.DataBind(); ////DetailsView1.DataBind(); DetailsView2.DataBind(); //System.Threading.Thread.Sleep(2000); //Response.Redirect("Admin.aspx?companyListBox.SelectedValue=" + companyListBox.SelectedValue); }
protected void Button10_Click1(object sender, EventArgs e) { SqlDataSource6.SelectCommand = "SELECT [ID_MaraProd], [MarcaP] FROM [MarcaProd] WHERE MarcaP like '%" + TextBox3.Text + "%'"; SqlDataSource6.DataBind(); }
protected void btnNext_Click(object sender, EventArgs e) { //save project code to cookie if (!Page.IsValid) { return; } else { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); // update to database SqlParameter pj_code = new SqlParameter("@pj_code", SqlDbType.NVarChar, 15); pj_code.Direction = ParameterDirection.Input; pj_code.Value = lblProjectCode.Text; SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int); p_id.Direction = ParameterDirection.Input; p_id.Value = ck.p_id; SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar, 20); d_id.Direction = ParameterDirection.Input; d_id.Value = ck.d_id; SqlParameter mi_id = new SqlParameter("@mi_id", SqlDbType.NVarChar, 25); mi_id.Direction = ParameterDirection.Input; mi_id.Value = ck.mi_id; SqlParameter pj_name = new SqlParameter("@pj_name", SqlDbType.NVarChar, 500); pj_name.Direction = ParameterDirection.Input; pj_name.Value = txtProjectName.Text; SqlParameter pj_yut_id = new SqlParameter("@pj_yut_id", SqlDbType.Int); pj_yut_id.Direction = ParameterDirection.Input; pj_yut_id.Value = ddlYudtasad.SelectedValue; SqlParameter pj_year = new SqlParameter("@pj_year", SqlDbType.NVarChar, 4); pj_year.Direction = ParameterDirection.Input; pj_year.Value = ddlYear.SelectedValue; SqlParameter pj_budget_money = new SqlParameter("@pj_budget_money", SqlDbType.Float); pj_budget_money.Direction = ParameterDirection.Input; pj_budget_money.Value = txtBudget.Text.Replace(",", ""); SqlParameter pj_budget = new SqlParameter("@pj_budget", SqlDbType.NVarChar, 50); pj_budget.Direction = ParameterDirection.Input; pj_budget.Value = txtBudget.Text; SqlParameter pj_budget_category = new SqlParameter("@pj_budget_category", SqlDbType.NVarChar, 200); pj_budget_category.Direction = ParameterDirection.Input; pj_budget_category.Value = DropDownList2.SelectedValue; //SqlParameter pj_integrateProject = new SqlParameter("@pj_integrateProject", SqlDbType.NVarChar); //pj_integrateProject.Direction = ParameterDirection.Input; ////pj_integrateProject.Value = txtIntegrate.Text; //pj_integrateProject.Value = string.Empty; //SqlParameter pj_relateDept = new SqlParameter("@pj_relateDept", SqlDbType.NVarChar); //pj_relateDept.Direction = ParameterDirection.Input; ////pj_relateDept.Value = txtRelate.Text; //pj_relateDept.Value = string.Empty; SqlParameter pj_status = new SqlParameter("@pj_status", SqlDbType.NVarChar); pj_status.Direction = ParameterDirection.Input; pj_status.Value = Request.QueryString["status"]; insertParameters.Add(pj_code); insertParameters.Add(p_id); insertParameters.Add(d_id); insertParameters.Add(mi_id); insertParameters.Add(pj_name); insertParameters.Add(pj_yut_id); insertParameters.Add(pj_year); insertParameters.Add(pj_budget); insertParameters.Add(pj_budget_money); //insertParameters.Add(pj_integrateProject); //insertParameters.Add(pj_relateDept); insertParameters.Add(pj_status); insertParameters.Add(pj_budget_category); try { SqlDataSource44.Update(); //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_code", lblProjectCode.Text); } catch (Exception ex) { //ELMA Log Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } SqlDataSource6.SelectCommand = "SELECT pj_id FROM [projects] where pj_code = '" + lblProjectCode.Text + "' and pj_status = '" + Request.QueryString["status"] + "'"; SqlDataSource6.DataBind(); DataView dv1 = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty); //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_id", dv1.Table.Rows[0]["pj_id"].ToString()); Response.Redirect("project_filter.aspx"); } }