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