コード例 #1
0
        public ActionResult SignUp(JobSeekerViewModel jsm)
        {
            List <tblUser> lst = _db.tblUsers.Where(u => u.Username == jsm.Username).ToList();

            if (lst.Count == 0)
            {
                if (jsm.Password != jsm.RetypePassword)
                {
                    ViewBag.Message = "Password Mismatch";
                }
                else
                {
                    string  password = encryptpass(jsm.Password);
                    tblUser tbu      = new tblUser();
                    tbu.Username = jsm.Username;
                    tbu.Password = password;
                    _db.tblUsers.Add(tbu);
                    _db.SaveChanges();

                    tblUserRole tbur = new tblUserRole();
                    tbur.UserId = tbu.UserId;
                    tbur.RoleId = 3;
                    _db.tblUserRoles.Add(tbur);
                    _db.SaveChanges();

                    tblJobSeeker tbj = new tblJobSeeker();
                    tbj.FullName        = jsm.FullName;
                    tbj.Gender          = jsm.Gender;
                    tbj.Email           = jsm.Email;
                    tbj.Address         = jsm.Address;
                    tbj.Skills          = jsm.Skills;
                    tbj.JobType         = jsm.JobType;
                    tbj.CurrentPosition = jsm.CurrentPosition;
                    tbj.HighestDegree   = jsm.HighestDegree;
                    tbj.ExpectedSalary  = jsm.ExpectedSalary;
                    tbj.Experience      = jsm.Experience;
                    tbj.UserId          = tbu.UserId;

                    HttpPostedFileBase fup = Request.Files["Resume"];
                    if (fup != null)
                    {
                        if (fup.FileName != "")
                        {
                            tbj.Resume = fup.FileName;
                            fup.SaveAs(Server.MapPath("~/ResumeUpload/" + fup.FileName));
                        }
                    }
                    _db.tblJobSeekers.Add(tbj);
                    _db.SaveChanges();
                    ViewBag.Message = "Your Account was created successfully";
                    RefreshPageControl();
                }
            }
            else
            {
                ViewBag.Message = "Username already exists!!!";
            }

            return(View());
        }
コード例 #2
0
        public ActionResult AddOrEdit(UserViewModel uv)
        {
            using (OnlineVotingSystemEntities db = new OnlineVotingSystemEntities())
            {
                tblUser tb = new tblUser();
                tb.UserName          = uv.UserName;
                tb.Password          = OnlineVotingSystemForCollege.Models.EncryptPassword.textToEncrypt(uv.Password);
                tb.Fullname          = uv.FullName;
                tb.Email             = uv.Email;
                tb.EmailVerification = true;

                db.tblUsers.Add(tb);
                db.SaveChanges();

                tblUserRole ud = new tblUserRole();
                ud.UserId = tb.UserId;
                ud.RoleId = 1;
                db.tblUserRoles.Add(ud);
                db.SaveChanges();
                ViewBag.Message = "User Created Successfully";


                return(RedirectToAction("ManageUser"));
            }
        }
コード例 #3
0
        public ActionResult AddOrEdit(UserViewModel uv)
        {
            tbluser tb = new tbluser();

            tb.Username = uv.Username;
            tb.Email    = uv.Email;
            tb.Password = uv.Password;

            HttpPostedFileBase fup = Request.Files["Photo"];

            if (fup != null)
            {
                if (fup.FileName != "")
                {
                    tb.Photo = fup.FileName;
                    fup.SaveAs(Server.MapPath("~/images/" + fup.FileName));
                }
            }
            _db.tblusers.Add(tb);
            _db.SaveChanges();

            tblUserRole ud = new tblUserRole();

            ud.UserId     = tb.UserId;
            ud.UserRoleId = 1;
            _db.tblUserRoles.Add(ud);
            _db.SaveChanges();
            ViewBag.Message = "User Created Successfully";


            return(View());
        }
コード例 #4
0
        public ActionResult Signup(UserViewModel uv)
        {
            tblUser tbl = db.tblUsers.Where(u => u.UserName == uv.UserName).FirstOrDefault();

            if (tbl != null)
            {
                return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet));
            }
            else
            {
                tblUser tb = new tblUser();
                tb.UserName = uv.UserName;
                tb.Password = uv.Password;
                tb.Fullname = uv.FullName;
                tb.Email    = uv.Email;
                db.tblUsers.Add(tb);
                db.SaveChanges();

                tblUserRole ud = new tblUserRole();
                ud.UserId = tb.UserId;
                ud.RoleId = 2;
                db.tblUserRoles.Add(ud);
                db.SaveChanges();
                return(Json(new { success = true, message = "User Register Successfully" }, JsonRequestBehavior.AllowGet));
            }
        }
コード例 #5
0
        public ActionResult AddOrEdit(UserViewModel sm)
        {
            using (ELaundryDBEntities db = new ELaundryDBEntities())
            {
                tblUser tb       = new tblUser();
                string  password = Utilities.Base64Encode(sm.Password);
                tb.Username = sm.Username;
                tb.Password = password;
                tb.Fullname = sm.Fullname;

                db.tblUsers.Add(tb);
                db.SaveChanges();

                tblUserRole tu = new tblUserRole();
                tu.RoleId = sm.RoleId;
                tu.UserId = tb.UserId;
                db.tblUserRoles.Add(tu);
                db.SaveChanges();

                tblUserBranch br = new tblUserBranch();
                br.UserId   = tb.UserId;
                br.BranchId = sm.BranchId;
                db.tblUserBranches.Add(br);
                db.SaveChanges();
                return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
            }
        }
コード例 #6
0
        public long UpdateRoleUser(long UserID, int RoleID)
        {
            long result = 0;

            try
            {
                tblUserRole userRole = new tblUserRole {
                    UserId = UserID, RoleId = RoleID
                };
                using (var db = ContextFactory.UsTransportEntities())
                {
                    var updaterole = db.tblUserRoles.FirstOrDefault(u => u.UserId == UserID);
                    if (updaterole != null)
                    {
                        updaterole.RoleId = RoleID;
                        if (db.SaveChanges() > 0)
                        {
                            result = updaterole.Id;
                        }
                    }
                    else
                    {
                        db.tblUserRoles.Add(userRole);
                        db.SaveChanges();
                        result = userRole.Id;
                    }
                }
            }
            catch (Exception)
            {
            }

            return(result);
        }
コード例 #7
0
        public DataModel.UserRoles UpdateUserRole(DataModel.UserRoles obj)
        {
            tblUserRole userrole = new tblUserRole();

            userrole.RoleID               = obj.RoleID;
            userrole.RoleName             = obj.RoleName;
            userrole.RoleAbbrivation      = obj.RoleAbbrivation;
            userrole.CreatedBy            = obj.CreatedBy;
            userrole.CreatedAt            = obj.CreatedAt;
            userrole.UpdatedBy            = obj.UpdatedBy;
            userrole.UpdatedAt            = obj.UpdatedAt;
            userrole.IsActive             = obj.IsActive;
            context.Entry(userrole).State = EntityState.Modified;
            context.SaveChanges();
            return(obj);
        }
コード例 #8
0
        public tblUserRole Select(string UserName)
        {
            tblUserRole result = new tblUserRole();

            try
            {
                using (var db = ContextFactory.UsTransportEntities())
                {
                    long userID = db.tblUsers.Where(x => x.Username.Contains(UserName)).Select(x => x.Id).FirstOrDefault();
                    result = db.tblUserRoles.Where(x => x.UserId == userID).SingleOrDefault();
                }
            }
            catch (Exception)
            {
            }
            return(result);
        }
コード例 #9
0
        public tblUserRole Select(string UserName)
        {
            tblUserRole result = new tblUserRole();

            try
            {
                using (var db = ContextFactory.UsTransportEntities())
                {
                    long userID = db.tblUsers.FirstOrDefault(x => x.Username.Contains(UserName))?.Id ?? -1;
                    result = db.tblUserRoles.SingleOrDefault(x => x.UserId == userID);
                }
            }
            catch (Exception ex)
            {
                SELog.WriteLog("RoleService => Select", ex);
            }
            return(result);
        }
コード例 #10
0
        public DataModel.UserRoles AddUserRole(DataModel.UserRoles obj)
        {
            try
            {
                //CustomResponse response = new CustomResponse();
                var existing = context.tblUserRoles.Where(u => u.RoleID == obj.RoleID).FirstOrDefault();
                if (obj.RoleID != 0)
                {
                    return(UpdateUserRole(obj));
                }
                tblUserRole userrole = new tblUserRole();
                userrole.RoleName        = obj.RoleName;
                userrole.RoleAbbrivation = obj.RoleAbbrivation;
                userrole.CreatedBy       = obj.CreatedBy;
                userrole.CreatedAt       = DateTime.Now;
                userrole.UpdatedBy       = obj.UpdatedBy;
                userrole.UpdatedAt       = DateTime.Now;
                userrole.IsActive        = obj.IsActive;
                if (existing != null)
                {
                    obj.ErrorMessage = "User Role with same name already exists";
                    obj.Success      = false;
                    obj.CreatedAt    = existing.CreatedAt.Value;
                    obj.UpdatedAt    = existing.UpdatedAt.Value;
                    return(obj);
                }
                context.tblUserRoles.Add(userrole);
                context.SaveChanges();

                //Assuming the database is generating your Id's for you
                obj.RoleID       = userrole.RoleID;
                obj.Success      = true;
                obj.CreatedAt    = DateTime.Now;
                obj.UpdatedAt    = DateTime.Now;
                obj.ErrorMessage = "User role saved successfully";
            }
            catch (Exception ex)
            {
                obj.ErrorMessage = ex.Message;
                obj.Success      = false;
            }
            return(obj);
        }
コード例 #11
0
        public ActionResult Create(UserViewModel uvm)
        {
            tblUser tb = new tblUser();

            tb.RoleId   = uvm.RoleId;
            tb.UserName = uvm.UserName;
            tb.Password = uvm.Password;

            tb.FullName          = uvm.FullName;
            tb.Email             = uvm.Email;
            tb.CitizenshipNumber = uvm.CitizenshipNumber;

            _db.tblUsers.Add(tb);
            _db.SaveChanges();
            int         latestUserId = tb.UserId;
            tblUserRole userRole     = new tblUserRole();

            userRole.UserId = latestUserId;
            userRole.RoleId = tb.RoleId;
            _db.tblUserRoles.Add(userRole);
            _db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #12
0
        public ActionResult Registration(RegistrationViewModel uv)
        {
            using (OnlineVotingSystemEntities db = new OnlineVotingSystemEntities())
            {
                tblUser tbl = db.tblUsers.Where(u => u.UserName == uv.UserName || u.Email == uv.Email).FirstOrDefault();
                if (tbl != null)
                {
                    return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet));
                }
                else
                {
                    tblUser tb = new tblUser();
                    tb.UserName          = uv.UserName;
                    tb.Password          = OnlineVotingSystemForCollege.Models.EncryptPassword.textToEncrypt(uv.Password);
                    tb.Fullname          = uv.FullName;
                    tb.Email             = uv.Email;
                    tb.EmailVerification = false;
                    tb.ActivationCode    = Guid.NewGuid();
                    db.tblUsers.Add(tb);
                    db.SaveChanges();

                    tblUserRole ud = new tblUserRole();
                    ud.UserId = tb.UserId;
                    ud.RoleId = 2;
                    db.tblUserRoles.Add(ud);
                    db.SaveChanges();

                    tblIdRequest tbid = new tblIdRequest();
                    tbid.UserEmail = tb.Email;
                    tbid.FullName  = tb.Fullname;
                    tbid.UserId    = tb.UserId;
                    db.tblIdRequests.Add(tbid);
                    db.SaveChanges();
                    return(Json(new { success = true, message = "Registration Completed . A Email would be send to your email" + tb.Email + "If You are a Valid User" }, JsonRequestBehavior.AllowGet));
                }
            }
        }
コード例 #13
0
        public ActionResult AddOrEdit(UserViewModel uv)
        {
            using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities())
            {
                tblUser tb = new tblUser();
                tb.UserName = uv.UserName;
                tb.Password = uv.Password;
                tb.Fullname = uv.FullName;
                tb.Email    = uv.Email;

                db.tblUsers.Add(tb);
                db.SaveChanges();

                tblUserRole ud = new tblUserRole();
                ud.UserId = tb.UserId;
                ud.RoleId = 1;
                db.tblUserRoles.Add(ud);
                db.SaveChanges();
                ViewBag.Message = "User Created Successfully";


                return(RedirectToAction("ManageUser"));
            }
        }
コード例 #14
0
        public LoginModel loginUser(LoginModel model)
        {
            LoginModel _LoginModel = new LoginModel();

            try
            {
                List <tblUserRole> _tblUserRole = new List <tblUserRole>();
                bool    FirstLog = false;
                tblUser _tblUser = new tblUser();

                tblUserLog _tblUserLog = new tblUserLog();
                model.Username = model.Username.Trim();
                model.Password = model.Password.Trim();
                model.Password = EncryptUtil.EncryptString(model.Password);


                model.Username = model.Username.ToLower();



                _tblUser = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username && x.Password == model.Password && x.IsActive == true && x.IsBlocked == false).FirstOrDefault();


                if (_tblUser != null)
                {
                    _tblUser.tblUserRole    = null;
                    _tblUser.InvalidAttempt = 0;
                    _ItblUserRepository.Update(_tblUser);
                    List <tblRole> _tblUserRole2 = _ItblUserRoleRepository.Get(x => x.FKUser == _tblUser.PKUser && x.IsActive == true).Select(s =>
                                                                                                                                              s.tblRole
                                                                                                                                              ).ToList();

                    foreach (var data in _tblUserRole2)
                    {
                        tblUserRole temp = new tblUserRole();
                        temp.tblRole = data;
                        temp.FKRole  = data.PKRole;

                        _tblUserRole.Add(temp);
                    }


                    _tblUserLog.LoginSuccess = true;
                    _tblUserLog.FKUser       = _tblUser.PKUser;

                    lastLogin = _ItblUserLogRepository.Get(x => x.UserName == _tblUser.Email && x.LoginSuccess == true).ToList();
                    if (lastLogin != null && lastLogin.Count > 0 && _tblUser.IsChangePassword == true)
                    {
                        FirstLog = true;
                    }
                    else
                    {
                        FirstLog = false;
                    }
                }

                else
                {
                    _tblUser = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username && x.Password == model.Password && x.IsActive == true && x.IsBlocked == true).FirstOrDefault();


                    if (_tblUser != null)
                    {
                        _LoginModel.ErrorMessage = "Your account has been blocked. Please contact to the administrator!";
                    }
                    else
                    {
                        _tblUser = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username).FirstOrDefault();


                        if (_tblUser != null)
                        {
                            _tblUser.tblUserRole    = null;
                            _tblUserLog.FKUser      = _tblUser.PKUser;
                            _tblUser.InvalidAttempt = _tblUser.InvalidAttempt + 1;
                            _ItblUserRepository.Update(_tblUser);
                        }
                        _tblUserLog.LoginSuccess = false;
                        _LoginModel.ErrorMessage = "Invalid Username Or Password";
                    }
                }


                _tblUserLog.UserName  = model.Username;
                _tblUserLog.Password  = model.Password;
                _tblUserLog.LoginTime = DateTime.Now;
                _tblUserLog.IPAddress = context.HttpContext.Connection.RemoteIpAddress.ToString();
                _tblUserLog.Origin    = model.Origin;
                _tblUserLog.IsActive  = true;
                _ItblUserLogRepository.Add(_tblUserLog);
                if (_tblUser != null && _tblUser.InvalidAttempt > 3)
                {
                    tblUser _tblUser1 = new tblUser();

                    _tblUser1 = _ItblUserRepository.Get(x => x.Email.ToLower() == model.Username).FirstOrDefault();



                    if (_tblUser1 != null)
                    {
                        _tblUser1.IsBlocked  = true;
                        _tblUser.IsBlocked   = true;
                        _tblUser.tblUserRole = null;
                        _ItblUserRepository.Update(_tblUser1);
                    }
                }

                if (_tblUser != null)
                {
                    _tblUser.IsActive    = FirstLog;
                    _tblUser.tblUserRole = _tblUserRole;
                    if (_tblUserLog.LoginSuccess == false)
                    {
                        _tblUser = null;
                    }
                    else
                    {
                        _tblUser.Password = null;
                    }
                }

                _LoginModel.Users = _tblUser;
                if (_LoginModel.ErrorMessage != null && _LoginModel.ErrorMessage.Length > 0)
                {
                    _LoginModel.Users = null;
                }
                return(_LoginModel);
            }
            catch (Exception ex)
            {
                _LoginModel.ErrorMessage = ex.Message;
                log.Fatal("login:", ex);
                throw ex;
            }
        }
コード例 #15
0
        public ActionResult Registration(StudentRegistrationViewModel ts = null, WardenRegistrationViewModel tw = null)
        {
            tbluser us = new tbluser();

            if (ts.StudentUserName != null)
            {
                if (ts.StudentId == 0)
                {
                    tblStudent         student = new tblStudent();
                    HttpPostedFileBase pic     = Request.Files["StudentPhoto"];
                    HttpPostedFileBase avt     = Request.Files["AvatarPhoto"];
                    student.UserName         = ts.StudentUserName;
                    student.StudentName      = ts.StudentName;
                    student.PermanentAddress = ts.PermanentAddress;
                    student.TemporaryAddress = ts.TemporaryAddress;
                    student.Phone            = ts.StudentPhone;
                    student.Email            = ts.StudentEmail;
                    student.Education        = ts.Education;
                    student.DOB         = ts.DOB;
                    student.Age         = Convert.ToInt32(DateTime.Now.Year) - Convert.ToInt32(student.DOB.Value.Year);
                    student.Photo       = pic.FileName;
                    student.AvatarPhoto = avt.FileName;
                    student.UserName    = ts.StudentUserName;
                    student.Password    = ts.StudentPassword;
                    us.UserName         = ts.StudentUserName;
                    us.Password         = ts.StudentPassword;
                    us.Email            = ts.StudentEmail;
                    if (pic.ContentLength > 0)
                    {
                        pic.SaveAs(Path.Combine(Server.MapPath("~/Images/Student"), pic.FileName));
                    }
                    if (avt.ContentLength > 0)
                    {
                        avt.SaveAs(Path.Combine(Server.MapPath("~/Images/Student"), avt.FileName));
                    }
                    db.tblusers.Add(us);
                    db.tblStudents.Add(student);
                    db.SaveChanges();
                    tbluser     tb = db.tblusers.Where(x => x.UserName == student.UserName).FirstOrDefault();
                    tblUserRole tr = new tblUserRole();
                    tr.UserId = tb.UserId;
                    tr.RoleId = 2;
                    db.tblUserRoles.Add(tr);
                    db.SaveChanges();
                }
                else
                {
                    StudentRegistrationViewModel sm = ts;
                    tblStudent         student      = db.tblStudents.Where(x => x.StudentId == sm.StudentId).FirstOrDefault();
                    HttpPostedFileBase pic          = Request.Files["StudentPhoto"];
                    HttpPostedFileBase avt          = Request.Files["AvatarPhoto"];
                    student.UserName         = sm.StudentUserName;
                    student.StudentName      = sm.StudentName + " " + sm.StudentSurName;
                    student.PermanentAddress = sm.PermanentAddress;
                    student.TemporaryAddress = sm.TemporaryAddress;
                    student.Phone            = sm.StudentPhone;
                    student.Email            = sm.StudentEmail;
                    student.Education        = sm.Education;
                    student.DOB         = sm.DOB;
                    student.Testomonial = sm.Testomonial;
                    student.Age         = Convert.ToInt32(DateTime.Now.Year) - Convert.ToInt32(student.DOB.Value.Year);
                    if (pic.ContentLength > 0)
                    {
                        System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Student/"), sm.StudentPhoto));
                        student.Photo = pic.FileName;
                        avt.SaveAs(Path.Combine(Server.MapPath("~/Images/Student/"), pic.FileName));
                    }
                    if (avt.ContentLength > 0)
                    {
                        System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Student/"), sm.AvatarPhoto));
                        student.AvatarPhoto = avt.FileName;
                        avt.SaveAs(Path.Combine(Server.MapPath("~/Images/Student/"), avt.FileName));
                    }
                    student.UserName = sm.StudentUserName;
                    student.Password = sm.StudentPassword;
                    foreach (var item in db.tblusers.ToList())
                    {
                        if (item.UserName == User.Identity.Name)
                        {
                            item.UserName = sm.StudentUserName;
                            item.Email    = sm.StudentEmail;
                            item.Password = sm.StudentPassword;
                        }
                    }
                    db.SaveChanges();
                    return(RedirectToAction("Index", "Opening"));
                }
            }

            if (tw.UserName != null)
            {
                if (tw.WardenId == 0)
                {
                    tblWarden          warden = new tblWarden();
                    HttpPostedFileBase fup    = Request.Files["Photo"];
                    var filename = fup.FileName;
                    warden.WardenName    = tw.WardenName + " " + tw.WardenSurName;
                    warden.WardenAddress = tw.WardenAddress;
                    warden.WardenPhone   = tw.WardenPhone;
                    warden.Email         = tw.Email;
                    warden.Photo         = filename;
                    warden.UserName      = tw.UserName;
                    warden.Password      = tw.Password;
                    us.UserName          = tw.UserName;
                    us.Password          = tw.Password;
                    us.Email             = tw.Email;
                    if (fup.ContentLength > 0)
                    {
                        fup.SaveAs(Path.Combine(Server.MapPath("~/Images/Warden/"), fup.FileName));
                    }
                    db.tblusers.Add(us);
                    db.tblWardens.Add(warden);
                    db.SaveChanges();
                    tbluser tb = db.tblusers.Where(x => x.UserName == warden.UserName).FirstOrDefault();

                    tblUserRole tr = new tblUserRole();
                    tr.UserId = tb.UserId;
                    tr.RoleId = 3;
                    db.tblUserRoles.Add(tr);
                    db.SaveChanges();
                }
                else
                {
                    tblWarden          warden = db.tblWardens.Where(x => x.WardenId == tw.WardenId).FirstOrDefault();
                    HttpPostedFileBase fup    = Request.Files["Photo"];
                    warden.WardenName    = tw.WardenName + " " + tw.WardenSurName;
                    warden.WardenAddress = tw.WardenAddress;
                    warden.WardenPhone   = tw.WardenPhone;
                    warden.Email         = tw.Email;
                    warden.Password      = tw.Password;
                    if (fup.ContentLength > 0)
                    {
                        System.IO.File.Delete(Path.Combine(Server.MapPath("~/Images/Warden/"), tw.Photo));
                        warden.Photo = fup.FileName;
                        fup.SaveAs(Path.Combine(Server.MapPath("~/Images/Warden/"), fup.FileName));
                    }

                    warden.UserName = tw.UserName;
                    foreach (var item in db.tblusers.ToList())
                    {
                        if (item.UserName == User.Identity.Name)
                        {
                            item.Password = tw.Password;
                            item.UserName = tw.UserName;
                            item.Email    = tw.Email;
                        }
                    }
                    db.SaveChanges();
                    return(RedirectToAction("Index", "Opening"));
                }
            }
            return(RedirectToAction("Login", "Account"));
        }
コード例 #16
0
        /// <summary>

        public static int UserRegistration(RegisterModel model)
        {
            try
            {
                using (var context = new IOASDBEntities())

                {
                    using (var transaction = context.Database.BeginTransaction())
                    {
                        tblUserRole objuserrole = new tblUserRole();

                        if (model.UserId == 0)
                        {
                            try
                            {
                                tblUser reg     = new tblUser();
                                var     chkuser = context.tblUser.FirstOrDefault(dup => dup.UserName == model.Username && dup.Status == "Active");
                                if (chkuser != null)
                                {
                                    return(2);
                                }
                                reg.FirstName    = model.Firstname;
                                reg.LastName     = model.Lastname;
                                reg.RoleId       = model.RoleId;
                                reg.UserName     = model.Username;
                                reg.Password     = Cryptography.Encrypt(model.Password, "LFPassW0rd");
                                reg.Dateofbirth  = model.Dateofbirth;
                                reg.DepartmentId = model.Department;
                                reg.Gender       = model.Gender;
                                reg.CRTDDateTS   = DateTime.Now;
                                reg.UPDTDateTS   = DateTime.Now;
                                string Username = model.Createuser;
                                reg.CreatedUserId = Common.GetUserid(Username);
                                reg.Email         = model.Username;
                                reg.Status        = "Active";
                                reg.UserImage     = model.Image;
                                context.tblUser.Add(reg);
                                context.SaveChanges();
                                if (model.SelectedRoles != null)
                                {
                                    var userid = (from U in context.tblUser
                                                  where (U.UserName == model.Username)
                                                  select U.UserId).FirstOrDefault();
                                    model.UserId = userid;
                                    for (int i = 0; i < model.SelectedRoles.Length; i++)
                                    {
                                        objuserrole.UserId      = model.UserId;
                                        objuserrole.RoleId      = model.SelectedRoles[i];
                                        objuserrole.Delegated_f = false;
                                        context.tblUserRole.Add(objuserrole);
                                        context.SaveChanges();
                                    }
                                }
                                transaction.Commit();
                            }
                            catch (Exception ex)
                            {
                                transaction.Rollback();
                                return(-1);
                            }
                            return(1);
                        }
                        else
                        {
                            var objupdateuser = context.tblUser.Where(U => U.UserId == model.UserId).FirstOrDefault();
                            if (objupdateuser != null)
                            {
                                try
                                {
                                    objupdateuser.UserId    = model.UserId;
                                    objupdateuser.FirstName = model.Firstname;
                                    objupdateuser.LastName  = model.Lastname;
                                    objupdateuser.RoleId    = model.RoleId;
                                    //bjupdateuser.UserName = model.Username;
                                    //reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd");
                                    objupdateuser.Dateofbirth  = model.Dateofbirth;
                                    objupdateuser.DepartmentId = model.Department;
                                    objupdateuser.Gender       = model.Gender;
                                    objupdateuser.UPDTDateTS   = DateTime.Now;
                                    string Username = model.Createuser;
                                    objupdateuser.LastUpdateUserId = Common.GetUserid(Username);
                                    //objupdateuser.Email = model.Username;
                                    if (model.Image != null)
                                    {
                                        objupdateuser.UserImage = model.Image;
                                    }

                                    context.SaveChanges();

                                    var username = (from U in context.tblUser
                                                    where (U.UserId == model.UserId)
                                                    select U.UserName).FirstOrDefault();
                                    model.Username = username;
                                    var query = (from R in context.tblUserRole
                                                 where (R.UserId == model.UserId)
                                                 select R).ToList();
                                    if (query.Count > 0)
                                    {
                                        context.tblUserRole.RemoveRange(query);
                                        context.SaveChanges();
                                    }
                                    if (model.SelectedRoles != null)
                                    {
                                        for (int i = 0; i < model.SelectedRoles.Length; i++)
                                        {
                                            objuserrole.UserId      = model.UserId;
                                            objuserrole.RoleId      = model.SelectedRoles[i];
                                            objuserrole.Delegated_f = false;
                                            context.tblUserRole.Add(objuserrole);
                                            context.SaveChanges();
                                        }
                                    }
                                    transaction.Commit();
                                }
                                catch (Exception ex)
                                {
                                    transaction.Rollback();
                                    return(-1);
                                }
                            }
                            return(3);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                return(-1);
            }
        }
コード例 #17
0
        public ActionResult EmployerSignUp(EmployerViewModel em)
        {
            if (ModelState.IsValid)
            {
                List <tblUser> lst = _db.tblUsers.Where(u => u.Username == em.Username).ToList();
                if (lst.Count == 0)
                {
                    if (em.Password != null)
                    {
                        if (em.Password != em.RetypePassword)
                        {
                            ViewBag.Message = "Password Mismatch";
                        }
                        else
                        {
                            string  password = encryptpass(em.Password);
                            tblUser tbu      = new tblUser();
                            tbu.Username = em.Username;
                            tbu.Password = password;
                            _db.tblUsers.Add(tbu);
                            _db.SaveChanges();

                            tblUserRole tbur = new tblUserRole();
                            tbur.UserId = tbu.UserId;
                            tbur.RoleId = 2;
                            _db.tblUserRoles.Add(tbur);
                            _db.SaveChanges();

                            tblEmployer tbe = new tblEmployer();
                            tbe.CompanyName    = em.CompanyName;
                            tbe.ContactPerson  = em.ContactPerson;
                            tbe.Phone          = em.Phone;
                            tbe.Email          = em.Email;
                            tbe.CompanyWebsite = em.CompanyWebsite;
                            tbe.Location       = em.Location;
                            tbe.CompanyDetails = em.CompanyDetails;
                            tbe.UserId         = tbu.UserId;

                            HttpPostedFileBase fup = Request.Files["Logo"];
                            if (fup != null)
                            {
                                if (fup.FileName != "")
                                {
                                    tbe.Logo = fup.FileName;
                                    fup.SaveAs(Server.MapPath("~/CompanyLogo/" + fup.FileName));
                                }
                            }
                            _db.tblEmployers.Add(tbe);
                            _db.SaveChanges();
                            ViewBag.Message = "Your Account was created successfully";
                        }
                    }
                    else
                    {
                        ViewBag.Message = "Password Field is empty";
                    }
                }
                else
                {
                    ViewBag.Message = "Username already exists!!!";
                }
            }

            return(View());
        }