public ActionResult DeleteCardiologicalCatheterization([DataSourceRequest] DataSourceRequest request, int?id)
{
try
{
if (ModelState.IsValid)
{
using (var db = new StoreContext())
{
var item = new CardiologicalCatheterization()
{
CardiologicalCatheterizationId = Convert.ToInt32(id),
};
db.CardiologicalCatheterizations.Attach(item);
db.CardiologicalCatheterizations.Remove(item);
db.SaveChanges();
}
}
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(CardiologicalCatheterization cardiologicalCatheterization /*, string folder, string fileImage, string fileMovie*/)
{
try
{
//string pxPath = "~/FileStorage/Catheterization/";
//string directoryPath = Server.MapPath(pxPath + folder);
if (!ModelState.IsValid)
{
return(this.Json(new { statuscode = -1, message = General.msgInvalidModel }, JsonRequestBehavior.AllowGet));
}
using (var db = new StoreContext())
{
// եթե 2-րդ մակարդակի աղյուսակի տողը նոր գրառումա ավելացնում ենք
if (cardiologicalCatheterization.CardiologicalCatheterizationId == 0)
{
//ավելացնել
db.CardiologicalCatheterizations.Add(cardiologicalCatheterization);
//հետո ավելացնում ենք ենթաաղյոսակների տողերը ամեն մի ենթաաղյուսակի համար, էս դեպքում 4 աղյուսակի համար
if (cardiologicalCatheterization.CardiologicalCatheterizationSegments != null)
{
foreach (var item in cardiologicalCatheterization.CardiologicalCatheterizationSegments)
{
if (item.RecordStatus == 1)
{
item.CardiologicalCatheterization = cardiologicalCatheterization;
db.CardiologicalCatheterizationSegments.Add(item);
}
}
}
}
else
{
//Վերջում խմբագրում ենք 2-րդ մակարդակի աղյուսակի գրառումը
CardiologicalCatheterization mCardiologicalCatheterization = db.CardiologicalCatheterizations.Find(cardiologicalCatheterization.CardiologicalCatheterizationId);
mCardiologicalCatheterization.ResidentId = cardiologicalCatheterization.ResidentId;
mCardiologicalCatheterization.CardiologicalCatheterizationDate = cardiologicalCatheterization.CardiologicalCatheterizationDate;
mCardiologicalCatheterization.DominanceTypeId = cardiologicalCatheterization.DominanceTypeId;
mCardiologicalCatheterization.LM = cardiologicalCatheterization.LM;
mCardiologicalCatheterization.LMStenosis = cardiologicalCatheterization.LMStenosis;
mCardiologicalCatheterization.LAD1 = cardiologicalCatheterization.LAD1;
mCardiologicalCatheterization.LAD1Stenosis = cardiologicalCatheterization.LAD1Stenosis;
mCardiologicalCatheterization.LAD2 = cardiologicalCatheterization.LAD2;
mCardiologicalCatheterization.LAD2Stenosis = cardiologicalCatheterization.LAD2Stenosis;
mCardiologicalCatheterization.LAD3 = cardiologicalCatheterization.LAD3;
mCardiologicalCatheterization.LAD3Stenosis = cardiologicalCatheterization.LAD3Stenosis;
mCardiologicalCatheterization.Diag1 = cardiologicalCatheterization.Diag1;
mCardiologicalCatheterization.Diag1Stenosis = cardiologicalCatheterization.Diag1Stenosis;
mCardiologicalCatheterization.Diag2 = cardiologicalCatheterization.Diag2;
mCardiologicalCatheterization.Diag2Stenosis = cardiologicalCatheterization.Diag2Stenosis;
mCardiologicalCatheterization.Cx1 = cardiologicalCatheterization.Cx1;
mCardiologicalCatheterization.Cx1Stenosis = cardiologicalCatheterization.Cx1Stenosis;
mCardiologicalCatheterization.Cx2 = cardiologicalCatheterization.Cx2;
mCardiologicalCatheterization.Cx2Stenosis = cardiologicalCatheterization.Cx2Stenosis;
mCardiologicalCatheterization.Cx3 = cardiologicalCatheterization.Cx3;
mCardiologicalCatheterization.Cx3Stenosis = cardiologicalCatheterization.Cx3Stenosis;
mCardiologicalCatheterization.Rm = cardiologicalCatheterization.Rm;
mCardiologicalCatheterization.RmStenosis = cardiologicalCatheterization.RmStenosis;
mCardiologicalCatheterization.OM1 = cardiologicalCatheterization.OM1;
mCardiologicalCatheterization.OM1Stenosis = cardiologicalCatheterization.OM1Stenosis;
mCardiologicalCatheterization.OM2 = cardiologicalCatheterization.OM2;
mCardiologicalCatheterization.OM2Stenosis = cardiologicalCatheterization.OM2Stenosis;
mCardiologicalCatheterization.OM3 = cardiologicalCatheterization.OM3;
mCardiologicalCatheterization.OM3Stenosis = cardiologicalCatheterization.OM3Stenosis;
mCardiologicalCatheterization.OM4 = cardiologicalCatheterization.OM4;
mCardiologicalCatheterization.OM4Stenosis = cardiologicalCatheterization.OM4Stenosis;
mCardiologicalCatheterization.RCA1 = cardiologicalCatheterization.RCA1;
mCardiologicalCatheterization.RCA1Stenosis = cardiologicalCatheterization.RCA1Stenosis;
mCardiologicalCatheterization.RCA2 = cardiologicalCatheterization.RCA2;
mCardiologicalCatheterization.RCA2Stenosis = cardiologicalCatheterization.RCA2Stenosis;
mCardiologicalCatheterization.RCA3 = cardiologicalCatheterization.RCA3;
mCardiologicalCatheterization.RCA3Stenosis = cardiologicalCatheterization.RCA3Stenosis;
mCardiologicalCatheterization.PDA = cardiologicalCatheterization.PDA;
mCardiologicalCatheterization.PDAStenosis = cardiologicalCatheterization.PDAStenosis;
mCardiologicalCatheterization.PL1 = cardiologicalCatheterization.PL1;
mCardiologicalCatheterization.PL1Stenosis = cardiologicalCatheterization.PL1Stenosis;
mCardiologicalCatheterization.LVGraphy = cardiologicalCatheterization.LVGraphy;
mCardiologicalCatheterization.LVEDP = cardiologicalCatheterization.LVEDP;
mCardiologicalCatheterization.LVEDV = cardiologicalCatheterization.LVEDV;
mCardiologicalCatheterization.LVESV = cardiologicalCatheterization.LVESV;
mCardiologicalCatheterization.LVEF = cardiologicalCatheterization.LVEF;
mCardiologicalCatheterization.PhysicianId = cardiologicalCatheterization.PhysicianId;
//mCardiologicalCatheterization.CatheterizationMovieURL = cardiologicalCatheterization.CatheterizationMovieURL;
//mCardiologicalCatheterization.CatheterizationImageURL = cardiologicalCatheterization.CatheterizationImageURL;
mCardiologicalCatheterization.Comment = cardiologicalCatheterization.Comment;
db.Entry(mCardiologicalCatheterization).State = EntityState.Modified;
//ենթաաղյուսակների լրացում
if (cardiologicalCatheterization.CardiologicalCatheterizationSegments != null)
{
foreach (var item in cardiologicalCatheterization.CardiologicalCatheterizationSegments)
{
if (item.RecordStatus == 1)
{
item.CardiologicalCatheterization = mCardiologicalCatheterization;
db.CardiologicalCatheterizationSegments.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalCatheterizationSegments.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalCatheterizationSegment rCardiologicalCatheterizationSegment = db.CardiologicalCatheterizationSegments.Find(item.CardiologicalCatheterizationSegmentId);
db.CardiologicalCatheterizationSegments.Remove(rCardiologicalCatheterizationSegment);
}
}
}
}
db.SaveChanges();
return(this.Json(new { statuscode = 1, message = "" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "CardiologicalCatheterization", "Save")));
}
}
