예제 #1
0
        public async Task <ActionResult> Create([Bind(Include = "S_Id,SchoolName,Address,ContactNo,AltContactNo,FaxNo,Email,Website,Logo,RegistrationNo,DiseNo,IndexNo,EstablishedYear,Class,SchoolType")] SchoolInfo schoolInfo)
        {
            if (ModelState.IsValid)
            {
                db.SchoolInfoes.Add(schoolInfo);
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }

            ViewBag.SchoolType = new SelectList(db.SchoolTypes, "Type", "Type", schoolInfo.SchoolType);
            return(View(schoolInfo));
        }
예제 #2
0
        public async Task <ActionResult> Create([Bind(Include = "RoleId,RoleName,Description")] Role role)
        {
            var    name     = db.Users.ToList().Where(a => a.Email == WebSecurity.CurrentUserName);
            string username = "";

            foreach (var p in name)
            {
                username = p.Username;
            }
            if (ModelState.IsValid)
            {
                db.Roles.Add(role);
                await db.SaveChangesAsync(username);

                System.Web.HttpContext.Current.Session["NOT"] = "You have successfully added the Role";

                return(RedirectToAction("Index"));
            }

            return(View(role));
        }
예제 #3
0
        public async Task <ActionResult> Create([Bind(Include = "ModulesID,ModulesName,RoleID,glyphicon,ControllerName,ViewName,Name,IsWebForm,webFormUrl,MenuRank")] Module modules)
        {
            var    name     = db.Users.ToList().Where(a => a.Email == WebSecurity.CurrentUserName);
            string username = "";

            foreach (var p in name)
            {
                username = p.Username;
            }
            if (ModelState.IsValid)
            {
                db.Modules.Add(modules);
                await db.SaveChangesAsync(username);

                System.Web.HttpContext.Current.Session["NOT"] = "You have successfully added the Module";

                return(RedirectToAction("Index"));
            }

            ViewBag.RoleID = new SelectList(db.Roles, "RoleId", "RoleName", modules.RoleID);
            var list4 = db.glyphicons.ToList();
            //Create List of SelectListItem
            List <SelectListItem> selectlist4 = new List <SelectListItem>();

            selectlist4.Add(new SelectListItem()
            {
                Text = "", Value = ""
            });
            foreach (var row in list4)
            {
                //Adding every record to list
                selectlist4.Add(new SelectListItem {
                    Text = row.glyphiconname, Value = row.glyphiconname.ToString()
                });
            }
            ViewBag.Dlyp = selectlist4;
            return(View(modules));
        }
예제 #4
0
        public async Task <ActionResult> Edit([Bind(Include = "UserId,Username,Email,Password,ConfirmPassword,FirstName,LastName,IsActive,LockCount,CreateDate,role,BrokerName,BrokerCode")] User user)
        {
            var    name     = db.Users.ToList().Where(a => a.Email == WebSecurity.CurrentUserName);
            string username = "";

            foreach (var p in name)
            {
                username = p.Username;
            }
            string name3 = WebSecurity.CurrentUserName;
            var    userw = db.Users.ToList().Where(a => a.Email == name3);
            int?   myid  = 0;
            string names = "";

            foreach (var row in userw)
            {
                myid  = row.UserId;
                names = row.Username;
            }
            int check = db.Users.ToList().Where(a => a.Email == user.Email && a.UserId != user.UserId).Count();

            if (ModelState.IsValid)
            {
                //db.Entry(user).State = EntityState.Modified;
                db.Users.AddOrUpdate(user);
                await db.SaveChangesAsync(names);

                System.Web.HttpContext.Current.Session["NOT"] = "You have successfully updated the user";

                //updateuserroles
                //var roles = db.Roles.ToList().Where(a => a.RoleName == user.role);
                //int role = 0;
                //foreach (var c in roles)
                //{
                //    role = c.RoleId;
                //}

                //openconn();
                //sql = "Update UserRoles set RoleId='" + role + "' where UserId='" + user.UserId + "'";
                //cmd = new System.Data.SqlClient.SqlCommand(sql, conn);
                //cmd.ExecuteNonQuery();
                //closeconn();

                return(RedirectToAction("Index"));
            }
            string name2 = WebSecurity.CurrentUserName;
            var    user2 = db.Users.ToList().Where(a => a.Email == name2);

            ViewBag.Users = "";
            foreach (var row in user2)
            {
                ViewBag.Users = row.FirstName + " " + row.LastName;
            }
            if (check >= 1)
            {
                var mod = ModelState.First(c => c.Key == "Email");  // this
                mod.Value.Errors.Add("Duplicate emails are not allowed");
            }



            ////Create List of SelectListItem
            List <SelectListItem> selectlist2 = new List <SelectListItem>();

            selectlist2.Add(new SelectListItem()
            {
                Text = user.BrokerName, Value = user.BrokerName
            });

            ViewBag.Sell = selectlist2;
            return(View(user));
        }
예제 #5
0
        public async Task <ActionResult> Create([Bind(Include = "UserId,Username,Email,Password,ConfirmPassword,FirstName,LastName,IsActive,LockCount,CreateDate,role,BrokerName,BrokerCode")] User user)
        {
            var    name     = db.Users.ToList().Where(a => a.Email == WebSecurity.CurrentUserName);
            string username = "";

            foreach (var p in name)
            {
                username = p.Username;
            }
            var list3 = db.Roles.ToList();

            //Create List of SelectListItem
            List <SelectListItem> selectlist = new List <SelectListItem>();

            selectlist.Add(new SelectListItem()
            {
                Text = "", Value = ""
            });
            foreach (var row in list3)
            {
                //Adding every record to list

                selectlist.Add(new SelectListItem {
                    Text = row.RoleName, Value = row.RoleName.ToString()
                });
            }
            ViewBag.Role = selectlist;
            int check = db.Users.ToList().Where(a => a.Email == user.Email).Count();

            if (check >= 1)
            {
                var mod = ModelState.First(c => c.Key == "Email");  // this
                mod.Value.Errors.Add("Duplicate emails are not allowed");
            }

            string h = "";

            if (user.BrokerCode == "")
            {
                user.BrokerCode = "MORCO";
                user.BrokerName = "Dry Associates";
            }
            if (ModelState.IsValid && check < 1)
            {
                string name4 = WebSecurity.CurrentUserName;
                var    userw = db.Users.ToList().Where(a => a.Email == name4);
                int?   myid  = 0;
                string names = "";
                foreach (var row in userw)
                {
                    myid  = row.UserId;
                    names = row.Username;
                }

                if (Request["role"] != "")
                {
                    //Role role = new Role {RoleName = Request["Roles"] };
                    string fullname = Request["role"];
                    var    role     = db.Roles.ToList().Where(a => a.RoleName == fullname);



                    //sql query


                    user.Password        = Request["Password"].ToString();
                    user.ConfirmPassword = Request["ConfirmPassword"].ToString();
                    user.Password        = ComputeHash(user.Password, new SHA256CryptoServiceProvider());
                    user.ConfirmPassword = ComputeHash(user.ConfirmPassword, new SHA256CryptoServiceProvider());
                    user.CreateDate      = DateTime.Now;
                    user.LockCount       = 0;
                    user.role            = Request["role"].ToString();
                    if (user.BrokerCode == null)
                    {
                        user.BrokerCode = "MORCO";
                        user.BrokerName = "Dry Associates";
                    }
                    db.Users.Add(user);
                    await db.SaveChangesAsync(names);

                    System.Web.HttpContext.Current.Session["NOT"] = "You have successfully added the user";



                    int roleid = 0;
                    int userid = 0;
                    foreach (var row in role)
                    {
                        roleid = row.RoleId;
                    }
                    int user2 = db.Users.Max(a => a.UserId);

                    userid = user2;
                    string cs = ConfigurationManager.ConnectionStrings["SBoardConnection"].ConnectionString;

                    using (SqlConnection cn = new SqlConnection(cs))
                    {
                        string sql =
                            "INSERT INTO UserRoles (UserId,RoleId) VALUES (@UserId,@RoleId)";
                        SqlCommand cmd = new SqlCommand(sql);
                        cmd.CommandType = CommandType.Text;
                        cmd.Connection  = cn;
                        cmd.Parameters.AddWithValue("@UserId", userid);
                        cmd.Parameters.AddWithValue("@RoleId", roleid);

                        cn.Open();
                        try
                        {
                            cmd.ExecuteNonQuery();
                            cn.Close();
                        }
                        catch (Exception)
                        {
                            throw;
                        }
                    }
                    // user.Roles.Add(role);
                }
                return(RedirectToAction("Index"));
            }
            else
            {
            }
            string name2 = WebSecurity.CurrentUserName;
            var    user3 = db.Users.ToList().Where(a => a.Email == name2);

            ViewBag.Users = "";
            foreach (var row in user3)
            {
                ViewBag.Users = row.FirstName + " " + row.LastName;
            }

            ////Create List of SelectListItem
            List <SelectListItem> selectlist2 = new List <SelectListItem>();

            selectlist2.Add(new SelectListItem()
            {
                Text = user.BrokerName, Value = user.BrokerName
            });

            return(View(user));
        }