DP44/DataPRO/Modules/DatabaseImporter/DatabaseImport/ISO/TestEngineerDetails.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using DTS.Common.Interface.TestMetaData;

namespace DatabaseImport.ISO
{
    [Serializable()]
    public class TestEngineerDetails //: ISerializableFile
    {
        private string _testEngineerName = "NOVALUE";
        public string TestEngineerName
        {
            get => _testEngineerName;
            set
            {
                if (value != string.Empty)
                {
                    _testEngineerName = value;
                }
            }
        }

        private string _testEngineerPhone = "NOVALUE";
        public string TestEngineerPhone
        {
            get => _testEngineerPhone;
            set
            {
                if (value != string.Empty)
                {
                    _testEngineerPhone = value;
                }
            }
        }

        private string _testEngineerFax = "NOVALUE";
        public string TestEngineerFax
        {
            get => _testEngineerFax;
            set
            {
                if (value != string.Empty)
                {
                    _testEngineerFax = value;
                }
            }
        }

        private string _testEngineerEmail = "NOVALUE";
        public string TestEngineerEmail
        {
            get => _testEngineerEmail;
            set
            {
                if (value != string.Empty)
                {
                    _testEngineerEmail = value;
                }
            }
        }

        public bool LocalOnly { get; set; } = false;

        public string Name { get; set; } = "";

        public DateTime LastModified { get; set; }

        public string LastModifiedBy { get; set; }
        public int Version { get; set; } = 1;

        public TestEngineerDetails()
        {
        }

        public TestEngineerDetails(DataRow dr)
        {
            Name = (string)dr["Name"];
            TestEngineerName = (string)dr["TestEngineerName"];
            TestEngineerPhone = (string)dr["TestEngineerPhone"];
            TestEngineerFax = (string)dr["TestEngineerFax"];
            TestEngineerEmail = (string)dr["TestEngineerEmail"];
            LocalOnly = Convert.ToBoolean(dr["LocalOnly"]);
            LastModified = Convert.ToDateTime(dr["LastModified"]);
            LastModifiedBy = (string)dr["LastModifiedBy"];
            Version = Convert.ToInt32(dr["Version"]);
        }
        public TestEngineerDetails(TestEngineerDetails copy)
        {
            Name = copy.Name;
            TestEngineerName = copy.TestEngineerName;
            TestEngineerPhone = copy.TestEngineerPhone;
            TestEngineerFax = copy.TestEngineerFax;
            TestEngineerEmail = copy.TestEngineerEmail;
            LocalOnly = copy.LocalOnly;
            LastModified = copy.LastModified;
            LastModifiedBy = copy.LastModifiedBy;
            Version = copy.Version;
        }
        public TestEngineerDetails(ITestEngineerDetailsDbRecord testEngineerDetailsDbRecord)
        {
            Name = testEngineerDetailsDbRecord.Name;
            TestEngineerName = testEngineerDetailsDbRecord.TestEngineerName;
            TestEngineerPhone = testEngineerDetailsDbRecord.TestEngineerPhone;
            TestEngineerFax = testEngineerDetailsDbRecord.TestEngineerFax;
            TestEngineerEmail = testEngineerDetailsDbRecord.TestEngineerEmail;
            LocalOnly = testEngineerDetailsDbRecord.LocalOnly;
            LastModified = testEngineerDetailsDbRecord.LastModified;
            LastModifiedBy = testEngineerDetailsDbRecord.LastModifiedBy;
            Version = testEngineerDetailsDbRecord.Version;
        }
        public static void DeleteAllTestEngineerDetails()
        {
            try
            {
                var errorNumber = DTS.Common.Storage.DbOperations.TestEngineerDetailsDelete(null, out string errorMessage);

                if (errorNumber != 0)
                {
                    //APILogger.Log("Failed to delete test engineer details", errorMessage);
                }
            }
            catch (Exception) { /*APILogger.Log("Failed to delete test engineer details", ex);*/ }
        }
        public static TestEngineerDetails[] GetAllTestEngineerDetails()
        {
            var list = new List<TestEngineerDetails>();
            try
            {
                var errorNumber = DTS.Common.Storage.DbOperations.TestEngineerDetailsGet(null, out ITestEngineerDetailsDbRecord[] testEngineerDetailsDbRecords);

                if (errorNumber == 0)
                {
                    foreach (var testEngineerDetailsDbRecord in testEngineerDetailsDbRecords)
                    {
                        try
                        {
                            list.Add(new TestEngineerDetails(testEngineerDetailsDbRecord));
                        }
                        catch (Exception ex)
                        {
                            //APILogger.Log("failed to get test engineer details", ex);
                        }
                    }
                }
            }
            catch (Exception) { /*APILogger.Log("Failed to retrieve test engineer details", ex);*/ }
            return list.ToArray();
        }
    }
}