//Get Images by Id public Images Get(int id) { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { return(entities.Images.FirstOrDefault(e => e.ID == id)); } }
//Get Images public IEnumerable <Images> Get() { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { return(entities.Images.ToList()); } }
//Get Accounts public IEnumerable <Accounts> Get() { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { return(entities.Accounts.ToList()); } }
//Delete Images public void Delete(int id) { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { entities.Images.Remove(entities.Images.FirstOrDefault(e => e.ID == id)); entities.SaveChanges(); } }
//Post Images public void Post([FromBody] Images imag) { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { entities.Images.Add(imag); entities.SaveChanges(); } }
//Post Accounts public void Post([FromBody] Accounts accounts) { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { entities.Accounts.Add(accounts); entities.SaveChanges(); } }
//Update Images (Put) public void Put(int id, [FromBody] Images img) { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { var entity = entities.Images.FirstOrDefault(e => e.ID == id); entity.ID = img.ID; entity.Data = img.Data; entities.SaveChanges(); } }
//Update Accounts (Put) public void Put(int id, [FromBody] Accounts accounts) { using (MSSQL600021Entities entities = new MSSQL600021Entities()) { var entity = entities.Accounts.FirstOrDefault(e => e.ID == id); entity.Username = accounts.Username; entity.Password = accounts.Password; entity.Attached = accounts.Attached; entities.SaveChanges(); } }