コード例 #1
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult DeleteResource(Guid resourceId)
        {
            if (!User.Identity.IsAuthenticated)
                return View("NotLogged");

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == User.Identity.Name.ToLower()).Select(o => o.UserId).Single();
                var resource = session.RBEPortalData.Resources.Single(o => o.ResourceId == resourceId);

                resource.Status = "deleted";
                resource.ModifiedDate = DateTime.Now;
                resource.ModifiedBy = userId;

                session.RBEPortalData.SaveChanges();
            }

            return NewSearch();
        }
コード例 #2
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult DisplayResource(Guid resourceId)
        {
            var model = new DisplayResourceModel();

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                model.Resource = session.RBEPortalData.Resources
                    .Include(o => o.ModifiedByUser)
                    .Single(o => o.ResourceId == resourceId);

                model.Resource.Requests = session.RBEPortalData.Requests
                    .Where(o => o.ResourceId == resourceId && o.Status == "active")
                    .OrderBy(o => o.Location)
                    .Include(o => o.User)
                    .ToList();

                model.Resource.Shares = session.RBEPortalData.Shares
                    .Where(o => o.ResourceId == resourceId && o.Status == "active")
                    .OrderBy(o => o.Location)
                    .Include(o => o.User)
                    .ToList();
            }

            return View("DisplayResource", model);
        }
コード例 #3
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult SaveShare(ShareModel model)
        {
            if (!User.Identity.IsAuthenticated)
                return View("NotLogged");

            model.Share.Location = HttpUtility.HtmlDecode(model.Share.Location);

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == User.Identity.Name.ToLower()).Select(o => o.UserId).Single();

                Share share;
                if (model.Share.ShareId == Guid.Empty)
                    share = null;
                else
                    share = session.RBEPortalData.Shares.SingleOrDefault(o => o.ShareId == model.Share.ShareId);

                if (share == null) {
                    share = new Share {
                        ShareId = Guid.NewGuid(),
                        ResourceId = model.Share.ResourceId,
                        UserId = userId,
                        Status = "active",
                        CreationDate = DateTime.Now,
                    };
                    session.RBEPortalData.Shares.Add(share);
                }

                share.Amount = model.Share.Amount;
                share.UoM = model.Share.UoM;
                share.Location = model.Share.Location;
                share.ModifiedDate = DateTime.Now;
                share.ModifiedBy = userId;

                session.RBEPortalData.SaveChanges();
            }

            return DisplayResource(model.Share.ResourceId);
        }
コード例 #4
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult Search(MainModel model)
        {
            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == "valtor").Select(o => o.UserId).SingleOrDefault();
                if (userId == Guid.Empty) {
                    Membership.CreateUser("Valtor", "123456", "*****@*****.**");
                    userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == "valtor").Select(o => o.UserId).Single();
                }

                if (!session.RBEPortalData.Resources.Any()) {
                    session.RBEPortalData.Resources.Add(new Resource {
                        ResourceId = Guid.NewGuid(),
                        Name = "Rice",
                        Description = "Rice bio and home grown.",
                        Status = "active",
                        CreationDate = DateTime.Now,
                        ModifiedDate = DateTime.Now,
                        ModifiedBy = userId,
                    });
                    session.RBEPortalData.Resources.Add(new Resource {
                        ResourceId = Guid.NewGuid(),
                        Name = "Corn",
                        Description = "Corn bio and home grown.",
                        Status = "active",
                        CreationDate = DateTime.Now,
                        ModifiedDate = DateTime.Now,
                        ModifiedBy = userId,
                    });
                    session.RBEPortalData.Resources.Add(new Resource {
                        ResourceId = Guid.NewGuid(),
                        Name = "Amaranth",
                        Description = "Amaranth bio and home grown.",
                        Status = "active",
                        CreationDate = DateTime.Now,
                        ModifiedDate = DateTime.Now,
                        ModifiedBy = userId,
                    });
                    session.RBEPortalData.Resources.Add(new Resource {
                        ResourceId = Guid.NewGuid(),
                        Name = "Barley",
                        Description = "Barley bio and home grown.",
                        Status = "active",
                        CreationDate = DateTime.Now,
                        ModifiedDate = DateTime.Now,
                        ModifiedBy = userId,
                    });
                    session.RBEPortalData.Resources.Add(new Resource {
                        ResourceId = Guid.NewGuid(),
                        Name = "Milk",
                        Description = "Milk bio and full fat.",
                        Status = "active",
                        CreationDate = DateTime.Now,
                        ModifiedDate = DateTime.Now,
                        ModifiedBy = userId,
                    });
                    session.RBEPortalData.Resources.Add(new Resource {
                        ResourceId = Guid.NewGuid(),
                        Name = "Shampoo",
                        Description = "<p><span style='font-size:medium;'>Good Shampoo</span></p><p>For <strong>all</strong> <em>Hair</em> types</p><p></p>",
                        Status = "active",
                        CreationDate = DateTime.Now,
                        ModifiedDate = DateTime.Now,
                        ModifiedBy = userId,
                    });

                    session.RBEPortalData.SaveChanges();
                }

                if (model != null && !model.ResourceName.IsNullOrEmpty()) {
                    model.Resources = session.RBEPortalData.Resources
                        .Where(o => (o.Name.Contains(model.ResourceName) || o.Description.Contains(model.ResourceName)) &&
                                    o.Status == "active")
                        .OrderBy(o => o.Name)
                        .Include(o => o.ModifiedByUser)
                        .ToList();
                    if (model.Resources.Count < 1)
                        model.Resources = null;
                } else {
                    model.Resources = session.RBEPortalData.Resources
                        .Where(o => o.Status == "active")
                        .OrderBy(o => o.Name)
                        .Include(o => o.ModifiedByUser)
                        .ToList();
                }
            }

            return View("Search", model);
        }
コード例 #5
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult SaveResource(EditResourceModel model)
        {
            if (!User.Identity.IsAuthenticated)
                return View("NotLogged");

            model.Description = HttpUtility.HtmlDecode(model.Description);

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == User.Identity.Name.ToLower()).Select(o => o.UserId).Single();
                var resource = session.RBEPortalData.Resources.Single(o => o.ResourceId == model.Id);

                resource.Name = model.Name;
                resource.Description = model.Description;
                resource.ModifiedDate = DateTime.Now;
                resource.ModifiedBy = userId;

                //session.RBEPortalData.Resources.Add(res);
                session.RBEPortalData.SaveChanges();
            }

            return DisplayResource(model.Id);
        }
コード例 #6
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult SaveRequest(RequestModel model)
        {
            if (!User.Identity.IsAuthenticated)
                return View("NotLogged");

            model.Request.Location = HttpUtility.HtmlDecode(model.Request.Location);

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == User.Identity.Name.ToLower()).Select(o => o.UserId).Single();

                Request request;
                if (model.Request.RequestId == Guid.Empty)
                    request = null;
                else
                    request = session.RBEPortalData.Requests.SingleOrDefault(o => o.RequestId == model.Request.RequestId);

                if (request == null) {
                    request = new Request {
                        RequestId = Guid.NewGuid(),
                        ResourceId = model.Request.ResourceId,
                        UserId = userId,
                        Status = "active",
                        CreationDate = DateTime.Now,
                    };
                    session.RBEPortalData.Requests.Add(request);
                }

                request.Amount = model.Request.Amount;
                request.UoM = model.Request.UoM;
                request.Location = model.Request.Location;
                request.ModifiedDate = DateTime.Now;
                request.ModifiedBy = userId;

                session.RBEPortalData.SaveChanges();
            }

            return DisplayResource(model.Request.ResourceId);
        }
コード例 #7
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult SaveNewResource(CreateResourceModel model)
        {
            if (!User.Identity.IsAuthenticated)
                return View("NotLogged");

            model.Description = HttpUtility.HtmlDecode(model.Description);

            Resource res;
            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var userId = session.RBEPortalData.Users.Where(o => o.LoweredUserName == User.Identity.Name.ToLower()).Select(o => o.UserId).Single();

                res = new Resource {
                    ResourceId = Guid.NewGuid(),
                    Name = model.Name,
                    Description = model.Description,
                    Status = "active",
                    CreationDate = DateTime.Now,
                    ModifiedDate = DateTime.Now,
                    ModifiedBy = userId,
                };
                session.RBEPortalData.Resources.Add(res);
                session.RBEPortalData.SaveChanges();
            }

            return DisplayResource(res.ResourceId);
        }
コード例 #8
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult NewShare(Guid resourceId)
        {
            var model = new ShareModel();

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var resource = session.RBEPortalData.Resources.Single(o => o.ResourceId == resourceId);

                model.Share = new Share {
                    ResourceId = resourceId,
                    Resource = resource,
                };
            }

            return View("CreateShare", model);
        }
コード例 #9
0
ファイル: HomeController.cs プロジェクト: ValtorX/RBEPortal
        public ActionResult EditResource(Guid resourceId)
        {
            var model = new EditResourceModel();
            model.Id = resourceId;

            using (var session = new RBEPortalServer.RBEPortalContext()) {
                var resource = session.RBEPortalData.Resources.Single(o => o.ResourceId == resourceId);
                model.Name = resource.Name;
                model.Description = resource.Description;
            }

            return View("EditResource", model);
        }