public void UpdateRole(VSEC_ROLE_MST vsec_role_mst)
        {
            try
            {
                if (vsec_role_mst != null)
                {
                    VSEC_ROLE_MST obj = new VSEC_ROLE_MST
                    {
                        RoleId      = vsec_role_mst.RoleId,
                        RoleSName   = vsec_role_mst.RoleSName,
                        DisplayName = vsec_role_mst.DisplayName,
                        ActiveFlag  = vsec_role_mst.Status == "A" ? "Y" : "N",
                        Status      = vsec_role_mst.Status,
                        MC_Status   = vsec_role_mst.Status,
                        CreatedBy   = vsec_role_mst.CreatedBy,
                        CreatedOn   = DateTime.Now,
                        LastUpDtBy  = vsec_role_mst.CreatedBy,
                        LastUpDtOn  = DateTime.Now
                    };

                    _db.VSEC_ROLE_MST.Attach(obj);
                    _db.Entry(obj).State = EntityState.Modified;
                    _db.SaveChanges();
                }
            }
            catch (Exception e)
            {
                throw;
            }
        }
        public void CreatRole(VSEC_ROLE_MST vsec_role_mst)
        {
            try
            {
                if (vsec_role_mst != null)
                {
                    VSEC_ROLE_MST obj = new VSEC_ROLE_MST
                    {
                        RoleId      = 0,
                        RoleSName   = vsec_role_mst.RoleSName,
                        DisplayName = vsec_role_mst.DisplayName,
                        ActiveFlag  = "Y",
                        Status      = "A",
                        MC_Status   = "A",
                        CreatedBy   = vsec_role_mst.CreatedBy,
                        CreatedOn   = DateTime.Now
                    };

                    _db.VSEC_ROLE_MST.Add(obj);
                    _db.SaveChanges();
                }
            }
            catch (Exception e)
            {
                throw;
            }
        }
        public VSEC_ROLE_MST GetRoleByID(int ID)
        {
            try
            {
                _db.Configuration.ProxyCreationEnabled = false;

                VSEC_ROLE_MST vsec_role_mst = _db.VSEC_ROLE_MST.Where(r => r.RoleId == ID).SingleOrDefault();
                return(vsec_role_mst);
            }
            catch (Exception e)
            {
                throw;
            }
        }
        // GET: RoleCRUD
        public JsonResult UpdateRole(VSEC_ROLE_MST vsec_role_mst)
        {
            try
            {
                string Message = string.Empty;
                bool   flag    = false;

                try
                {
                    if (vsec_role_mst != null)
                    {
                        string LoginID = string.Empty;
                        GVObjDict = new Dictionary <string, string>();
                        GVObjDict = (Dictionary <string, string>)Session["GMVSession"];
                        GVObjDict.TryGetValue("LoginID", out LoginID);

                        vsec_role_mst.CreatedBy = LoginID;
                        _IVSEC_ROLE_MST.UpdateRole(vsec_role_mst);

                        Message = "Role Updated Successfully";
                        flag    = true;
                    }
                    else
                    {
                        return(Json("Failed"));
                    }
                }
                catch (Exception e)
                {
                    Message = "Role updation failed! Please try again";;
                }

                return(new JsonResult {
                    Data = new { Message = Message, Status = flag }
                });
            }
            catch (Exception e)
            {
                throw;
            }
        }