public int UpdateLookUp(mp_lookup lookup) { var existing = _context.mp_lookup.FirstOrDefault(m => m.id == lookup.id); if (existing != null) { //do update lookup.deleted = 0; _context.Entry(existing).CurrentValues.SetValues(lookup); return _context.SaveChanges(); } return 0; }
public void Update(mp_clinic clinic) { var old = _context.mp_clinic.FirstOrDefault(e => e.id == clinic.id); clinic.created_at = old.created_at; _context.Entry(old).CurrentValues.SetValues(clinic); _context.SaveChanges(); }
public void Update(mp_employment employment) { var old = _context.mp_employment.FirstOrDefault(e => e.id == employment.id); employment.created_at = old.created_at; _context.Entry(old).CurrentValues.SetValues(employment); _context.SaveChanges(); }
public void Update(mp_family_history family_History) { var old = _context.mp_family_history.FirstOrDefault(e => e.id == family_History.id); family_History.created_at = old.created_at; _context.Entry(old).CurrentValues.SetValues(family_History); _context.SaveChanges(); }
public void Update(mp_children children) { var old = _context.mp_children.FirstOrDefault(e => e.id == children.id); children.created_at = old.created_at; _context.Entry(old).CurrentValues.SetValues(children); _context.SaveChanges(); }
public void Update(mp_applicant profile) { var old = _context.mp_applicant.FirstOrDefault(e => e.id == profile.id); profile.created_at = old.created_at; _context.Entry(old).CurrentValues.SetValues(profile); _context.SaveChanges(); }
public void Update(mp_appointment_refund refund) { var old = _context.mp_appointment_refund.FirstOrDefault(e => e.id == refund.id); refund.created_at = DateTime.Now; refund.created_by = refund.created_by; _context.Entry(old).CurrentValues.SetValues(refund); _context.SaveChanges(); }
public void Update(mp_appointment appointment) { var old = _context.mp_appointment.FirstOrDefault(e => e.id == appointment.id); appointment.created_at = old.created_at; appointment.created_by = old.created_by; _context.Entry(old).CurrentValues.SetValues(appointment); _context.SaveChanges(); }
public ActionResult Edit([Bind(Include = "PregledID,Naziv,Opis")] Pregled pregled) { if (ModelState.IsValid) { db.Entry(pregled).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pregled)); }
public static void MarkAsRead(long notification_id) { var old = _context.mp_notification.FirstOrDefault(e => e.id == notification_id); var notification = _context.mp_notification.FirstOrDefault(e => e.id == notification_id); notification.read = 1; _context.Entry(old).CurrentValues.SetValues(notification); _context.SaveChanges(); }
public void Update(mp_notification notification) { var old = _context.mp_notification.FirstOrDefault(e => e.id == notification.id); notification.created_at = old.created_at; notification.created_by = old.created_by; notification.updated_at = DateTime.Now; _context.Entry(old).CurrentValues.SetValues(notification); _context.SaveChanges(); }
public int AddPediatricEvaluation(mp_pediatric_evaluation evaluation) { var old = _context.mp_pediatric_evaluation.FirstOrDefault(e => e.appointment_id == evaluation.appointment_id && e.profile_id == evaluation.profile_id); if (old == null) { _context.Add(evaluation); } else { evaluation.created_by = old.created_by; evaluation.created_date = old.created_date; evaluation.id = old.id; _context.Entry(old).CurrentValues.SetValues(evaluation); } _context.SaveChanges(); return(evaluation.id); }
public void Update(mp_family_intake intake) { var old = _context.mp_family_intake.FirstOrDefault(e => e.id == intake.id); intake.updated_at = DateTime.Now; intake.created_at = old.created_at; intake.created_by = old.created_by; _context.Entry(old).CurrentValues.SetValues(intake); _context.SaveChanges(); }
public int UpdateProfileDocument(mp_clinician_document document) { var existing = _context.mp_clinician_document.FirstOrDefault(m => m.id == document.id); if (existing != null) { //do update document.created_at = existing.created_at; _context.Entry(existing).CurrentValues.SetValues(document); return(_context.SaveChanges()); } return(0); }
public int UpdatePsychosocial(mp_psychosocial psychosocial) { var existing = _context.mp_psychosocial.FirstOrDefault(m => m.id == psychosocial.id); if (existing != null) { //do update psychosocial.created_at = existing.created_at; psychosocial.created_by = existing.created_by; _context.Entry(existing).CurrentValues.SetValues(psychosocial); return(_context.SaveChanges()); } return(0); }
//updates mp_substance_use record //returns 0 if record was not found public int UpdateSubstanceUse(mp_substance_use substance_use) { var existing = _context.mp_substance_use.FirstOrDefault(m => m.id == substance_use.id); if (existing != null) { //do update substance_use.created_at = existing.created_at; substance_use.created_by = existing.created_by; _context.Entry(existing).CurrentValues.SetValues(substance_use); return(_context.SaveChanges()); } return(0); }
public int UpdateProgressNote(mp_progress_note note) { var existing = _context.mp_progress_note.FirstOrDefault(m => m.id == note.id); if (existing != null) { //do update note.created_at = existing.created_at; note.created_by = existing.created_by; _context.Entry(existing).CurrentValues.SetValues(note); return(_context.SaveChanges()); } return(0); }
public int UpdateSocialRelationship(mp_social_relationship relationship) { var existing = _context.mp_social_relationship.FirstOrDefault(m => m.id == relationship.id); if (existing != null) { //do update relationship.created_at = existing.created_at; relationship.created_by = existing.created_by; _context.Entry(existing).CurrentValues.SetValues(relationship); return(_context.SaveChanges()); } return(0); }
public void AddOrUpdate(mp_clinician_availability availability) { if (_context.mp_clinician_availability.Any(e => e.clinician_id == availability.clinician_id && e.day_name == availability.day_name)) { // run update var old = _context.mp_clinician_availability.FirstOrDefault(e => e.clinician_id == availability.clinician_id && e.day_name == availability.day_name); availability.id = old.id; _context.Entry(old).CurrentValues.SetValues(availability); } else { _context.mp_clinician_availability.Add(availability); } _context.SaveChanges(); }
public ActionResult EditPost(int?id, HttpPostedFileBase upload) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var lekarZaUpdate = db.Lekari.Find(id); if (TryUpdateModel(lekarZaUpdate, "", new string[] { "ID", "Prezime", "Ime", "DatumZaposlenja", "Email" })) { try { if (upload != null && upload.ContentLength > 0) { if (lekarZaUpdate.Files.Any(f => f.FileType == FileType.Foto)) { db.Files.Remove(lekarZaUpdate.Files.First(f => f.FileType == FileType.Foto)); } var foto = new File { FileName = System.IO.Path.GetFileName(upload.FileName), FileType = FileType.Foto, ContentType = upload.ContentType }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { foto.Content = reader.ReadBytes(upload.ContentLength); } lekarZaUpdate.Files = new List <File> { foto }; } db.Entry(lekarZaUpdate).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (DataException) { ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator."); } } return(View(lekarZaUpdate)); }
public void AddOrUpdate(mp_clinician_rating rating) { var old = _context.mp_clinician_rating.FirstOrDefault(e => e.id == rating.id); if (old != null) { rating.created_at = old.created_at; rating.created_by = old.created_by; _context.Entry(old).CurrentValues.SetValues(rating); } else { rating.created_at = DateTime.Now; _context.mp_clinician_rating.Add(rating); } _context.SaveChanges(); }
public void AddOrUpdate(mp_profile_bank bank) { var old = _context.mp_profile_bank.FirstOrDefault(e => e.id == bank.id); if (old != null) { bank.created_at = old.created_at; bank.created_by = old.created_by; bank.updated_at = DateTime.Now; _context.Entry(old).CurrentValues.SetValues(bank); } else { bank.created_at = DateTime.Now; _context.mp_profile_bank.Add(bank); } _context.SaveChanges(); }
public void AddOrUpdate(mp_profile_hmo hmo) { var old = _context.mp_profile_hmo.FirstOrDefault(e => e.id == hmo.id); if (old != null) { hmo.created_at = old.created_at; hmo.created_by = old.created_by; hmo.updated_at = DateTime.Now; _context.Entry(old).CurrentValues.SetValues(hmo); } else { hmo.created_at = DateTime.Now; _context.mp_profile_hmo.Add(hmo); } _context.SaveChanges(); }
public void AddOrUpdate(mp_applicant_checklist applicant_checklist) { var old = _context.mp_applicant_checklist.FirstOrDefault(e => e.clinician_id == applicant_checklist.clinician_id); if (old != null) { applicant_checklist.created_at = old.created_at; applicant_checklist.updated_at = DateTime.Now; applicant_checklist.created_by = old.created_by; _context.Entry(old).CurrentValues.SetValues(applicant_checklist); } else { applicant_checklist.created_at = DateTime.Now; _context.mp_applicant_checklist.Add(applicant_checklist); } _context.SaveChanges(); }
public void AddOrUpdate(mp_service_costing service_cost) { var old = _context.mp_service_costing.FirstOrDefault(e => e.clinician_id == service_cost.clinician_id && e.appointment_service_id == service_cost.appointment_service_id && e.appointment_activity_sub_id == service_cost.appointment_activity_sub_id); if (old != null) { service_cost.id = old.id; service_cost.created_at = old.created_at; service_cost.created_by = old.created_by; service_cost.updated_at = DateTime.Now; _context.Entry(old).CurrentValues.SetValues(service_cost); } else { service_cost.created_at = DateTime.Now; _context.mp_service_costing.Add(service_cost); } _context.SaveChanges(); }