public IEnumerator GetEnumerator()
{
_arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
_arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
_arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
EditableArrayList list = (EditableArrayList)_objectBinder.List;
_arguments.TotalRowCount = list.Count;
if (!string.IsNullOrEmpty(_arguments.SortExpression))
{
list = new EditableArrayList(list.ItemType, list.Count);
list.AddRange(_objectBinder.List);
list.SortEx(_arguments.SortExpression);
}
int start = _arguments.StartRowIndex >= 0? _arguments.StartRowIndex: 0;
int count = _arguments.MaximumRows > 0?
Math.Min(_arguments.MaximumRows, list.Count): list.Count;
for (int i = 0; i < count; i++)
{
object o = list[i + start];
yield return(o is ICustomTypeDescriptor? o: new ObjectHolder(o, _objectBinder));
}
}
protected void btnAddCatManJob_Click(object sender, EventArgs e)
{
string vettedCreateJobText = Regex.Replace(txtCreateJob.Text.ToLower(), @"[\s]+", "");
try
{
if (vettedCreateJobText != null && vettedCreateJobText != "" && vettedCreateJobText.Length <= 50)
{
sds.ConnectionString = Resources.ConnectionStrings.ATHENA;
sds.SelectCommand = Resources.CatalogManagerSQLQueries.VerifyRegexSelect;
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)sds.Select(dssa);
if (dv.Count == 0)
{
sds.InsertCommand = Resources.CatalogManagerSQLQueries.InsertCleanValues;
sds.Insert();
sds.UpdateCommand = Resources.CatalogManagerSQLQueries.UpdateJobs;
sds.Update();
}
}
txtCreateJob.Text = String.Empty;
}
catch (InvalidCastException ex) { }
}
protected void btnSubmitSuperCategoryChanges_Click(object sender, EventArgs e)
{
string preEditState = (string)(Session["preEditState"]);
string preEditState2 = (string)(Session["preEditState2"]);
string vettedtxtSuperCategory = Regex.Replace(txtSuperCategory.Text.ToLower(), "[ \t\n]+", "");
try
{
if (vettedtxtSuperCategory != null && vettedtxtSuperCategory != "" && vettedtxtSuperCategory.Length <= 50 && txtSuperCategory.Text != ddlSuperCategory.Text)
{
sds.ConnectionString = Resources.ConnectionStrings.ATHENA;
sds.SelectCommand = Resources.CatalogManagerSQLQueries.VerifySuper;
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)sds.Select(dssa);
if (preEditState == ddlMegaCategory.Text)
{
if (dv.Count == 0)
{
sds.UpdateCommand = Resources.CatalogManagerSQLQueries.UpdateSuper;
sds.Update();
sds.InsertCommand = Resources.CatalogManagerSQLQueries.InsertSuper;
sds.Insert();
}
}
}
preEditState = String.Empty;
preEditState2 = String.Empty;
txtSuperCategory.Text = String.Empty;
}
catch (InvalidCastException ex) { }
}
protected void btnAddCategory_Click(object sender, EventArgs e)
{
string vettedTxtCreateCategory1 = Regex.Replace(txtCreateCategory.Text.Trim(), "[^a-zA-Z0-9 ]+", "");
try
{
string vettedTxtCreateCategory2 = Regex.Replace(vettedTxtCreateCategory1.ToLower(), "[ \n\t]", "");
if (vettedTxtCreateCategory2 != null && vettedTxtCreateCategory2 != "" && vettedTxtCreateCategory2.Length <= 75 && vettedTxtCreateCategory2.Length >= 4)
{
sds.ConnectionString = Resources.ConnectionStrings.ATHENA;
sds.SelectCommand = Resources.CatalogManagerSQLQueries.FormattedCat;
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)sds.Select(dssa);
if (dv.Count == 0)
{
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommand command = new SqlCommand(Resources.CatalogManagerSQLQueries.InsertNewCategory);
command.Connection = new SqlConnection(sds.ConnectionString);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Mega", SqlDbType.NVarChar, 50).Value = ddlMegaCategory.Text;
command.Parameters.Add("@Super", SqlDbType.NVarChar, 50).Value = ddlSuperCategory.Text;
command.Parameters.Add("@Cat", SqlDbType.NVarChar, 50).Value = txtCreateCategory.Text;
adapter.InsertCommand = command;
command.Connection.Open();
adapter.InsertCommand.ExecuteNonQuery();
command.Connection.Dispose();
}
else
{
errorMessage.Insert(0, "You're doing it wrong");
lblErrorMessage.Text = string.Join("<br />", errorMessage);
lblErrorMessage.Visible = true;
}
}
else
{
errorMessage.Insert(0, "You're doing it wrong");
lblErrorMessage.Text = string.Join("<br />", errorMessage);
lblErrorMessage.Visible = true;
}
}
catch (Exception ex)
{
errorMessage.Insert(0, "The machine is confused");
lblErrorMessage.Text = string.Join("<br />", errorMessage);
lblErrorMessage.Visible = true;
txtCreateCategory.Text = String.Empty;
ddlMegaCategory.SelectedIndex = 0;
ddlSuperCategory.SelectedIndex = 0;
ddlCategory.SelectedIndex = 0;
ddlSubCategory.SelectedIndex = 0;
}
txtCreateCategory.Text = String.Empty;
}
private void AddSupportedCapabilities(DataSourceSelectArguments arguments)
{
if (CanSort)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
}
if (CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
if (CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
arguments.RaiseUnsupportedCapabilitiesError(this);
}
protected void btnSubmitSubCategoryChanges_Click(object sender, EventArgs e)
{
string preEditState = (string)(Session["preEditState"]);
string preEditState2 = (string)(Session["preEditState2"]);
string vettedtxtSubCategory = Regex.Replace(txtCreateSubCategory.Text.ToLower(), "[ \t\n]+", "");
try
{
if (vettedtxtSubCategory != null && vettedtxtSubCategory != "" && vettedtxtSubCategory.Length <= 50 && txtCreateSubCategory.Text != ddlSubCategory.Text)
{
sds.ConnectionString = Resources.ConnectionStrings.ATHENA;
sds.SelectCommand = Resources.CatalogManagerSQLQueries.VerifySubCat;
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)sds.Select(dssa);
if (preEditState == ddlCategory.Text)
{
if (dv.Count == 0)
{
sds.InsertCommand = Resources.CatalogManagerSQLQueries.InsertSubCat;
sds.Insert();
sds.UpdateCommand = Resources.CatalogManagerSQLQueries.UpdateSubCat;
sds.Update();
sds.UpdateCommand = Resources.CatalogManagerSQLQueries.UpdateSubCatInGlobalProduct;
sds.Update();
sds.InsertCommand = Resources.CatalogManagerSQLQueries.InsertSubCatIntoLog;
sds.Insert();
}
}
if (preEditState != ddlCategory.Text && ddlCategory.SelectedIndex > 1)
{
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommand command = new SqlCommand(Resources.CatalogManagerSQLQueries.UpdateCatUnderEditSubCat);
command.Connection = new SqlConnection(sds.ConnectionString);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@CatInDDL", SqlDbType.NVarChar, 50).Value = ddlCategory.Text;
command.Parameters.Add("@SubCatTxt", SqlDbType.NVarChar, 50).Value = txtCreateSubCategory.Text;
adapter.InsertCommand = command;
command.Connection.Open();
adapter.InsertCommand.ExecuteNonQuery();
command.Connection.Dispose();
}
}
preEditState = String.Empty;
preEditState2 = String.Empty;
}
catch (InvalidCastException ex) { }
}
/// <summary>
/// Executa a consulta para recupera os itens.
/// </summary>
/// <param name="arguments"></param>
/// <returns></returns>
protected override System.Collections.IEnumerable ExecuteSelect(DataSourceSelectArguments arguments)
{
if (CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
if (CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
if (arguments.RetrieveTotalRowCount)
{
arguments.TotalRowCount = Count();
}
if (_owner.Items is Colosoft.Collections.IVirtualList && arguments.MaximumRows > 0)
{
var virtualList = (Colosoft.Collections.IVirtualList)_owner.Items;
virtualList.Configure(arguments.MaximumRows);
}
return(CreateEnumerableData(_owner.Items, arguments));
}
IEnumerable IExcuteableDataSource.Select(DataSourceSelectArguments arguments)
{
_mOrderBy = string.IsNullOrEmpty(DefaultOrderBy) ? new OrderBy((DESC)"Id") : OrderBy.Parse(DefaultOrderBy);
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
string se = arguments.SortExpression;
if (!string.IsNullOrEmpty(se))
{
DefaultOrderBy = se;
_mOrderBy = OrderBy.Parse(se, typeof(T));
}
int pageIndex = (arguments.MaximumRows == 0) ? 0 : arguments.StartRowIndex / arguments.MaximumRows;
int totalRowCount = arguments.TotalRowCount;
List <T> ret = ExecuteSelect(_condition, _mOrderBy, arguments.MaximumRows, pageIndex, ref totalRowCount);
arguments.TotalRowCount = totalRowCount;
return(ret);
}
protected override void PerformSelect()
{
if (!IsBoundUsingDataSourceID)
{
OnDataBinding(EventArgs.Empty);
}
DataSourceView dataSourceView = GetData();
DataSourceViewSelectCallback callback =
delegate(IEnumerable data)
{
if (IsBoundUsingDataSourceID)
{
OnDataBinding(EventArgs.Empty);
}
PerformDataBinding(data);
};
if (EnablePaging && dataSourceView.CanPage)
{
DataSourceSelectArguments selectArguments = CreateDataSourceSelectArguments();
selectArguments.StartRowIndex = PageSize * PageIndex;
selectArguments.MaximumRows = PageSize;
dataSourceView.Select(selectArguments, callback);
}
else
{
DataSourceSelectArguments selectArguments = CreateDataSourceSelectArguments();
if (dataSourceView.CanPage)
{
selectArguments.AddSupportedCapabilities(DataSourceCapabilities.None);
selectArguments.StartRowIndex = 0;
selectArguments.MaximumRows = Int16.MaxValue;
}
dataSourceView.Select(selectArguments, callback);
}
RequiresDataBinding = false;
MarkAsDataBound();
OnDataBound(EventArgs.Empty);
}
private int GetTotalRowCount()
{
int totalRowCount = 0;
DataSourceView dataSourceView = GetData();
if (dataSourceView.CanRetrieveTotalRowCount)
{
DataSourceSelectArguments selectArguments = CreateDataSourceSelectArguments();
selectArguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
selectArguments.RetrieveTotalRowCount = true;
DataSourceViewSelectCallback callback =
delegate
{
totalRowCount = selectArguments.TotalRowCount;
};
dataSourceView.Select(selectArguments, callback);
}
return(totalRowCount);
}
protected void ddl_College_FiscalYear_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddl_fiscalyear.SelectedIndex > 0 && ddl_College.SelectedIndex > 0)
{
pan_Acc.Visible = true;
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)SQLDS_Accountablity.Select(dssa);
Label1.Text = dv.Table.Rows[0][0].ToString();
hf_Accountability_Id.Value = dv.Table.Rows[0][0].ToString();
lbl_Acc_Id.Text = dv.Table.Rows[0][0].ToString();
txt_Note.Text = dv.Table.Rows[0][4].ToString();
//ds_Level.DataBind();
dv = (DataView)ds_Level.Select(dssa);
lbl_Level.Text = dv.Table.Rows[0][1].ToString();
hf_Level_Id.Value = dv.Table.Rows[0][0].ToString();
ddl_Acct_Next_Level.DataBind();
//ds_Acc_Narr.DataBind();
//SqlDS_Gender.DataBind();
//SqlDS_Race.DataBind();
//ds_2p1_Spec_Pop.DataBind();
//ds_3p1_Spec_Pop.DataBind();
//ds_4p1_Spec_Pop.DataBind();
//ds_5p1_Spec_Pop.DataBind();
//ds_5p2_Spec_Pop.DataBind();
//ds_Enrollment.DataBind();
rg_Narratives.DataBind();
rg_Enrollment.DataBind();
}
else
pan_Acc.Visible = false;
}
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments)
{
if (!String.IsNullOrEmpty(Source.FindMethod))
{
return(ExecuteCustomSelect(arguments));
}
if (CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
if (CanSort)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
}
if (CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
ActiveRecordDataSourceFindEventArgs args = new ActiveRecordDataSourceFindEventArgs();
CreateCriteriaFromFindParameters(args);
CreateOrderFromFindParameters(args, arguments.SortExpression);
//set default sort
if (args.Order.Count <= 0)
{
CreateOrderFromFindParameters(args, Source.DefaultSort);
}
args.ModelType = BuildManager.GetType(Source.TypeName, false, true);
Source.OnBeforeFind(args);
if (args.Cancel)
{
return(null);
}
Array result = null;
try
{
if (arguments.RetrieveTotalRowCount)
{
arguments.TotalRowCount = ExecuteCount(args);
}
bool useSlicedFind = false;
int firstResult = 0;
int maxResults = 0;
if (CanPage)
{
useSlicedFind = true;
firstResult = arguments.StartRowIndex;
maxResults = arguments.MaximumRows;
}
else if (Source.DefaultMaximumRows > 0)
{
useSlicedFind = true;
firstResult = 0;
maxResults = Source.DefaultMaximumRows;
}
if (useSlicedFind)
{
result = ActiveRecordMediator.SlicedFindAll(args.ModelType, firstResult, maxResults, args.Order.ToArray(), args.Criteria.ToArray());
}
else
{
result = ActiveRecordMediator.FindAll(args.ModelType, args.Order.ToArray(), args.Criteria.ToArray());
}
}
catch (Exception e)
{
args.Exception = e;
args.WasError = true;
Source.OnFindError(args);
if (Source.ThrowOnError && !args.DoNotThrow)
{
throw;
}
return(null);
}
args.Result = result;
Source.OnFind(args);
return(result);
}
protected void ReloadData()
{
DataView dv1 = (DataView)sqlds_accountablityCheck.Select(DataSourceSelectArguments.Empty);
DataSet rowcountds = dv1.Table.DataSet.Copy();
if (rowcountds.Tables[0].Rows[0][0].ToString() == "0")
{
btnCreate.Visible = true;
lbl_Acc_Id.Text = "";
lbl_Acc_Id.Visible = false;
txt_Note.Visible = false;
lbl_Level.Visible = false;
hf_Level_Id.Visible = false;
ddl_Acct_Next_Level.Visible = false;
btn_Save.Visible = false;
Label3.Visible = false;
Label4.Visible = false;
Label5.Visible = false;
Label6.Visible = false;
HL_Errors.Visible = false;
HL_RPLIST.Visible = false;
lnkSubmit.Visible = false;
if (Session[Session.SessionID + "roleid"].ToString() != "101")
{
btnCreate.Visible = false;
}
else
{
btnCreate.Visible = true;
}
lbl_error.Visible = true;
}
else
{
btnCreate.Visible = false;
lbl_error.Visible = false;
if (ddl_fiscalyear.SelectedIndex > 0)
{
SQLDS_Accountablity.SelectParameters.Clear();
SQLDS_Accountablity.SelectParameters.Add("p_key_college_id", ddl_College.SelectedValue);
SQLDS_Accountablity.SelectParameters.Add("p_nbr_fiscal_year", ddl_fiscalyear.SelectedValue);
SQLDS_Accountablity.SelectParameters.Add("p_txt_created_by", HttpContext.Current.User.Identity.Name.ToString());
SQLDS_Accountablity.Select(DataSourceSelectArguments.Empty);
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)SQLDS_Accountablity.Select(dssa);
hf_Accountability_Id.Value = dv.Table.Rows[0][0].ToString();
lbl_Acc_Id.Text = dv.Table.Rows[0][0].ToString();
txt_Note.Text = dv.Table.Rows[0][4].ToString();
dv = (DataView)ds_Level.Select(dssa);
lbl_Level.Text = dv.Table.Rows[0][1].ToString();
Session.Add(HttpContext.Current.User.Identity.Name + Session.SessionID + "LevelTitle", lbl_Level.Text);
hf_Level_Id.Value = dv.Table.Rows[0][0].ToString();
ddl_Acct_Next_Level.DataBind();
lbl_Acc_Id.Visible = true;
txt_Note.Visible = true;
lbl_Level.Visible = true;
hf_Level_Id.Visible = true;
ddl_Acct_Next_Level.Visible = true;
btn_Save.Visible = true;
Label3.Visible = true;
Label4.Visible = true;
Label5.Visible = true;
Label6.Visible = true;
HL_RPLIST.Visible = true;
lnkSubmit.Visible = true;
}
else
{
lbl_Acc_Id.Text = "";
txt_Note.Text = "";
lbl_Level.Text = "";
hf_Level_Id.Value = "";
//ds_Acct_Next_Level.DataBind();
ddl_Acct_Next_Level.Items.Clear();
HL_Errors.Visible = false;
HL_RPLIST.Visible = false;
lnkSubmit.Visible = false;
}
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
// Create an Accountability Report
if (ddl_fiscalyear.SelectedIndex > 0)
{
SQLDS_Accountablity.InsertParameters.Clear();
SQLDS_Accountablity.InsertParameters.Add("p_key_college_id", ddl_College.SelectedValue);
SQLDS_Accountablity.InsertParameters.Add("p_nbr_fiscal_year", ddl_fiscalyear.SelectedValue);
SQLDS_Accountablity.InsertParameters.Add("p_txt_created_by", HttpContext.Current.User.Identity.Name.ToString());
SQLDS_Accountablity.Insert();
SQLDS_Accountablity.SelectParameters.Clear();
SQLDS_Accountablity.SelectParameters.Add("p_key_college_id", ddl_College.SelectedValue);
SQLDS_Accountablity.SelectParameters.Add("p_nbr_fiscal_year", ddl_fiscalyear.SelectedValue);
SQLDS_Accountablity.SelectParameters.Add("p_txt_created_by",HttpContext.Current.User.Identity.Name.ToString());
SQLDS_Accountablity.Select(DataSourceSelectArguments.Empty);
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)SQLDS_Accountablity.Select(dssa);
hf_Accountability_Id.Value = dv.Table.Rows[0][0].ToString();
lbl_Acc_Id.Text = dv.Table.Rows[0][0].ToString();
txt_Note.Text = dv.Table.Rows[0][4].ToString();
dv = (DataView)ds_Level.Select(dssa);
lbl_Level.Text = dv.Table.Rows[0][1].ToString();
hf_Level_Id.Value = dv.Table.Rows[0][0].ToString();
ddl_Acct_Next_Level.DataBind();
lbl_Acc_Id.Visible = true;
txt_Note.Visible = true;
lbl_Level.Visible = true;
hf_Level_Id.Visible = true;
ddl_Acct_Next_Level.Visible = true;
btn_Save.Visible = true;
Label3.Visible = true;
Label4.Visible = true;
Label5.Visible = true;
Label6.Visible = true;
HL_RPLIST.Visible = true;
lnkSubmit.Visible = true;
}
else
{
lbl_Acc_Id.Text = "";
txt_Note.Text = "";
lbl_Level.Text = "";
hf_Level_Id.Value = "";
//ds_Acct_Next_Level.DataBind();
ddl_Acct_Next_Level.Items.Clear();
HL_Errors.Visible = false;
HL_RPLIST.Visible = false;
lnkSubmit.Visible = false;
btn_Save.Visible = false;
}
LoadSession();
ReloadData();
}
protected override IAsyncResult BeginExecuteSelect(
DataSourceSelectArguments arguments,
AsyncCallback asyncCallback,
object asyncState)
{
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "Begin");
if (CanSort)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
}
if (CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
if (CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
string fetchXml;
QueryByAttribute query;
InitializeParameters(out fetchXml, out query);
// raise pre-event
CrmDataSourceSelectingEventArgs selectingArgs = new CrmDataSourceSelectingEventArgs(
Owner,
arguments,
fetchXml,
query);
OnSelecting(selectingArgs);
IEnumerable selectResult = null;
if (selectingArgs.Cancel)
{
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "Cancel");
return(new SynchronousAsyncSelectResult(selectResult, asyncCallback, asyncState));
}
// merge event results
arguments.RaiseUnsupportedCapabilitiesError(this);
fetchXml = selectingArgs.FetchXml;
if (CancelSelectOnNullParameter && string.IsNullOrEmpty(fetchXml) && query == null)
{
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "CancelSelectOnNullParameter");
return(new SynchronousAsyncSelectResult(selectResult, asyncCallback, asyncState));
}
try
{
_client = OrganizationServiceContextFactory.Create(Owner.CrmDataContextName);
if (!string.IsNullOrEmpty(fetchXml))
{
var fetch = ToFetch(arguments, fetchXml);
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "End");
return(ExecuteSelect(_client, null, fetch, asyncCallback, asyncState));
}
if (query != null)
{
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "QueryByAttribute");
// the SortExpression has high priority, apply it to the query
AppendSortExpressionToQuery(arguments.SortExpression, order => query.Orders.Add(order));
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "End");
return(ExecuteSelect(_client, query, null, asyncCallback, asyncState));
}
}
catch (System.Web.Services.Protocols.SoapException ex)
{
ADXTrace.Instance.TraceError(TraceCategory.Application, string.Format("{0}\n\n{1}", ex.Detail.InnerXml, ex.ToString()));
}
catch (Exception e)
{
ADXTrace.Instance.TraceError(TraceCategory.Application, string.Format("Exception: {0}", e.ToString()));
_client = null;
return(new SynchronousAsyncSelectResult(e, asyncCallback, asyncState));
}
ADXTrace.Instance.TraceInfo(TraceCategory.Application, "End");
return(new SynchronousAsyncSelectResult(selectResult, asyncCallback, asyncState));
}
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments args)
{
args.AddSupportedCapabilities(DataSourceCapabilities.Page);
args.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
args.RaiseUnsupportedCapabilitiesError(this);
var parameters = Owner.SelectParameters.GetValues(HttpContext.Current, Owner);
var filter = GetFilter(args, parameters);
var logicalNames = GetLogicalNames(args, parameters);
var pageSize = GetPageSize(args, parameters);
var pageNumber = GetPageNumber(args, parameters, pageSize);
var queryText = GetQueryText(args, parameters);
ContextLanguageInfo contextLanguage;
var multiLanguageEnabled = TryGetLanguageCode(out contextLanguage);
if (string.IsNullOrWhiteSpace(queryText) && string.IsNullOrWhiteSpace(filter))
{
args.TotalRowCount = 0;
return(new CrmEntitySearchResultPage(new List <ICrmEntitySearchResult>(), 0, pageNumber, pageSize));
}
var provider = SearchManager.GetProvider(Owner.SearchProvider);
var query = new CrmEntityQuery(queryText, pageNumber, pageSize, logicalNames, contextLanguage.ContextLanguage, multiLanguageEnabled, filter);
var selectingArgs = new SearchDataSourceSelectingEventArgs(provider, query);
Owner.OnSelecting(selectingArgs);
if (selectingArgs.Cancel)
{
args.TotalRowCount = 0;
return(new CrmEntitySearchResultPage(new List <ICrmEntitySearchResult>(), 0, pageNumber, pageSize));
}
try
{
using (var searcher = provider.GetIndexSearcher())
{
var results = searcher.Search(query);
args.TotalRowCount = results.ApproximateTotalHits;
Owner.OnSelected(new SearchDataSourceStatusEventArgs(provider, query, results));
return(results);
}
}
catch (Exception e)
{
ADXTrace.Instance.TraceError(TraceCategory.Application, e.ToString());
var selectedArgs = new SearchDataSourceStatusEventArgs(provider, query, new CrmEntitySearchResultPage(new List <ICrmEntitySearchResult>(), 0, pageNumber, pageSize))
{
Exception = e
};
Owner.OnSelected(selectedArgs);
if (!selectedArgs.ExceptionHandled)
{
throw;
}
args.TotalRowCount = 0;
return(new CrmEntitySearchResultPage(new List <ICrmEntitySearchResult>(), 0, pageNumber, pageSize));
}
}
private String GetCurrentLevel_Id()
{
try
{
DecipherSession myobj = new DecipherSession(Session[Session.SessionID + HttpContext.Current.User.Identity + "accountiblityids"].ToString());
SQLDS_Accountablity.SelectParameters.Clear();
SQLDS_Accountablity.SelectParameters.Add("p_key_college_id", myobj.CollID.ToString());
SQLDS_Accountablity.SelectParameters.Add("p_nbr_fiscal_year", myobj.FiscalYear.ToString());
SQLDS_Accountablity.Select(DataSourceSelectArguments.Empty);
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)SQLDS_Accountablity.Select(dssa);
return dv.Table.Rows[0][3].ToString();
}
catch
{
return "";
}
return "";
}
public void RaiseUnsupportedCapabilitiesError()
{
PockerDataSourceView view = new PockerDataSourceView();
DataSourceSelectArguments arg = new DataSourceSelectArguments();
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsFalse(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.StartRowIndex = 10;
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsTrue(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
Assert.AreEqual(DataSourceCapabilities.Page, view.DataSourceCapabilities, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.MaximumRows = 5;
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsTrue(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
Assert.AreEqual(DataSourceCapabilities.Page, view.DataSourceCapabilities, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.SortExpression = "Sort";
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsTrue(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
Assert.AreEqual(DataSourceCapabilities.Sort, view.DataSourceCapabilities, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.RetrieveTotalRowCount = true;
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsTrue(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
Assert.AreEqual(DataSourceCapabilities.RetrieveTotalRowCount, view.DataSourceCapabilities, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.AddSupportedCapabilities(DataSourceCapabilities.Page | DataSourceCapabilities.Sort | DataSourceCapabilities.RetrieveTotalRowCount);
arg.SortExpression = "Sort";
arg.StartRowIndex = 10;
arg.MaximumRows = 5;
arg.RetrieveTotalRowCount = true;
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsFalse(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.SortExpression = "Sort";
arg.StartRowIndex = 10;
arg.MaximumRows = 5;
arg.RetrieveTotalRowCount = true;
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsTrue(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
Assert.AreEqual(DataSourceCapabilities.RetrieveTotalRowCount, view.DataSourceCapabilities, "RaiseUnsupportedCapabilitiesError");
view = new PockerDataSourceView();
arg = new DataSourceSelectArguments();
arg.SortExpression = "Sort";
arg.StartRowIndex = 10;
arg.MaximumRows = 5;
arg.RaiseUnsupportedCapabilitiesError(view);
Assert.IsTrue(view.RaiseUnsupportedCapabilityErrorCalled, "RaiseUnsupportedCapabilitiesError");
Assert.AreEqual(DataSourceCapabilities.Page, view.DataSourceCapabilities, "RaiseUnsupportedCapabilitiesError");
}
protected internal override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments)
{
SqlCacheDependency dependency;
if (this.SelectCommand.Length == 0)
{
return(null);
}
DbConnection connection = this._owner.CreateConnection(this._owner.ConnectionString);
if (connection == null)
{
throw new InvalidOperationException(System.Web.SR.GetString("SqlDataSourceView_CouldNotCreateConnection", new object[] { this._owner.ID }));
}
DataSourceCache cache = this._owner.Cache;
bool flag = (cache != null) && cache.Enabled;
string sortExpression = arguments.SortExpression;
if (this.CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
if (this.CanSort)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
}
if (this.CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
if (flag)
{
if (this._owner.DataSourceMode != SqlDataSourceMode.DataSet)
{
throw new NotSupportedException(System.Web.SR.GetString("SqlDataSourceView_CacheNotSupported", new object[] { this._owner.ID }));
}
arguments.RaiseUnsupportedCapabilitiesError(this);
DataSet set = this._owner.LoadDataFromCache(0, -1) as DataSet;
if (set != null)
{
IOrderedDictionary parameterValues = this.FilterParameters.GetValues(this._context, this._owner);
if (this.FilterExpression.Length > 0)
{
SqlDataSourceFilteringEventArgs args = new SqlDataSourceFilteringEventArgs(parameterValues);
this.OnFiltering(args);
if (args.Cancel)
{
return(null);
}
}
return(FilteredDataSetHelper.CreateFilteredDataView(set.Tables[0], sortExpression, this.FilterExpression, parameterValues));
}
}
DbCommand command = this._owner.CreateCommand(this.SelectCommand, connection);
this.InitializeParameters(command, this.SelectParameters, null);
command.CommandType = GetCommandType(this.SelectCommandType);
SqlDataSourceSelectingEventArgs e = new SqlDataSourceSelectingEventArgs(command, arguments);
this.OnSelecting(e);
if (e.Cancel)
{
return(null);
}
string sortParameterName = this.SortParameterName;
if (sortParameterName.Length > 0)
{
if (command.CommandType != CommandType.StoredProcedure)
{
throw new NotSupportedException(System.Web.SR.GetString("SqlDataSourceView_SortParameterRequiresStoredProcedure", new object[] { this._owner.ID }));
}
command.Parameters.Add(this._owner.CreateParameter(this.ParameterPrefix + sortParameterName, sortExpression));
arguments.SortExpression = string.Empty;
}
arguments.RaiseUnsupportedCapabilitiesError(this);
sortExpression = arguments.SortExpression;
if (this.CancelSelectOnNullParameter)
{
int count = command.Parameters.Count;
for (int i = 0; i < count; i++)
{
DbParameter parameter = command.Parameters[i];
if (((parameter != null) && (parameter.Value == null)) && ((parameter.Direction == ParameterDirection.Input) || (parameter.Direction == ParameterDirection.InputOutput)))
{
return(null);
}
}
}
this.ReplaceNullValues(command);
IEnumerable enumerable = null;
switch (this._owner.DataSourceMode)
{
case SqlDataSourceMode.DataReader:
{
if (this.FilterExpression.Length > 0)
{
throw new NotSupportedException(System.Web.SR.GetString("SqlDataSourceView_FilterNotSupported", new object[] { this._owner.ID }));
}
if (sortExpression.Length > 0)
{
throw new NotSupportedException(System.Web.SR.GetString("SqlDataSourceView_SortNotSupported", new object[] { this._owner.ID }));
}
bool flag4 = false;
try
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
enumerable = command.ExecuteReader(CommandBehavior.CloseConnection);
flag4 = true;
SqlDataSourceStatusEventArgs args6 = new SqlDataSourceStatusEventArgs(command, 0, null);
this.OnSelected(args6);
}
catch (Exception exception2)
{
bool flag5;
if (!flag4)
{
SqlDataSourceStatusEventArgs args7 = new SqlDataSourceStatusEventArgs(command, 0, exception2);
this.OnSelected(args7);
if (!args7.ExceptionHandled)
{
throw;
}
return(enumerable);
}
exception2 = this.BuildCustomException(exception2, DataSourceOperation.Select, command, out flag5);
if (flag5)
{
throw exception2;
}
throw;
}
return(enumerable);
}
case SqlDataSourceMode.DataSet:
dependency = null;
if (flag && (cache is SqlDataSourceCache))
{
SqlDataSourceCache cache2 = (SqlDataSourceCache)cache;
if (string.Equals(cache2.SqlCacheDependency, "CommandNotification", StringComparison.OrdinalIgnoreCase))
{
if (!(command is SqlCommand))
{
throw new InvalidOperationException(System.Web.SR.GetString("SqlDataSourceView_CommandNotificationNotSupported", new object[] { this._owner.ID }));
}
dependency = new SqlCacheDependency((SqlCommand)command);
break;
}
}
break;
default:
return(enumerable);
}
DbDataAdapter adapter = this._owner.CreateDataAdapter(command);
DataSet dataSet = new DataSet();
int affectedRows = 0;
bool flag2 = false;
try
{
affectedRows = adapter.Fill(dataSet, base.Name);
flag2 = true;
SqlDataSourceStatusEventArgs args3 = new SqlDataSourceStatusEventArgs(command, affectedRows, null);
this.OnSelected(args3);
}
catch (Exception exception)
{
if (flag2)
{
bool flag3;
exception = this.BuildCustomException(exception, DataSourceOperation.Select, command, out flag3);
if (flag3)
{
throw exception;
}
throw;
}
SqlDataSourceStatusEventArgs args4 = new SqlDataSourceStatusEventArgs(command, affectedRows, exception);
this.OnSelected(args4);
if (!args4.ExceptionHandled)
{
throw;
}
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
DataTable table = (dataSet.Tables.Count > 0) ? dataSet.Tables[0] : null;
if (flag && (table != null))
{
this._owner.SaveDataToCache(0, -1, dataSet, dependency);
}
if (table == null)
{
return(enumerable);
}
IOrderedDictionary values = this.FilterParameters.GetValues(this._context, this._owner);
if (this.FilterExpression.Length > 0)
{
SqlDataSourceFilteringEventArgs args5 = new SqlDataSourceFilteringEventArgs(values);
this.OnFiltering(args5);
if (args5.Cancel)
{
return(null);
}
}
return(FilteredDataSetHelper.CreateFilteredDataView(table, sortExpression, this.FilterExpression, values));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Clear();
string connectionStr = ConfigurationManager.ConnectionStrings["UcccPubMedDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionStr);
string sqlStatement = "";
string sqlStatement2 = "";
string sqlStatement3 = "";
if (txtPmid.Text != "" || txtPmcid.Text != "")
{
if (txtPmid.Text != "")
{
sqlStatement =
"select p.*,pp.authorlist, lyn.description as final_confirm, pp.review_editorial" +
" from publication p" +
" inner join publication_processing pp on p.publication_id = pp.publication_id" +
" left outer join l_yes_no lyn" +
" on pp.final_confirm_id = lyn.l_yes_no_id" +
" where p.pmid = " + txtPmid.Text;
sqlStatement2 =
"select pp.publication_program_id," +
" lp.abbreviation as program," +
" case when lfg.group_number >= 0 then" +
" 'FG ' + convert(varchar,lfg.group_number) + '-' + lfg.description" +
" else lfg.description end" +
" as focus_group" +
" from publication_program pp" +
" inner join publication p" +
" on pp.publication_id = p.publication_id" +
" inner join l_program lp" +
" on pp.l_program_id = lp.l_program_id" +
" left outer join l_focus_group lfg" +
" on pp.l_focus_group_id = lfg.l_focus_group_id" +
" where p.pmid = " +
txtPmid.Text;
sqlStatement3 =
"select" +
" lr.description as resource" +
" from publication_resource pr" +
" inner join publication p" +
" on pr.publication_id = p.publication_id" +
" inner join l_resource lr" +
" on pr.l_resource_id = lr.l_resource_id" +
" where p.pmid = " +
txtPmid.Text;
}
else if (txtPmcid.Text != "")
{
sqlStatement =
"select p.*,pp.authorlist, lyn.description as final_confirm, pp.review_editorial" +
" from publication p" +
" inner join publication_processing pp on p.publication_id = pp.publication_id" +
" left outer join l_yes_no lyn" +
" on pp.final_confirm_id = lyn.l_yes_no_id" +
" where p.pmcid = '" + txtPmcid.Text + "'";
sqlStatement2 =
"select pp.publication_program_id," +
" lp.abbreviation as program," +
" case when lfg.group_number >= 0 then" +
" 'FG ' + convert(varchar,lfg.group_number) + '-' + lfg.description" +
" else lfg.description end" +
" as focus_group" +
" from publication_program pp" +
" inner join publication p" +
" on pp.publication_id = p.publication_id" +
" inner join l_program lp" +
" on pp.l_program_id = lp.l_program_id" +
" left outer join l_focus_group lfg" +
" on pp.l_focus_group_id = lfg.l_focus_group_id" +
" where p.pmcid = '" +
txtPmcid.Text + "'";
sqlStatement3 =
"select" +
" lr.description as resource" +
" from publication_resource pr" +
" inner join publication p" +
" on pr.publication_id = p.publication_id" +
" inner join l_resource lr" +
" on pr.l_resource_id = lr.l_resource_id" +
" where p.pmcid = '" +
txtPmcid.Text + "'";
}
SqlDataSource ds = new SqlDataSource(connectionStr, sqlStatement);
dvPublication.DataSource = ds;
DataSourceSelectArguments dssa = new DataSourceSelectArguments();
dssa.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
dssa.RetrieveTotalRowCount = true;
DataView dv = (DataView)ds.Select(dssa);
if (dv.Table.Rows.Count > 0)
{
dvPublication.DataBind();
btnEdit.Visible = true;
}
else
{
ErrorMessage.Text = "No pub in database. You can import it.";
btnImport.Visible = true;
}
SqlDataSource ds2 = new SqlDataSource(connectionStr, sqlStatement2);
gvProgram.DataSource = ds2;
gvProgram.DataBind();
SqlDataSource ds3 = new SqlDataSource(connectionStr, sqlStatement3);
gvResource.DataSource = ds3;
gvResource.DataBind();
}
else if (txtTitle.Text != "")
{
sqlStatement =
"select p.publication_id," +
" p.pmid," +
" p.article_title" +
" from publication p" +
" where p.article_title like '%" +
txtTitle.Text +
"%'";
Helper.BindGridview(sqlStatement, gvPublication);
}
else if (txtLastName.Text != "")
{
sqlStatement =
"select p.publication_id," +
" p.pmid," +
" p.article_title" +
" from publication p" +
" inner join publication_processing pp" +
" on p.publication_id = pp.publication_id" +
" where pp.authorlist like '%" +
txtLastName.Text +
"%'";
Helper.BindGridview(sqlStatement, gvPublication);
}
}
protected Array ExecuteCustomSelect(DataSourceSelectArguments arguments)
{
if (CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
if (CanSort)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
}
if (CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
ActiveRecordDataSourceFindEventArgs args = new ActiveRecordDataSourceFindEventArgs();
CreateOrderFromFindParameters(args, arguments.SortExpression);
if (args.Order.Count <= 0)
{
CreateOrderFromFindParameters(args, Source.DefaultSort);
}
args.ModelType = BuildManager.GetType(Source.TypeName, false, true);
Source.OnBeforeFind(args);
if (args.Cancel)
{
return(null);
}
bool useSlicedFind = false;
int firstResult = 0;
int maxResults = 0;
if (CanPage)
{
useSlicedFind = true;
firstResult = arguments.StartRowIndex;
maxResults = arguments.MaximumRows;
}
else if (Source.DefaultMaximumRows > 0)
{
useSlicedFind = true;
firstResult = 0;
maxResults = Source.DefaultMaximumRows;
}
Dictionary <string, object> methodParameters = CreateMethodParametersFromFindParameters();
if (!String.IsNullOrEmpty(Source.FindMethodFirstResultParam) && useSlicedFind)
{
methodParameters[Source.FindMethodFirstResultParam] = firstResult;
}
if (!String.IsNullOrEmpty(Source.FindMethodMaxResultsParam) && useSlicedFind)
{
methodParameters[Source.FindMethodMaxResultsParam] = maxResults;
}
if (!String.IsNullOrEmpty(Source.FindMethodOrderParam) && CanSort)
{
methodParameters[Source.FindMethodOrderParam] = args.Order.ToArray();
}
Array result = null;
try
{
if (arguments.RetrieveTotalRowCount)
{
arguments.TotalRowCount = ExecuteCount(args);
}
MethodInfo findMethod;
Dictionary <string, int> methodParameterNameToIndex;
ResolveCustomFindMethod(args.ModelType, methodParameters, out findMethod, out methodParameterNameToIndex);
if (findMethod == null)
{
throw new ApplicationException(String.Format("Invalid custom find method '{0}'.", Source.FindMethod));
}
object[] findMethodArgs = new object[methodParameters.Keys.Count];
foreach (string key in methodParameters.Keys)
{
findMethodArgs[methodParameterNameToIndex[key]] = methodParameters[key];
}
result = findMethod.Invoke(null, findMethodArgs) as Array;
}
catch (Exception e)
{
args.Exception = e;
args.WasError = true;
Source.OnFindError(args);
if (Source.ThrowOnError && !args.DoNotThrow)
{
throw;
}
return(null);
}
args.Result = result;
Source.OnFind(args);
return(result);
}
protected override IEnumerable ExecuteSelect(DataSourceSelectArguments arguments)
{
Tracing.FrameworkInformation("CrmMetadataDataSourceView", "ExecuteSelect", "Begin");
if (CanSort)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Sort);
}
if (CanPage)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.Page);
}
if (CanRetrieveTotalRowCount)
{
arguments.AddSupportedCapabilities(DataSourceCapabilities.RetrieveTotalRowCount);
}
// merge SelectParameters
IOrderedDictionary parameters = SelectParameters.GetValues(Context, Owner);
string sortExpression = GetNonNullOrEmpty(
arguments.SortExpression,
parameters[_sortExpressionParameterName] as string,
SortExpression);
string entityName = GetNonNullOrEmpty(
parameters[_entityNameParameterName] as string,
EntityName);
string attributeName = GetNonNullOrEmpty(
parameters[_attributeNameParameterName] as string,
AttributeName);
var metadataFlags = MetadataFlags;
if (parameters.Contains(_metadataFlagsParameterName))
{
metadataFlags = (parameters[_metadataFlagsParameterName] as string).ToEnum <EntityFilters>();
}
var entityFlags = EntityFlags;
if (parameters.Contains(_entityFlagsParameterName))
{
entityFlags = (parameters[_entityFlagsParameterName] as string).ToEnum <EntityFilters>();
}
// raise pre-event
CrmMetadataDataSourceSelectingEventArgs selectingArgs = new CrmMetadataDataSourceSelectingEventArgs(
Owner,
arguments,
entityName,
attributeName,
metadataFlags,
entityFlags,
sortExpression);
OnSelecting(selectingArgs);
if (selectingArgs.Cancel)
{
Tracing.FrameworkInformation("CrmMetadataDataSourceView", "ExecuteSelect", "Cancel");
return(null);
}
// merge event results
arguments.RaiseUnsupportedCapabilitiesError(this);
sortExpression = selectingArgs.SortExpression;
entityName = selectingArgs.EntityName;
attributeName = selectingArgs.AttributeName;
metadataFlags = selectingArgs.MetadataFlags;
entityFlags = selectingArgs.EntityFlags;
if (CancelSelectOnNullParameter && string.IsNullOrEmpty(entityName) && string.IsNullOrEmpty(attributeName))
{
Tracing.FrameworkInformation("CrmMetadataDataSourceView", "ExecuteSelect", "CancelSelectOnNullParameter");
return(null);
}
IEnumerable result = null;
int rowsAffected = 0;
try
{
if (Owner.CacheParameters.Enabled)
{
var cacheKey = GetCacheKey(metadataFlags, entityFlags, entityName, attributeName, sortExpression);
result = ObjectCacheManager.Get(cacheKey,
cache =>
{
var metadata = ExecuteSelect(entityName, attributeName, sortExpression, entityFlags, metadataFlags, out rowsAffected);
return(metadata);
},
(cache, metadata) =>
{
if (metadata != null)
{
var dependencies = GetCacheDependencies(metadata);
cache.Insert(cacheKey, metadata, dependencies);
}
});
}
else
{
result = ExecuteSelect(entityName, attributeName, sortExpression, entityFlags, metadataFlags, out rowsAffected);
}
}
catch (System.Web.Services.Protocols.SoapException ex)
{
Tracing.FrameworkError("CrmMetadataDataSourceView", "ExecuteSelect", "{0}\n\n{1}", ex.Detail.InnerXml, ex);
}
catch (Exception e)
{
Tracing.FrameworkError("CrmMetadataDataSourceView", "ExecuteSelect", "Exception: {0}", e);
// raise post-event with exception
CrmMetadataDataSourceStatusEventArgs selectedExceptionArgs = new CrmMetadataDataSourceStatusEventArgs(0, e);
OnSelected(selectedExceptionArgs);
if (!selectedExceptionArgs.ExceptionHandled)
{
throw;
}
return(result);
}
// raise post-event
CrmMetadataDataSourceStatusEventArgs selectedArgs = new CrmMetadataDataSourceStatusEventArgs(rowsAffected, null);
OnSelected(selectedArgs);
Tracing.FrameworkInformation("CrmMetadataDataSourceView", "ExecuteSelect", "End");
return(result);
}
