protected void AssertionsGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int intRowIndex = e.RowIndex;
AssertionsGrid.SelectRow(intRowIndex);
GridViewRow row = AssertionsGrid.SelectedRow;
string strWS_ID = ""; // = "6";
strWS_ID = AssertionsGrid.DataKeys[row.RowIndex]["target_WSID"].ToString();
string strMethodID = AssertionsGrid.DataKeys[row.RowIndex]["method_id"].ToString();
string strRuleID = AssertionsGrid.DataKeys[row.RowIndex]["rule_id"].ToString();
string strRuleItemID = AssertionsGrid.DataKeys[row.RowIndex]["rule_item_id"].ToString();
string strResourceID = AssertionsGrid.DataKeys[row.RowIndex]["resource_id"].ToString();
try
{
AssertionsGrid.DataBind();
SqlDataSource4.DeleteCommand = "spDelete_AssertionWS_FromGrid";
SqlDataSource4.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure;
SqlDataSource4.DeleteParameters["ws_id"].DefaultValue = strWS_ID;
SqlDataSource4.DeleteParameters["method_id"].DefaultValue = strMethodID;
SqlDataSource4.DeleteParameters["rule_id"].DefaultValue = strRuleID;
SqlDataSource4.DeleteParameters["rule_item_id"].DefaultValue = strRuleItemID;
SqlDataSource4.DeleteParameters["resource_id"].DefaultValue = strResourceID;
// *************** extra items to avoid bug (Microsoft counts added Key values as part of procedure params)
SqlDataSource4.DeleteParameters["target_WSID"].DefaultValue = "";
SqlDataSource4.DeleteParameters["topic_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["level_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["domain_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["scope_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["weight"].DefaultValue = "";
SqlDataSource4.DeleteParameters["mandatory_flag"].DefaultValue = "";
SqlDataSource4.DeleteParameters["target_ws_id"].DefaultValue = "";
//********************************************
SqlDataSource4.Delete();
}
catch (Exception exc)
{
var dataFile = Server.MapPath("~/App_Data/ErrorLog.txt");
File.AppendAllText(@dataFile, "Privacy Policies, AssertionsGrid_RowDeleting: " + exc.Message.ToString());
}
finally
{
}
}
protected void AssertionsGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int intRowIndex = e.RowIndex;
AssertionsGrid.SelectRow(intRowIndex);
GridViewRow row = AssertionsGrid.SelectedRow;
string strWS_ID = "6";
string strMethodID = AssertionsGrid.DataKeys[row.RowIndex]["method_id"].ToString();
string strRuleID = AssertionsGrid.DataKeys[row.RowIndex]["rule_id"].ToString();
string strRuleItemID = AssertionsGrid.DataKeys[row.RowIndex]["rule_item_id"].ToString();
string strResourceID = AssertionsGrid.DataKeys[row.RowIndex]["resource_id"].ToString();
try
{
AssertionsGrid.DataBind();
SqlDataSource4.DeleteCommand = "spDelete_AssertionClient_FromGrid";
SqlDataSource4.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure;
SqlDataSource4.DeleteParameters["ws_id"].DefaultValue = strWS_ID;
SqlDataSource4.DeleteParameters["method_id"].DefaultValue = strMethodID;
SqlDataSource4.DeleteParameters["rule_id"].DefaultValue = strRuleID;
SqlDataSource4.DeleteParameters["rule_item_id"].DefaultValue = strRuleItemID;
SqlDataSource4.DeleteParameters["resource_id"].DefaultValue = strResourceID;
// *************** extra items to avoid bug (Microsoft counts added Key values as part of procedure params)
SqlDataSource4.DeleteParameters["target_WSID"].DefaultValue = "";
SqlDataSource4.DeleteParameters["topic_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["level_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["domain_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["scope_id"].DefaultValue = "";
SqlDataSource4.DeleteParameters["weight"].DefaultValue = "";
SqlDataSource4.DeleteParameters["mandatory_flag"].DefaultValue = "";
SqlDataSource4.DeleteParameters["target_ws_id"].DefaultValue = "";
//********************************************
SqlDataSource4.Delete();
}
catch (Exception exc)
{
}
finally
{
}
}
