Example #1
0
        public static List <ServiceableZipCodes> GetServiceableZipCodes(string zipCode)
        {
            try
            {
                using (var ctx = new ClearviewContext())
                {
                    var query = ctx.ServiceableZipCodeses
                                .Where(z => z.ZipCodeFull == zipCode)
                                .AsEnumerable()
                                .Select(z => new ServiceableZipCodes()
                    {
                        ZipCodeFull            = z.ZipCodeFull,
                        ZIP                    = z.ZIP,
                        ELEC_Non_IOU_Type      = z.ELEC_Non_IOU_Type,
                        GAS_LDC_Type           = z.GAS_LDC_Type,
                        Holding_Company        = z.Holding_Company,
                        Percent_of_Overlap     = z.Percent_of_Overlap,
                        Utility_ID             = z.Utility_ID,
                        Utility_Name           = z.Utility_Name,
                        Utility_Territory_Type = z.Utility_Territory_Type,
                        ZIP_County             = z.ZIP_County,
                        ZIP_CountyFIPS         = z.ZIP_CountyFIPS,
                        ZIP_Name               = z.ZIP_Name,
                        ZIP_State              = z.ZIP_State
                    }).ToList();

                    return(query);
                }
            }
            catch (Exception e)
            {
                var x = e.Message;
                throw;
            }
        }
Example #2
0
        public static List <UserLog> GetUserLogs(int id)
        {
            try
            {
                using (var ctx = new ClearviewContext())
                {
                    var query = ctx.UserLogs
                                .Where(z => z.UserId == id)
                                .AsEnumerable()
                                .Select(z => new UserLog()
                    {
                        UserLogId       = z.UserLogId,
                        UserId          = z.UserId,
                        IsActive        = z.IsActive,
                        Note            = z.Note,
                        CreatedDateTime = z.CreatedDateTime,
                        CreatedBy       = z.CreatedBy
                    }).ToList();

                    return(query);
                }
            }
            catch (Exception e)
            {
                var x = e.Message;
                throw;
            }
        }