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
}
