private System.Data.DataTable GetData()
{
var data = new FieldConfigurationDataModel();
var dt = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
return(dt);
}
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();
}
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");
}
}
}
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 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);
}
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);
}
}
}
protected override DataTable GetEntityData(int?entityKey)
{
var fieldConfigurationdata = new FieldConfigurationDataModel();
fieldConfigurationdata.FieldConfigurationId = entityKey;
var results = FieldConfigurationDataManager.Search(fieldConfigurationdata, SessionVariables.RequestProfile);
return(results);
}
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);
}
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);
}
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.FunctionalityXFunctionalityDevelopmentStep.Value();
data.FieldConfigurationModeId = SessionVariables.SearchControlColumnsModeId;
var list = FieldConfigurationDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo);
return(Json(list, JsonRequestBehavior.AllowGet));
}
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 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);
}
}
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);
}
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);
}
protected override void Update(Dictionary <string, string> values)
{
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = int.Parse(values[FieldConfigurationDataModel.DataColumns.FieldConfigurationId].ToString());
data.FieldConfigurationModeId = int.Parse(values[FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId].ToString());
data.Name = values[FieldConfigurationDataModel.DataColumns.Name].ToString();
data.Value = values[FieldConfigurationDataModel.DataColumns.Value].ToString();
data.HorizontalAlignment = values[FieldConfigurationDataModel.DataColumns.HorizontalAlignment].ToString();
data.Formatting = values[FieldConfigurationDataModel.DataColumns.Formatting].ToString();
data.GridViewPriority = int.Parse(values[FieldConfigurationDataModel.DataColumns.GridViewPriority].ToString());
data.DetailsViewPriority = int.Parse(values[FieldConfigurationDataModel.DataColumns.DetailsViewPriority].ToString());
data.SystemEntityTypeId = int.Parse(values[FieldConfigurationDataModel.DataColumns.SystemEntityTypeId].ToString());
data.DisplayColumn = int.Parse(values[FieldConfigurationDataModel.DataColumns.DisplayColumn].ToString());
FieldConfigurationDataManager.Update(data, SessionVariables.RequestProfile);
base.Update(values);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var data = new FieldConfigurationDataModel();
var modedt = FieldConfigurationModeDataManager.GetList(SessionVariables.RequestProfile);
var rows = modedt.Select("Name = 'CommonEditable'");
if (rows.Length == 1)
{
data.FieldConfigurationModeId =
int.Parse(rows[0][FieldConfigurationModeDataModel.DataColumns.FieldConfigurationModeId].ToString());
}
data.SystemEntityTypeId = (int)Enum.Parse(typeof(SystemEntity), EntityName);
Columns = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
repUpdate.DataSource = Columns;
repUpdate.DataBind();
}
}
public static Dictionary <string, string> GetLabelDictonaryObject(int systemEntityTypeId, int auditId)
{
var validColumns = new Dictionary <string, string>();
var obj = new FieldConfigurationDataModel();
obj.SystemEntityTypeId = systemEntityTypeId;
var odt = FieldConfigurationDataManager.GetDetailsViewColumns(obj, SessionVariables.RequestProfile);
for (var i = 0; i < odt.Rows.Count; i++)
{
var key = Convert.ToString(odt.Rows[i][FieldConfigurationDataModel.DataColumns.Name]);
var value = Convert.ToString(odt.Rows[i][FieldConfigurationDataModel.DataColumns.Value]);
if (!validColumns.ContainsKey(key))
{
validColumns.Add(key, value);
}
}
return(validColumns);
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var fieldConfigurationdata = new FieldConfigurationDataModel();
selectedrows = FieldConfigurationDataManager.GetDetails(fieldConfigurationdata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
fieldConfigurationdata.FieldConfigurationId = entityKey;
var result = FieldConfigurationDataManager.GetDetails(fieldConfigurationdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
fieldConfigurationdata.FieldConfigurationId = SetId;
var result = FieldConfigurationDataManager.GetDetails(fieldConfigurationdata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new FieldConfigurationDataModel();
UpdatedData = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.FieldConfigurationId =
Convert.ToInt32(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.FieldConfigurationId].ToString());
data.Name = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.Name))
? CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.Name).ToString()
: SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.Name].ToString();
data.Value =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.Value))
? CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.Value).ToString()
: SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.Value].ToString();
data.ControlType =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.ControlType))
? CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.ControlType).ToString()
: SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.ControlType].ToString();
data.Formatting =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.Formatting))
? CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.Formatting).ToString()
: SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.Formatting].ToString();
data.HorizontalAlignment =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.HorizontalAlignment))
? CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.HorizontalAlignment).ToString()
: SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.HorizontalAlignment].ToString();
data.FieldConfigurationModeId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId).ToString())
: int.Parse(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId].ToString());
data.SystemEntityTypeId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.SystemEntityTypeId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.SystemEntityTypeId).ToString())
: int.Parse(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.SystemEntityTypeId].ToString());
data.GridViewPriority =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.GridViewPriority))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.GridViewPriority).ToString())
: int.Parse(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.GridViewPriority].ToString());
data.DetailsViewPriority =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.DetailsViewPriority))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.DetailsViewPriority).ToString())
: int.Parse(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.DetailsViewPriority].ToString());
data.DisplayColumn =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.DisplayColumn))
? int.Parse(CheckAndGetRepeaterTextBoxValue(FieldConfigurationDataModel.DataColumns.DisplayColumn).ToString())
: int.Parse(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.DisplayColumn].ToString());
FieldConfigurationDataManager.Update(data, SessionVariables.RequestProfile);
data = new FieldConfigurationDataModel();
data.FieldConfigurationId = Convert.ToInt32(SelectedData.Rows[i][FieldConfigurationDataModel.DataColumns.FieldConfigurationId].ToString());
var dt = FieldConfigurationDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
private void UpdateData()
{
if (rbtnList.SelectedValue.Equals("GridView"))
{
foreach (GridViewRow row in EditableGridView.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
var data = new FieldConfigurationDataModel();
var lblFieldConfigurationId = (Label)row.FindControl("lblFieldConfigurationId");
var txtName = (TextBox)row.FindControl("txtName");
var txtValue = (TextBox)row.FindControl("txtValue");
var txtWidth = (TextBox)row.FindControl("txtWidth");
var txtHorizontalAlignment = (TextBox)row.FindControl("txtHorizontalAlignment");
var txtFormatting = (TextBox)row.FindControl("txtFormatting");
var txtControlType = (TextBox)row.FindControl("txtControlType");
var txtGridViewPriority = (TextBox)row.FindControl("txtGridViewPriority");
var txtDetailsViewPriority = (TextBox)row.FindControl("txtDetailsViewPriority");
var txtAEFLModeId = (TextBox)row.FindControl("txtFieldConfigurationModeId");
try
{
data.FieldConfigurationId = int.Parse(lblFieldConfigurationId.Text);
data.Name = txtName.Text;
data.Value = txtValue.Text;
data.Width = decimal.Parse(txtWidth.Text);
data.SystemEntityTypeId = SystemEntityTypeId;
data.Formatting = txtFormatting.Text;
data.ControlType = txtControlType.Text;
data.HorizontalAlignment = txtHorizontalAlignment.Text;
data.GridViewPriority = int.Parse(txtGridViewPriority.Text);
data.DetailsViewPriority = int.Parse(txtDetailsViewPriority.Text);
data.FieldConfigurationModeId = int.Parse(txtAEFLModeId.Text);
FieldConfigurationDataManager.Update(data, AuditId);
}
catch (Exception)
{
continue;
}
}
}
EditableGridView.Visible = false;
ReadOnlyGridView.Visible = true;
}
else
{
foreach (RepeaterItem item in EditableRepeater.Items)
{
var data = new FieldConfigurationDataModel();
var hdnFieldConfigurationId = (HiddenField)item.FindControl("hdnFieldConfigurationId");
var txtName = (TextBox)item.FindControl("txtName");
var txtValue = (TextBox)item.FindControl("txtValue");
var txtWidth = (TextBox)item.FindControl("txtWidth");
var txtHorizontalAlignment = (TextBox)item.FindControl("txtHorizontalAlignment");
var txtFormatting = (TextBox)item.FindControl("txtFormatting");
var txtControlType = (TextBox)item.FindControl("txtControlType");
var txtGridViewPriority = (TextBox)item.FindControl("txtGridViewPriority");
var txtDetailsViewPriority = (TextBox)item.FindControl("txtDetailsViewPriority");
var txtAEFLModeId = (TextBox)item.FindControl("txtAEFLModeId");
try
{
data.FieldConfigurationId = int.Parse(hdnFieldConfigurationId.Value);
data.Name = txtName.Text;
data.Value = txtValue.Text;
data.Width = decimal.Parse(txtWidth.Text);
data.SystemEntityTypeId = SystemEntityTypeId;
data.Formatting = txtFormatting.Text;
data.ControlType = txtControlType.Text;
data.HorizontalAlignment = txtHorizontalAlignment.Text;
data.GridViewPriority = int.Parse(txtGridViewPriority.Text);
data.DetailsViewPriority = int.Parse(txtDetailsViewPriority.Text);
data.FieldConfigurationModeId = int.Parse(txtAEFLModeId.Text);
FieldConfigurationDataManager.Update(data, AuditId);
}
catch (Exception)
{
continue;
;
}
}
EditableRepeater.Visible = false;
ReadOnlyRepeater.Visible = true;
}
UpdateGridTableInCache(SystemEntityTypeId, AuditId);
BindData(ApplicationId);
btnEdit.Visible = true;
btnUpdate.Visible = false;
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
var notDeletableIds = new List <int>();
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = int.Parse(index);
if (!FieldConfigurationDataManager.IsDeletable(data, SessionVariables.RequestProfile))
{
notDeletableIds.Add(Convert.ToInt32(data.FieldConfigurationId));
}
}
if (notDeletableIds.Count == 0)
{
foreach (string index in deleteIndexList)
{
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = int.Parse(index);
FieldConfigurationDataManager.Delete(data, SessionVariables.RequestProfile);
}
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.FieldConfiguration, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("FieldConfigurationEntityRoute", new { Action = "Default", SetId = true }), false);
}
else
{
var msg = String.Empty;
foreach (var id in notDeletableIds)
{
if (!string.IsNullOrEmpty(msg))
{
msg += ", <br/>";
}
msg += "FieldConfigurationId: " + id + " has detail records";
var data = new FieldConfigurationDisplayNameDataModel();
data.FieldConfigurationId = id;
var dt = FieldConfigurationDisplayNameDataManager.Search(data, SessionVariables.RequestProfile, SessionVariables.ApplicationMode);
foreach (DataRow dr in dt.Rows)
{
var fcdnid = int.Parse(dr[FieldConfigurationDisplayNameDataModel.DataColumns.FieldConfigurationDisplayNameId].ToString());
data.FieldConfigurationDisplayNameId = fcdnid;
FieldConfigurationDisplayNameDataManager.Delete(data, SessionVariables.RequestProfile);
}
var fcdata = new FieldConfigurationDataModel();
fcdata.FieldConfigurationId = id;
FieldConfigurationDataManager.Delete(fcdata, SessionVariables.RequestProfile);
Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(id.ToString(), (int)Framework.Components.DataAccess.SystemEntity.FieldConfiguration, SessionVariables.RequestProfile);
Response.Redirect(Page.GetRouteUrl("FieldConfigurationEntityRoute", new { Action = "Default", SetId = true }), false);
}
Response.Write(msg);
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected override System.Data.DataTable GetData()
{
var dt = FieldConfigurationDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
return(dt);
}
public void LoadData(int fieldConfigurationId, bool showId)
{
// clear UI
Clear();
// set up parameters
var data = new FieldConfigurationDataModel();
data.FieldConfigurationId = fieldConfigurationId;
// get data
var items = FieldConfigurationDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo);
// should only have single match
if (items.Count != 1)
{
return;
}
var item = items[0];
txtFieldConfigurationId.Text = item.FieldConfigurationId.ToString();
txtName.Text = item.Name;
txtApplication.Text = item.ApplicationId.ToString();
txtSystemEntityTypeId.Text = item.SystemEntityTypeId.ToString();
drpSystemEntityTypeList.SelectedValue = item.SystemEntityTypeId.ToString();
txtDisplayName.Text = item.FieldConfigurationDisplayName;
txtName.Text = item.Name;
txtValue.InnerText = item.Value;
txtWidth.Text = item.Width.ToString();
txtFormatting.Text = item.Formatting;
txtControlType.Text = item.ControlType;
txtHorizontalAlignment.Text = item.HorizontalAlignment;
txtGridViewPriority.Text = item.GridViewPriority.ToString();
txtDetailsViewPriority.Text = item.DetailsViewPriority.ToString();
ddlFieldConfigurationMode.SelectedValue = item.FieldConfigurationModeId.ToString();
txtFieldConfigurationMode.Text = item.FieldConfigurationModeId.ToString();
txtDisplayColumn.Text = item.DisplayColumn.ToString();
txtCellCount.Text = item.CellCount.ToString();
var applicationData = new ApplicationDataModel();
applicationData.ApplicationId = item.ApplicationId;
var appDatas = ApplicationDataManager.GetDetails(applicationData, SessionVariables.RequestProfile);
//drpApplicationList.SelectedValue = appDatas.Rows[0][ApplicationDataModel.DataColumns.Name].ToString();
if (!showId)
{
txtFieldConfigurationId.Text = item.FieldConfigurationId.ToString();
txtDisplayName.Enabled = false;
//PlaceHolderAuditHistory.Visible = true;
// only show Audit History in case of Update page, not for Clone.
oHistoryList.Setup(PrimaryEntity, fieldConfigurationId, PrimaryEntityKey);
}
else
{
txtFieldConfigurationId.Text = String.Empty;
}
//oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction);
}
