public void TestUpdateDataPointDB01() { OPCSampleGrpConfigStartModel oPCSampleGrpConfigStartModel = OPCSampleGrpConfigStartModelFactory.CreateOPCSampleGrpConfigStartModel01(); double sampleGrpID = double.MinValue; oPCSampleGrpConfigStartModel.UpdateDataPointDB(sampleGrpID); //Test2---Valid input #region TestSetup //insert testing group EtyDataLogDPGroupTrend etySampleGrp = new EtyDataLogDPGroupTrend(); etySampleGrp.NewData = true; etySampleGrp.SampleGrpName = "DOTTestParasoftTesting123"; etySampleGrp.Interval = 1; etySampleGrp.IntervalType = "M"; etySampleGrp.Disabled = false; oPCSampleGrpConfigStartModel.InsertOPCSampleGrp(etySampleGrp); //getSampleId from DB List <EtyDataLogDPGroupTrend> list = oPCSampleGrpConfigStartModel.GetAllOPCSampelGrp(OPCSampleGrpConfigStart.OPCSAMPLEGRPDESC_COL_NAME, OPCSampleGrpConfigStart.OPCSAMPLEGRP_SORT_ASC); foreach (var item in list) { if (item.SampleGrpName.Equals("DOTTestParasoftTesting123")) { etySampleGrp = item; break; } } //insert testing Datapoint EtyDataLogDPTrend etyOPCDP = new EtyDataLogDPTrend(); etyOPCDP.OPCDataPointName = "DOTTestParasoftDP1.Value"; etyOPCDP.EntityKey = 20099999; etyOPCDP.OPCSampleGrpId = etySampleGrp.SampleGrpID; etyOPCDP.Disabled = false; DatalogDPTrendDAO.GetInstance().InsertOPCDataPoint(etyOPCDP); #endregion //Test Procedure Call oPCSampleGrpConfigStartModel.UpdateDataPointDB(etySampleGrp.SampleGrpID); //Post Condition Check #region PostConditionCheck bool bDisable = false; string sampleGrpIDstr = etySampleGrp.SampleGrpID.ToString(); //Get DataPoint from DB double sampleid = DatalogDPTrendDAO.GetInstance().GetGrpIDByDPName("DOTTestParasoftDP1.Value"); //Assert.IsTrue(bDisable); Assert.AreEqual(sampleid, -1); #endregion #region CleanUp //Clean up inserted test data in DB //Delete testing DP string localSQL = "Delete from OPC_DT_PT where DATA_PT_NAME = 'DOTTestParasoftDP1.Value'"; SimpleDatabase.GetInstance().ExecuteNonQuery(localSQL); //Delete Testing sampleGrp DatalogDPGroupTrendDAO.GetInstance().DeleteOPCSampleGroupById(etySampleGrp.SampleGrpID.ToString()); #endregion }
/// <summary> /// Returns all the Sample Group in the Database in ID_Name map format /// </summary> /// <returns>Sample Group IdToName map</returns> public Dictionary <string, string> GetSampleGrps() { Dictionary <string, string> opcSampleGrpDic = new Dictionary <string, string>(); Dictionary <string, string> opcDic = DatalogDPGroupTrendDAO.GetInstance().GetAllOPCGrpIdAndName(false); foreach (KeyValuePair <string, string> pair in opcDic) { if (!opcSampleGrpDic.ContainsKey(pair.Key)) { opcSampleGrpDic.Add(pair.Key, pair.Value); } } return(opcSampleGrpDic); }
/// <summary> /// /// </summary> /// <param name="dataPoint"></param> /// <returns></returns> public bool CheckConfiguredByOcc(string dataPoint) { bool bConfigured = false; double sampleGrpID = DatalogDPTrendDAO.GetInstance().GetGrpIDByDPName(dataPoint); if (sampleGrpID != -1) { EtyDataLogDPGroupTrend etySampleGrp = DatalogDPGroupTrendDAO.GetInstance().GetOPCGrpByID(sampleGrpID); if (etySampleGrp.LocationName.ToUpper() == DAOHelper.OCC_LOCATIONNAME) { bConfigured = true; } } return(bConfigured); }
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 }
/// <summary> /// Deletes Sample Group from the Database based on the ID. /// </summary> /// <param name="opcSampelGrpId"> Sample Group Id</param> public bool DeleteOPCSampleGrp(string opcSampelGrpId) { bool result = DatalogDPGroupTrendDAO.GetInstance().DeleteOPCSampleGroupById(opcSampelGrpId); return(result); }
/// <summary> /// Returns the total Count of the Sample Group in the Database. /// </summary> /// <returns>Total count</returns> public int GetOPCGrpCount() { return(DatalogDPGroupTrendDAO.GetInstance().GetRowCount()); }
/// <summary> /// Updates the value of the existing Sample Group in Database. /// </summary> /// <param name="etyOPCSampleGroup">Sample group entity with updated values</param> public void UpdateOPCSampleGrp(EtyDataLogDPGroupTrend etyOPCSampleGroup) { DatalogDPGroupTrendDAO.GetInstance().UpdateOPCGrpData(etyOPCSampleGroup); }
/// <summary> /// Returns all Sample Group Entity List which is sorted. /// </summary> /// <param name="sortCol"></param> /// <param name="sortingOrder"></param> /// <returns></returns> public List <EtyDataLogDPGroupTrend> GetAllOPCSampelGrp(string sortCol, string sortingOrder) { return(DatalogDPGroupTrendDAO.GetInstance().GetAllOPCGrpsBySort(sortCol, sortingOrder)); }
/// <summary> /// Returns the Sample Group Entity List which is sorted and indexed. /// </summary> /// <param name="sortCol">column used for sorting</param> /// <param name="sortingOrder">sorting order</param> /// <param name="lowerRecord">starting index</param> /// <param name="upperRecord">end index</param> /// <returns>Sample Groups Entity List</returns> public List <EtyDataLogDPGroupTrend> GetAllOPCSampelGrp(string sortCol, string sortingOrder, int lowerRecord, int upperRecord) { return(DatalogDPGroupTrendDAO.GetInstance().GetAllOPCGrpsBySortNPage(sortCol, sortingOrder, lowerRecord, upperRecord)); }
public void TestReleaseInstance01() { DatalogDPGroupTrendDAO.ReleaseInstance(); datalogDPGroupTrendDAO = DatalogDPGroupTrendDAO.GetInstance(); }
public void TestGetInstance01() { datalogDPGroupTrendDAO = DatalogDPGroupTrendDAO.GetInstance(); }