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 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_code; 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 = new SqlParameter("@pj_budget", SqlDbType.NVarChar, 50); pj_budget.Direction = ParameterDirection.Input; pj_budget.Value = txtBudget.Text; 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_category = new SqlParameter("@pj_budget_category", SqlDbType.NVarChar, 200); pj_budget_category.Direction = ParameterDirection.Input; pj_budget_category.Value = DropDownList2.SelectedValue; SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int); pj_id.Direction = ParameterDirection.Input; pj_id.Value = ck.pj_id; //SqlParameter pj_integrateProject = new SqlParameter("@pj_integrateProject", SqlDbType.NVarChar); //pj_integrateProject.Direction = ParameterDirection.Input; //pj_integrateProject.Value = txtIntegrate.Text; //SqlParameter pj_relateDept = new SqlParameter("@pj_relateDept", SqlDbType.NVarChar); //pj_relateDept.Direction = ParameterDirection.Input; //pj_relateDept.Value = txtRelate.Text; 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_id); insertParameters.Add(pj_budget_category); //insertParameters.Add(pj_integrateProject); //insertParameters.Add(pj_relateDept); 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); } //Response.Redirect("project_filter_edit.aspx"); Response.Redirect("project_edit.aspx"); } }
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"); } }