public ActionResult DeleteCardiologicalEchoCG([DataSourceRequest] DataSourceRequest request, int?id)
{
try
{
if (ModelState.IsValid)
{
using (var db = new StoreContext())
{
var item = new CardiologicalEchoCG()
{
CardiologicalEchoCGId = Convert.ToInt32(id),
};
db.CardiologicalEchoCGS.Attach(item);
db.CardiologicalEchoCGS.Remove(item);
db.SaveChanges();
}
}
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(CardiologicalEchoCG cardiologicalEchoCG)
{
try
{
if (!ModelState.IsValid)
{
return(this.Json(new { statuscode = -1, message = General.msgInvalidModel }, JsonRequestBehavior.AllowGet));
}
using (var db = new StoreContext())
{
// եթե 2-րդ մակարդակի աղյուսակի տողը նոր գրառումա ավելացնում ենք
if (cardiologicalEchoCG.CardiologicalEchoCGId == 0)
{
//ավելացնել
db.CardiologicalEchoCGS.Add(cardiologicalEchoCG);
//հետո ավելացնում ենք ենթաաղյոսակների տողերը ամեն մի ենթաաղյուսակի համար, էս դեպքում 4 աղյուսակի համար
if (cardiologicalEchoCG.CardiologicalEchoCGVelocitys != null)
{
foreach (var item in cardiologicalEchoCG.CardiologicalEchoCGVelocitys)
{
if (item.RecordStatus == 1)
{
item.CardiologicalEchoCG = cardiologicalEchoCG;
db.CardiologicalEchoCGVelocitys.Add(item);
}
}
}
if (cardiologicalEchoCG.CardiologicalEchoCGWalls != null)
{
foreach (var item in cardiologicalEchoCG.CardiologicalEchoCGWalls)
{
if (item.RecordStatus == 1)
{
item.CardiologicalEchoCG = cardiologicalEchoCG;
db.CardiologicalEchoCGWalls.Add(item);
}
}
}
}
else
{
//Վերջում խմբագրում ենք 2-րդ մակարդակի աղյուսակի գրառումը
CardiologicalEchoCG mCardiologicalEchoCG = db.CardiologicalEchoCGS.Find(cardiologicalEchoCG.CardiologicalEchoCGId);
mCardiologicalEchoCG.CardiologicalEchoCGDate = cardiologicalEchoCG.CardiologicalEchoCGDate;
mCardiologicalEchoCG.ResidentId = cardiologicalEchoCG.ResidentId;
mCardiologicalEchoCG.AOD = cardiologicalEchoCG.AOD;
mCardiologicalEchoCG.LAD = cardiologicalEchoCG.LAD;
mCardiologicalEchoCG.RVDD = cardiologicalEchoCG.RVDD;
mCardiologicalEchoCG.LVSD = cardiologicalEchoCG.LVSD;
mCardiologicalEchoCG.LVDD = cardiologicalEchoCG.LVDD;
mCardiologicalEchoCG.LVPW = cardiologicalEchoCG.LVPW;
mCardiologicalEchoCG.LVSV = cardiologicalEchoCG.LVSV;
mCardiologicalEchoCG.LVDV = cardiologicalEchoCG.LVDV;
mCardiologicalEchoCG.IVSW = cardiologicalEchoCG.IVSW;
mCardiologicalEchoCG.SV = cardiologicalEchoCG.SV;
mCardiologicalEchoCG.EF = cardiologicalEchoCG.EF;
mCardiologicalEchoCG.PAACTET = cardiologicalEchoCG.PAACTET;
mCardiologicalEchoCG.MenaPAP = cardiologicalEchoCG.MenaPAP;
mCardiologicalEchoCG.PeakPAP = cardiologicalEchoCG.PeakPAP;
mCardiologicalEchoCG.PericardialAnteriorSeparation = cardiologicalEchoCG.PericardialAnteriorSeparation;
mCardiologicalEchoCG.Comment = cardiologicalEchoCG.Comment;
//mCardiologicalEchoCG.CardiologicalEchoCGMoviePath = cardiologicalEchoCG.CardiologicalEchoCGMoviePath;
db.Entry(mCardiologicalEchoCG).State = EntityState.Modified;
//ենթաաղյուսակների լրացում
if (cardiologicalEchoCG.CardiologicalEchoCGVelocitys != null)
{
foreach (var item in cardiologicalEchoCG.CardiologicalEchoCGVelocitys)
{
if (item.RecordStatus == 1)
{
item.CardiologicalEchoCG = mCardiologicalEchoCG;
db.CardiologicalEchoCGVelocitys.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalEchoCGVelocitys.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalEchoCGVelocity rCardiologicalEchoCGVelocity = db.CardiologicalEchoCGVelocitys.Find(item.CardiologicalEchoCGVelocityId);
db.CardiologicalEchoCGVelocitys.Remove(rCardiologicalEchoCGVelocity);
}
}
}
if (cardiologicalEchoCG.CardiologicalEchoCGWalls != null)
{
foreach (var item in cardiologicalEchoCG.CardiologicalEchoCGWalls)
{
if (item.RecordStatus == 1)
{
item.CardiologicalEchoCG = mCardiologicalEchoCG;
db.CardiologicalEchoCGWalls.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalEchoCGWalls.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalEchoCGWall rCardiologicalEchoCGWall = db.CardiologicalEchoCGWalls.Find(item.CardiologicalEchoCGWallId);
db.CardiologicalEchoCGWalls.Remove(rCardiologicalEchoCGWall);
}
}
}
}
db.SaveChanges();
return(this.Json(new { statuscode = 1, message = "" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "CardiologicalEchoCG", "Save")));
}
}
