public ActionResult DeleteCardiologicalObjective([DataSourceRequest] DataSourceRequest request, int?id) { try { if (ModelState.IsValid) { using (var db = new StoreContext()) { var item = new CardiologicalObjective() { CardiologicalObjectiveId = Convert.ToInt32(id), }; db.CardiologicalObjectives.Attach(item); db.CardiologicalObjectives.Remove(item); db.SaveChanges(); } } return(Json("1", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public ActionResult Save(CardiologicalObjective cardiologicalObjective) { try { if (!ModelState.IsValid) { return(this.Json(new { statuscode = -1, message = General.msgInvalidModel }, JsonRequestBehavior.AllowGet)); } using (var db = new StoreContext()) { // եթե 2-րդ մակարդակի աղյուսակի տողը նոր գրառումա ավելացնում ենք if (cardiologicalObjective.CardiologicalObjectiveId == 0) { //ավելացնել db.CardiologicalObjectives.Add(cardiologicalObjective); //հետո ավելացնում ենք ենթաաղյոսակների տողերը ամեն մի ենթաաղյուսակի համար, էս դեպքում 4 աղյուսակի համար if (cardiologicalObjective.CardiologicalObjectiveDrugs != null) { foreach (var item in cardiologicalObjective.CardiologicalObjectiveDrugs) { if (item.RecordStatus == 1) { item.CardiologicalObjective = cardiologicalObjective; db.CardiologicalObjectiveDrugs.Add(item); } } } } else { //Վերջում խմբագրում ենք 2-րդ մակարդակի աղյուսակի գրառումը CardiologicalObjective mCardiologicalObjective = db.CardiologicalObjectives.Find(cardiologicalObjective.CardiologicalObjectiveId); mCardiologicalObjective.ResidentId = cardiologicalObjective.ResidentId; mCardiologicalObjective.CardiologicalObjectiveDate = cardiologicalObjective.CardiologicalObjectiveDate; mCardiologicalObjective.Temperature = cardiologicalObjective.Temperature; mCardiologicalObjective.Pulse = cardiologicalObjective.Pulse; mCardiologicalObjective.RNIBP = cardiologicalObjective.RNIBP; mCardiologicalObjective.LNIBP = cardiologicalObjective.LNIBP; mCardiologicalObjective.LungId = cardiologicalObjective.LungId; mCardiologicalObjective.HeartSoundTypeId = cardiologicalObjective.HeartSoundTypeId; mCardiologicalObjective.HeartMurmurTypeId = cardiologicalObjective.HeartMurmurTypeId; mCardiologicalObjective.RCBId = cardiologicalObjective.RCBId; mCardiologicalObjective.LCBId = cardiologicalObjective.LCBId; mCardiologicalObjective.AbdominalStatusId = cardiologicalObjective.AbdominalStatusId; mCardiologicalObjective.LiverId = cardiologicalObjective.LiverId; mCardiologicalObjective.RRAId = cardiologicalObjective.RRAId; mCardiologicalObjective.LRAId = cardiologicalObjective.LRAId; mCardiologicalObjective.RADPId = cardiologicalObjective.RADPId; mCardiologicalObjective.LADPId = cardiologicalObjective.LADPId; mCardiologicalObjective.PeripherialStatusId = cardiologicalObjective.PeripherialStatusId; mCardiologicalObjective.PhysicianId = cardiologicalObjective.PhysicianId; db.Entry(mCardiologicalObjective).State = EntityState.Modified; //ենթաաղյուսակների լրացում if (cardiologicalObjective.CardiologicalObjectiveDrugs != null) { foreach (var item in cardiologicalObjective.CardiologicalObjectiveDrugs) { if (item.RecordStatus == 1) { item.CardiologicalObjective = mCardiologicalObjective; db.CardiologicalObjectiveDrugs.Add(item); } else if (item.RecordStatus == 2) { db.CardiologicalObjectiveDrugs.Attach(item); db.Entry(item).State = EntityState.Modified; } else if (item.RecordStatus == 3) { CardiologicalObjectiveDrug rCardiologicalObjectiveDrug = db.CardiologicalObjectiveDrugs.Find(item.CardiologicalObjectiveDrugId); db.CardiologicalObjectiveDrugs.Remove(rCardiologicalObjectiveDrug); } } } } db.SaveChanges(); return(this.Json(new { statuscode = 1, message = "" }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "CardiologicalObjective", "Save"))); } }