예제 #1
0
        public static List <Lane> LaneIPAdresses()
        {
            var lanes = new List <Lane>();

            try
            {
                var context = new PCSDataIntergrationEntities();
                lanes.AddRange(context.Lanes);
            }
            catch (Exception ex)
            {
            }
            return(lanes);
        }
예제 #2
0
        public static List <uspIncidentTypesGet_Result> IncidentTypes()
        {
            var incidentTypeList = new List <uspIncidentTypesGet_Result>();

            try
            {
                var context = new PCSDataIntergrationEntities();
                incidentTypeList.AddRange(context.uspIncidentTypesGet());
            }
            catch (Exception ex)
            {
            }
            return(incidentTypeList);
        }
예제 #3
0
        public static List <PaymentGroupsMapping> PaymentGroupsMappings()
        {
            var context = new PCSDataIntergrationEntities();

            var paymentGroupsList = new List <PaymentGroupsMapping>();

            try
            {
                paymentGroupsList.AddRange(context.PaymentGroupsMappings.ToList());
            }
            catch (Exception ex)
            {
            }
            return(paymentGroupsList);
        }
예제 #4
0
        //public static Guid? IncidentTypesMapping(string incidentCode)
        //{

        //    string incidentType = string.Empty;
        //    try
        //    {
        //        Dictionary<string, string> dictionary = new Dictionary<string, string>();
        //        dictionary.Add("0", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");
        //        dictionary.Add("1", "036C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("2", "046C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("3", "056C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("4", "066C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("5", "076C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("6", "086C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("7", "096C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("8", "0A6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("9", "0B6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("10", "0C6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("11", "0D6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("12", "0E6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("13", "0F6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("14", "106C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("15", "116C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("16", "126C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("17", "136C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("18", "146C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("19", "156C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("20", "166C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("21", "176C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("22", "186C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("23", "196C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("24", "1A6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("25", "356C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("26", "1B6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("27", "1C6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("28", "366C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("29", "376C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("30", "386C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("31", "396C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("32", "3A6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("33", "266C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("34", "1D6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("35", "276C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("37", "286C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("38", "296C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("39", "2A6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("40", "2B6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("41", "1E6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("42", "1F6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("43", "206C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("44", "216C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("45", "3B6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("46", "226C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("47", "236C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("48", "2C6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("49", "2D6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("50", "2E6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("51", "2F6C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("52", "306C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("53", "316C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("54", "246C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("55", "256C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("56", "326C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("57", "336C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("58", "346C8AE2-E700-DF11-AD4B-001517C991CF");
        //        dictionary.Add("59", "66D07173-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("60", "E38FD47E-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("61", "02F51487-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("62", "B5BF249B-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("63", "4FF9BDA6-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("64", "5B5C35B0-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("65", "427406C7-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("66", "84E9B6D0-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("67", "338455DA-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("68", "26E39FE3-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("69", "1192DBEE-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("70", "13D0B6F9-ADDF-E111-8706-C82A14062982");
        //        dictionary.Add("71", "65F54D06-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("72", "E9135913-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("73", "F7FBBF1C-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("74", "6F568B24-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("75", "4F19482D-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("80", "988787B3-45E4-4845-AE6E-3D392ECEA75D");
        //        dictionary.Add("81", "31B5401D-AEDF-4807-8006-76CAD267ECD4");
        //        dictionary.Add("82", "B3C59AEC-C343-401F-AC36-855811BBAC97");
        //        dictionary.Add("84", "D121C4ED-3998-4E3F-A126-8C8D944BD0D8");
        //        dictionary.Add("87", "B03BE6C0-92D1-462A-B8A1-C463E88752E1");
        //        dictionary.Add("92", "CF06DED5-5048-46EC-AB28-902E95BBD8F5");
        //        dictionary.Add("93", "81FCAD31-5A18-4666-89BC-D5E8895E15C3");
        //        dictionary.Add("94", "7F9746B5-9854-4AA5-A982-E18E54FE2729");
        //        dictionary.Add("1000", "A0EDDE4E-AB26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1001", "5047FF60-AB26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1002", "70A24C7A-AB26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1003", "3001A02D-AE26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1004", "D1E31F77-BC26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1005", "B0872692-BC26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1006", "000BC09D-BC26-DF11-BA8B-001517C991CF");
        //        dictionary.Add("1007", "D5CC02E2-ED9E-DF11-A601-001517DD2D44");
        //        dictionary.Add("5001", "35064552-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5002", "2062AF5A-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5003", "9A60B261-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5004", "8E4ADB6C-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5005", "346E8874-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5006", "356E8874-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5007", "6BA4C782-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5008", "5BF3438A-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5009", "59C10497-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5010", "F20D089E-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5011", "A35DBCA5-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5012", "F1758DAC-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5013", "4DD4A6B2-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5014", "90632CB9-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5015", "BCE785C0-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5016", "921B08C7-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5017", "09CCACCD-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5018", "509516DC-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5019", "204135E4-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5020", "FDADACEB-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5021", "FEADACEB-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5022", "4EB687F5-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5023", "4FB687F5-AEDF-E111-8706-C82A14062982");
        //        dictionary.Add("5024", "E1F99A03-AFDF-E111-8706-C82A14062982");
        //        dictionary.Add("5025", "E2F99A03-AFDF-E111-8706-C82A14062982");
        //        dictionary.Add("5026", "2AD55E10-AFDF-E111-8706-C82A14062982");
        //        dictionary.Add("5027", "0A51A2F5-B2DF-E111-8706-C82A14062982");
        //        dictionary.Add("5028", "0AC85655-231C-E211-97C6-E0F8473BA773");
        //        dictionary.Add("5029", "D05B3362-231C-E211-97C6-E0F8473BA773");
        //        dictionary.Add("5030", "B67D5432-7B2D-4955-ACE1-BA21F56F155F");
        //        dictionary.Add("5031", "AB433CA4-EEE2-434E-A4B3-3A73550FEE02");
        //        dictionary.Add("5032", "28592B49-5215-417A-A6A2-10B4CFEEF7CE");
        //        dictionary.Add("5033", "30F4A098-245B-46C2-BBC4-EA104F546E56");
        //        dictionary.Add("5034", "E4898572-0076-49F7-830F-88E37ABE6556");
        //        dictionary.Add("5035", "0F2197B7-0D82-42C6-B772-DEBAA8624AD5");
        //        dictionary.Add("5036", "286A5A3B-B496-46B5-B8D7-033CCE9D32E9");
        //        dictionary.Add("5037", "703ABBC7-7FD2-4161-8081-2D7223C8169A");
        //        dictionary.Add("5038", "FDDC4B3C-84F0-4B04-ABF8-C19BD58C6A86");
        //        dictionary.Add("5039", "37138ABA-A01B-442A-86AC-1B060871C98A");
        //        dictionary.Add("5040", "0606549B-7DFF-4219-9C1A-EC57E479B3B0");
        //        dictionary.Add("5041", "3A170926-5689-4BEB-B6F1-E5F93452553F");
        //        dictionary.Add("5042", "A7D5275E-B5DD-40E1-9EAD-FAE96B526E6B");
        //        dictionary.Add("5043", "D0700273-3E27-40DB-962C-A3DC44AF37BA");
        //        dictionary.Add("5044", "28BC43D4-C88F-4F02-A5C7-1285F0530706");
        //        dictionary.Add("5045", "A7020A3C-62F1-478E-A74D-D66BA82F08E0");
        //        dictionary.Add("5046", "9EA66238-B66B-4BCE-A5CD-7ED40267D31C");
        //        dictionary.Add("5047", "06B473E6-E7A8-45E4-93BD-B3033CDE7C88");
        //        dictionary.Add("5048", "2157A470-B777-424C-B4A5-5743459B90E5");
        //        dictionary.Add("5061", "658F8C01-1BD0-4A52-9870-4482AFBD4655");
        //        dictionary.Add("5062", "2B12CE23-8C6B-4732-8C7A-B9187B0B538E");
        //        dictionary.Add("5063", "161A9328-BE23-4C29-B9D6-9C506C9F9F4F");
        //        dictionary.Add("5064", "7E3C436E-29B3-4E85-BA69-70830ECABCD1");
        //        dictionary.Add("5065", "9420798F-433B-4245-AF0B-320C8FD39B7A");
        //        dictionary.Add("5066", "D73B84D4-5E2A-4EA2-9F9D-0916E941B206");
        //        dictionary.Add("5067", "2D199674-B098-484A-A861-BB0B0E8D1862");
        //        dictionary.Add("5068", "755DE521-8DA3-4E99-948C-C87C71FAFBF8");
        //        dictionary.Add("5069", "58640300-C388-43C1-B545-BC656CBE3952");
        //        dictionary.Add("5100", "7AA9E945-192E-E511-BB65-001917BD1D46");
        //        dictionary.Add("10000", "CA60A87F-8F5D-DF11-934B-001517C991CF");

        //        ////Add 300 range

        //        //dictionary.Add("300", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//BatteryCharging = undefined on intertoll
        //        dictionary.Add("301", "FDDC4B3C-84F0-4B04-ABF8-C19BD58C6A86"); //AVC Critical Mode Start
        //        dictionary.Add("302", "37138ABA-A01B-442A-86AC-1B060871C98A");//AVC Critical Mode Ended
        //        dictionary.Add("303", "0606549B-7DFF-4219-9C1A-EC57E479B3B0");//AVC Serious Mode Start
        //        dictionary.Add("304", "3A170926-5689-4BEB-B6F1-E5F93452553F");//AVC Serious Mode Ended
        //        //dictionary.Add("305", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//OHLSToGreen
        //        //dictionary.Add("306", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//OHLSToRed
        //        //dictionary.Add("307", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//CashLimitReached
        //        //dictionary.Add("308", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//AutoTariffUpdate
        //        dictionary.Add("309", "509516DC-AEDF-E111-8706-C82A14062982");//CancelledClassSelection
        //        dictionary.Add("310", "2AD55E10-AFDF-E111-8706-C82A14062982");//ManualKeyEntry
        //        //dictionary.Add("311", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//QueueLineBreached
        //        //dictionary.Add("312", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//QueueLineBreachCleared
        //        //dictionary.Add("313", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//QLSCameraFailureStart
        //        //dictionary.Add("314", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//QLSCameraFailureStop
        //        //dictionary.Add("315", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//ApplicationNotRresponding
        //        //dictionary.Add("316", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//ApplicationResponding
        //        //dictionary.Add("317", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//TCCUserLogin
        //        //dictionary.Add("318", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//TCCUserLogout
        //        //dictionary.Add("319", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//StartAVCCommunicationFail
        //        //dictionary.Add("320", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//EndAVCCommunicationFail
        //        //dictionary.Add("321", "B6AB99E8-5DA4-4C33-9EDD-08298A1A2104");//PanicButtonPressed
        //        dictionary.Add("322", "658F8C01-1BD0-4A52-9870-4482AFBD4655");//ExemptPassage

        //        if (dictionary.ContainsKey(incidentCode) == true)
        //        {
        //            incidentType = dictionary[incidentCode];
        //        }
        //    }
        //    catch (Exception ex)
        //    {
        //    }
        //    if (string.IsNullOrWhiteSpace(incidentType))
        //        return null;
        //    else
        //        return Guid.Parse(incidentType);
        //}

        public static List <TariffMapping> TariffMapping()
        {
            var context = new PCSDataIntergrationEntities();

            var tariffList = new List <TariffMapping>();

            try
            {
                tariffList.AddRange(context.TariffMappings.ToList());
            }
            catch (Exception ex)
            {
            }
            return(tariffList);
        }