public void AddEmptyRecordTest() { DataTable dt = new DataTable("Table"); DataColumn dc = new DataColumn("Id", typeof(int)); dt.Columns.Add(dc); dc = new DataColumn("Name", typeof(string)); dt.Columns.Add(dc); DataRow newRow = dt.NewRow(); newRow["Id"] = 1; newRow["Name"] = "cici"; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow["Id"] = 2; newRow["Name"] = "mimi"; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow["Id"] = 3; newRow["Name"] = "lili"; dt.Rows.Add(newRow); DSUtils.AddEmptyRecord(dt); Assert.AreEqual(4, dt.Rows.Count); Assert.AreEqual(DBNull.Value, dt.Rows[0]["Name"]); Assert.AreEqual(-1, dt.Rows[0]["Id"]); }
private void LoadProgramsFiltered(int ownerId) { ProjectSelectorFilter projectSelectorFilter = new ProjectSelectorFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); projectSelectorFilter.IdAssociate = CurrentUser.IdAssociate; projectSelectorFilter.ShowOnly = cmbShowOnly.SelectedValue; projectSelectorFilter.OrderBy = rbOrderProjects.SelectedValue; //Fill the project combo box with the values corresponding to the selected owner projectSelectorFilter.IdOwner = ownerId; DataSet programsDS = projectSelectorFilter.SelectProcedure("SelectPrograms"); DSUtils.AddEmptyRecord(programsDS.Tables[0]); cmbPG.DataSource = programsDS; cmbPG.DataMember = programsDS.Tables[0].ToString(); cmbPG.DataValueField = "ProgramId"; cmbPG.DataTextField = "Name"; cmbPG.DataBind(); //reset the function lblFunction.Text = String.Empty; //reset additional labels lblActiveMembers.Text = String.Empty; lblTimingIntercoPercent.Text = String.Empty; lblInitialBudgetValidated.Text = String.Empty; }
public void SetDataSource(object[] attributes) { try { ReferenceMappingAttribute attribute = attributes[0] as ReferenceMappingAttribute; if (attribute == null) { throw new IndException(ApplicationMessages.EXCEPTION_WRONG_ATTRIBUTE_RECEIVED); } IGenericEntity referencedEntity = EntityFactory.GetEntityInstance(attribute.ReferencedEntity, SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.CONNECTION_MANAGER)); //Call the GetAll() method of the referenced object DataSet referencedDataSet = referencedEntity.GetAll(); DSUtils.AddEmptyRecord(referencedDataSet.Tables[0]); //Set the DataSource, DataMember, DataValueField and DataTextField of the combobox this.DataSource = referencedDataSet; this.DataMember = referencedDataSet.Tables[0].TableName; this.DataBind(); this.SelectedValue = ApplicationConstants.INT_NULL_VALUE.ToString(); } catch (IndException ex) { ControlHierarchyManager.ReportError(ex); return; } catch (Exception ex) { ControlHierarchyManager.ReportError(new IndException(ex)); return; } }
protected void cmbCt_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { try { Associate associate = new Associate(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); associate.IdCountry = int.Parse(cmbCt.SelectedValue); DataSet associateDataSet = associate.SelectActiveAssociates(); DSUtils.AddEmptyRecord(associateDataSet.Tables[0]); cmbAs.DataSource = associateDataSet; cmbAs.DataMember = associateDataSet.Tables[0].TableName; cmbAs.DataTextField = "Name"; cmbAs.DataValueField = "Id"; cmbAs.DataBind(); } catch (IndException ex) { ShowError(ex); return; } catch (Exception ex) { ShowError(new IndException(ex)); return; } }
public DataSet SelectProcedure(string spName) { DataSet ds; try { ds = this.GetEntity().GetCustomDataSet(spName.ToString(), this); DSUtils.AddEmptyRecord(ds.Tables[0]); } catch (Exception ex) { throw new IndException(ex); } return(ds); }
/// <summary> /// Gets all roles in the database (except Program manager and core team member) /// </summary> /// <returns>datatable containing information about all roles in the database</returns> public DataTable GetRoles() { DataTable rolesDataTable; try { rolesDataTable = dbProfile.GetRoles(); DSUtils.AddEmptyRecord(rolesDataTable); } catch (Exception ex) { throw new IndException(ex); } return(rolesDataTable); }
/// <summary> /// Gets all associates in the database /// </summary> /// <returns>datatable containing information about all associates in the database</returns> public DataTable GetAssociates() { DataTable associatesDataTable; try { associatesDataTable = dbProfile.GetAssociates(); DSUtils.AddEmptyRecord(associatesDataTable); } catch (Exception ex) { throw new IndException(ex); } return(associatesDataTable); }
private void LoadCostCenterCodeCombo() { CostCenter costCenter = new CostCenter(SessionManager.GetSessionValueNoRedirect(this.Page, SessionStrings.CONNECTION_MANAGER)); costCenter.IdInergyLocation = Int32.Parse(cmbInergyLocation.SelectedValue); DataSet ds = costCenter.GetAll(true); if (ds != null) { cmbCostCenter.Items.Clear(); DSUtils.AddEmptyRecord(ds.Tables[0]); cmbCostCenter.DataSource = ds; cmbCostCenter.DataMember = ds.Tables[0].TableName; cmbCostCenter.DataTextField = "Code"; cmbCostCenter.DataValueField = "Id"; cmbCostCenter.DataBind(); } }
private void LoadProgramsFiltered(int ownerId) { ProjectSelectorFilter projectSelectorFilter = new ProjectSelectorFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); projectSelectorFilter.IdOwner = ownerId; projectSelectorFilter.IdAssociate = currentUser.IdAssociate; projectSelectorFilter.ShowOnly = string.Empty; //it is not used projectSelectorFilter.IdProgram = -1; //all program DataSet programsDS = projectSelectorFilter.SelectProcedure("SelectPrograms"); DSUtils.AddEmptyRecord(programsDS.Tables[0], "ProgramId"); cmbProgram.DataSource = programsDS; cmbProgram.DataMember = programsDS.Tables[0].ToString(); cmbProgram.DataValueField = "ProgramId"; cmbProgram.DataTextField = "Name"; cmbProgram.DataBind(); }
private void LoadOwnersFiltered(int ownerId) { ProjectSelectorFilter projectSelectorFilter = new ProjectSelectorFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); projectSelectorFilter.IdAssociate = CurrentUser.IdAssociate; projectSelectorFilter.ShowOnly = cmbShowOnly.SelectedValue; projectSelectorFilter.OrderBy = rbOrderProjects.SelectedValue; //Fill the project combo box with the values corresponding to the selected owner projectSelectorFilter.IdOwner = ownerId; DataSet ownerDS = projectSelectorFilter.SelectProcedure("SelectOwners"); DSUtils.AddEmptyRecord(ownerDS.Tables[0]); cmbOW.DataSource = ownerDS; cmbOW.DataMember = ownerDS.Tables[0].ToString(); cmbOW.DataValueField = "OwnerId"; cmbOW.DataTextField = "Name"; cmbOW.DataBind(); }
/// <summary> /// Loads the countries of the users that have the given inergy login from the database /// </summary> private void LoadCountries() { if (Session[SessionStrings.INERGY_LOGIN] == null) { ClientScript.RegisterClientScriptBlock(this.GetType(), "SessionExpiredClose", "doReturn(-1);", true); return; } string inergyLogin = Session[SessionStrings.INERGY_LOGIN].ToString(); //Build a currentUser object only to get the countries of the user having the known inergy login (the inergy login is the only //information we know so far when opening this window when the application starts or after the session has expired) CurrentUser newCurrentUser = new CurrentUser(inergyLogin, Session[SessionStrings.CONNECTION_MANAGER]); DataTable tblCountries = newCurrentUser.GetUserCountries(); DSUtils.AddEmptyRecord(tblCountries); //Get the bool value indicating if the page is opened from user settings page or not bool isFromUserSettings = String.IsNullOrEmpty(HttpContext.Current.Request.QueryString["UserSettings"]) ? false : true; if (isFromUserSettings) { if (Session[SessionStrings.CURRENT_USER] == null) { ClientScript.RegisterClientScriptBlock(this.GetType(), "SessionExpiredClose", "doReturn(-1);", true); return; } tblCountries.PrimaryKey = new DataColumn[] { tblCountries.Columns["Id"] }; int currentCountryId = ((CurrentUser)Session[SessionStrings.CURRENT_USER]).IdCountry; DataRow currentCountryRow = tblCountries.Rows.Find(currentCountryId); tblCountries.Rows.Remove(currentCountryRow); } cmbCountries.DataSource = tblCountries; cmbCountries.DataValueField = "Id"; cmbCountries.DataTextField = "Name"; cmbCountries.DataBind(); }
private void PopulateControls() { Country country = new Country(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); DataSet countryDataSet = country.GetAll(); DSUtils.AddEmptyRecord(countryDataSet.Tables[0]); cmbCt.DataSource = countryDataSet; cmbCt.DataMember = countryDataSet.Tables[0].TableName; cmbCt.DataTextField = "Name"; cmbCt.DataValueField = "Id"; cmbCt.DataBind(); Associate associate = new Associate(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); DataSet associateDataSet = associate.SelectActiveAssociates(); DSUtils.AddEmptyRecord(associateDataSet.Tables[0]); cmbAs.DataSource = associateDataSet; cmbAs.DataMember = associateDataSet.Tables[0].TableName; cmbAs.DataTextField = "Name"; cmbAs.DataValueField = "Id"; cmbAs.DataBind(); }
private void LoadProjectsFiltered(int programId) { ProjectSelectorFilter projectSelectorFilter = new ProjectSelectorFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); if (!cmbOW.IsEmptyValueSelected()) { projectSelectorFilter.IdOwner = Int32.Parse(cmbOW.SelectedValue); } projectSelectorFilter.IdAssociate = CurrentUser.IdAssociate; projectSelectorFilter.ShowOnly = cmbShowOnly.SelectedValue; projectSelectorFilter.OrderBy = rbOrderProjects.SelectedValue; projectSelectorFilter.IdProgram = programId; DataSet projectDS = projectSelectorFilter.SelectProcedure("SelectProjects");; DSUtils.AddEmptyRecord(projectDS.Tables[0]); cmbPJ.DataSource = projectDS; cmbPJ.DataMember = projectDS.Tables[0].ToString(); cmbPJ.DataValueField = "ProjectId"; cmbPJ.DataTextField = "ProjectName"; cmbPJ.DataBind(); }
private void LoadProjectsFiltered(int programId) { ProjectSelectorFilter projectSelectorFilter = new ProjectSelectorFilter(SessionManager.GetSessionValueNoRedirect(this, SessionStrings.CONNECTION_MANAGER)); CurrentUser currentUser = (CurrentUser)SessionManager.GetSessionValueRedirect(this, SessionStrings.CURRENT_USER); if (!cmbProgram.IsEmptyValueSelected()) { projectSelectorFilter.IdProgram = Int32.Parse(cmbProgram.SelectedValue); } else { projectSelectorFilter.IdProgram = -1; } projectSelectorFilter.IdAssociate = currentUser.IdAssociate; DataSet projectDS = projectSelectorFilter.SelectProcedure("SelectProjects");; DSUtils.AddEmptyRecord(projectDS.Tables[0], "ProjectId"); cmbProject.DataSource = projectDS; cmbProject.DataMember = projectDS.Tables[0].ToString(); cmbProject.DataValueField = "ProjectId"; cmbProject.DataTextField = "ProjectName"; cmbProject.DataBind(); }