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);
}
