public static List <FieldConfigurationDataModel> GetEntityDetails(FieldConfigurationDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.FieldConfigurationSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
//, ApplicationId = dataQuery.ApplicationId
, ApplicationId = requestProfile.ApplicationId
, ApplicationMode = requestProfile.ApplicationModeId
, FieldConfigurationId = dataQuery.FieldConfigurationId
, SystemEntityTypeId = dataQuery.SystemEntityTypeId
, FieldConfigurationModeId = dataQuery.FieldConfigurationModeId
, DisplayColumn = dataQuery.DisplayColumn
, CellCount = dataQuery.CellCount
, Name = dataQuery.Name
, ReturnAuditInfo = returnAuditInfo
};
List <FieldConfigurationDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <FieldConfigurationDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static DataTable GetGridViewColumns(int systemEntityTypeId, int auditId)
{
var obj = new FieldConfigurationDataModel();
var odt = new DataTable();
if (SessionVariables.AEFLTable == null)
{
obj.SystemEntityTypeId = systemEntityTypeId;
odt = FieldConfigurationDataManager.Search(obj, auditId, SessionVariables.ApplicationMode);
SessionVariables.AEFLTable = odt;
}
else
{
var dtInSession = SessionVariables.AEFLTable;
odt = dtInSession.Clone();
var datarows = dtInSession.Select("SystemEntityTypeId = " + systemEntityTypeId);
if (datarows.Length > 0)
{
foreach (var dr in datarows)
{
odt.ImportRow(dr);
}
}
else
{
obj.SystemEntityTypeId = systemEntityTypeId;
odt = FieldConfigurationDataManager.Search(obj, auditId, SessionVariables.ApplicationMode);
dtInSession.Merge(odt);
SessionVariables.AEFLTable = dtInSession;
}
}
return(odt);
}
public static int Create(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var sql = Save(data, requestProfile, "Create");
var fieldConfigurationId = DBDML.RunScalarSQL("FieldConfiguration.Insert", sql, DataStoreKey);
return(Convert.ToInt32(fieldConfigurationId));
}
private static void UpdateGridTableInCache(int systemEntityTypeId, int auditId)
{
var obj = new FieldConfigurationDataModel();
var data = new DataTable();
obj.SystemEntityTypeId = systemEntityTypeId;
data = FieldConfigurationDataManager.Search(obj, auditId, SessionVariables.ApplicationMode);
var dtInSession = (DataTable)SessionVariables.GridColumnsTable;
if (dtInSession != null)
{
var odt = dtInSession.Clone();
var datarows = dtInSession.Select("SystemEntityTypeId = " + systemEntityTypeId);
if (datarows.Length > 0)
{
foreach (var dr in datarows)
{
dtInSession.Rows.Remove(dr);
}
}
dtInSession.Merge(data);
SessionVariables.GridColumnsTable = dtInSession;
}
else
{
SessionVariables.GridColumnsTable = data;
}
}
public void SetupSearch()
{
if (SearchColumns == null)
{
//Code to bind the Search fields repeater with SearchField Mode columns from FieldConfig table
var colsdata = new FieldConfigurationDataModel();
colsdata.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
colsdata.SystemEntityTypeId = Convert.ToInt32(Framework.Components.DataAccess.SystemEntity.Application);
var cols = FieldConfigurationDataManager.Search(colsdata, AuditId, SessionVariables.ApplicationMode);
SearchColumns = cols;
}
SearchParametersRepeater.DataSource = SearchColumns;
SearchParametersRepeater.DataBind();
if (!string.IsNullOrEmpty(SettingCategory))
{
PerferenceUtility.CreateUserPreferenceCategoryIfNotExists(SettingCategory, "Search Control Name");
}
else
{
throw new Exception("Search control is not named");
}
GetSettings();
SaveSettings();
RaiseSearch();
}
private System.Data.DataTable GetData()
{
var data = new FieldConfigurationDataModel();
var dt = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public void CreateFCStandardModeEntries(string entityName)
{
fcModeId = GetFCModeId("Standard");
var entityDataModel = entityName + "DataModel";
var objDataModel = CreateClassInstance(entityDataModel);
if (objDataModel == null)
{
var objType = objDataModel.GetType();
var objProps = objType.GetProperties();
int i = 0;
foreach (var propInfo in objProps)
{
if (propInfo.DeclaringType.Name == entityDataModel)
{
var data = new FieldConfigurationDataModel();
data.Name = propInfo.Name;
CreateFCEntries(data, fcModeId, i, entityName);
i++;
}
}
}
}
protected override void ShowData(int fieldConfigurationId)
{
base.ShowData(fieldConfigurationId);
oDetailButtonPanel.SetId = SetId;
Clear();
var dataQuery = new FieldConfigurationDataModel();
dataQuery.FieldConfigurationId = fieldConfigurationId;
var entityList = FieldConfigurationDataManager.GetEntityDetails(dataQuery, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo);
if (entityList.Count == 1)
{
foreach (var entityItem in entityList)
{
lblFieldConfigurationId.Text = entityItem.FieldConfigurationId.ToString();
lblName.Text = entityItem.Name;
lblValue.Text = entityItem.Value;
lblSystemEntityTypeId.Text = entityItem.SystemEntityTypeId.ToString();
lblWidth.Text = entityItem.Width.ToString();
lblFormatting.Text = entityItem.Formatting;
lblControlType.Text = entityItem.ControlType;
lblHorizontalAlignment.Text = entityItem.HorizontalAlignment;
lblDisplayColumn.Text = entityItem.DisplayColumn.ToString();
lblCellCount.Text = entityItem.CellCount.ToString();
//oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction);
oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.FieldConfiguration, fieldConfigurationId, "FieldConfiguration");
}
}
}
public static List <FieldConfigurationDataModel> GetFieldConfigurationList(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FieldConfigurationSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.FieldConfigurationId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.SystemEntityTypeId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.DisplayColumn) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.Name);
var result = new List <FieldConfigurationDataModel>();
using (var reader = new DBDataReader("Get List", sql, DataStoreKey))
{
var dbReader = reader.DBReader;
while (dbReader.Read())
{
var dataItem = new FieldConfigurationDataModel();
dataItem.Name = dbReader[FieldConfigurationDataModel.DataColumns.Name].ToString();
dataItem.FieldConfigurationDisplayName = (string)dbReader[FieldConfigurationDataModel.DataColumns.FieldConfigurationDisplayName];
dataItem.Value = (string)dbReader[FieldConfigurationDataModel.DataColumns.Value];
result.Add(dataItem);
}
}
return(result);
}
public static DataTable Search(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
var table = list.ToDataTable();
return(table);
}
protected override DataTable GetEntityData(int?entityKey)
{
var fieldConfigurationdata = new FieldConfigurationDataModel();
fieldConfigurationdata.FieldConfigurationId = entityKey;
var results = FieldConfigurationDataManager.Search(fieldConfigurationdata, SessionVariables.RequestProfile);
return(results);
}
protected void SearchParametersRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var label = (Label)e.Item.FindControl("label");
var hdnfield = (HiddenField)e.Item.FindControl("hdnfield");
var txtbox = (TextBox)e.Item.FindControl("txtbox");
var txtbox1 = (TextBox)e.Item.FindControl("txtbox1");
var dropdownlist = (DropDownList)e.Item.FindControl("dropdownlist");
if (label != null && dropdownlist != null)
{
var name = hdnfield.Value;
var data = new FieldConfigurationDataModel();
data.Name = name;
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var dt = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count >= 1)
{
var controltype = dt.Rows[0]
[FieldConfigurationDataModel.DataColumns.ControlType].ToString();
if (controltype.Equals("TextBox"))
{
txtbox.Visible = true;
txtbox1.Visible = false;
dropdownlist.Visible = false;
}
else
if (controltype.Equals("DropDownList"))
{
txtbox.Visible = false;
txtbox1.Visible = true;
dropdownlist.Visible = true;
if (name.Equals("FunctionalityId"))
{
var functionalityData = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(functionalityData, dropdownlist,
StandardDataModel.StandardDataColumns.Name,
FunctionalityDataModel.DataColumns.FunctionalityId);
}
if (name.Equals("FunctionalityActiveStatusId"))
{
var FunctionalityActiveStatusData = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(FunctionalityActiveStatusData, dropdownlist,
StandardDataModel.StandardDataColumns.Name,
FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId);
}
dropdownlist.Items.Insert(0, new ListItem("All", "-1"));
dropdownlist.SelectedIndex = 0;
}
}
e.Item.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(name + "Visibility", SettingCategory);
}
}
}
private static DataSet GetChildren(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FieldConfigurationChildrenGet " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.FieldConfigurationId);
var oDT = new DBDataSet("Get Children", sql, DataStoreKey);
return(oDT.DBDataset);
}
public void EditableGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
var selectedrow = e.RowIndex.ToString();
var lbl = (Label)EditableGridView.Rows[e.RowIndex].Cells[2].FindControl("lblFieldConfigurationId");
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = int.Parse(lbl.Text);
FieldConfigurationDataManager.Delete(data, SessionVariables.AuditId);
BindData(ApplicationId);
}
protected void SearchParametersRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var label = (Label)e.Item.FindControl("label");
var hdnfield = (HiddenField)e.Item.FindControl("hdnfield");
var txtbox = (TextBox)e.Item.FindControl("txtbox");
var txtbox1 = (TextBox)e.Item.FindControl("txtbox1");
var dropdownlist = (DropDownList)e.Item.FindControl("dropdownlist");
if (label != null && txtbox != null && dropdownlist != null)
{
var name = hdnfield.Value;
var data = new FieldConfigurationDataModel();
data.Name = name;
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var dt = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count >= 1)
{
var controltype = dt.Rows[0]
[FieldConfigurationDataModel.DataColumns.ControlType].ToString();
if (controltype.Equals("TextBox"))
{
txtbox.Visible = true;
txtbox1.Visible = false;
dropdownlist.Visible = false;
}
else if (controltype.Equals("DropDownList"))
{
txtbox.Visible = false;
txtbox1.Visible = true;
dropdownlist.Visible = true;
if (name.Equals("ApplicationUserId"))
{
var applicationUserData = Framework.Components.ApplicationUser.ApplicationUserDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(applicationUserData, dropdownlist,
ApplicationUserDataModel.DataColumns.FullName,
ApplicationUserDataModel.DataColumns.ApplicationUserId);
}
if (name.Equals("UserPreferenceKeyId"))
{
var UserPreferenceKeyData = Framework.Components.UserPreference.UserPreferenceKeyDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(UserPreferenceKeyData, dropdownlist,
StandardDataModel.StandardDataColumns.Name,
UserPreferenceKeyDataModel.DataColumns.UserPreferenceKeyId);
}
}
}
e.Item.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(name + "Visibility", SettingCategory);
}
}
}
public JsonResult GetSearchFilterColumns()
{
var data = new FieldConfigurationDataModel();
data.SystemEntityTypeId = SystemEntity.DailyTaskItemQueueStatus.Value();
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var list = FieldConfigurationDataManager.GetEntityList(data, SessionVariables.AuditId);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSearchFilterColumns()
{
var data = new FieldConfigurationDataModel();
data.SystemEntityTypeId = SystemEntity.DailyTaskItemQueue.Value();
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var list = FieldConfigurationDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo);
list = list.OrderBy(item => item.GridViewPriority).ToList();
return Json(list, JsonRequestBehavior.AllowGet);
}
public JsonResult GetSearchFilterColumns()
{
var data = new FieldConfigurationDataModel();
data.SystemEntityTypeId = SystemEntity.FunctionalityXFunctionalityDevelopmentStep.Value();
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var list = FieldConfigurationDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public static DataTable CheckDefaultView(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.CheckDefaultViewList" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, data.ApplicationId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DataAccess.DBDataTable("CheckDefaultView", sql, DataStoreKey);
return(oDT.DBTable);
}
public void CreateFCEntries(FieldConfigurationDataModel data, int?fcModeId, int index, string entityName)
{
int?systemEntityTypeId = GetEntityTypeId(entityName);
var dataFC = new FieldConfigurationDataModel();
dataFC.SystemEntityTypeId = systemEntityTypeId;
dataFC.ApplicationId = Convert.ToInt32(ddlApplication.SelectedValue);
dataFC.FieldConfigurationDisplayName = data.Name;
dataFC.Name = data.Name;
dataFC.Value = data.Name;
dataFC.Formatting = "";
dataFC.ControlType = "TextBox";
dataFC.GridViewPriority = index;
dataFC.DetailsViewPriority = index;
dataFC.FieldConfigurationModeId = fcModeId;
dataFC.DisplayColumn = 1;
dataFC.CellCount = 3;
if (data.Width == null)
{
dataFC.Width = 50;
}
else
{
dataFC.Width = data.Width;
}
if (!string.IsNullOrEmpty(data.HorizontalAlignment))
{
dataFC.HorizontalAlignment = data.HorizontalAlignment;
}
else
{
dataFC.HorizontalAlignment = "Left";
}
var dtFC = FieldConfigurationDataManager.DoesExist(dataFC, SessionVariables.RequestProfile);
if (dtFC.Rows.Count == 0)
{
dataFC.FieldConfigurationId = FieldConfigurationDataManager.Create(dataFC, SessionVariables.RequestProfile);
var dataDisplayName = new FieldConfigurationDisplayNameDataModel();
dataDisplayName.FieldConfigurationId = dataFC.FieldConfigurationId;
dataDisplayName.Value = data.Name;
dataDisplayName.LanguageId = ApplicationCommon.LanguageId;
dataDisplayName.IsDefault = 1;
FieldConfigurationDisplayNameDataManager.Create(dataDisplayName, SessionVariables.RequestProfile);
}
}
private System.Data.DataTable GetData(string name)
{
// basic list -- no longer needed as Search will be more robust and powerfull
//var dt = Shared.Components.BusinessLayer.Project.GetList(SessionVariables.RequestProfile);
// List given search parameters
var data = new FieldConfigurationDataModel();
var dt = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
public static bool DoesExist(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var doesExistRequest = new FieldConfigurationDataModel();
doesExistRequest.Name = data.Name;
doesExistRequest.FieldConfigurationModeId = data.FieldConfigurationModeId;
doesExistRequest.SystemEntityTypeId = data.SystemEntityTypeId;
doesExistRequest.ApplicationId = requestProfile.ApplicationId;
var list = GetEntityDetails(doesExistRequest, requestProfile, 0);
return(list.Count > 0);
}
public override int?Save(string action)
{
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = FieldConfigurationId;
data.SystemEntityTypeId = SystemEntityTypeId;
data.ApplicationId = ApplicationId;
data.FieldConfigurationDisplayName = DisplayName;
data.Name = Name;
data.Value = Value;
data.Width = Width;
data.Formatting = Formatting;
data.ControlType = ControlType;
data.HorizontalAlignment = HorizontalAlignment;
data.GridViewPriority = GridViewPriority;
data.DetailsViewPriority = DetailsViewPriority;
data.FieldConfigurationModeId = FieldConfigurationModeId;
data.DisplayColumn = DisplayColumn;
data.CellCount = CellCount;
if (action == "Insert")
{
var dtFieldConfiguration = FieldConfigurationDataManager.DoesExist(data, SessionVariables.RequestProfile);
if (dtFieldConfiguration.Rows.Count == 0)
{
data.FieldConfigurationId = FieldConfigurationDataManager.Create(data, SessionVariables.RequestProfile);
var dataDisplayName = new FieldConfigurationDisplayNameDataModel();
dataDisplayName.FieldConfigurationId = data.FieldConfigurationId;
dataDisplayName.Value = DisplayName;
dataDisplayName.LanguageId = ApplicationCommon.LanguageId;
dataDisplayName.IsDefault = 1;
FieldConfigurationDisplayNameDataManager.Create(dataDisplayName, SessionVariables.RequestProfile);
}
else
{
throw new Exception("Unique Combination already exists.");
}
}
else
{
FieldConfigurationDataManager.Update(data, SessionVariables.RequestProfile);
}
FieldConfigurationUtility.SetFieldConfigurations();
// not correct ... when doing insert, we didn't get/change the value of FieldConfigurationId ?
return(data.FieldConfigurationId);
}
private DataTable GetGridFormatSettings()
{
var entityId = GetSystemEntityTypeId();
var auditId = SessionVariables.RequestProfile.AuditId;
var dtGridFormat = new FieldConfigurationDataModel();
dtGridFormat.SystemEntityTypeId = entityId;
var gridFormatdt = FieldConfigurationDataManager.Search(dtGridFormat, SessionVariables.RequestProfile);
return(gridFormatdt);
//var validColumns = _getColumnDelegate();
}
public IEnumerable <FieldConfigurationDataModel> GetGroupByList(string value)
{
var entityName = value;
var systemEntityTypeId = (SystemEntity)Enum.Parse(typeof(SystemEntity), entityName, true);
var result = new List <FieldConfigurationDataModel>();
var data = new FieldConfigurationDataModel();
data.SystemEntityTypeId = (int)systemEntityTypeId;
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var items = FieldConfigurationDataManager.GetFieldConfigurationList(data, SessionVariables.RequestProfile);
var LstGroupByItems = new List <string>();
// method used to get the list of items not required to be bound to the GroupBy dropdownlist
if (entityName == "ReleaseLogDetail")
{
for (var i = 0; i < items.Count(); i++)
{
var item = items[i];
if (item.Name.Equals("UpdatedRange"))
{
LstGroupByItems.Add(item.Name);
}
}
}
var oData = new FieldConfigurationDataModel();
oData.FieldConfigurationDisplayName = "None";
oData.Name = "-1";
result.Add(oData);
foreach (var item in items)
{
if (!item.Name.Contains("GroupBy") && !LstGroupByItems.Contains(item.Name))
{
oData = new FieldConfigurationDataModel();
oData.Name = item.Name.ToString();
oData.FieldConfigurationDisplayName = item.FieldConfigurationDisplayName;
result.Add(oData);
}
}
return(result.OrderBy(o => o.Name).ToList());
}
private DataTable GetApplicableModesList(int systemEntityTypeId)
{
var data = new FieldConfigurationDataModel();
data.SystemEntityTypeId = systemEntityTypeId;
var columns = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
var modes = FieldConfigurationModeDataManager.GetList(SessionVariables.RequestProfile);
var validModes = new DataTable();
validModes = modes.Clone();
for (var j = 0; j < modes.Rows.Count; j++)
{
for (var i = 0; i < columns.Rows.Count; i++)
{
if (
int.Parse(
columns.Rows[i][
FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId].
ToString()) ==
int.Parse(
modes.Rows[j][
FieldConfigurationModeDataModel.DataColumns.
FieldConfigurationModeId].ToString())
)
{
var temp = validModes.Select("FieldConfigurationModeId = " + int.Parse(
modes.Rows[j][
FieldConfigurationModeDataModel.DataColumns.
FieldConfigurationModeId].ToString()));
if (temp.Length == 0)
{
validModes.ImportRow(modes.Rows[j]);
}
}
}
}
var dv = validModes.DefaultView;
dv.Sort = "SortOrder ASC";
var sortedValidModes = dv.ToTable();
return(sortedValidModes);
}
public static void Delete(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
const string sql = @"dbo.FieldConfigurationDelete ";
var parameters = new
{
AuditId = requestProfile.AuditId
,
FieldConfigurationId = data.FieldConfigurationId
};
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure);
}
}
private void DataBind()
{
var data = new FieldConfigurationDataModel();
data.FieldConfigurationModeId = GetFCModeId(ddlView.SelectedValue);
data.ApplicationId = Convert.ToInt32(ApplicationId);
var dt = FieldConfigurationDataManager.CheckDefaultView(data, SessionVariables.RequestProfile);
var GroupByField = drpGroupBy.SelectedValue;
var tabControl = ApplicationCommon.GetNewDetailTabControl();
var distinctTabNames = (from row in dt.AsEnumerable()
orderby row[GroupByField].ToString().Trim()
select row[GroupByField].ToString().Trim())
.Distinct(StringComparer.CurrentCultureIgnoreCase).ToList();
foreach (var tabName in distinctTabNames)
{
var dtGroupingResult = dt.AsEnumerable().Where(t => t[GroupByField].ToString() == tabName).CopyToDataTable();
var totalRecordsInTab = dtGroupingResult.Rows.Count;
var groupHeader = tabName;
var strHeader = groupHeader + " (" + totalRecordsInTab.ToString(CultureInfo.InvariantCulture) + ")";
if (tabName == "True")
{
chkListDataWithview.DataSource = dtGroupingResult;
chkListDataWithview.DataTextField = "EntityName";
chkListDataWithview.DataValueField = "EntityName";
chkListDataWithview.DataBind();
lblWithView.Text = strHeader;
}
else
{
chkListData.DataSource = dtGroupingResult;
chkListData.DataTextField = "EntityName";
chkListData.DataValueField = "EntityName";
chkListData.DataBind();
lblView.Text = strHeader;
}
}
}
public static string[] GetDetailsViewColumns(int systemEntityTypeId, int auditId)
{
var obj = new FieldConfigurationDataModel();
obj.SystemEntityTypeId = systemEntityTypeId;
var odt = FieldConfigurationDataManager.GetDetailsViewColumns(obj, SessionVariables.RequestProfile);
var validColumns = new string[odt.Rows.Count];
for (var i = 0; i < odt.Rows.Count; i++)
{
validColumns[i] = odt.Rows[i][FieldConfigurationDataModel.DataColumns.Name].ToString();
}
return(validColumns);
}
public static bool IsDeletable(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var isDeletable = true;
var ds = GetChildren(data, requestProfile);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataTable dt in ds.Tables)
{
if (dt.Rows.Count > 0)
{
isDeletable = false;
break;
}
}
}
return(isDeletable);
}
