コード例 #1
0
        public JsonResult GetUserInfo(EPortal.Models.UserInfo Userinfo)
        {
            //string orgid = Session["OrgId"].ToString();

            string orgid = User.OrgId;


            UserList UserinfoUser = new UserList();

            using (EPortalEntities entity = new EPortalEntities())
            {
                UserinfoUser = (from o in entity.UserInfoes
                                where o.Id == Userinfo.Id &&
                                o.OrganizationID == orgid
                                select new UserList
                {
                    Id = o.Id,
                    Code = o.Code,
                    Name = o.Name,
                    LogInId = o.LogInId,
                    IsApplicant = o.IsApplicant.Value,
                    MobileNo = o.MobileNo,
                    Email = o.Email,
                    Operation = "Edit",
                    DateOfBirth = o.DateOfBirth.Value,
                    ImageUrl = "/Home/GetFile?fileid=" + o.Id
                }).FirstOrDefault();
            }
            return(Json(UserinfoUser, JsonRequestBehavior.AllowGet));
        }
コード例 #2
0
        public JsonResult DeleteUser(EPortal.Models.UserInfo Userinfo)
        {
            //string orgid = Session["OrgId"].ToString();

            string orgid    = User.OrgId;
            string errormsg = string.Empty;
            int    result   = 0;

            // validation = EPortal.Utility.Utility.ValidateProperty(orgdata.Code, "Required");

            using (EPortalEntities entity = new EPortalEntities())
            {
                var checkreferance = (from r in entity.ApplicantTests
                                      where r.OrganizationID == orgid &&
                                      r.ApplicantId == Userinfo.Id
                                      select r).FirstOrDefault();
                if (checkreferance != null)
                {
                    errormsg = "Operation conflict:Operation cannot be performed.Record already in Used.";
                }
                else
                {
                    entity.Entry(Userinfo).State = System.Data.Entity.EntityState.Deleted;
                    result = entity.SaveChanges();
                }
            }

            return(Json(new { result = result > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
        }
コード例 #3
0
        public JsonResult ChangePassword(changePassword password)
        {
            string orgid       = User.OrgId.ToString();
            string userid      = User.UserId.ToString();
            int    result      = 0;
            string msg         = "";
            bool   sendmailper = false;

            EPortal.Models.UserInfo model = null;
            using (EPortalEntities entity = new EPortalEntities())
            {
                model = (from u in entity.UserInfoes
                         where u.OrganizationID == orgid &&
                         u.Id == userid
                         select u).FirstOrDefault();
                if (model != null)
                {
                    if (model.UserPassword == password.oldpassword)
                    {
                        model.UserPassword        = password.newpassword;
                        entity.Entry(model).State = System.Data.Entity.EntityState.Modified;
                        result = entity.SaveChanges();

                        if (result > 0)
                        {
                            var checkformail = (from mc in entity.EMailConfigurations
                                                where mc.OrganizationId == orgid
                                                select mc).FirstOrDefault();
                            if (checkformail != null)
                            {
                                if (checkformail.AfterChangePasswordMail == true)
                                {
                                    sendmailper = true;
                                }
                            }
                        }
                    }
                    else
                    {
                        msg = "Please enter valid current password.";
                    }
                }
            }

            if (sendmailper == true && (model.Email != null || model.Email != ""))
            {
                string body     = "Hi " + model.Name + ",just now your password is change.if not you ,please contact us.";
                string heading  = model.Name + " your password change";
                bool   sendmail = SendMail(model.Email, heading, body, null);
            }

            return(Json(new { result = result > 0 ? true : false, msg = msg }, JsonRequestBehavior.AllowGet));
        }
コード例 #4
0
        public JsonResult ActivateUser(string Userid)
        {
            int    result = 0;
            string msg    = string.Empty;
            //string orgid = Session["OrgId"].ToString();
            string orgid = User.OrgId;

            EPortal.Models.UserRole Userrole = null;
            EPortal.Models.UserInfo userinfo = null;
            using (EPortalEntities entity = new EPortalEntities())
            {
                Userrole = (from us in entity.UserRoles
                            where us.OrganizationID == orgid &&
                            us.UserId == Userid
                            select us).FirstOrDefault();
                userinfo = (from u in entity.UserInfoes
                            where u.OrganizationID == orgid &&
                            u.Id == Userid
                            select u).FirstOrDefault();
                if (userinfo != null)
                {
                    if (userinfo.NoOfLogin.HasValue && userinfo.NoOfLogin.Value == 1)
                    {
                        userinfo.NoOfLogin           = null;
                        entity.Entry(userinfo).State = System.Data.Entity.EntityState.Modified;
                    }
                }
                if (Userrole != null)
                {
                    Userrole.RowState = true;

                    entity.Entry(Userrole).State = System.Data.Entity.EntityState.Modified;
                    result = entity.SaveChanges();
                }
                else
                {
                    msg = "Please assign role for selected user.";
                }
            }

            return(Json(new { result = result > 0 ? true : false, msg = msg }, JsonRequestBehavior.AllowGet));
        }
コード例 #5
0
        public ActionResult Login(EPortal.Models.UserInfo Userinfo)
        {
            if (Userinfo == null)
            {
                throw new ArgumentNullException(nameof(Userinfo));
            }

            JavaScriptSerializer serializer = new JavaScriptSerializer();

            EPortal.Models.Organization org      = null;
            EPortal.Models.UserInfo     Userdata = null;
            EPortal.Models.UserRole     Userrole = null;
            bool sendmailper = false;

            using (EPortalEntities entity = new EPortalEntities())
            {
                try
                {
                    org = (from o in entity.Organizations
                           where o.Code == Userinfo.OrganizationName
                           select o).FirstOrDefault();
                }
                catch (Exception)
                {
                }
                if (org != null)
                {
                    Userdata = (from u in entity.UserInfoes
                                where u.OrganizationID == org.Id &&
                                u.LogInId == Userinfo.LogInId &&
                                u.UserPassword == Userinfo.UserPassword
                                select u).FirstOrDefault();
                    if (Userdata != null)
                    {
                        Userrole = (from ro in entity.UserRoles
                                    where ro.OrganizationID == org.Id &&
                                    ro.UserId == Userdata.Id &&
                                    ro.RowState == true
                                    select ro).FirstOrDefault();
                    }
                    var checkformail = (from mc in entity.EMailConfigurations
                                        where mc.OrganizationId == org.Id
                                        select mc).FirstOrDefault();
                    if (checkformail != null)
                    {
                        if (checkformail.AfterLoginMail == true)
                        {
                            sendmailper = true;
                        }
                    }
                }
            }
            if (Userdata != null && Userrole != null)
            {
                CustomPrincipalSerializeModel serializeModel = new CustomPrincipalSerializeModel();
                //FormsAuthentication.SetAuthCookie(Userdata.LogInId, true);

                serializeModel.OrgId = org.Id;
                //Session["OrgId"] = org.Id;

                // Session["OrgName"] = org.Name;
                serializeModel.OrgName = org.Name;

                //Session["UserId"] = Userdata.Id;
                serializeModel.UserId = Userdata.Id;

                //Session["UserName"] = Userdata.Name;
                serializeModel.UserName = Userdata.Name;

                //Session["ISApplicant"] = Userdata.IsApplicant;
                serializeModel.ISApplicant = Userdata.IsApplicant.ToString();

                if (Userrole != null)
                {
                    //Session["RoleId"] = Userrole.RoleId;
                    serializeModel.RoleId = Userrole.RoleId;
                }
                string userData = serializer.Serialize(serializeModel);
                //FormsAuthentication.SetAuthCookie(Userdata.LogInId, true);
                FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket(
                    1,
                    Userinfo.LogInId,
                    DateTime.Now,
                    DateTime.Now.AddMinutes(15),
                    false,
                    userData.ToString(),
                    FormsAuthentication.FormsCookiePath);
                string     encTicket = FormsAuthentication.Encrypt(GetAuthTicket(GetAuthTicket1(authTicket: authTicket)));
                HttpCookie faCookie  = new HttpCookie(FormsAuthentication.FormsCookieName, GetEncTicket(encTicket));
                Response.Cookies.Add(cookie: faCookie);
                int cookieSize = Encoding.UTF8.GetByteCount(faCookie.Values.ToString());
                if (sendmailper == true)
                {
                    //getting client ip address
                    string ipAddress = Request.UserHostAddress.ToString();

                    //getting client browser name
                    string browserName = Request.Browser.Browser.ToString();

                    //getting client browser version



                    string body    = "Hi,Just now someone login to youe acocunt with IP:" + ipAddress + ",Browser:" + browserName + Request.Browser.Version.ToString() + ",If not you please contact us.";
                    string heading = "User login Details:";
                    if (Userdata.Email != null || Userdata.Email != "")
                    {
                        bool sendmail = SendMail(Userdata.Email, heading, body, null);
                    }
                }

                //var log = new logWriter("Login Successful for user:"******"UserHome"));
            }
            else
            {
                Session["InvalidUser"] = true;
                return(Redirect("/Home/Index"));
            }
        }
コード例 #6
0
 public ActionResult LostPasswordCheck(EPortal.Models.UserInfo lostpassword)
 {
     return(Json(true, JsonRequestBehavior.AllowGet));
 }
コード例 #7
0
        public JsonResult fileUpload(HttpPostedFileBase filedata)
        {
            EPortal.Models.Previleage        Previleageforadmin     = null;
            EPortal.Models.UserRole          Userroleforadmin       = new UserRole();
            List <EPortal.Models.Previleage> Previleageforadminlist = new List <Previleage>();
            List <EPortal.Models.Page>       getPage = new List <Page>();


            string errormsg      = string.Empty;
            int    resultforsave = 0;
            var    data          = Request.Files[0];
            bool   fileerror     = false;

            if (!Request.Files[0].ContentType.Contains("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"))
            {
                errormsg  = "Please select Excel file only.";
                fileerror = true;
            }
            if (fileerror == false)
            {
                #region Excel FIle upload
                //string orgid = Session["OrgId"].ToString();

                string orgid = User.OrgId;

                string path = string.Empty;
                //FileStream stream = new FileStream(data.FileName, FileMode.Open, FileAccess.Read);
                Excel.IExcelDataReader excelReader;
                excelReader = Excel.ExcelReaderFactory.CreateOpenXmlReader(data.InputStream);
                excelReader.IsFirstRowAsColumnNames = true;
                DataSet result = excelReader.AsDataSet();
                List <EPortal.Models.UserInfo> useinfolist = new List <UserInfo>();
                EPortal.Models.UserInfo        useinfo     = null;

                using (EPortalEntities entity = new EPortalEntities())
                {
                    if (result.Tables.Count > 0)
                    {
                        foreach (var item in result.Tables[0].Rows)
                        {
                            string loginid = ((System.Data.DataRow)item).ItemArray[2].ToString();
                            string code    = ((System.Data.DataRow)item).ItemArray[0].ToString();

                            var checkexist = (from u in entity.UserInfoes
                                              where u.OrganizationID == orgid &&
                                              (u.LogInId == loginid || u.Code == code)
                                              select u).ToList();
                            if (checkexist.Count() > 0)
                            {
                                errormsg = "One or more User already exist with same Details.";
                                break;
                            }
                            if (!EmailValidate(((System.Data.DataRow)item).ItemArray[4].ToString()))
                            {
                                errormsg = "One or more User have invalid emailid.";
                                break;
                            }
                            if (errormsg == "")
                            {
                                useinfo         = new UserInfo();
                                useinfo.Id      = Guid.NewGuid().ToString();
                                useinfo.Code    = ((System.Data.DataRow)item).ItemArray[0].ToString();
                                useinfo.Name    = ((System.Data.DataRow)item).ItemArray[1].ToString();
                                useinfo.LogInId = loginid;
                                DateTime password = Convert.ToDateTime(((System.Data.DataRow)item).ItemArray[3].ToString());
                                useinfo.UserPassword   = loginid;
                                useinfo.DateOfBirth    = Convert.ToDateTime(((System.Data.DataRow)item).ItemArray[3].ToString());
                                useinfo.OrganizationID = orgid;
                                useinfo.RowState       = true;
                                useinfo.CreateDateTime = System.DateTime.Now;
                                useinfo.Email          = ((System.Data.DataRow)item).ItemArray[4].ToString();
                                useinfo.IsApplicant    = Convert.ToBoolean(Convert.ToInt16(((System.Data.DataRow)item).ItemArray[5].ToString()));
                                useinfo.MobileNo       = null;
                                useinfo.PhotoPath      = null;
                                useinfo.NoOfLogin      = null;



                                if (Convert.ToBoolean(Convert.ToInt16(((System.Data.DataRow)item).ItemArray[5].ToString())))
                                {
                                    useinfo.UserType = "40";
                                    #region For Applicant
                                    var roleid = (from r in entity.RoleMasters
                                                  where r.OrganizationID == orgid &&
                                                  r.Code == "Applicant"
                                                  select r).FirstOrDefault();

                                    Userroleforadmin                = new UserRole();
                                    Userroleforadmin.Id             = Guid.NewGuid().ToString();
                                    Userroleforadmin.UserId         = useinfo.Id;
                                    Userroleforadmin.RoleId         = roleid.Id;
                                    Userroleforadmin.OrganizationID = orgid;
                                    Userroleforadmin.RowState       = true;
                                    Userroleforadmin.CreateDateTime = System.DateTime.Now;
                                    entity.UserRoles.Add(Userroleforadmin);


                                    var checkroleexist = (from r in entity.Previleages
                                                          where r.OrganizationID == orgid &&
                                                          r.RoleId == roleid.Id
                                                          select r).ToList();

                                    if (checkroleexist.Count() == 0)
                                    {
                                        #region Get All Page
                                        getPage = (from p in entity.Pages
                                                   where p.Code != "Organization" &&
                                                   p.ForAdmin == false
                                                   select p).ToList();
                                        if (getPage.Count() > 0)
                                        {
                                            foreach (Page itemp in getPage)
                                            {
                                                Previleageforadmin                = new Previleage();
                                                Previleageforadmin.Id             = Guid.NewGuid().ToString();
                                                Previleageforadmin.RoleId         = roleid.Id;
                                                Previleageforadmin.PageId         = itemp.Id;
                                                Previleageforadmin.OperationId    = string.Empty;
                                                Previleageforadmin.PCreate        = true;
                                                Previleageforadmin.PUpdate        = true;
                                                Previleageforadmin.PDelete        = true;
                                                Previleageforadmin.PView          = true;
                                                Previleageforadmin.OrganizationID = orgid;
                                                Previleageforadmin.RowState       = true;
                                                Previleageforadmin.CreateDateTime = System.DateTime.Now;
                                                Previleageforadminlist.Add(Previleageforadmin);
                                            }
                                        }
                                        #endregion

                                        foreach (Previleage itempre in Previleageforadminlist)
                                        {
                                            entity.Entry(itempre).State = System.Data.Entity.EntityState.Added;
                                            entity.Previleages.Add(itempre);
                                        }
                                    }
                                    #endregion
                                }
                                entity.Entry(useinfo).State = System.Data.Entity.EntityState.Added;
                                entity.UserInfoes.Add(useinfo);
                            }
                        }
                    }
                    else
                    {
                        errormsg = "Selected file is empty.No Data found.";
                    }

                    if (errormsg == string.Empty)
                    {
                        try
                        {
                            resultforsave = entity.SaveChanges();
                        }
                        catch (Exception ex)
                        {
                        }
                    }
                }
                #endregion
            }
            return(Json(new { result = resultforsave > 0 ? true : false, errormsg = errormsg }, JsonRequestBehavior.AllowGet));
        }
コード例 #8
0
        public JsonResult SaveUser(EPortal.Models.UserInfo UserInfo)
        {
            string errormsg = "";
            int    result   = 0;
            //string orgid = Session["OrgId"].ToString();
            string orgid = User.OrgId;



            #region Operation save

            EPortal.Models.Previleage        Previleageforadmin     = null;
            EPortal.Models.UserRole          Userroleforadmin       = new UserRole();
            List <EPortal.Models.Previleage> Previleageforadminlist = new List <Previleage>();
            List <EPortal.Models.Page>       getPage = new List <Page>();



            using (EPortalEntities entity = new EPortalEntities())
            {
                if (UserInfo.Operation == "Create")
                {
                    var checkforloginid = (from u in entity.UserInfoes
                                           where u.OrganizationID == orgid &&
                                           (u.LogInId == UserInfo.LogInId || u.Code == UserInfo.Code)
                                           select u).FirstOrDefault();
                    if (checkforloginid == null)
                    {
                        UserInfo.Id             = Guid.NewGuid().ToString();
                        UserInfo.OrganizationID = orgid;
                        UserInfo.RowState       = true;
                        UserInfo.CreateDateTime = System.DateTime.Now;
                        // string password = UserInfo.DateOfBirth.Value.Day + "-" + UserInfo.DateOfBirth.Value.Month + "-" + UserInfo.DateOfBirth.Value.Year;
                        UserInfo.UserPassword = UserInfo.LogInId;
                        UserInfo.IsApplicant  = UserInfo.IsApplicant;
                        UserInfo.MobileNo     = null;
                        if (UserInfo.Email == null || UserInfo.Email == "")
                        {
                            UserInfo.Email = null;
                        }
                        else
                        {
                            UserInfo.Email = UserInfo.Email;
                        }

                        UserInfo.PhotoPath           = null;
                        UserInfo.NoOfLogin           = null;
                        UserInfo.UserType            = "40";
                        entity.Entry(UserInfo).State = System.Data.Entity.EntityState.Added;
                        entity.UserInfoes.Add(UserInfo);

                        if (UserInfo.IsApplicant == true)
                        {
                            try
                            {
                                #region For Applicant
                                var roleid = (from r in entity.RoleMasters
                                              where r.OrganizationID == orgid &&
                                              r.Code == "Applicant"
                                              select r).FirstOrDefault();

                                Userroleforadmin                = new UserRole();
                                Userroleforadmin.Id             = Guid.NewGuid().ToString();
                                Userroleforadmin.UserId         = UserInfo.Id;
                                Userroleforadmin.RoleId         = roleid.Id;
                                Userroleforadmin.OrganizationID = orgid;
                                Userroleforadmin.RowState       = true;
                                Userroleforadmin.CreateDateTime = System.DateTime.Now;
                                entity.UserRoles.Add(Userroleforadmin);


                                var checkroleexist = (from r in entity.Previleages
                                                      where r.OrganizationID == orgid &&
                                                      r.RoleId == roleid.Id
                                                      select r).ToList();

                                if (checkroleexist.Count() == 0)
                                {
                                    #region Get All Page

                                    var getorgpage = (from p in entity.OrganizationPages
                                                      where p.OrganizationID == orgid
                                                      select p).ToList();

                                    getPage = (from p in entity.Pages
                                               where p.Code != "Organization" &&
                                               p.ForAdmin == false
                                               select p).ToList();
                                    if (getPage.Count() > 0)
                                    {
                                        foreach (var item in getorgpage)
                                        {
                                            Previleageforadmin                = new Previleage();
                                            Previleageforadmin.Id             = Guid.NewGuid().ToString();
                                            Previleageforadmin.RoleId         = roleid.Id;
                                            Previleageforadmin.PageId         = item.PageId;
                                            Previleageforadmin.OperationId    = string.Empty;
                                            Previleageforadmin.PCreate        = true;
                                            Previleageforadmin.PUpdate        = true;
                                            Previleageforadmin.PDelete        = true;
                                            Previleageforadmin.PView          = true;
                                            Previleageforadmin.OrganizationID = orgid;
                                            Previleageforadmin.RowState       = true;
                                            Previleageforadmin.CreateDateTime = System.DateTime.Now;
                                            Previleageforadminlist.Add(Previleageforadmin);
                                        }
                                    }
                                    #endregion

                                    foreach (Previleage item in Previleageforadminlist)
                                    {
                                        entity.Entry(item).State = System.Data.Entity.EntityState.Added;
                                        entity.Previleages.Add(item);
                                    }
                                }
                                #endregion
                            }
                            catch (Exception ex)
                            {
                                errormsg = ex.Message;
                            }
                        }
                    }
                    else
                    {
                        errormsg = "User already exist with same details.";
                    }
                    try
                    {
                        if (errormsg == "")
                        {
                            result = entity.SaveChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        errormsg = ex.Message;
                    }
                }
                else
                {
                    EPortal.Models.UserInfo usedata = (from o in entity.UserInfoes
                                                       where o.OrganizationID == orgid &&
                                                       o.Id == UserInfo.Id
                                                       select o
                                                       ).FirstOrDefault();
                    usedata.Code                = UserInfo.Code;
                    usedata.Name                = UserInfo.Name;
                    usedata.LogInId             = UserInfo.LogInId;
                    usedata.IsApplicant         = UserInfo.IsApplicant;
                    usedata.MobileNo            = UserInfo.MobileNo;
                    usedata.Email               = UserInfo.Email;
                    entity.Entry(usedata).State = System.Data.Entity.EntityState.Modified;
                    try
                    {
                        result = entity.SaveChanges();
                    }
                    catch (Exception ex)
                    {
                        errormsg = ex.Message;
                    }
                }
            }
            #endregion


            #region Send Mail
            if (UserInfo.Operation == "Create" && (UserInfo.Email != null || UserInfo.Email != ""))
            {
                bool sendmailper = false;
                using (EPortalEntities entity = new EPortalEntities())
                {
                    var checkformail = (from mc in entity.EMailConfigurations
                                        where mc.OrganizationId == orgid
                                        select mc).FirstOrDefault();
                    if (checkformail != null)
                    {
                        if (checkformail.UserCreationMail == true)
                        {
                            sendmailper = true;
                        }
                    }
                }
                if (sendmailper == true)
                {
                    string body     = "please find your UserName and Password below for E-Assessment.in ,UserName:"******" and Password :"******"";
                    string heading  = "Applicant " + UserInfo.Name + " created";
                    bool   sendmail = homecontroller.SendMail(UserInfo.Email, heading, body, null);
                }
            }
            #endregion


            return(Json(new { result = result > 0 ? true : false, errormsg = errormsg, id = UserInfo.Id }, JsonRequestBehavior.AllowGet));
        }