// PUT: api/Shedule/5 public void Put(Schedule value) { if (value != null && value.Id != 0) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Schedules.Load(); var r = context.Schedules.Find(value.Id); if (r != null) { r.TeacherId = value.TeacherId; r.Data = value.Data; r.DisciplineId = value.DisciplineId; r.EndTime = value.EndTime; r.StartTime = value.StartTime; r.GroupId = value.GroupId; context.SaveChanges(); } } } } }
// POST: api/Authorization public string Post([FromBody] User value) { User user = null; using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (SQLiteCommand fmd = connection.CreateCommand()) { fmd.CommandText = $"Select * from user t where t.login ='******' and t.password='******'"; fmd.CommandType = CommandType.Text; SQLiteDataReader reader = fmd.ExecuteReader(); while (reader.Read()) { user = new User { GroupId = Convert.ToInt32(reader["group_id"]), FullName = Convert.ToString(reader["fullname"]), Login = Convert.ToString(reader["login"]), Password = Convert.ToString(reader["password"]) }; } return(user != null ? JsonConvert.SerializeObject(user, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore, ReferenceLoopHandling = ReferenceLoopHandling.Ignore }) : null); } } }
//GET: api/User public string Get() { try { var users = new List <User>(); using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Users.Load(); users = context.Users.ToList(); return(JsonConvert.SerializeObject(users, Formatting.None, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore, ReferenceLoopHandling = ReferenceLoopHandling.Ignore })); } } } catch (Exception e) { Debug.WriteLine(e); throw; } }
// POST: api/User public void Post([FromBody] User value) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Users.Load(); if (value != null) { context.Users.Add(value); context.SaveChanges(); } } } }
// GET: api/User/5 public User Get(int id) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); var u = new User(); using (var context = new TestProjectContext()) { context.Users.Load(); if (context.Users.Find(id) != null) { u = context.Users.Find(id); } } return(u); } }
// DELETE: api/User/5 public void Delete(int id) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { var temp = context.Users.Find(id); if (temp != null) { context.Users.Load(); context.Users.Remove(temp); context.SaveChanges(); } } } }
// GET: api/Group/5 public Group Get(int id) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); var g = new Group(); using (var context = new TestProjectContext()) { context.Groups.Load(); if (context.Groups.Find(id) != null) { g = context.Groups.Find(id); } } return(g); } }
// GET: api/Discipline/5 public Discipline Get(int id) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); var d = new Discipline(); using (var context = new TestProjectContext()) { context.Disciplines.Load(); if (context.Disciplines.Find(id) != null) { d = context.Disciplines.Find(id); } } return(d); } }
// GET: api/Shedule/5 public Schedule Get(int id) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); var t = new Schedule(); using (var context = new TestProjectContext()) { context.Schedules.Load(); if (context.Schedules.Find(id) != null) { t = context.Schedules.Find(id); } } return(t); } }
// PUT: api/Group/5 public void Put(Group value) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Groups.Load(); var r = context.Groups.Find(value.Id); if (r != null) { r.GroupName = value.GroupName; r.StartDate = value.StartDate; r.EndDate = value.EndDate; context.SaveChanges(); } } } }
// PUT: api/User/5 public void Put(User value) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Users.Load(); var r = context.Users.Find(value.Id); if (r != null) { r.FullName = value.FullName; r.Login = value.Login; r.Password = value.Password; r.GroupId = value.GroupId; context.SaveChanges(); } } } }
// PUT: api/Discipline/5 public void Put(Discipline value) { if (value != null && value.DisciplineId != 0) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Disciplines.Load(); var r = context.Disciplines.Find(value.DisciplineId); if (r != null) { r.DisciplineName = value.DisciplineName; r.TeacherId = value.TeacherId; context.SaveChanges(); } } } } }
// PUT: api/Teacher/5 public void Put(Teacher value) { if (value != null && value.Id != 0) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Teachers.Load(); var r = context.Teachers.Find(value.Id); if (r != null) { r.FullName = value.FullName; r.Phone = value.Phone; context.SaveChanges(); } } } } }