public void TestChangeStrToBool01() { string str = string.Empty; bool b = DAOHelper.ChangeStrToBool(str); DAOHelper.ChangeStrToBool("Y"); }
public void TestUpdateOPCSampleGrp01() { OPCSampleGrpConfigStartModel oPCSampleGrpConfigStartModel = new OPCSampleGrpConfigStartModel(); //insert temp grp EtyDataLogDPGroupTrend etySampleGrp = new EtyDataLogDPGroupTrend(); etySampleGrp.SampleGrpName = "ParasoftTesting123"; etySampleGrp.SampleGrpDescription = "testing"; etySampleGrp.IntervalType = "S"; etySampleGrp.Interval = 23; etySampleGrp.DeltaValue = 1; etySampleGrp.Disabled = true; etySampleGrp.StartTime = "09:44"; etySampleGrp.NewData = true; oPCSampleGrpConfigStartModel.InsertOPCSampleGrp(etySampleGrp); //update the values etySampleGrp.IntervalType = "H"; etySampleGrp.Interval = 1; etySampleGrp.DeltaValue = 4; etySampleGrp.Disabled = false; etySampleGrp.StartTime = ""; //Test Procedure Call oPCSampleGrpConfigStartModel.UpdateOPCSampleGrp(etySampleGrp); //Post Condition Check #region PostConditionCheck //Check updation from DB try { string localSQL = "SELECT PKEY,NAME,DESCRIPTION,SAMPLE_INTERVAL,INTERVAL_TYPE,START_TIME,DELTA_VALUE,ENABLED FROM DATALOG_DP_GROUP_TREND where NAME ='" + etySampleGrp.SampleGrpName + "'"; System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL); if (drReader != null && drReader.Read()) { if (!drReader.IsDBNull(0)) { etySampleGrp.SampleGrpID = drReader.GetInt32(0); double Interval = drReader.GetInt32(3); Assert.AreEqual(Interval, etySampleGrp.Interval); string IntervalType = drReader.GetString(4).ToString(); Assert.AreEqual(etySampleGrp.IntervalType, IntervalType); string StartTime = drReader.GetString(5).ToString(); Assert.AreEqual(etySampleGrp.StartTime, StartTime); double DeltaValue = drReader.GetDouble(6); Assert.AreEqual(etySampleGrp.DeltaValue, DeltaValue); string disabled = drReader.GetString(7).ToString(); bool bdis = DAOHelper.ChangeStrToBool(disabled); Assert.AreEqual(etySampleGrp.Disabled, bdis); } } if (drReader != null) { drReader.Close(); drReader.Dispose(); } } catch (Exception localException) { //failed test } #endregion #region Cleanup //delete inserted temp group DatalogDPGroupTrendDAO.GetInstance().DeleteOPCSampleGroupById(etySampleGrp.SampleGrpID.ToString()); #endregion }