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); }