public bool Add(UserAttachment user) { using (SqlConnection con = new SqlConnection(conStr)) { SqlCommand cmd = con.CreateCommand(); con.Open(); cmd.CommandText = "dbo.AddUserAttachment"; cmd.CommandType = System.Data.CommandType.StoredProcedure; var LoginParam = new SqlParameter() { DbType = System.Data.DbType.String, ParameterName = "@Login", Value = user.Login, }; var PasswordParam = new SqlParameter() { DbType = System.Data.DbType.String, ParameterName = "@Password", Value = user.Password, }; cmd.Parameters.Add(LoginParam); cmd.Parameters.Add(PasswordParam); cmd.ExecuteNonQuery(); } return(true); }
public UserAttachment AddUser(string Login, string Password) { UserAttachment user = new UserAttachment { Login = Login, Password = Password }; if (_userAttachmentDao.Add(user)) { return(user); } throw new ArgumentException("Error on user added"); }
public IEnumerable <UserAttachment> GetAll() { HashSet <UserAttachment> userAttachment = new HashSet <UserAttachment>(); using (SqlConnection con = new SqlConnection(conStr)) { SqlCommand cmd = con.CreateCommand(); con.Open(); cmd.CommandText = "dbo.GetAllUsersAttachment"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sqlDataReader = cmd.ExecuteReader(); UserAttachment[] usersAttachment = new UserAttachment[] { }; while (sqlDataReader.Read()) { string Login = (string)sqlDataReader["Login"]; string Password = (string)sqlDataReader["Password"]; string Role = ""; HashSet <string> Roles = new HashSet <string> { }; if (!System.DBNull.Value.Equals(sqlDataReader["Role"])) { Role = (string)sqlDataReader["Role"]; Roles.Add(Role); } UserAttachment user = new UserAttachment { Login = Login, Password = Password, Roles = Roles }; UserAttachment SerchUser = userAttachment.FirstOrDefault(element => element.Login == user.Login); if (SerchUser != null && Role != "") { SerchUser.Roles.Add(Role); } else { userAttachment.Add(user); } } } return(userAttachment); }
public bool Add(UserAttachment user) { _userAttachment.Add(user.Login, user); Save(); return(true); }