public void ReplaceBooleanColumnTest() { DataSet ds = new DataSet(); DataTable dt = new DataTable("Table"); DataColumn dc = new DataColumn("BoolColumn", typeof(bool)); dt.Columns.Add(dc); ds.Tables.Add(dt); DataRow newRow = dt.NewRow(); newRow["BoolColumn"] = true; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow["BoolColumn"] = true; dt.Rows.Add(newRow); newRow = dt.NewRow(); newRow["BoolColumn"] = false; dt.Rows.Add(newRow); DataSet newDs = DSUtils.ReplaceBooleanColumn("BoolColumn", ds, 0); Assert.AreEqual(1, newDs.Tables.Count); Assert.AreEqual("Table", newDs.Tables[0].TableName); Assert.AreEqual(2, newDs.Tables[0].Columns.Count); Assert.AreEqual("BoolColumn", newDs.Tables[0].Columns[0].ColumnName); Assert.AreEqual(3, newDs.Tables[0].Rows.Count); Assert.AreEqual("Yes", newDs.Tables[0].Rows[0]["BoolColumn"]); Assert.AreEqual("Yes", newDs.Tables[0].Rows[1]["BoolColumn"]); Assert.AreEqual("No", newDs.Tables[0].Rows[2]["BoolColumn"]); }
protected override DataSet PostGetEntities(DataSet ds) { DSUtils.ReplaceBooleanColumn("IsActive", ds, 0); DataColumn newStartDate = new DataColumn("Start Date", typeof(string)); DataColumn newEndDate = new DataColumn("End Date", typeof(string)); DataColumn newProjectCodeName = new DataColumn("Project", typeof(string)); int oldStartDatePosition = ds.Tables[0].Columns["StartYearMonth"].Ordinal; int oldEndDatePosition = ds.Tables[0].Columns["EndYearMonth"].Ordinal; ds.Tables[0].Columns.Add(newStartDate); newStartDate.SetOrdinal(oldStartDatePosition); ds.Tables[0].Columns.Add(newEndDate); newEndDate.SetOrdinal(oldEndDatePosition); //move old YearMonth columns to the end - since they will be hidded DataColumn startYearMonthColumn = ds.Tables[0].Columns["StartYearMonth"]; DataColumn endYearMonthColumn = ds.Tables[0].Columns["EndYearMonth"]; startYearMonthColumn.SetOrdinal(ds.Tables[0].Columns.Count - 1); endYearMonthColumn.SetOrdinal(ds.Tables[0].Columns.Count - 1); ds.Tables[0].Columns.Add(newProjectCodeName); //transform the null values for StartYearMonth and EndYearMonth foreach (DataRow row in ds.Tables[0].Rows) { int startYearMonth = (row["StartYearMonth"] == DBNull.Value) ? ApplicationConstants.INT_NULL_VALUE : (int)row["StartYearMonth"]; int endYearMonth = (row["EndYearMonth"] == DBNull.Value) ? ApplicationConstants.INT_NULL_VALUE : (int)row["EndYearMonth"]; //Get the startyearmonth value if (startYearMonth == ApplicationConstants.INT_NULL_VALUE) { row["Start Date"] = String.Empty; } else { row["Start Date"] = DateTimeUtils.GetDateFromYearMonth(startYearMonth); } //Get the endyearmonth value if (endYearMonth == ApplicationConstants.INT_NULL_VALUE) { row["End Date"] = String.Empty; } else { row["End Date"] = DateTimeUtils.GetDateFromYearMonth(endYearMonth); } } return(ds); }
protected override DataSet PostGetEntities(DataSet ds) { DSUtils.ReplaceBooleanColumn("IsActive", ds, 0); DSUtils.ReplaceBooleanColumn("IsInitialBudgetValidated", ds, 0); DataColumn newProjectCodeName = new DataColumn("CodeName", typeof(string)); ds.Tables[0].Columns.Add(newProjectCodeName); //transform the null values for StartYearMonth and EndYearMonth foreach (DataRow row in ds.Tables[0].Rows) { //Set column Project row["CodeName"] = row["Code"] + " - " + row["Name"]; } return(ds); }
protected override DataSet PostGetEntities(DataSet ds) { DSUtils.ReplaceBooleanColumn("IsActive", ds, 0); return(ds); }