protected override void ShowData(int StoredProcedureLogDetailId)
{
var data = new Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel();
data.StoredProcedureLogDetailId = StoredProcedureLogDetailId;
var dt = Framework.Components.LogAndTrace.StoredProcedureLogDetailDataManager.GetStoredProcedureLogDetails(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
var row = dt.Rows[0];
lblStoredProcedureLogDetailId.Text = Convert.ToString(row[Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel.DataColumns.StoredProcedureLogDetailId]);
lblStoredProcedureLogId.Text = Convert.ToString(row[Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel.DataColumns.StoredProcedureLogId]);
lblParameterName.Text = Convert.ToString(row[Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel.DataColumns.ParameterName]);
lblParameterValue.Text = Convert.ToString(row[Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel.DataColumns.ParameterValue]);
//oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.StoredProcedureLogDetail, StoredProcedureLogDetailId, "StoredProcedureLogDetail");
dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "StoredProcedureLogDetail");
}
else
{
Clear();
}
}
private DataTable GetData(string StoredProcedureLog)
{
var data = new Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel();
data.StoredProcedureLogId = int.Parse(StoredProcedureLog);
var dt = Framework.Components.LogAndTrace.StoredProcedureLogDetailDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
var indexes = Request.QueryString["DeleteIds"].ToString();
var deleteindexlist = indexes.Split(',');
foreach (string index in deleteindexlist)
{
var data = new Framework.Components.LogAndTrace.StoredProcedureLogDetailDataModel();
data.StoredProcedureLogDetailId = int.Parse(index);
Framework.Components.LogAndTrace.StoredProcedureLogDetailDataManager.Delete(data, SessionVariables.RequestProfile);
}
Response.Redirect("Default.aspx?Deleted=" + true, false);
//ShowData();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}