private void Edit(int filter_id)
{
DataRow dr = ProfileMetric.GetThreshold(filter_id);
if (dr != null)
{
ltfilter_displayname.Text = dr["threshold_filter_displayname"].ToString();
txtfilter_ytd.Text = dr["threshold_filter_ytd"].ToString();
txtfilter_yoy.Text = dr["threshold_filter_yoy"].ToString();
if (dr["threshold_filter_ytd_operator"] != System.DBNull.Value &&
ddlfilter_ytd_operator.Items.FindByValue(dr["threshold_filter_ytd_operator"].ToString()) != null)
{
ddlfilter_ytd_operator.SelectedValue = dr["threshold_filter_ytd_operator"].ToString();
}
if (dr["threshold_filter_yoy_operator"] != System.DBNull.Value &&
ddlfilter_yoy_operator.Items.FindByValue(dr["threshold_filter_yoy_operator"].ToString()) != null)
{
ddlfilter_yoy_operator.SelectedValue = dr["threshold_filter_yoy_operator"].ToString();
}
}
ViewState["edit_filter_id"] = filter_id;
pnlAddEdit.Visible = true;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (ViewState["edit_filter_id"] != null && (int)ViewState["edit_filter_id"] > 0)
{
DataRow dr = ProfileMetric.GetThreshold((int)ViewState["edit_filter_id"]);
if (dr != null)
{
if (dr != null)
{
if (txtfilter_ytd.Text == string.Empty)
{
dr["threshold_filter_ytd"] = System.DBNull.Value;
}
else
{
dr["threshold_filter_ytd"] = decimal.Parse(txtfilter_ytd.Text);
}
if (txtfilter_yoy.Text == string.Empty)
{
dr["threshold_filter_yoy"] = System.DBNull.Value;
}
else
{
dr["threshold_filter_yoy"] = decimal.Parse(txtfilter_yoy.Text);
}
dr["threshold_filter_ytd_operator"] = int.Parse(ddlfilter_ytd_operator.SelectedValue);
dr["threshold_filter_yoy_operator"] = int.Parse(ddlfilter_yoy_operator.SelectedValue);
}
dr.AcceptChanges();
}
ltMessage.Text = "Threshold update successful";
}
else
{
ltMessage.Text = "Error occurred while saving changes";
}
if (ViewState["redirect"] != null)
{
Response.Redirect(ViewState["redirect"].ToString());
}
else
{
Clear();
BindGrid();
}
}
}
protected void gvThresholds_RowEditing(object sender, GridViewEditEventArgs e)
{
int filter_id = (int)gvThresholds.DataKeys[e.NewEditIndex].Value;
DataRow dr = ProfileMetric.GetThreshold(filter_id);
if (dr != null)
{
txtfilter_desc.Text = dr["threshold_filter_desc"].ToString();
txtfilter_displayname.Text = dr["threshold_filter_displayname"].ToString();
txtfilter_ytd.Text = dr["threshold_filter_ytd"].ToString();
txtfilter_yoy.Text = dr["threshold_filter_yoy"].ToString();
if (ddlfilter_formatstring.Items.FindByValue(dr["threshold_filter_formatstring"].ToString()) != null)
{
ddlfilter_formatstring.SelectedValue = dr["threshold_filter_formatstring"].ToString();
}
chkfilter_percentage.Checked = (dr["threshold_filter_percentage"] != System.DBNull.Value &&
(bool)dr["threshold_filter_percentage"] == true);
if (dr["threshold_filter_ytd_operator"] != System.DBNull.Value &&
ddlfilter_ytd_operator.Items.FindByValue(dr["threshold_filter_ytd_operator"].ToString()) != null)
{
ddlfilter_ytd_operator.SelectedValue = dr["threshold_filter_ytd_operator"].ToString();
}
if (dr["threshold_filter_yoy_operator"] != System.DBNull.Value &&
ddlfilter_yoy_operator.Items.FindByValue(dr["threshold_filter_yoy_operator"].ToString()) != null)
{
ddlfilter_yoy_operator.SelectedValue = dr["threshold_filter_yoy_operator"].ToString();
}
}
ViewState["edit_filter_id"] = filter_id;
e.Cancel = true;
btnSave.Text = "Save Threshold";
}
