protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new NeedDataModel(); UpdatedData = NeedDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.NeedId = Convert.ToInt32(SelectedData.Rows[i][NeedDataModel.DataColumns.NeedId].ToString()); data.Name = SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Name].ToString(); data.Description = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description)) ? CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description) : SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Description].ToString(); data.SortOrder = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder).ToString()) : int.Parse(SelectedData.Rows[i][StandardDataModel.StandardDataColumns.SortOrder].ToString()); NeedDataManager.Update(data, SessionVariables.RequestProfile); data = new NeedDataModel(); data.NeedId = Convert.ToInt32(SelectedData.Rows[i][NeedDataModel.DataColumns.NeedId].ToString()); var dt = NeedDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
public void LoadData(int needId, bool showId) { Clear(); var data = new NeedDataModel(); data.NeedId = needId; var items = NeedDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count != 1) { return; } var item = items[0]; SetData(item); if (!showId) { SystemKeyId = item.NeedId; oHistoryList.Setup(PrimaryEntity, needId, PrimaryEntityKey); } else { CoreSystemKey.Text = String.Empty; } }
public override int?Save(string action) { var data = new NeedDataModel(); data.NeedId = SystemKeyId; data.Name = Name; data.Description = Description; data.SortOrder = SortOrder; if (action == "Insert") { var dtNeed = NeedDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtNeed.Rows.Count == 0) { NeedDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { NeedDataManager.Update(data, SessionVariables.RequestProfile); } return(data.NeedId); }
private DataTable GetData() { // TODO: on all export pages var data = new NeedDataModel(); var dt = NeedDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override DataTable GetEntityData(int?entityKey) { var needdata = new NeedDataModel(); needdata.NeedId = entityKey; var results = NeedDataManager.Search(needdata, SessionVariables.RequestProfile); return(results); }
protected override void Update(Dictionary <string, string> values) { var data = new NeedDataModel(); // copies properties from values dictionary object to data object PropertyMapper.CopyProperties(data, values); NeedDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
private void UpdateData(ArrayList values) { var data = new NeedDataModel(); data.NeedId = int.Parse(values[0].ToString()); data.Name = values[1].ToString(); data.Description = values[2].ToString(); data.SortOrder = int.Parse(values[3].ToString()); NeedDataManager.Update(data, SessionVariables.RequestProfile); ReBindEditableGrid(); }
private DataTable GetNeedData(int projectId) { var dt = ProjectXNeedDataManager.GetByProject(projectId, SessionVariables.RequestProfile.AuditId); var needdt = NeedDataManager.GetList(SessionVariables.RequestProfile); var resultdt = needdt.Clone(); foreach (DataRow row in dt.Rows) { var rows = needdt.Select("NeedId = " + row[NeedDataModel.DataColumns.NeedId]); resultdt.ImportRow(rows[0]); } return(resultdt); }
private int GetNextValidId(int tempId) { var dt = NeedDataManager.GetList(SessionVariables.RequestProfile); foreach (DataRow dr in dt.Rows) { if (dr[NeedDataModel.DataColumns.NeedId].ToString().Equals(tempId.ToString())) { tempId -= 1; return(GetNextValidId(tempId)); } } return(tempId); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new NeedDataModel(); data.NeedId = int.Parse(index); NeedDataManager.Delete(data, SessionVariables.RequestProfile); DeleteAndRedirect(); } } catch (Exception ex) { Response.Write(ex.Message); } }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var needdata = new NeedDataModel(); selectedrows = NeedDataManager.GetDetails(needdata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { needdata.NeedId = entityKey; var result = NeedDataManager.GetDetails(needdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { needdata.NeedId = SetId; var result = NeedDataManager.GetDetails(needdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
protected override void ShowData(int needId) { base.ShowData(needId); oDetailButtonPanel.SetId = SetId; Clear(); var data = new NeedDataModel(); data.NeedId = needId; var items = NeedDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; SetData(item); oHistoryList.Setup(PrimaryEntity, needId, "Need"); } }
private void ReBindEditableGrid() { var data = new NeedDataModel(); var dtNeed = NeedDataManager.Search(data, SessionVariables.RequestProfile); }
public virtual void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl) { DataTable dataSource = null; if (fieldName.Equals("FunctionalityId")) { dataSource = FunctionalityDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityDataModel.DataColumns.FunctionalityId); } else if (fieldName.Equals("ProjectId")) { dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, ProjectDataModel.DataColumns.ProjectId); } else if (fieldName.Equals("DeveloperRoleId")) { dataSource = DeveloperRoleDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, DeveloperRoleDataModel.DataColumns.DeveloperRoleId); } else if (fieldName.Equals("UseCaseId")) { dataSource = UseCaseDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, UseCaseDataModel.DataColumns.UseCaseId); } else if (fieldName.Equals("NeedId")) { dataSource = NeedDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, NeedDataModel.DataColumns.NeedId); } else if (fieldName.Equals("ProjectUseCaseStatusId")) { dataSource = ProjectUseCaseStatusDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, ProjectUseCaseStatusDataModel.DataColumns.ProjectUseCaseStatusId); } else if (fieldName.Equals("FeatureOwnerStatusId")) { dataSource = FeatureOwnerStatusDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FeatureOwnerStatusDataModel.DataColumns.FeatureOwnerStatusId); } else if (fieldName.Equals("EntityId")) { dataSource = Framework.Components.Core.SystemEntityTypeDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, DataModel.Framework.Core.SystemEntityTypeDataModel.DataColumns.SystemEntityTypeId); } else if (fieldName.Equals("ProjectId")) { dataSource = ProjectDataManager.GetList(SessionVariables.RequestProfile); UIHelper.LoadDropDown(dataSource, dropDownListControl, StandardDataModel.StandardDataColumns.Name, ProjectDataModel.DataColumns.ProjectId); } else if (fieldName.Equals("ApplicationId")) { var applicationData = ApplicationDataManager.GetList(SessionVariables.RequestProfile); var dv = applicationData.DefaultView; dv.Sort = "Name ASC"; UIHelper.LoadDropDown(dv.ToTable(), dropDownListControl, StandardDataModel.StandardDataColumns.Name, BaseDataModel.BaseDataColumns.ApplicationId); } else if (fieldName.Equals("FunctionalityOwner")) { var drData = FunctionalityOwnerDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); var originalList = new ArrayList(); var duplicateList = new ArrayList(); foreach (DataRow dtRow in drData.Rows) { if (originalList.Contains(dtRow["Developer"])) { duplicateList.Add(dtRow); } else { originalList.Add(dtRow["Developer"]); } } foreach (DataRow dtRow in duplicateList) { drData.Rows.Remove(dtRow); } UIHelper.LoadDropDown(drData, dropDownListControl, FunctionalityOwnerDataModel.DataColumns.Developer, FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId); } else if (fieldName.Equals("FunctionalityActiveStatus")) { var drData = FunctionalityActiveStatusDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityActiveStatusDataModel.DataColumns.FunctionalityActiveStatusId); } else if (fieldName.Equals("FunctionalityImage")) { var drData = FunctionalityImageDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, FunctionalityImageDataModel.DataColumns.Title, FunctionalityImageDataModel.DataColumns.FunctionalityImageId); } else if (fieldName.Equals("FunctionalityImageAttribute")) { var drData = FunctionalityImageAttributeDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, FunctionalityImageAttributeDataModel.DataColumns.FunctionalityImageAttributeId); } else if (fieldName.Equals("TabParentStructure")) { var drData = TabParentStructureDataManager.GetList(SessionVariables.RequestProfile); CommonSearchParameters(); UIHelper.LoadDropDown(drData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, TabParentStructureDataModel.DataColumns.TabParentStructureId); } }
protected override DataTable GetData() { var dt = NeedDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile); return(dt); }
private DataTable GetNeedList() { var dt = NeedDataManager.GetList(SessionVariables.RequestProfile); return(dt); }
protected override void OnInit(EventArgs e) { try { var superKey = ""; var newId = SystemEntityTypeDataManager.GetNextSequence("Need", (int)SystemEntity.Need, SessionVariables.RequestProfile); var Needdata = new NeedDataModel(); var systemdevdata = new SystemDevNumbersDataModel(); systemdevdata.ApplicationUserId = SessionVariables.RequestProfile.AuditId; var dtnumbers = SystemDevNumbersDataManager.Search(systemdevdata, SessionVariables.RequestProfile); var rangefrom = Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeFrom].ToString()); var rangeto = Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeTo].ToString()); if (Request.QueryString["SuperKey"] != null) { superKey = Request.QueryString["SuperKey"].ToString(); var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(superKey); data.SystemEntityTypeId = (int)SystemEntity.Need; var dt = SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); Needdata.NeedId = key; var Needdt = NeedDataManager.GetDetails(Needdata, SessionVariables.RequestProfile); if (Needdt.Rows.Count == 1) { var row = Needdt.Rows[0]; if (Request.QueryString["Mode"].ToString().Equals("Test")) { Needdata.NeedId = GetNextValidId(rangefrom); } Needdata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]); Needdata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]); Needdata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]); NeedDataManager.Create(Needdata, SessionVariables.RequestProfile); } } } } else if (Request.QueryString["SetId"] != null) { var key = int.Parse(Request.QueryString["SetId"]); Needdata.NeedId = key; var Needdt = NeedDataManager.GetDetails(Needdata, SessionVariables.RequestProfile); if (Needdt.Rows.Count == 1) { var row = Needdt.Rows[0]; var newNeeddata = new NeedDataModel(); if (Request.QueryString["Mode"].ToString().Equals("Test")) { newNeeddata.NeedId = newId = (int)GetNextValidId(rangefrom); } newNeeddata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]); newNeeddata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]); newNeeddata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]); UpdatedFKDepenedencies(key, newId); NeedDataManager.Delete(Needdata, SessionVariables.RequestProfile); NeedDataManager.Create(newNeeddata, SessionVariables.RequestProfile); } } else if (Request.QueryString["Mode"].ToString().Equals("Renumber")) { var seed = int.Parse(Request.QueryString["Seed"].ToString()); //ApplicationVariables.Seed; var increment = int.Parse(Request.QueryString["Increment"].ToString()); //ApplicationVariables.Increment; NeedDataManager.Renumber(seed, increment, SessionVariables.RequestProfile); } base.OnInit(e); Response.Redirect("Default.aspx?Added=true", false); } catch (Exception ex) { Response.Write(ex.Message); } }