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