public async Task <ResponseObject> PostApproveNotes(NotesRequests status) { ResponseObject temp = new ResponseObject(); try { if (!ModelState.IsValid) { temp.Status = false; temp.Message = "Model State is not valid."; return(temp); } Notes notes = await db.Notes.FirstOrDefaultAsync(x => x.ID == status.NotesID); if (notes != null) { NotesRequests check = await db.NotesRequests.FirstOrDefaultAsync(x => x.NotesID == status.NotesID && x.SecretaryID == status.SecretaryID); if (check == null) { notes.Status = status.Status; db.Entry(notes).State = EntityState.Modified; db.NotesRequests.Add(status); await db.SaveChangesAsync(); } else { notes.Status = status.Status; db.Entry(notes).State = EntityState.Modified; check.Status = status.Status; db.Entry(check).State = EntityState.Modified; await db.SaveChangesAsync(); } } else { temp.Status = false; temp.Message = "Note id is not valid."; return(temp); } temp.Status = true; temp.Message = "Successfully Updated."; temp.Data = notes; return(temp); } catch (Exception e) { temp.Status = false; temp.Message = e.InnerException.ToString(); return(temp); } }
public async Task <Response> DeletePeoples(int id) { Response obj = new Response(); Peoples people = await db.Peoples.FirstOrDefaultAsync(x => x.ID == id && x.Type != "Admin"); if (people == null) { obj.Status = false; obj.Message = "404 Not Found"; return(obj); } var users = db.AgendaUsers.Where(x => x.User == id).ToList(); db.AgendaUsers.RemoveRange(users); await db.SaveChangesAsync(); var notes = db.Notes.Where(x => x.User == id).ToList(); foreach (var details in notes) { NotesRequests temp = await db.NotesRequests.FirstOrDefaultAsync(x => x.NotesID == details.ID); db.NotesRequests.Remove(temp); await db.SaveChangesAsync(); } db.Notes.RemoveRange(notes); await db.SaveChangesAsync(); db.Peoples.Remove(people); await db.SaveChangesAsync(); obj.Status = true; obj.Message = "Delete Successfull"; return(obj); }