Esempio n. 1
0
        public IHttpActionResult Register(AccountModel user)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            List <user> existsLoginOrMail = _db.user.Where(x => x.login == user.Login || x.mail == user.Mail).ToList();

            if (existsLoginOrMail.Count > 0)
            {
                return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Login or Mail exists")));
            }

            using (DbContextTransaction dbtransaction = _db.Database.BeginTransaction())
            {
                try
                {
                    user newUser = new user()
                    {
                        login    = user.Login,
                        password = Auth.HashPassword(user.Password),
                        mail     = user.Mail
                    };
                    _db.user.Add(newUser);
                    _db.SaveChanges();

                    roles     roles        = _db.roles.Where(x => x.name == "user").First();
                    userRoles newUserRoles = new userRoles()
                    {
                        userId  = newUser.id,
                        rolesId = roles.id
                    };

                    _db.userRoles.Add(newUserRoles);
                    _db.SaveChanges();

                    newUser.rolesId = newUserRoles.id;

                    _db.user.Attach(newUser);
                    _db.Entry(newUser).State = EntityState.Modified;
                    _db.SaveChanges();

                    dbtransaction.Commit();
                }
                catch
                {
                    dbtransaction.Rollback();
                    return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Register user failed!")));
                }

                return(Ok());
            }
        }
Esempio n. 2
0
        public async Task <ActionResult> USERACCESS()
        {
            List <userRoles> userRolesList = new List <userRoles>();

            using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["DatabaseServer"].ToString()))
            {
                if (con.State == System.Data.ConnectionState.Closed || con.State == System.Data.ConnectionState.Broken)
                {
                    await con.OpenAsync();
                }
                string SQLCMD = "exec dbo.COPR16_CUST_REPORT_USELIST";
                using (var cmd = con.CreateCommand())
                {
                    cmd.CommandText = SQLCMD;
                    DbDataReader reader = await cmd.ExecuteReaderAsync();

                    {
                        //var model = Utils.Serialize((SqlDataReader)reader);
                        while (reader.Read())
                        {
                            userRoles data = new userRoles();
                            data.UserName       = reader["UID"].ToString();
                            data.UserRoles      = reader["ROLES"].ToString();
                            data.ExpireDateTime = reader["EXPIRE"] != DBNull.Value ? Convert.ToDateTime(reader["EXPIRE"]) : default(DateTime);
                            data.NeverExpire    = reader["NEVER_EXPIRE"] != DBNull.Value ? Convert.ToBoolean(reader["NEVER_EXPIRE"]) : default(bool);
                            data.CreateDate     = reader["CREATEDATE"] != DBNull.Value ? Convert.ToDateTime(reader["CREATEDATE"]): default(DateTime);
                            data.CreateBy       = reader["CREATEBY"].ToString();
                            data.UpdateDate     = reader["UPDATEDATE"] != DBNull.Value ? Convert.ToDateTime(reader["UPDATEDATE"]) : default(DateTime);
                            data.UpdateBy       = reader["UPDATEBY"].ToString();

                            userRolesList.Add(data);
                        }
                    }
                }
            }
            return(View(userRolesList));
        }