public void RenderViewContextTest()
        {
            StringDictionary parameters = new StringDictionary();

            parameters.Add("styles", "default");
            parameters.Add("width", "512");
            parameters.Add("height", "512");
            parameters.Add("crs", "EPSG:4326");
            parameters.Add("layers", "world_admin");
            parameters.Add("bgcolor", "0x0000FF");
            parameters.Add("version", "1.3.0");
            parameters.Add("format", "image/png");
            parameters.Add("request", "GetMap");
            parameters.Add("bbox", "-180,-85,180,85");

            ViewContext context = new ViewContext();

            // add context details inline for test, this is normally done by ViewContext(parameters)
            // which applies details from configuration files etc.
            context.General.Window.Width  = 512;
            context.General.Window.Height = 512;

            Layer layer = new Layer();

            layer.Title            = "World Administration Boundaries";
            layer.Table            = "world_admin";
            layer.Name             = "world_admin";
            layer.GeometryColumn   = "shape";
            layer.FeatureIdColumn  = "fid";
            layer.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Projects\\GeospatialServices\\TestGeospatialServices\\Input\\Runtime\\TestGeospatialServicesDatabase.mdf;Integrated Security=True;User Instance=True";

            Style     style     = new Style();
            UserLayer userLayer = new UserLayer();

            userLayer.UserStyles = new List <UserStyle>();
            UserStyle         userStyle        = new UserStyle();
            FeatureTypeStyle  featureTypeStyle = new FeatureTypeStyle();
            Rule              rule             = new Rule();
            PolygonSymbolizer polygon          = new PolygonSymbolizer();

            style.Name     = "default";
            userLayer.Name = "World in green";
            polygon.Fill.SvgParameters.Add(new SvgParameter("fill", "#2E8C7C"));

            BaseSymbolizer[] symbolizers = new BaseSymbolizer[] { polygon };
            rule.Symbolizers = symbolizers;
            featureTypeStyle.Rules.Add(rule);
            userStyle.FeatureTypeStyles.Add(featureTypeStyle);
            userLayer.UserStyles.Add(userStyle);
            style.SLD.StyledLayerDescriptor.UserLayers.Add(userLayer);
            layer.StyleList.Add(style);
            context.Layers.Add(layer);

            System.Drawing.Image mapImage = context.Render(parameters);
        }
        // GET: Emp
        public ActionResult Index()
        {
            UserLayer blayer = new UserLayer();



            List <editUser> users = blayer.Users.ToList();



            return(View(users));
        }
        public ActionResult ViewUsers(int id)
        {
            UserLayer blayer = new UserLayer();

            if (blayer.DeleteCustomer(id))
            {
                TempData["Success"] = "Deleted Successfully";
                return(RedirectToAction("ViewUsers"));
            }

            TempData["Exception"] = "Cannot Delete";
            return(RedirectToAction("ViewUsers"));
        }
Exemplo n.º 4
0
        private UserLayer GetSelectedLayerInTreeView()
        {
            UserLayer layer = null;
            TreeIter  iter;

            var paths = tree.Selection.GetSelectedRows();

            if (paths != null && paths.Length > 0 && store.GetIter(out iter, paths[0]))
            {
                layer = store.GetValue(iter, store_index_layer) as UserLayer;
            }

            return(layer);
        }
Exemplo n.º 5
0
        protected ShapeEngine(ShapeEngine src)
        {
            DrawingLayer = src.DrawingLayer;
            ShapeType    = src.ShapeType;
            AntiAliasing = src.AntiAliasing;
            Closed       = src.Closed;
            OutlineColor = src.OutlineColor.Clone();
            FillColor    = src.FillColor.Clone();
            BrushWidth   = src.BrushWidth;

            // Don't clone the GeneratedPoints or OrganizedPoints, as they will be calculated.
            ControlPoints = src.ControlPoints.Select(i => i.Clone()).ToList();
            DashPattern   = src.DashPattern;
            parent_layer  = null !;           // NRT - This constructor needs to set parent_layer somehow as code expects it to be not-null
        }
Exemplo n.º 6
0
        //   [Authorize]
        public async Task <UserObject> GetSession()
        {
            UserLayer  userLayer = new UserLayer();
            UserObject uo        = await userLayer.GetSession();

            try
            {
                uo.PreviousUser = UserImpersonation.PrevUserName;
            }
            catch (Exception)
            {
                // ignored
            }
            return(uo);
        }
        public ActionResult Create_Post()
        {
            User user = new User();

            TryUpdateModel(user);

            if (ModelState.IsValid)
            {
                UserLayer usr = new UserLayer();
                usr.AddUser(user);
                return(RedirectToAction("Index"));
            }


            return(View());
        }
Exemplo n.º 8
0
        /// <summary>
        /// Returns whether or not the setting is overridden by the active layer
        /// </summary>
        public bool SettingExistsInLayer(string sliceSetting, NamedSettingsLayers layer)
        {
            switch (layer)
            {
            case NamedSettingsLayers.Quality:
                return(QualityLayer?.ContainsKey(sliceSetting) == true);

            case NamedSettingsLayers.Material:
                return(MaterialLayer?.ContainsKey(sliceSetting) == true);

            case NamedSettingsLayers.User:
                return(UserLayer?.ContainsKey(sliceSetting) == true);

            default:
                return(false);
            }
        }
Exemplo n.º 9
0
        public ActionResult saveimage(int id)
        {
            UserImage user   = new UserImage();
            UserLayer blayer = new UserLayer();

            try
            {
                user = blayer.images.Single(us => us.UserId == id);
                return(View(user));
            }
            catch (Exception ex) {
            }

            UserImage u1 = new UserImage();

            return(View(u1));
        }
Exemplo n.º 10
0
        private void SetLayerVisibility(UserLayer layer, bool visibility)
        {
            var doc = PintaCore.Workspace.ActiveDocument;

            var initial = new LayerProperties(layer.Name, visibility, layer.Opacity, layer.BlendMode);
            var updated = new LayerProperties(layer.Name, !visibility, layer.Opacity, layer.BlendMode);

            var historyItem = new UpdateLayerPropertiesHistoryItem(
                Resources.Icons.LayerProperties,
                (visibility) ? Translations.GetString("Layer Shown") : Translations.GetString("Layer Hidden"),
                doc.Layers.IndexOf(layer),
                initial,
                updated);

            historyItem.Redo();

            doc.History.PushNewItem(historyItem);
        }
Exemplo n.º 11
0
        public ActionResult editpassword(clsUserPasswordedit user)
        {
            try
            {
                UserLayer ul = new UserLayer();


                var usr = ul.Usersl.Where(u => u.OldPassword == user.OldPassword).Where(i => i.UserId == user.UserId);
                if (usr != null)
                {
                    ul.SaveUserPassword(user);
                    return(RedirectToAction("Index", "Home"));
                }
            }
            catch (Exception ex)
            {
                ViewData["Exception"] = "Password error :" + ex.Message;
            }
            return(View(user));
        }
Exemplo n.º 12
0
        /// <summary>
        /// Create a new ShapeEngine.
        /// </summary>
        /// <param name="passedParentLayer">The parent UserLayer for the ReEditable DrawingLayer.</param>
        /// <param name="passedDrawingLayer">An existing ReEditableLayer to reuse. This is for cloning only. If not cloning, pass in null.</param>
        /// <param name="passedShapeType">The type of shape to create.</param>
        /// <param name="passedAA">Whether or not antialiasing is enabled.</param>
        /// <param name="passedClosed">Whether or not the shape is closed (first and last points are connected).</param>
        /// <param name="passedOutlineColor">The outline color for the shape.</param>
        /// <param name="passedFillColor">The fill color for the shape.</param>
        /// <param name="passedBrushWidth">The width of the outline of the shape.</param>
        public ShapeEngine(UserLayer passedParentLayer, ReEditableLayer passedDrawingLayer, BaseEditEngine.ShapeTypes passedShapeType,
                           bool passedAA, bool passedClosed, Color passedOutlineColor, Color passedFillColor, int passedBrushWidth)
        {
            parentLayer = passedParentLayer;

            if (passedDrawingLayer == null)
            {
                DrawingLayer = new ReEditableLayer(parentLayer);
            }
            else
            {
                DrawingLayer = passedDrawingLayer;
            }

            ShapeType    = passedShapeType;
            AntiAliasing = passedAA;
            Closed       = passedClosed;
            OutlineColor = passedOutlineColor.Clone();
            FillColor    = passedFillColor.Clone();
            BrushWidth   = passedBrushWidth;
        }
Exemplo n.º 13
0
        /// <summary>
        /// A history item for when curves are finalized.
        /// </summary>
        /// <param name="icon">The history item's icon.</param>
        /// <param name="text">The history item's title.</param>
        /// <param name="passedUserSurface">The stored UserLayer surface.</param>
        /// <param name="passedUserLayer">The UserLayer being modified.</param>
        /// <param name="passedSelectedPointIndex">The selected point's index.</param>
        /// <param name="passedSelectedPointCurveIndex">The selected point's curve index.</param>
        public CurvesHistoryItem(string icon, string text, ImageSurface passedUserSurface, UserLayer passedUserLayer,
                                 int passedSelectedPointIndex, int passedSelectedPointCurveIndex) : base(icon, text)
        {
            userLayer = passedUserLayer;


            user_surface_diff = SurfaceDiff.Create(passedUserSurface, userLayer.Surface, true);

            if (user_surface_diff == null)
            {
                userSurface = passedUserSurface;
            }
            else
            {
                (passedUserSurface as IDisposable).Dispose();
            }


            cEngines                = Pinta.Tools.LineCurveTool.cEngines.PartialClone();
            selectedPointIndex      = passedSelectedPointIndex;
            selectedPointCurveIndex = passedSelectedPointCurveIndex;
        }
Exemplo n.º 14
0
        private void SetLayerVisibility(UserLayer layer, bool visibility)
        {
            if (layer != null)
            {
                layer.Hidden = !visibility;
            }

            var initial = new LayerProperties(layer.Name, visibility, layer.Opacity, layer.BlendMode);
            var updated = new LayerProperties(layer.Name, !visibility, layer.Opacity, layer.BlendMode);

            var historyItem = new UpdateLayerPropertiesHistoryItem(
                "Menu.Layers.LayerProperties.png",
                (visibility) ? Catalog.GetString("Layer Shown") : Catalog.GetString("Layer Hidden"),
                PintaCore.Layers.IndexOf(layer),
                initial,
                updated);

            PintaCore.History.PushNewItem(historyItem);

            //TODO Call this automatically when the layer visibility changes.
            PintaCore.Workspace.Invalidate();
        }
Exemplo n.º 15
0
        /// <summary>
        /// Create a new ShapeEngine.
        /// </summary>
        /// <param name="parent_layer">The parent UserLayer for the ReEditable DrawingLayer.</param>
        /// <param name="drawing_layer">An existing ReEditableLayer to reuse. This is for cloning only. If not cloning, pass in null.</param>
        /// <param name="shape_type">The type of shape to create.</param>
        /// <param name="antialiasing">Whether or not antialiasing is enabled.</param>
        /// <param name="closed">Whether or not the shape is closed (first and last points are connected).</param>
        /// <param name="outline_color">The outline color for the shape.</param>
        /// <param name="fill_color">The fill color for the shape.</param>
        /// <param name="brush_width">The width of the outline of the shape.</param>
        public ShapeEngine(UserLayer parent_layer, ReEditableLayer?drawing_layer,
                           BaseEditEngine.ShapeTypes shape_type, bool antialiasing,
                           bool closed, Color outline_color, Color fill_color,
                           int brush_width)
        {
            this.parent_layer = parent_layer;

            if (drawing_layer == null)
            {
                DrawingLayer = new ReEditableLayer(parent_layer);
            }
            else
            {
                DrawingLayer = drawing_layer;
            }

            ShapeType    = shape_type;
            AntiAliasing = antialiasing;
            Closed       = closed;
            OutlineColor = outline_color.Clone();
            FillColor    = fill_color.Clone();
            BrushWidth   = brush_width;
        }
Exemplo n.º 16
0
        public async Task <ActionResult> Signup(User user)
        {
            if (ModelState.IsValid)
            {
                UserLayer userBusinessLayer = new UserLayer();
                userBusinessLayer.AddUser(user);
                var message = await EmailTemplate("WelcomeEmail");

                message = message.Replace("@ViewBag.Name", CultureInfo.CurrentCulture.TextInfo.ToTitleCase

                                              (user.Fname));


                await MessageServices.SendEmailAsync(user.Email, "Welcome", message);

                return(RedirectToAction("Index", "Home"));



                ModelState.Clear();
            }
            return(View());
        }
Exemplo n.º 17
0
        public ActionResult Edituserinfo(editUser user)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    UserLayer blayer = new UserLayer();
                    TryUpdateModel(user);
                    blayer.SaveUser(user);
                    TempData["Sucess"] = "Profile Successfully updated";

                    return(RedirectToAction("Edituserinfo", "User", user));

                    //return View(user);
                }
            }

            catch (Exception ex)
            {
                ViewData["Exception"] = "Error :" + ex.Message;
            }
            ViewData["Exception"] = "Fill All required Fields";
            return(View(user));
        }
Exemplo n.º 18
0
        public async Task <ActionResult> PasswordRecovery(editUser user)
        {
            UserLayer ulayer = new UserLayer();
            Random    r      = new Random(1001);
            int       code   = new Random().Next(1001, 9999);

            try
            {
                var result = ulayer.Users.Single(u => u.Email == user.Email);


                if (result != null)
                {
                    ulayer.Updatecode(code, user.Email);

                    var message = await EmailTemplate("RecoveryEmail");

                    message = message.Replace("@ViewBag.Code", CultureInfo.CurrentCulture.TextInfo.ToTitleCase

                                                  (code.ToString()));


                    await MessageServices.SendEmailAsync(user.Email, "Password Recovery", message);

                    TempData["Email"] = "Email has been Sent successfully to " + user.Email + ". Please enter the recovery code. ";
                    return(View("Recoverychange"));
                }
            }
            catch (Exception e)
            {
                ViewData["Exception"] = "This account does not exist. Please Sign Up";
            }


            return(View());
        }
Exemplo n.º 19
0
        public string SaveUserSettings(SavedUserSettings setting)
        {
            UserLayer userLayer = new UserLayer();

            return(userLayer.SaveUserSettings(setting));
        }
Exemplo n.º 20
0
        public ActionResult SignIn(userlogin user)
        {
            if (user.IsValid(user.Username, user.Password))
            {
                Session["UserId"]   = user.UserId.ToString();
                Session["Username"] = user.Username.ToString();

                if (user.Rememberme)
                {
                    HttpCookie cookieusername = new HttpCookie("Username");
                    cookieusername.Expires = DateTime.Now.AddSeconds(3600);
                    cookieusername.Value   = user.Username;
                    Response.Cookies.Add(cookieusername);
                    HttpCookie cookiepassword = new HttpCookie("Password");
                    cookiepassword.Expires = DateTime.Now.AddSeconds(3600);
                    cookiepassword.Value   = user.Password;
                    Response.Cookies.Add(cookiepassword);
                }


                if (user.Username == "admin" || user.Username == "ADMIN")
                {
                    return(RedirectToAction("AdminIndex", "Admin"));
                }


                UserLayer ulayer = new UserLayer();
                ulayer.saveLoginhistory(user);
                return(RedirectToAction("Index", "Home"));
            }
            else
            {
                ViewData["Name"] = "Credentials does not match our records";
                return(View());
            }



            /*
             * if (user.IsValid(user.Username, user.Password))
             * {
             *  //  FormsAuthentication.SetAuthCookie(user.Email, model.RememberMe);
             * // ViewData["IDV"] = user.UserId;
             *
             *
             *  Session["UserId"] = user.UserId.ToString();
             *  Session["Username"] = user.Username.ToString();
             *
             *  return RedirectToAction("Index", "Home");
             *
             * }
             * else
             * {
             *  ModelState.AddModelError("", "The user name or password provided is incorrect.");
             *
             * }
             *
             * ViewData["Name"] = "Credentials does not match our records";
             *
             * return View();
             */
        }
Exemplo n.º 21
0
 public UserController(UserLayer.IUserDataAccess dataAccess)
 {
     if (dataAccess == null) throw new ArgumentNullException(nameof(dataAccess));
     _dataAcess = dataAccess;
 }
Exemplo n.º 22
0
 /// <summary>
 /// Create a new RoundedLineEngine.
 /// </summary>
 /// <param name="parent_layer">The parent UserLayer for the re-editable DrawingLayer.</param>
 /// <param name="drawing_layer">An existing ReEditableLayer to reuse. This is for cloning only. If not cloning, pass in null.</param>
 /// <param name="passedRadius">The radius of the corners.</param>
 /// <param name="antialiasing">Whether or not antialiasing is enabled.</param>
 /// <param name="outline_color">The outline color for the shape.</param>
 /// <param name="fill_color">The fill color for the shape.</param>
 /// <param name="brush_width">The width of the outline of the shape.</param>
 public RoundedLineEngine(UserLayer parentLayer, ReEditableLayer?passedDrawingLayer, double passedRadius, bool passedAA,
                          Color passedOutlineColor, Color passedFillColor, int passedBrushWidth) : base(parentLayer, passedDrawingLayer,
                                                                                                        BaseEditEngine.ShapeTypes.RoundedLineSeries, passedAA, true, passedOutlineColor, passedFillColor, passedBrushWidth)
 {
     Radius = passedRadius;
 }
Exemplo n.º 23
0
 /// <summary>
 /// Create a new EllipseEngine.
 /// </summary>
 /// <param name="parentLayer">The parent UserLayer for the re-editable DrawingLayer.</param>
 /// <param name="passedDrawingLayer">An existing ReEditableLayer to reuse. This is for cloning only. If not cloning, pass in null.</param>
 /// <param name="passedAA">Whether or not antialiasing is enabled.</param>
 /// <param name="passedOutlineColor">The outline color for the shape.</param>
 /// <param name="passedFillColor">The fill color for the shape.</param>
 /// <param name="passedBrushWidth">The width of the outline of the shape.</param>
 public EllipseEngine(UserLayer parentLayer, ReEditableLayer passedDrawingLayer, bool passedAA,
                      Color passedOutlineColor, Color passedFillColor, int passedBrushWidth) : base(parentLayer, passedDrawingLayer,
                                                                                                    BaseEditEngine.ShapeTypes.Ellipse, passedAA, true, passedOutlineColor, passedFillColor, passedBrushWidth)
 {
 }
Exemplo n.º 24
0
        /// <summary>
        /// A history item for when shapes are finalized.
        /// </summary>
        /// <param name="passedEE">The EditEngine being used.</param>
        /// <param name="icon">The history item's icon.</param>
        /// <param name="text">The history item's title.</param>
        /// <param name="passedUserSurface">The stored UserLayer surface.</param>
        /// <param name="passedUserLayer">The UserLayer being modified.</param>
        /// <param name="passedSelectedPointIndex">The selected point's index.</param>
        /// <param name="passedSelectedShapeIndex">The selected point's shape index.</param>
        /// <param name="passedRedrawEverything">Whether every shape should be redrawn when undoing (e.g. finalization).</param>
        public ShapesHistoryItem(BaseEditEngine passedEE, string icon, string text, ImageSurface passedUserSurface, UserLayer passedUserLayer,
                                 int passedSelectedPointIndex, int passedSelectedShapeIndex, bool passedRedrawEverything) : base(icon, text)
        {
            ee = passedEE;

            userLayer = passedUserLayer;


            userSurfaceDiff = SurfaceDiff.Create(passedUserSurface, userLayer.Surface, true);

            if (userSurfaceDiff == null)
            {
                userSurface = passedUserSurface;
            }
            else
            {
                (passedUserSurface as IDisposable).Dispose();
            }


            sEngines           = BaseEditEngine.SEngines.PartialClone();
            selectedPointIndex = passedSelectedPointIndex;
            selectedShapeIndex = passedSelectedShapeIndex;

            redrawEverything = passedRedrawEverything;
        }
Exemplo n.º 25
0
        /// <summary>
        /// GetFiltersParameters
        /// </summary>
        /// <param name="filter"></param>
        /// <param name="spName"></param>
        /// <param name="userName"></param>
        /// <param name="comparison"></param>
        /// <returns></returns>
        public static SqlCommand GetFiltersParameters(Filter filter, string spName, string userName, Period comparison = null)
        {
            var sqlComm = new SqlCommand();

            sqlComm.CommandTimeout = int.MaxValue;
            sqlComm.CommandText    = spName;
            sqlComm.CommandType    = CommandType.StoredProcedure;
            using (SqlConnection sqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CC_ProdConn"].ConnectionString))
            {
                UserLayer ul = new UserLayer();

                var uf = ul.GetUserForsedFilters(userName, sqlCon);

                filter.filters.agents.AddRange(uf.agent);
                filter.filters.QAs.AddRange(uf.qa);
                filter.filters.teamLeads.AddRange(uf.teamLead);
                filter.filters.groups.AddRange(uf.group);
                filter.filters.campaigns.AddRange(uf.campaign);
            }
            sqlComm.Parameters.AddWithValue("@userName", userName);
            if (filter != null)
            {
                if (filter.filters.teamLeads != null && filter.filters.teamLeads.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.teamLeads)
                    {
                        preparedLst.Append("'" + value + "',");
                    }
                    sqlComm.Parameters.AddWithValue("@teamLeadIDs", preparedLst.ToString().Trim(Convert.ToChar(",")));
                }
                if (filter.filters.scorecards != null && filter.filters.scorecards.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.scorecards)
                    {
                        preparedLst.Append("'" + value + "',");
                    }
                    sqlComm.Parameters.AddWithValue("@scorecardIDs", preparedLst.ToString().Trim(Convert.ToChar(",")));
                }
                if (filter.filters.campaigns != null && filter.filters.campaigns.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.campaigns)
                    {
                        preparedLst.Append("'" + value + "',");
                    }
                    sqlComm.Parameters.AddWithValue("@campaignIDs", preparedLst.ToString().Trim(Convert.ToChar(",")));
                }

                if (filter.filters.groups != null && filter.filters.groups.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.groups)
                    {
                        preparedLst.Append("'" + value + "',");
                    }
                    sqlComm.Parameters.AddWithValue("@groupIDs", preparedLst.ToString().Trim(Convert.ToChar(",")));
                }
                if (filter.filters.agents != null && filter.filters.agents.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.agents)
                    {
                        preparedLst.Append("'" + value.Replace(",", "<!@!>") + "',");
                    }
                    sqlComm.Parameters.AddWithValue("@agentIDs", preparedLst.ToString().Trim(Convert.ToChar(",")));
                }
                if (filter.filters.QAs != null && filter.filters.QAs.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.QAs)
                    {
                        preparedLst.Append("'" + value + "',");
                    }
                    sqlComm.Parameters.AddWithValue("@qaIDs", preparedLst.ToString().Trim(Convert.ToChar(",")));
                }
                if (filter.filters.missedItems != null && filter.filters.missedItems.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.missedItems)
                    {
                        preparedLst.Append(("'" + (value + "',")));
                    }

                    if (preparedLst != null)
                    {
                        sqlComm.Parameters.AddWithValue("@missedItemsIDs", preparedLst.ToString().Trim(','));
                    }
                }
                if (filter.filters.commentIds != null && filter.filters.commentIds.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.commentIds)
                    {
                        preparedLst.Append(("'" + (value + "',")));
                    }

                    if (preparedLst != null)
                    {
                        sqlComm.Parameters.AddWithValue("@answerCommentIds", preparedLst.ToString().Trim(','));
                    }
                }
                if (filter.filters.answerIds != null && filter.filters.answerIds.Count > 0)
                {
                    var preparedLst = new StringBuilder();
                    foreach (var value in filter.filters.answerIds)
                    {
                        preparedLst.Append(("'" + (value + "',")));
                    }

                    if (preparedLst != null)
                    {
                        sqlComm.Parameters.AddWithValue("@answerIds", preparedLst.ToString().Trim(','));
                    }
                }
                try
                {
                    sqlComm.Parameters.AddWithValue("@badCallOnly", filter.filters.badCallsOnly);
                }
                catch { }

                if (filter.filters != null)
                {
                    sqlComm.Parameters.AddWithValue("@filterByReviewDate", filter.filters.filterByReviewDate);
                    sqlComm.Parameters.AddWithValue("@passedOnly", filter.filters.passedOnly);
                    sqlComm.Parameters.AddWithValue("@failed", filter.filters.failedOnly);
                    sqlComm.Parameters.AddWithValue("@reviewType", filter.filters.reviewType);
                    sqlComm.Parameters.AddWithValue("@missedBy", filter.filters.missedBy);
                    if (filter.filters.isConversion)
                    {
                        sqlComm.Parameters.AddWithValue("@isConversion", 1);
                    }
                }
            }
            if (filter == null || filter.range.start == null || filter.range.start.Length < 4)
            {
                sqlComm.Parameters.AddWithValue("@Start", DateTime.Now.AddDays(-14));
            }
            else
            {
                sqlComm.Parameters.AddWithValue("@Start", DateTime.Parse(filter.range.start));
            }
            if (filter == null || filter.range.end == null || filter.range.end.Length < 4)
            {
                sqlComm.Parameters.AddWithValue("@end", DateTime.Now);
            }
            else
            {
                sqlComm.Parameters.AddWithValue("@end", DateTime.Parse(filter.range.end));
            }

            if (comparison != null)
            {
                if (filter == null || comparison.start == null || comparison.start.Length < 4)
                {
                    sqlComm.Parameters.AddWithValue("@CompareStart", System.DateTime.Now.AddMonths(-1).AddDays(-14).ToString("d/M/YYYY"));
                }
                else
                {
                    sqlComm.Parameters.AddWithValue("@CompareStart", DateTime.Parse(comparison.start));
                }
                if (filter == null || comparison.end == null || comparison.end.Length < 4)
                {
                    sqlComm.Parameters.AddWithValue("@CompareEnd", System.DateTime.Now.AddMonths(-1).ToString("d/M/YYYY"));
                }
                else
                {
                    sqlComm.Parameters.AddWithValue("@CompareEnd", DateTime.Parse(comparison.end));
                }
            }

            return(sqlComm);
        }
Exemplo n.º 26
0
        public void ExerciseWmcFromCodeTest()
        {
            ViewContext context = new ViewContext();

            // Context -> General
            context.General.Window.Width     = 500;
            context.General.Window.Height    = 300;
            context.General.BoundingBox.SRS  = "EPSG:4326";
            context.General.BoundingBox.MinX = -180;
            context.General.BoundingBox.MinY = -90;
            context.General.BoundingBox.MaxX = 180;
            context.General.BoundingBox.MaxY = 90;
            context.General.Title            = "EOS Data Gateways";
            context.General.KeywordList.Add("EOS");
            context.General.KeywordList.Add("EOSDIS");
            context.General.KeywordList.Add("NASA");
            context.General.KeywordList.Add("CCRS");
            context.General.KeywordList.Add("CEOS");
            context.General.KeywordList.Add("OGC");
            context.General.Abstract       = "Map View of EOSDIS partners locations";
            context.General.LogoURL.Width  = 130;
            context.General.LogoURL.Height = 74;
            context.General.LogoURL.Format = "image/gif";
            context.General.LogoURL.OnlineResource.Type        = "simple";
            context.General.LogoURL.OnlineResource.Href        = "http://redhook.gsfc.nasa.gov/~imswww/pub/icons/logo.gif";
            context.General.DescriptionURL.Format              = "text/html";
            context.General.DescriptionURL.OnlineResource.Type = "simple";
            context.General.DescriptionURL.OnlineResource.Href = "http://eos.nasa.gov/imswelcome";
            context.General.ContactInformation.ContactPersonPrimary.ContactPerson       = "Tom Kralidis";
            context.General.ContactInformation.ContactPersonPrimary.ContactOrganisation = "Canada Centre for Remote Sensing";
            context.General.ContactInformation.ContactPosition                = "Systems Scientist";
            context.General.ContactInformation.ContactAddress.AddressType     = "postal";
            context.General.ContactInformation.ContactAddress.Address         = "615 Booth Street, room 650";
            context.General.ContactInformation.ContactAddress.City            = "Ottawa";
            context.General.ContactInformation.ContactAddress.StateOrProvince = "Ontario";
            context.General.ContactInformation.ContactAddress.Country         = "Canada";
            context.General.ContactInformation.ContactVoiceTelephone          = "+01 613 947 1828";
            context.General.ContactInformation.ContactFacsimileTelephone      = "+01 613 947 2410";
            context.General.ContactInformation.ContactElectronicMailAddress   = "*****@*****.**";

            context.Version = "1.0";
            context.Id      = "TEST";

            // Context -> Layer
            Layer layer = new Layer();

            layer.Queryable                  = 1;
            layer.Hidden                     = 0;
            layer.Server.Service             = GeospatialServices.Ogc.Common.ServiceNames.WMS;
            layer.Server.Version             = "1.0.7";
            layer.Title                      = "The GLOBE Program Visualization Server";
            layer.Server.OnlineResource.Type = "simple";
            layer.Server.OnlineResource.Href = "http://globe.digitalearth.gov/viz-bin/wmt.cgi";
            layer.Name     = "NATIONAL";
            layer.Title    = "National Boundaries";
            layer.Abstract = "Context layer: National Boundaries";
            layer.SRS      = "EPSG:4326";

            // Context -> Layer -> Format
            layer.FormatList.Add(new Format("GIF", 1));

            // Context -> Layer -> Style
            Style style1 = new Style();

            style1.Current          = 1;
            style1.Name             = "default";
            style1.LegendURL.Width  = 16;
            style1.LegendURL.Height = 16;
            style1.LegendURL.Format = "image/gif";
            style1.LegendURL.OnlineResource.Type = "simple";
            style1.LegendURL.OnlineResource.Href = "http://mapserv2.esrin.esa.it/cubestor/cubeserv.cgi?VERSION=1.1.0&REQUEST=GetLegendIcon&LAYER=WORLD_MODIS_1KM:MapAdmin&SPATIAL_TYPE=RASTER&STYLE=default&FORMAT=image//gif";


            // Context  -> Layer -> Style -> Named Layer
            NamedLayer namedLayer = new NamedLayer();

            namedLayer.Name = "Roads";

            //  Context  -> Layer -> Style -> Named Layer ->  Named Styles
            namedLayer.NamedStyles.Add(new NamedStyle("Casing"));
            namedLayer.NamedStyles.Add(new NamedStyle("Centerline"));

            //  Context  -> Layer -> Style -> Named Layer ->  User Style
            UserStyle userStyle1 = new UserStyle();

            //  Context  -> Layer -> Style -> Named Layer ->  User Style -> FeatureTypeStyle
            FeatureTypeStyle featureTypeStyle1 = new FeatureTypeStyle();
            Rule             rule1             = new Rule();

            // Context  -> Layer -> Style -> Named Layer ->  User Style -> FeatureTypeStyle -> Rule -> Symbolizers
            BaseSymbolizer[]  symbolizers          = new BaseSymbolizer[6];
            SymbolizerTypes[] symbolizerSelections = new SymbolizerTypes[6];

            // Line Symbolizer
            LineSymbolizer lineSymbolizer = new LineSymbolizer();

            lineSymbolizer.Geometry.PropertyName = "center-line";
            lineSymbolizer.Stroke.SvgParameters.Add(new SvgParameter("stroke", "#0000ff"));
            lineSymbolizer.Stroke.SvgParameters.Add(new SvgParameter("stroke-width", "2"));

            symbolizers[0]          = lineSymbolizer;
            symbolizerSelections[0] = SymbolizerTypes.LineSymbolizer;


            // Polygon Symbolizer
            PolygonSymbolizer polygonSymbolizer = new PolygonSymbolizer();

            polygonSymbolizer.Geometry.PropertyName = "the_area";
            polygonSymbolizer.Fill.SvgParameters.Add(new SvgParameter("fill", "#aaaaff"));
            polygonSymbolizer.Stroke.SvgParameters.Add(new SvgParameter("stroke", "#0000aa"));

            symbolizers[1]          = polygonSymbolizer;
            symbolizerSelections[1] = SymbolizerTypes.PolygonSymbolizer;


            // Point Symbolizer
            PointSymbolizer pointSymbolizer = new PointSymbolizer();

            // Point Symbolizer - > External Graphic 1
            ExternalGraphic externalGraphic1 = new ExternalGraphic();

            externalGraphic1.OnlineResource.Type = "simple";
            externalGraphic1.OnlineResource.Href = "http://www.vendor.com/geosym/2267.svg";
            externalGraphic1.Format = "image/svg+xml";
            pointSymbolizer.Graphic.ExternalGraphics.Add(externalGraphic1);

            // Point Symbolizer - > External Graphic 2
            ExternalGraphic externalGraphic2 = new ExternalGraphic();

            externalGraphic2.OnlineResource.Type = "simple";
            externalGraphic2.OnlineResource.Href = "http://www.vendor.com/geosym/2267.png";
            externalGraphic2.Format = "image/png";

            pointSymbolizer.Graphic.ExternalGraphics.Add(externalGraphic2);
            pointSymbolizer.Graphic.Size = 15.0;

            symbolizers[2]          = pointSymbolizer;
            symbolizerSelections[2] = SymbolizerTypes.PointSymbolizer;

            // Text Symbolizer
            TextSymbolizer textSymbolizer = new TextSymbolizer();

            textSymbolizer.Geometry.PropertyName = "locatedAt";
            textSymbolizer.Label = @"ogc:PropertyName[hospitalName]";
            textSymbolizer.Font.SvgParameters.Add(new SvgParameter("font-family", "Arial"));
            textSymbolizer.Font.SvgParameters.Add(new SvgParameter("font-family", "Sans-Serif"));
            textSymbolizer.Font.SvgParameters.Add(new SvgParameter("font-style", "italic"));
            textSymbolizer.Font.SvgParameters.Add(new SvgParameter("font-size", "10"));
            textSymbolizer.Fill.SvgParameters.Add(new SvgParameter("fill", "#000000"));
            textSymbolizer.LabelPlacement.PointPlacement = new PointPlacement();
            textSymbolizer.LabelPlacement.PointPlacement.AnchorPoint.AnchorPointX = 456;
            textSymbolizer.LabelPlacement.PointPlacement.AnchorPoint.AnchorPointY = 123;
            textSymbolizer.LabelPlacement.PointPlacement.Rotation = 180;
            textSymbolizer.LabelPlacement.PointPlacement.Displacement.DisplacementX = 111;
            textSymbolizer.LabelPlacement.PointPlacement.Displacement.DisplacementY = 222;
            textSymbolizer.LabelPlacement.LinePlacement                     = new LinePlacement();
            textSymbolizer.LabelPlacement.LinePlacement.Gap                 = 12;
            textSymbolizer.LabelPlacement.LinePlacement.GeneraliseLine      = 3;
            textSymbolizer.LabelPlacement.LinePlacement.InitialGap          = 3;
            textSymbolizer.LabelPlacement.LinePlacement.IsAligned           = 0;
            textSymbolizer.LabelPlacement.LinePlacement.IsRepeated          = 1;
            textSymbolizer.LabelPlacement.LinePlacement.PerpendicularOffset = 5;
            textSymbolizer.Halo.Fill = new Fill();
            textSymbolizer.Halo.Fill.SvgParameters.Add(new SvgParameter("fill", "#000000"));
            textSymbolizer.Halo.Radius = 3;

            symbolizers[3]          = textSymbolizer;
            symbolizerSelections[3] = SymbolizerTypes.TextSymbolizer;

            // Raster Symbolizer 1
            RasterSymbolizer rasterSymbolizer1 = new RasterSymbolizer();

            rasterSymbolizer1.Opacity          = 1.0;
            rasterSymbolizer1.OverlapBehaviour = OverlapBehaviourTypes.Average;
            rasterSymbolizer1.ColourMap.Categorize.LookupValue = "Rasterdata";
            rasterSymbolizer1.ColourMap.Categorize.Values.Add("#00ff00");
            rasterSymbolizer1.ColourMap.Categorize.Thresholds.Add(-417);
            rasterSymbolizer1.ColourMap.Categorize.Values.Add("#00fa00");
            rasterSymbolizer1.ColourMap.Categorize.Thresholds.Add(-333);

            symbolizers[4]          = rasterSymbolizer1;
            symbolizerSelections[4] = SymbolizerTypes.RasterSymbolizer;

            // Raster Symbolizer 2
            RasterSymbolizer rasterSymbolizer2 = new RasterSymbolizer();

            rasterSymbolizer2.Opacity          = 1.0;
            rasterSymbolizer2.OverlapBehaviour = OverlapBehaviourTypes.LatestOnTop;
            rasterSymbolizer2.ChannelSelection.RedChannel.SourceChannelName   = "1";
            rasterSymbolizer2.ChannelSelection.GreenChannel.SourceChannelName = "2";
            rasterSymbolizer2.ChannelSelection.GreenChannel.ContrastEnhancement.GammaValue = 2.5;
            rasterSymbolizer2.ChannelSelection.BlueChannel.SourceChannelName = "3";
            rasterSymbolizer2.ColourMap.Interpolate.FallBackValue            = "#dddddd";
            rasterSymbolizer2.ColourMap.Interpolate.LookupValue = "Rasterdata";
            rasterSymbolizer2.ColourMap.Interpolate.InterpolationPoints.Add(new InterpolationPoint(0, "#000000"));
            rasterSymbolizer2.ColourMap.Interpolate.InterpolationPoints.Add(new InterpolationPoint(255, "#ffffff"));
            rasterSymbolizer2.ContrastEnhancement.GammaValue = 1;
            rasterSymbolizer2.Geometry.PropertyName          = "Coastlines";

            symbolizers[5]          = rasterSymbolizer2;
            symbolizerSelections[5] = SymbolizerTypes.RasterSymbolizer;

            rule1.SymbolizerSelections = symbolizerSelections;
            rule1.Symbolizers          = symbolizers;

            featureTypeStyle1.Rules.Add(rule1);

            Rule rule2 = new Rule();

            rule2.ElseFilter = new ElseFilter();
            featureTypeStyle1.Rules.Add(rule2);


            Rule rule3 = new Rule();

            GeospatialServices.Ogc.Wmc.PropertyIsEqualTo propEqualTo = new PropertyIsEqualTo();
            propEqualTo.Literal.Value = "NEW YORK";
            propEqualTo.PropertyName  = "SALES_AREA";

            //BaseComparisonOps ComparisonOps[] = new BaseComparisonOps[2];

            rule3.Filter.FilterExpression = propEqualTo;
            featureTypeStyle1.Rules.Add(rule3);

            userStyle1.FeatureTypeStyles.Add(featureTypeStyle1);
            namedLayer.UserStyles.Add(userStyle1);

            // Context - > Layer -> Style -> User Layer
            UserLayer userLayer = new UserLayer();

            userLayer.Name = "Lakes and Rivers";

            UserStyle userStyle = new UserStyle("Default");

            userStyle.FeatureTypeStyles.Add(featureTypeStyle1);
            userLayer.UserStyles = new List <UserStyle>();
            userLayer.UserStyles.Add(userStyle);

            style1.SLD.StyledLayerDescriptor.NamedLayers.Add(namedLayer);
            style1.SLD.StyledLayerDescriptor.UserLayers.Add(userLayer);

            layer.StyleList.Add(style1);
            context.Layers.Add(layer);
        }
Exemplo n.º 27
0
        public void RenderSLDInParametersTest()
        {
            StringBuilder sld = new StringBuilder();

            sld.Append("<SLD>");
            sld.Append("<sld:StyledLayerDescriptor>");
            sld.Append("<sld:UserLayer>");
            sld.Append("<sld:Name>World</sld:Name>");
            sld.Append("<sld:UserStyles>");
            sld.Append("<sld:UserStyle>");
            sld.Append("<se:FeatureTypeStyle>");
            sld.Append("<se:Rule>");
            sld.Append("<se:PointSymbolizer>");
            sld.Append("<se:Graphic>");
            sld.Append("<se:Opacity>255</se:Opacity>");
            sld.Append("<se:Mark>");
            sld.Append("<se:WellKnownName>font://Webdings?CharIndex=114</se:WellKnownName>");
            sld.Append("<se:Fill>");
            sld.Append("<se:SvgParameter name=\"fill\">#000000</se:SvgParameter>");
            sld.Append("</se:Fill>");
            sld.Append("</se:Mark>");
            sld.Append("<se:Size>12</se:Size>");
            sld.Append("</se:Graphic>");
            sld.Append("</se:PointSymbolizer>");
            sld.Append("<se:PolygonSymbolizer>");
            sld.Append("<se:Fill>");
            sld.Append("<se:SvgParameter name=\"fill\">#2E8C7C</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"fill-opacity\">255</se:SvgParameter>");
            sld.Append("</se:Fill>");
            sld.Append("<se:Stroke>");
            sld.Append("<se:SvgParameter name=\"stroke\">#206055</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-opacity\">255</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-width\">1</se:SvgParameter>");
            sld.Append("</se:Stroke>");
            sld.Append("</se:PolygonSymbolizer>");
            sld.Append("<se:LineSymbolizer>");
            sld.Append("<se:Stroke>");
            sld.Append("<se:SvgParameter name=\"stroke\">#000000</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-width\">1</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-opacity\">255</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-dasharray\">Solid</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-linecap\">Flat</se:SvgParameter>");
            sld.Append("<se:SvgParameter name=\"stroke-linejoin\">Miter</se:SvgParameter>");
            sld.Append("</se:Stroke>");
            sld.Append("</se:LineSymbolizer>");
            sld.Append("</se:Rule>");
            sld.Append("</se:FeatureTypeStyle>");
            sld.Append("</sld:UserStyle>");
            sld.Append("</sld:UserStyles>");
            sld.Append("</sld:UserLayer>");
            sld.Append("</sld:StyledLayerDescriptor>");
            sld.Append("</SLD>");

            StringDictionary parameters = new StringDictionary();

            parameters.Add(WmsParameters.Styles, "default");
            parameters.Add(WmsParameters.Width, "512");
            parameters.Add(WmsParameters.Height, "512");
            parameters.Add(WmsParameters.Crs, "EPSG:4326");
            parameters.Add(WmsParameters.Layers, "world_admin");
            parameters.Add(WmsParameters.BgColor, "0x0000FF");
            parameters.Add("version", "1.3.0");
            parameters.Add(WmsParameters.Format, "image/png");
            parameters.Add("request", "GetMap");
            parameters.Add(WmsParameters.Bbox, "-180,-85,180,85");
            parameters.Add(WmsParameters.SldBody, sld.ToString());

            ViewContext context = new ViewContext();

            // add context details inline for test, this is normally done by ViewContext(parameters)
            // which applies details from configuration files etc.
            context.General.Window.Width  = 512;
            context.General.Window.Height = 512;

            Layer layer = new Layer();

            layer.Title            = "World Administration Boundaries";
            layer.Table            = "world_admin";
            layer.Name             = "world_admin";
            layer.GeometryColumn   = "shape";
            layer.FeatureIdColumn  = "fid";
            layer.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Projects\\GeospatialServices\\TestGeospatialServices\\Input\\Runtime\\TestGeospatialServicesDatabase.mdf;Integrated Security=True;User Instance=True";

            Style     style     = new Style();
            UserLayer userLayer = new UserLayer();

            userLayer.UserStyles = new List <UserStyle>();
            UserStyle         userStyle        = new UserStyle();
            FeatureTypeStyle  featureTypeStyle = new FeatureTypeStyle();
            Rule              rule             = new Rule();
            PolygonSymbolizer polygon          = new PolygonSymbolizer();

            style.Name     = "default";
            userLayer.Name = "World in green";
            polygon.Fill.SvgParameters.Add(new SvgParameter("fill", "#2E8C7C"));

            BaseSymbolizer[] symbolizers = new BaseSymbolizer[] { polygon };
            rule.Symbolizers = symbolizers;
            featureTypeStyle.Rules.Add(rule);
            userStyle.FeatureTypeStyles.Add(featureTypeStyle);
            userLayer.UserStyles.Add(userStyle);
            style.SLD.StyledLayerDescriptor.UserLayers.Add(userLayer);
            layer.StyleList.Add(style);
            context.Layers.Add(layer);

            System.Drawing.Image mapImage = context.Render(parameters);
        }
        public ActionResult ViewLoginhistory(int?page)
        {
            UserLayer ulayer = new UserLayer();

            return(View(ulayer.Loginhistory.ToList().ToPagedList(page ?? 1, 15)));
        }
Exemplo n.º 29
0
        public CallsCountModel GetCallsCount()
        {
            UserLayer layer = new UserLayer();

            return(layer.GetCallsCount());
        }
Exemplo n.º 30
0
 internal MouseManager(List <UserLayer> userLayers, OperationLayer operationLayer) : this()
 {
     __defaultLayer = userLayers[0];
     __userLayers   = userLayers;
     __opLayer      = operationLayer;
 }
Exemplo n.º 31
0
 /// <summary>
 /// Create a new LineCurveSeriesEngine.
 /// </summary>
 /// <param name="parent_layer">The parent UserLayer for the re-editable DrawingLayer.</param>
 /// <param name="drawing_layer">An existing ReEditableLayer to reuse. This is for cloning only. If not cloning, pass in null.</param>
 /// <param name="shape_type">The owner EditEngine.</param>
 /// <param name="antialiasing">Whether or not antialiasing is enabled.</param>
 /// <param name="closed">Whether or not the shape is closed (first and last points are connected).</param>
 /// <param name="outline_color">The outline color for the shape.</param>
 /// <param name="fill_color">The fill color for the shape.</param>
 /// <param name="brush_width">The width of the outline of the shape.</param>
 public LineCurveSeriesEngine(UserLayer parentLayer, ReEditableLayer?passedDrawingLayer, BaseEditEngine.ShapeTypes passedShapeType,
                              bool passedAA, bool passedClosed, Color passedOutlineColor, Color passedFillColor, int passedBrushWidth) : base(parentLayer,
                                                                                                                                              passedDrawingLayer, passedShapeType, passedAA, passedClosed, passedOutlineColor, passedFillColor, passedBrushWidth)
 {
 }