protected void btn_add_Click(object sender, EventArgs e)
{
try
{
ds_analytics.projectsDataTable prj_dt = new ds_analytics.projectsDataTable();
ds_analytics.projectsRow prj_row = prj_dt.NewprojectsRow();
prj_row.projectname = tb_prj_name.Text;
prj_row.projecttype = ddl_prj_type.SelectedItem.Text;
prj_row.projectcategory = ddl_prj_category.SelectedItem.Text;
prj_row.projectbrand = ddl_prj_brand.SelectedItem.Text;
if (tb_prj_start.Text == "")
{
prj_row.SetcreatedateNull();
}
else
{
prj_row.createdate = Convert.ToDateTime(tb_prj_start.Text);
}
if (tb_prj_end.Text == "")
{
prj_row.SetcompletiondateNull();
}
else
{
prj_row.completiondate = Convert.ToDateTime(tb_prj_end.Text).AddHours(23).AddMinutes(59).AddSeconds(59);
}
if (tb_prj_budget.Text == "")
{
prj_row.SetbudgetNull();
}
else
{
prj_row.budget = Convert.ToDouble(tb_prj_budget.Text);
}
prj_row.isactive = cb_isactive.Checked;
projects.insert(prj_row);
string url = "projects.aspx";
ClientScript.RegisterStartupScript(this.GetType(), "callfunction", "alert('Record Added Successfully.');window.location.href = '" + url + "';", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>alert('Error in adding record.');</script>");
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
ds_analytics.projectsRow prj_row = ((ds_analytics.projectsRow)(ViewState["prj_row"]));
prj_row.projectname = tb_prj_name.Text;
prj_row.projecttype = ddl_prj_type.SelectedItem.Text;
prj_row.projectcategory = ddl_prj_category.SelectedItem.Text;
prj_row.projectbrand = ddl_prj_brand.SelectedItem.Text;
if (tb_prj_start.Text == "")
{
prj_row.SetcreatedateNull();
}
else
{
prj_row.createdate = Convert.ToDateTime(tb_prj_start.Text);
}
if (tb_prj_end.Text == "")
{
prj_row.SetcompletiondateNull();
}
else
{
prj_row.completiondate = Convert.ToDateTime(tb_prj_end.Text).AddHours(23).AddMinutes(59).AddSeconds(59);
}
if (tb_prj_budget.Text == "")
{
prj_row.SetbudgetNull();
}
else
{
prj_row.budget = Convert.ToDouble(tb_prj_budget.Text);
}
prj_row.isactive = cb_isactive.Checked;
projects.update(prj_row);
ds_analytics.projectsDataTable prj_dt = projects.getAllProjects();
gv_projects.DataSource = prj_dt;
gv_projects.DataBind();
ViewState["dtStored"] = prj_dt;
Reset();
}