private static void Add(AnimalUser item)
{
int id = GetLastId();
XDocument document = XDocument.Load("test.xml");
XElement element = new XElement("User",
new XAttribute(nameof(AnimalUser.Id), ++id),
new XAttribute(nameof(AnimalUser.Name), item.Name),
new XAttribute(nameof(AnimalUser.Role), item.Role),
new XAttribute(nameof(AnimalUser.Password), item.Password));
document.Element("root").Add(element);
document.Save("test.xml");
}
private static AnimalUser update(AnimalUser item)
{
XDocument document = XDocument.Load("test.xml");
var dbuser = getUsers().FirstOrDefault(a => a.Id);
}
private static void Main(string[] args)
{
Delete(3);
var users = GetUsers();
users.ForEach(u => Console.WriteLine(u));
Add(new AnimalUser
{
Id = 4,
Name = "Nowy",
Role = "Admin",
Password = "******"
});
//var users = new List<AnimalUser>();
//XDocument document = XDocument.Load("test.xml");
//List<XElement> elements = document.Element("Root").Elements().ToList();
//elements.ForEach(e =>
//{
// var user = new AnimalUser
// {
// Id = int.Parse(e.Attribute("Id").Value),
// Name = e.Attribute("Name").Value,
// Role = e.Attribute("Role").Value,
// Password = e.Attribute("Password").Value
// };
// users.Add(user);
//});
//users.ForEach(u => Console.WriteLine(u));
//Console.Read();
List <AnimalUser> GetUsers()
{
List <AnimalUser> result = new List <AnimalUser>();
var xd = XDocument.Load("test.xml");
var tempList = xd.Element("root").Elements("User").ToList();
tempList.ForEach(u =>
{
AnimalUser user = new AnimalUser();
user.Id = int.Parse(u.Attribute("Id").Value);
user.Name = u.Attribute("Name").Value.ToString();
user.Role = u.Attribute("Role").Value.ToString();
user.Password = u.Attribute("Password").Value.ToString();
result.Add(user);
});
return(result);
}
void Add(AnimalUser user)
{
int id = GetLastId();
var xd = XDocument.Load("test.xml");
XElement element = new XElement("User",
new XAttribute("Id", ++id),
new XAttribute("Name", user.Name),
new XAttribute("Role", user.Role),
new XAttribute("Password", user.Password)
);
xd.Element("root").Add(element);
xd.Save("test.xml");
}
int GetLastId()
{
return(GetUsers().Count != 0 ? GetUsers().Max(a => a.Id): 0);
}
bool Delete(int id)
{
var item = GetUsers().FirstOrDefault(a => a.Id == id);
var xd = XDocument.Load("test.xml");
if (item == null)
{
return(false);
}
xd.Element("root").Elements().Where(a => a.Attribute("Id").Value == item.Id.ToString()).Remove();
xd.Save("test.xml");
return(true);
}
AnimalUser Replace(AnimalUser item)
{
var dbitem = GetUsers().FirstOrDefault(a => a.Id == item.Id);
if (item != null)
{
Delete(dbitem.Id);
var xd = XDocument.Load("test.xml");
dbitem.Name = item.Name;
dbitem.Password = item.Password;
dbitem.Role = item.Role;
XElement element = new XElement("User",
new XAttribute("Id", dbitem.Id),
new XAttribute("Name", dbitem.Name),
new XAttribute("Role", dbitem.Role),
new XAttribute("Password", dbitem.Password)
);
xd.Element("root").Add(element);
xd.Save("test.xml");
return(dbitem);
}
}
//Names names = new Names();
//names.Add("Roman"); //1
//names.Add("Anna"); //2
//names.Add("Jarek"); //3
////int i = names["Anna"]; // i ==2
////names["Jarek"] = 1;
//names["Damian"] = 9;
//int x = names["Roman"];
//int y = names["Anna"];
//int z = names["Jarek"];
//int a = names["Damian"];
//Console.WriteLine(x);
//Console.WriteLine(y);
//Console.WriteLine(z);
//Console.WriteLine(a);
//Console.WriteLine(names.Lenght);
//List<Animal> animalson = new List<Animal>();
//List<Country> countries = new List<Country>();
//countries.Add(new Country { CountryId = 1, Name = "Polska" });
//countries.Add(new Country { CountryId = 2, Name = "Anglia" });
//xd(animalson);
//var polskieZwierzaki = animalson.Join(countries,
// animal => animal.CountryId,
// country => country.CountryId,
// (animal, country) => new
// {
// Id = animal.id,
// Name = animal.Name,
// Age = animal.Age,
// CountryName = country.Name,
// CountryId = animal.CountryId
// })
// .Select(a=> new Animal
// {
// Name =a.Name,
// id = a.Id,
// Age = a.Age,
// CountryId = a.CountryId
// })
// .Where(a=> a.CountryId==2)
// .ToList();
//polskieZwierzaki.ForEach(a =>
//{
// Console.WriteLine(a);
//});
//IEnumerable<Animal> elefants = from animals in animalson
// where animals.Name == "Słoń"
// select animals;
//IEnumerable<Animal> elefants = from animals in animalson
// where animals.id < 4 && animals.Age >20 || animals.Age%2 ==0
// select animals;
//var ń = animalson
// .Where(a => a.Name.Contains("ń"))
// .Select(a => a.Name)
// .Distinct()
// .ToList();
//Console.WriteLine(elefants.FirstOrDefault());
//Console.WriteLine(elefants.Count());
//Console.WriteLine(elefants.LastOrDefault());
//Console.WriteLine(elefants.SingleOrDefault());
//foreach (var item in elefants)
//{
// Console.WriteLine(item);
//}
//Console.WriteLine(ń);
//double avg = elefants.Average(e => e.Age);
//int max = elefants.Max(e => e.Age);
//int min = elefants.Min(e => e.Age);
//int sum = elefants.Sum(e => e.Age);
//int sum1 = elefants.Select(a => a.Age).Sum();
//var cos = elefants.(e => new
//{
// e.Name
//}).Select(g => new { Name = g.Key, Age = g.Sum(a => a.Age) });
//Console.WriteLine(group.FirstOrDefault());
//List<Animal> toRemove = elefants.ToList();
//var toAdd = elefants.ToList();
//animalson.AddRange(toAdd)
//animalson.ForEach(a =>
// {
// Console.WriteLine(a);
// }
// );
Console.Read();
}