public void Update(string _Name, string _Description, DateTime _StartingDay, DateTime _LastDay, string _Type)
{
using (var context = new localsql())
{
Objective task = context.Objectives
.Where(c => c.Name == _Name)
.FirstOrDefault();
task.Name = _Name;
task.Description = _Description;
task.StartingDay = _StartingDay;
task.LastDay = _LastDay;
task.Type = _Type;
context.SaveChanges();
}
}
public void AddGoal(string _Name, string _Description, DateTime _StartingDay, DateTime _LastDay, string _Type)
{
using (var context = new localsql())
{
Objective task = new Objective
{
Description = _Description,
Name = _Name,
StartingDay = _StartingDay,
LastDay = _LastDay,
Type = _Type
};
context.Objectives.Add(task);
context.SaveChanges();
}
}
public void Remove(string _Name)
{
using (var context = new localsql())
{
Objective task = new Objective();
foreach (var item in context.Set <Objective>().ToList())
{
if (item.Name.ToString() == _Name)
{
context.Objectives.Attach(item);
context.Objectives.Remove(item);
context.SaveChanges();
}
}
}
}
public void AddUser(string _Nickname, string _Name, int _Age, string _Password)
{
Random rnd = new Random();
using (var context = new localsql())
{
User task = new User
{
Nickname = _Nickname,
Name = _Name,
Age = _Age,
Password = _Password,
Salt = rnd.Next(10000, 1000000).ToString()
};
context.User.Add(task);
context.SaveChanges();
}
}