public ActionResult DeleteCardiologicalSurgery([DataSourceRequest] DataSourceRequest request, int?id)
{
try
{
if (ModelState.IsValid)
{
using (var db = new StoreContext())
{
var item = new CardiologicalSurgery()
{
CardiologicalSurgeryId = Convert.ToInt32(id),
};
db.CardiologicalSurgeryes.Attach(item);
db.CardiologicalSurgeryes.Remove(item);
db.SaveChanges();
}
}
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(CardiologicalSurgery cardiologicalSurgery)
{
try
{
if (!ModelState.IsValid)
{
return(this.Json(new { statuscode = -1, message = General.msgInvalidModel }, JsonRequestBehavior.AllowGet));
}
using (var db = new StoreContext())
{
// եթե 2-րդ մակարդակի աղյուսակի տողը նոր գրառումա ավելացնում ենք
if (cardiologicalSurgery.CardiologicalSurgeryId == 0)
{
//ավելացնել
db.CardiologicalSurgeryes.Add(cardiologicalSurgery);
//հետո ավելացնում ենք ենթաաղյոսակների տողերը ամեն մի ենթաաղյուսակի համար, էս դեպքում 4 աղյուսակի համար
if (cardiologicalSurgery.CardiologicalSurgeryComplications != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryComplications)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = cardiologicalSurgery;
db.CardiologicalSurgeryComplications.Add(item);
}
}
}
if (cardiologicalSurgery.CardiologicalSurgeryDrugs != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryDrugs)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = cardiologicalSurgery;
db.CardiologicalSurgeryDrugs.Add(item);
}
}
}
if (cardiologicalSurgery.CardiologicalSurgeryProcedures != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryProcedures)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = cardiologicalSurgery;
db.CardiologicalSurgeryProcedures.Add(item);
}
}
}
if (cardiologicalSurgery.CardiologicalSurgeryValves != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryValves)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = cardiologicalSurgery;
db.CardiologicalSurgeryValves.Add(item);
}
}
}
}
else
{
//Վերջում խմբագրում ենք 2-րդ մակարդակի աղյուսակի գրառումը
CardiologicalSurgery mCardiologicalSurgery = db.CardiologicalSurgeryes.Find(cardiologicalSurgery.CardiologicalSurgeryId);
mCardiologicalSurgery.ResidentId = cardiologicalSurgery.ResidentId;
mCardiologicalSurgery.CardiologicalSurgeryDate = cardiologicalSurgery.CardiologicalSurgeryDate;
mCardiologicalSurgery.DiseaseStatusId = cardiologicalSurgery.DiseaseStatusId;
mCardiologicalSurgery.CPB = cardiologicalSurgery.CPB;
mCardiologicalSurgery.EuroSCORE = cardiologicalSurgery.EuroSCORE;
mCardiologicalSurgery.CABGX = cardiologicalSurgery.CABGX;
mCardiologicalSurgery.BypassB1Id = cardiologicalSurgery.BypassB1Id;
mCardiologicalSurgery.SegmentB1Id = cardiologicalSurgery.SegmentB1Id;
mCardiologicalSurgery.BypassB2Id = cardiologicalSurgery.BypassB2Id;
mCardiologicalSurgery.SegmentB2Id = cardiologicalSurgery.SegmentB2Id;
mCardiologicalSurgery.BypassB3Id = cardiologicalSurgery.BypassB3Id;
mCardiologicalSurgery.SegmentB3Id = cardiologicalSurgery.SegmentB3Id;
mCardiologicalSurgery.BypassC1Id = cardiologicalSurgery.BypassC1Id;
mCardiologicalSurgery.SegmentC1Id = cardiologicalSurgery.SegmentC1Id;
mCardiologicalSurgery.SegmentD1Id = cardiologicalSurgery.SegmentD1Id;
mCardiologicalSurgery.BypassC2Id = cardiologicalSurgery.BypassC2Id;
mCardiologicalSurgery.SegmentC2Id = cardiologicalSurgery.SegmentC2Id;
mCardiologicalSurgery.SegmentD2Id = cardiologicalSurgery.SegmentD2Id;
mCardiologicalSurgery.BypassC3Id = cardiologicalSurgery.BypassC3Id;
mCardiologicalSurgery.SegmentC3Id = cardiologicalSurgery.SegmentC3Id;
mCardiologicalSurgery.SegmentD3Id = cardiologicalSurgery.SegmentD3Id;
mCardiologicalSurgery.LFL = cardiologicalSurgery.LFL;
mCardiologicalSurgery.HFL = cardiologicalSurgery.HFL;
mCardiologicalSurgery.NaCl = cardiologicalSurgery.NaCl;
mCardiologicalSurgery.GEL = cardiologicalSurgery.GEL;
mCardiologicalSurgery.Mannitol = cardiologicalSurgery.Mannitol;
mCardiologicalSurgery.BicarbonateTypeId = cardiologicalSurgery.BicarbonateTypeId;
mCardiologicalSurgery.NaHCO3 = cardiologicalSurgery.NaHCO3;
mCardiologicalSurgery.Heparin1 = cardiologicalSurgery.Heparin1;
mCardiologicalSurgery.CaCl2 = cardiologicalSurgery.CaCl2;
mCardiologicalSurgery.RBCCPB = cardiologicalSurgery.RBCCPB;
mCardiologicalSurgery.FFPCPB = cardiologicalSurgery.FFPCPB;
mCardiologicalSurgery.LiquidId = cardiologicalSurgery.LiquidId;
mCardiologicalSurgery.Other1 = cardiologicalSurgery.Other1;
//mCardiologicalSurgery.PrimaryVolume = cardiologicalSurgery.PrimaryVolume;
mCardiologicalSurgery.Na = cardiologicalSurgery.Na;
mCardiologicalSurgery.Gelofusin = cardiologicalSurgery.Gelofusin;
mCardiologicalSurgery.Man = cardiologicalSurgery.Man;
mCardiologicalSurgery.NaHCO = cardiologicalSurgery.NaHCO;
mCardiologicalSurgery.Heparin2 = cardiologicalSurgery.Heparin2;
mCardiologicalSurgery.CaCl = cardiologicalSurgery.CaCl;
mCardiologicalSurgery.R = cardiologicalSurgery.R;
mCardiologicalSurgery.F = cardiologicalSurgery.F;
mCardiologicalSurgery.Other2 = cardiologicalSurgery.Other2;
//mCardiologicalSurgery.TotalVolume = cardiologicalSurgery.TotalVolume;
mCardiologicalSurgery.ResidualVolume = cardiologicalSurgery.ResidualVolume;
//mCardiologicalSurgery.InPatientVolume = cardiologicalSurgery.InPatientVolume;
mCardiologicalSurgery.SkinIncisionStartTime = cardiologicalSurgery.SkinIncisionStartTime;
mCardiologicalSurgery.SkinIncisionCloseTime = cardiologicalSurgery.SkinIncisionCloseTime;
//mCardiologicalSurgery.TotalOperationTime = cardiologicalSurgery.TotalOperationTime;
mCardiologicalSurgery.CrossClampTime = cardiologicalSurgery.CrossClampTime;
mCardiologicalSurgery.BypassTime = cardiologicalSurgery.BypassTime;
mCardiologicalSurgery.CardioplegiaTypeId = cardiologicalSurgery.CardioplegiaTypeId;
mCardiologicalSurgery.AnesthesiaTime = cardiologicalSurgery.AnesthesiaTime;
mCardiologicalSurgery.RBCId = cardiologicalSurgery.RBCId;
mCardiologicalSurgery.FFPId = cardiologicalSurgery.FFPId;
mCardiologicalSurgery.PLTId = cardiologicalSurgery.PLTId;
mCardiologicalSurgery.InotropicSupportId = cardiologicalSurgery.InotropicSupportId;
mCardiologicalSurgery.BloodLossVolume = cardiologicalSurgery.BloodLossVolume;
mCardiologicalSurgery.SkinTemperature = cardiologicalSurgery.SkinTemperature;
mCardiologicalSurgery.ExtubatedPOD = cardiologicalSurgery.ExtubatedPOD;
mCardiologicalSurgery.InitialHoursVentilated = cardiologicalSurgery.InitialHoursVentilated;
mCardiologicalSurgery.ReIntubation = cardiologicalSurgery.ReIntubation;
mCardiologicalSurgery.AdditionalHoursVentilated = cardiologicalSurgery.AdditionalHoursVentilated;
//mCardiologicalSurgery.TotalHoursVentilated = cardiologicalSurgery.TotalHoursVentilated;
mCardiologicalSurgery.Hb = cardiologicalSurgery.Hb;
mCardiologicalSurgery.Hct = cardiologicalSurgery.Hct;
mCardiologicalSurgery.Platelet = cardiologicalSurgery.Platelet;
mCardiologicalSurgery.Creatinine = cardiologicalSurgery.Creatinine;
mCardiologicalSurgery.APTT = cardiologicalSurgery.APTT;
mCardiologicalSurgery.Sodium = cardiologicalSurgery.Sodium;
mCardiologicalSurgery.Potassium = cardiologicalSurgery.Potassium;
mCardiologicalSurgery.PH = cardiologicalSurgery.PH;
mCardiologicalSurgery.PaO2 = cardiologicalSurgery.PaO2;
mCardiologicalSurgery.PaCO2 = cardiologicalSurgery.PaCO2;
mCardiologicalSurgery.ICULength = cardiologicalSurgery.ICULength;
mCardiologicalSurgery.DischargeDate = cardiologicalSurgery.DischargeDate;
mCardiologicalSurgery.CSDLength = cardiologicalSurgery.CSDLength;
//mCardiologicalSurgery.Mortality = cardiologicalSurgery.Mortality;
mCardiologicalSurgery.DeathDate = cardiologicalSurgery.DeathDate;
mCardiologicalSurgery.DeathCauseId = cardiologicalSurgery.DeathCauseId;
mCardiologicalSurgery.Comment = cardiologicalSurgery.Comment;
db.Entry(mCardiologicalSurgery).State = EntityState.Modified;
//ենթաաղյուսակների լրացում
if (cardiologicalSurgery.CardiologicalSurgeryComplications != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryComplications)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = mCardiologicalSurgery;
db.CardiologicalSurgeryComplications.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalSurgeryComplications.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalSurgeryComplication rCardiologicalSurgeryComplication = db.CardiologicalSurgeryComplications.Find(item.CardiologicalSurgeryComplicationId);
db.CardiologicalSurgeryComplications.Remove(rCardiologicalSurgeryComplication);
}
}
}
if (cardiologicalSurgery.CardiologicalSurgeryDrugs != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryDrugs)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = mCardiologicalSurgery;
db.CardiologicalSurgeryDrugs.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalSurgeryDrugs.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalSurgeryDrug rCardiologicalSurgeryDrug = db.CardiologicalSurgeryDrugs.Find(item.CardiologicalSurgeryDrugId);
db.CardiologicalSurgeryDrugs.Remove(rCardiologicalSurgeryDrug);
}
}
}
if (cardiologicalSurgery.CardiologicalSurgeryProcedures != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryProcedures)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = mCardiologicalSurgery;
db.CardiologicalSurgeryProcedures.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalSurgeryProcedures.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalSurgeryProcedure rCardiologicalSurgeryProcedure = db.CardiologicalSurgeryProcedures.Find(item.CardiologicalSurgeryProcedureId);
db.CardiologicalSurgeryProcedures.Remove(rCardiologicalSurgeryProcedure);
}
}
}
if (cardiologicalSurgery.CardiologicalSurgeryValves != null)
{
foreach (var item in cardiologicalSurgery.CardiologicalSurgeryValves)
{
if (item.RecordStatus == 1)
{
item.CardiologicalSurgery = mCardiologicalSurgery;
db.CardiologicalSurgeryValves.Add(item);
}
else if (item.RecordStatus == 2)
{
db.CardiologicalSurgeryValves.Attach(item);
db.Entry(item).State = EntityState.Modified;
}
else if (item.RecordStatus == 3)
{
CardiologicalSurgeryValve rCardiologicalSurgeryValve = db.CardiologicalSurgeryValves.Find(item.CardiologicalSurgeryValveId);
db.CardiologicalSurgeryValves.Remove(rCardiologicalSurgeryValve);
}
}
}
}
db.SaveChanges();
return(this.Json(new { statuscode = 1, message = "" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "CardiologicalSurgery", "Save")));
}
}
