public dynamic RoomChangeEvent(string roomType, string roomNo)
{
var FreeAccommodationsMaster = new FreeAccommodationsMaster();
FreeAccommodationsMaster = Context.Free_Accommodations_Master.Where(u => u.ROOMTYPE == roomType && u.ROOM_NO == roomNo).FirstOrDefault();
return(FreeAccommodationsMaster);
}
public dynamic InsertCampDischarge(Camp_Discharge CampDischarge)
{
if (CampDischarge.MedicalRecord.Count() > 0)
{
var MedicalrecordDtl = new MedicalRecordDtl();
foreach (var item in CampDischarge.MedicalRecord.ToList())
{
var locationcode = Context.ICD_Code_Master.Where(x => x.Icd_Code == item.ICD_Code).Select(x => x.Location_Code).FirstOrDefault();
MedicalrecordDtl.Visit_Date = DateTime.Now.Date;
MedicalrecordDtl.MR_NO = CampDischarge.Admission.Mr_No;
MedicalrecordDtl.IPA_No = CampDischarge.Admission.Ipa_No;
MedicalrecordDtl.UIN = CampDischarge.Admission.UIN;
MedicalrecordDtl.SiteId = CampDischarge.Admission.SiteId;
MedicalrecordDtl.ICD_Type_Code = "D";
MedicalrecordDtl.Additional_Surgery = "";
MedicalrecordDtl.Reference = "N";
MedicalrecordDtl.Location_Code = locationcode;
MedicalrecordDtl.ICD_Code = item.ICD_Code;
MedicalrecordDtl.Eye = item.Eye;
MedicalrecordDtl.Sysdate = DateTime.Now.Date;
MedicalrecordDtl.Doctor_Code = "";
MedicalrecordDtl.Additional_Surgery = "";
MedicalrecordDtl.Camp_Code = CampDischarge.campMaster.CAMP_CODE;
Context.Medical_Record_Dtl.Add(MedicalrecordDtl);
}
}
var clinicaldtl = Context.CLINICAL_DETAIL.Where(X => X.Ipa_No == CampDischarge.Admission.Ipa_No).FirstOrDefault();
if (clinicaldtl != null)
{
var clinicaldetailss = new ClinicalDetail();
clinicaldetailss.UIN = CampDischarge.Admission.UIN;
clinicaldetailss.Mr_No = CampDischarge.Admission.Mr_No;
clinicaldetailss.Ipa_No = CampDischarge.Admission.Ipa_No;
clinicaldetailss.SiteId = CampDischarge.Admission.SiteId;
clinicaldetailss.Room = CampDischarge.ClinicalDetail.Room;
clinicaldetailss.Noofsuture = CampDischarge.ClinicalDetail.Noofsuture;
clinicaldetailss.Pre_Op = CampDischarge.ClinicalDetail.Pre_Op;
clinicaldetailss.Pre_Op1 = CampDischarge.ClinicalDetail.Pre_Op1;
clinicaldetailss.Bp = CampDischarge.ClinicalDetail.Bp;
clinicaldetailss.Ductre = CampDischarge.ClinicalDetail.Ductre;
clinicaldetailss.Ductle = CampDischarge.ClinicalDetail.Ductle;
clinicaldetailss.Tensionre = CampDischarge.ClinicalDetail.Tensionre;
clinicaldetailss.Tensionle = CampDischarge.ClinicalDetail.Tensionle;
clinicaldetailss.Lenstre = CampDischarge.ClinicalDetail.Lenstre;
clinicaldetailss.Lenstle = CampDischarge.ClinicalDetail.Lenstle;
clinicaldetailss.Discharge_Status = "DIS";
clinicaldetailss.Rev_Date = DateTime.Now.Date;
clinicaldetailss.Vaatdischarge = CampDischarge.ClinicalDetail.Vaatdischarge;
clinicaldetailss.Diabet = CampDischarge.ClinicalDetail.Diabet;
Context.Entry(clinicaldetailss).State = EntityState.Modified;
}
else
{
//if (CampDischarge.MedicalRecord.Count() > 0)
//{
var clinicaldetails = new ClinicalDetail();
clinicaldetails.UIN = CampDischarge.Admission.UIN;
clinicaldetails.Mr_No = CampDischarge.Admission.Mr_No;
clinicaldetails.Ipa_No = CampDischarge.Admission.Ipa_No;
clinicaldetails.SiteId = CampDischarge.Admission.SiteId;
clinicaldetails.Room = CampDischarge.ClinicalDetail.Room;
clinicaldetails.Noofsuture = CampDischarge.ClinicalDetail.Noofsuture;
clinicaldetails.Pre_Op = CampDischarge.ClinicalDetail.Pre_Op;
clinicaldetails.Pre_Op1 = CampDischarge.ClinicalDetail.Pre_Op1;
clinicaldetails.Bp = CampDischarge.ClinicalDetail.Bp;
clinicaldetails.Ductre = CampDischarge.ClinicalDetail.Ductre;
clinicaldetails.Ductle = CampDischarge.ClinicalDetail.Ductle;
clinicaldetails.Tensionre = CampDischarge.ClinicalDetail.Tensionre;
clinicaldetails.Tensionle = CampDischarge.ClinicalDetail.Tensionle;
clinicaldetails.Lenstre = CampDischarge.ClinicalDetail.Lenstre;
clinicaldetails.Lenstle = CampDischarge.ClinicalDetail.Lenstle;
clinicaldetails.Discharge_Status = "DIS";
clinicaldetails.Rev_Date = DateTime.Now.Date;
clinicaldetails.Vaatdischarge = CampDischarge.ClinicalDetail.Vaatdischarge;
clinicaldetails.Diabet = CampDischarge.ClinicalDetail.Diabet;
//clinicaldetails.Clinical_Detail_Id =01;
Context.CLINICAL_DETAIL.Add(clinicaldetails);
//}
}
if (CampDischarge.History.Count() > 0)
{
var patienthistory = new PatientHistory();
foreach (var item in CampDischarge.History.ToList())
{
patienthistory.DurationMonth = item.DurationMonth;
patienthistory.DurationYear = item.DurationYear;
patienthistory.PatientHistoryDescription = item.PatientHistoryDescription;
patienthistory.MR_NO = CampDischarge.Admission.Mr_No;
patienthistory.SiteId = CampDischarge.Admission.SiteId;
patienthistory.UIN = CampDischarge.Admission.UIN;
patienthistory.CreatedUTC = DateTime.Now.Date;
Context.PatientHistory.Add(patienthistory);
}
}
var ipadmissions = Context.Ip_Admission.Where(x => x.UIN == CampDischarge.Admission.UIN && x.SiteId == CampDischarge.Admission.SiteId).FirstOrDefault();
var ipano = ipadmissions.Ipa_No;
if (ipadmissions != null)
{
ipadmissions.Discharge_Status = "DIS";
ipadmissions.Discharge_Date = DateTime.Now;
Context.Entry(ipadmissions).State = EntityState.Modified;
}
var ipaccount = Context.IP_Account.Where(x => x.Uin == CampDischarge.Admission.UIN && x.Siteid == CampDischarge.Admission.SiteId).FirstOrDefault();
if (ipaccount != null)
{
ipaccount.Status = "DIS";
Context.Entry(ipaccount).State = EntityState.Modified;
}
var freeaccomodmaster = _context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampDischarge.Admission.Room_No).FirstOrDefault(); //x.ROOMTYPE == CampDischarge.Admission.Room_Type &&
var isFreeAccomod = false;
if (freeaccomodmaster == null)
{
isFreeAccomod = true;
freeaccomodmaster = new FreeAccommodationsMaster();
freeaccomodmaster.ROOMTYPE = CampDischarge.Admission.Room_Type;
freeaccomodmaster.ROOM_NO = CampDischarge.Admission.Room_No;
}
if (freeaccomodmaster.LAST_ALLOCATION == 0)
{
freeaccomodmaster.LAST_ALLOCATION = 0;
}
else
{
freeaccomodmaster.LAST_ALLOCATION -= 1;
}
if (isFreeAccomod)
{
_context.Free_Accommodations_Master.Add(freeaccomodmaster);
}
else
{
_context.Entry(freeaccomodmaster).State = EntityState.Modified;
}
var additionalprocedure = new AdditionalProcedureTrans();
if (CampDischarge.AdditionalProcedureTrans.Count() > 0)
{
foreach (var item in CampDischarge.AdditionalProcedureTrans.ToList())
{
additionalprocedure.UIN = CampDischarge.Admission.UIN;
additionalprocedure.IPANO = CampDischarge.Admission.Ipa_No;
additionalprocedure.Siteid = CampDischarge.Admission.SiteId;
additionalprocedure.Test_Code = item.Test_Code;
Context.Additional_Procedure_Trans.Add(additionalprocedure);
}
// CampDischarge.AdditionalProcedureTrans.All(x =>
//{
// x.UIN = CampDischarge.Master.UIN;
// x.IPANO = CampDischarge.Admission.Ipa_No;
// x.Siteid = 1;
// return true;
//});
}
try
{
if (Context.SaveChanges() > 0)
{
return new
{
Success = true,
Message = "Patient Camp Discharge saved successfully"
}
}
;
}
catch (Exception ex)
{
Console.Write(ex);
}
return(new
{
Success = false,
Message = "Some data are Missing"
});
}
