public dynamic ToDBCampAdmission(CampAdmission CampAdmission)
{
if (CampAdmission.Patient_Name != null || CampAdmission.Patient_Name != "")
{
var mrNo = "";
var uin = "";
var aadNo = "";
var ipano = "";
var ipno = "";
var invno = "";
var patientClass = "";
var statusDesc = Context.State_Master.Where(x => x.State_Name == CampAdmission.C_StateDesc).Select(x => x.State_Code).FirstOrDefault();
CampAdmission.StateCode = statusDesc;
var CountryDesc = Context.Country_Master.Where(x => x.Country_Name == CampAdmission.C_CountryDesc).Select(x => x.Country_Code).FirstOrDefault();
CampAdmission.ContryCode = CountryDesc;
var Districtcodes = Context.District_Master.Where(x => x.District_Name == CampAdmission.C_DistrictDesc).Select(x => x.District_Code).FirstOrDefault();
CampAdmission.DistrictCode = Districtcodes;
var talukcodes = Context.Taluk_Master.Where(x => x.Taluk_Name == CampAdmission.C_TalukDesc).Select(x => x.Taluk_Code).FirstOrDefault();
CampAdmission.Taluk_Code = talukcodes;
if (CampAdmission.IsCOTChecked == "Y")
{
CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.COTCharges).FirstOrDefault();
}
else if (CampAdmission.IsMATChecked == "Y")
{
CampAdmission.bedCharges = Context.StateBedCharges.Where(o => o.StateID == CampAdmission.StateCode).Select(x => x.MATCharges).FirstOrDefault();
}
mrNo = GenerateRunningCtrlNo("MR_NO_CAMP", CampAdmission.Site_ID);
uin = GenerateRunningCtrlNo("UIN", CampAdmission.Site_ID);
CampAdmission.mr_no = mrNo;
CampAdmission.uin = uin;
if (CampAdmission.IDProof_Desc == "Aadhar Card")
{
aadNo = CampAdmission.IDProof_Code;
}
//if (CampAdmission.bedCharges > 0)
//{
// ipano = GenerateRunningCtrlNo("CIPA_NO", CampAdmission.Site_ID);
// patientClass = "SITE03";
//}
//else if (CampAdmission.bedCharges == 0)
//{
ipano = GenerateRunningCtrlNo("FIPA_NO", CampAdmission.Site_ID);
patientClass = "SITE02";
// }
ipno = GenerateRunningCtrlNo("CAMP_IP_NO ", CampAdmission.Site_ID);
CampAdmission.ipno = ipno;
invno = GenerateRunningCtrlNo("INVOICE_NO", CampAdmission.Site_ID);
var icpl = new Ip_Camp_Place();
icpl.mr_no = mrNo;
icpl.ipa_no = ipano;
icpl.Admission_place = CampAdmission.Admission_Place;
icpl.Sysdate = DateTime.Now;
Context.ip_camp_place.Add(icpl);
var ipadmissions = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).FirstOrDefault();
if (ipadmissions != null)
{
ipadmissions.LAST_ALLOCATION -= 1;
Context.Entry(ipadmissions).State = EntityState.Modified;
}
var isOPeXists = Context.Op_Visit_Datewise.Where(x => x.Date == DateTime.Now.Date && x.Patient_Class == patientClass).Count();
var opvd = Context.Op_Visit_Datewise.Where(x => x.Patient_Class == patientClass && x.Date == DateTime.Now.Date).FirstOrDefault();
var opvdw = new OpVisitDatewise();
opvdw.Patient_Class = patientClass;
opvdw.Date = DateTime.Now.Date;
opvdw.New = 0;
opvdw.Old = 0;
opvdw.Week_Day = (int)DateTime.Now.DayOfWeek;
if (isOPeXists > 0)
{
//Context.Op_Visit_Datewise.Update(opvdw);
if (opvd != null)
{
opvd.Admission += 1;
Context.Entry(opvd).State = EntityState.Modified;
}
}
//else if (isOPeXists == 0)
//{
// Context.Op_Visit_Datewise.Add(opvdw);
//}
var PRM = new PatientRegistrationMaster();
PRM.MR_NO = mrNo;
PRM.IP_NO = ipno;
PRM.Patient_Class = patientClass;
PRM.Patient_Name = CampAdmission.Patient_Name;
PRM.Next_Of_Kin = $"{CampAdmission.Next_Of_Kin_Prefix},{CampAdmission.Next_Of_Kin_Suffix}";
PRM.Date_Of_Birth = CampAdmission.Patient_DOB;
PRM.Sex = CampAdmission.Gender;
PRM.Door = CampAdmission.Door;
PRM.Street_Locality = CampAdmission.Street;
PRM.Pincode = CampAdmission.Pincode;
PRM.Town_City = CampAdmission.City;
PRM.Taluk = CampAdmission.Taluk_Code;
PRM.District = CampAdmission.DistrictCode;
PRM.State = CampAdmission.StateCode;
PRM.Country = CampAdmission.ContryCode;
PRM.Phone = CampAdmission.Phone_No;
PRM.Registered_Date = DateTime.Now;
PRM.Last_Visit_Date = DateTime.Now;
PRM.AadhaarNo = CampAdmission.Master.AadhaarNo;
PRM.Base_Unit = "LC15";
PRM.Last_Unit_Visited = "LC15";
PRM.Visit_Number = 1;
PRM.Sysdate = DateTime.Now;
PRM.UIN = uin;
//PRM.AadhaarNo = aadNo;
PRM.SiteId = CampAdmission.Site_ID;
Context.Patient_Registration_Master.Add(PRM);
var PRD = new PatientRegistrationDetail();
PRD.MR_NO = mrNo;
PRD.Allocation_Code = "LC15";
PRD.Visit_Date = DateTime.Now;
PRD.Visit_Number = 1;
PRD.Category_Code = "CATC002";
PRD.Type_Code = "PTY001";
PRD.Instance_Code = "INSC001";
PRD.Speciality_Code = "SPC001";
PRD.Sysdate = DateTime.Now;
PRD.Allocation_Code = "LC007";
PRD.Camp_Code = CampAdmission.Camp_Code;
PRD.UIN = uin;
PRD.SiteId = CampAdmission.Site_ID;
Context.Patient_Registration_Detail.Add(PRD);
var LM = new MRLocationMaster();
LM.MR_NO = mrNo;
LM.Location_Code = "LC15";
LM.Patient_Name = CampAdmission.Patient_Name;
LM.Town_City = CampAdmission.City;
LM.UIN = uin;
LM.SiteId = 1;
Context.MR_Location_Master.Add(LM);
var PS = new PatientStatus();
PS.Visit_Date = DateTime.Now;
PS.MR_NO = mrNo;
PS.Assign_Doctor = "N";
PS.UIN = uin;
//PS.PurposeId = Convert.ToInt32( CampAdmission.Camp_Code);
PS.PurposeId = 42;
PS.SiteId = CampAdmission.Site_ID;
Context.Patient_Status.Add(PS);
if (CampAdmission.History.Count() > 0)
{
foreach (var item in CampAdmission.History.ToList())
{
var PH = new PatientHistory();
PH.UIN = uin;
PH.MR_NO = mrNo;
PH.PatientHistoryDescription = item.PatientHistoryDescription;
PH.DurationMonth = item.DurationMonth;
PH.DurationYear = item.DurationYear;
PH.CreatedUTC = DateTime.Now;
PH.CreatedBy = Convert.ToInt32(CampAdmission.Operator_ID);
PH.SiteId = CampAdmission.Site_ID;
Context.PatientHistory.AddRange(PH);
}
}
var IDPD = new IDProofDtl();
IDPD.UIN = uin;
IDPD.MR_NO = mrNo;
IDPD.PROOF_TYPE = CampAdmission.IDProof_Code;
IDPD.PROOF_NO = CampAdmission.IDProof_Desc;
IDPD.CASTE_CODE = Convert.ToString(CampAdmission.Caste_Code);
Context.IDProof_Dtl.Add(IDPD);
var IPSD = new IpSurgeryDtl();
IPSD.Ipa_No = ipano;
IPSD.Surgery_Code = CampAdmission.Surgery_Code;
IPSD.Surgery_Type_Code = "T";
IPSD.Anaesthesia = "AN002";
IPSD.Doctor_Code = "401";
IPSD.Eye = CampAdmission.Eye_Code;
IPSD.Surgery_Date = DateTime.Now.Date;
IPSD.Surgery_Approval = "Y";
IPSD.Surgery_Done = "N";
IPSD.SiteId = CampAdmission.Site_ID;
IPSD.UIN = uin;
Context.Ip_Surgery_Dtl.Add(IPSD);
var IPAcc = new IPAccount();
IPAcc.Ipa_No = ipano;
IPAcc.Mr_No = mrNo;
IPAcc.Status = "ADM";
IPAcc.System = DateTime.Now;
IPAcc.Ip_No = ipno;
IPAcc.Siteid = CampAdmission.Site_ID;
IPAcc.Uin = uin;
PRM.IPAccountIC = new List <IPAccount>()
{
IPAcc
};
var IPA = new IPAdmission();
IPA.Ipa_No = ipano;
IPA.Ip_No = ipno;
IPA.Mr_No = mrNo;
IPA.Surgery_Code = CampAdmission.Surgery_Code;
IPA.Surgery_Type_Code = "T";
IPA.Admission_Date = DateTime.Now;
IPA.Room_Type = "FREETYPE7";
IPA.Room_No = CampAdmission.Room_No;
IPA.Expected_Discharge_Date = DateTime.Now.AddDays(2);
IPA.Doctor_Code = "401";
IPA.Category_Code = "CATC002";
IPA.Anesthesia = "AN002";
IPA.Discharge_Status = "ADM";
IPA.Eye = CampAdmission.Eye_Code;
//IPA.Ipa_No = ipno;
IPA.Room_Type2 = null;
IPA.Lens_Code = CampAdmission.Lens_Code;
IPA.Operator_Code = CampAdmission.Operator_ID;
IPA.Camp_Code = CampAdmission.Camp_Code;
IPA.UIN = uin;
IPA.SiteId = CampAdmission.Site_ID;
PRM.IPAdmissionIC = new List <IPAdmission>()
{
IPA
};
if (CampAdmission.bedCharges > 0)
{
var IM = new InvoiceMaster();
IM.Invoice_No = invno;
IM.Invoice_Date = DateTime.Now;
IM.Invoice_Value = float.Parse(CampAdmission.bedCharges.ToString());
IM.Invoice_Received_Value = float.Parse(CampAdmission.bedCharges.ToString());
IM.Module_Code = "MOD4";
IM.SiteId = CampAdmission.Site_ID;
IM.UIN = uin;
IM.MR_NO = mrNo;
PRM.Invoice_Master = new List <InvoiceMaster>()
{
IM
};
var accDtl = new IpAccountDtl();
if (CampAdmission.bedCharges > 0)
{
accDtl.Ipa_Sl_No = Convert.ToInt32(GenerateRunningCtrlNo("IPA_SL_NO", CampAdmission.Site_ID));
accDtl.Ipa_No = ipano;
accDtl.Cash_Flow_Code = "501";
accDtl.Tinvoice_No = invno;
accDtl.Sysdate = DateTime.Now;
accDtl.Date = DateTime.Now.Date;
accDtl.Cost_Value = Convert.ToDecimal(CampAdmission.bedCharges);
accDtl.UIN = uin;
accDtl.SiteId = CampAdmission.Site_ID;
Context.Ip_Account_Dtl.Add(accDtl);
}
var cashPaid = new CashPaid();
if (CampAdmission.bedCharges > 0)
{
cashPaid.Operator_Code = CampAdmission.Operator_ID;
cashPaid.Module_Code = "MOD4";
cashPaid.MR_NO = mrNo;
cashPaid.IPA_NO = ipano;
cashPaid.Receipt_NO = GenerateRunningCtrlNo("FRES_RECEIPT_NO", CampAdmission.Site_ID);
cashPaid.Fees_Paid = Convert.ToDouble(CampAdmission.bedCharges);
cashPaid.Date = DateTime.Now.Date;
cashPaid.Transaction_Code = "RECPT";
cashPaid.Category_Code = "CATC001";
cashPaid.Sysdate = DateTime.Now;
cashPaid.OP_IP_Flag = "IP";
cashPaid.Paymode_Code = "PC001";
cashPaid.Outstanding = "N";
cashPaid.Invoice_No = invno;
cashPaid.UIN = uin;
cashPaid.SiteId = CampAdmission.Site_ID;
Context.Cash_Paid.Add(cashPaid);
}
}
}
try
{
if (Context.SaveChanges() > 0)
{
return new
{
Success = true,
name = CampAdmission.Patient_Name,
eyes = CampAdmission.Eye_Code,
taluks = CampAdmission.C_TalukDesc,
DistrictDesc = CampAdmission.C_DistrictDesc,
StateDesc = CampAdmission.C_StateDesc,
CountryDesc = CampAdmission.C_CountryDesc,
MRNO = CampAdmission.mr_no,
UIN = CampAdmission.uin,
Siteid = CampAdmission.Site_ID,
campcodes = CampAdmission.Camp_Code,
campnames = Context.CAMP_MASTER.Where(x => x.CAMP_CODE == CampAdmission.Camp_Code).Select(x => x.CAMP_NAME).FirstOrDefault(),
ages = CampAdmission.Age,
sex = CampAdmission.Gender,
kins = CampAdmission.Next_Of_Kin_Suffix,
room = CampAdmission.Room_No,
town = CampAdmission.City,
numer = CampAdmission.Phone_No,
ipnos = CampAdmission.ipno,
VacantBed = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.LAST_ALLOCATION).FirstOrDefault(),
Endrange = Context.Free_Accommodations_Master.Where(x => x.ROOM_NO == CampAdmission.Room_No).Select(x => x.END_RANGE).FirstOrDefault(),
}
}
;
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(new
{
Success = false,
message = "Details not saved!"
});
}
public dynamic UpdateAppointment(Appointment Appointment)
{
var Appointmentupdate = _context.Patient_Registration_Master.Where(x => x.MR_NO == Appointment.Master.MR_NO).AsNoTracking().FirstOrDefault();
var masters = Context.Patient_Registration_Master.Where(x => x.MR_NO == Appointment.Master.MR_NO).ToList();
if (masters != null)
{
masters.All(x => { x.Last_Visit_Date = DateTime.Now.Date; return(true); });
Context.Patient_Registration_Master.UpdateRange(masters);
}
var PatientRegDtl = new PatientRegistrationDetail();
PatientRegDtl.MR_NO = Appointment.Master.MR_NO;
PatientRegDtl.UIN = Appointment.Master.UIN;
PatientRegDtl.Sysdate = DateTime.Now;
PatientRegDtl.Visit_Number = 0;
PatientRegDtl.Visit_Date = DateTime.Now.Date;
PatientRegDtl.Allocation_Code = "LC009";
PatientRegDtl.Category_Code = "CATC001";
PatientRegDtl.Type_Code = "PC001";
PatientRegDtl.Instance_Code = "INSC002";
PatientRegDtl.Speciality_Code = "SPC001";
PatientRegDtl.SiteId = Appointment.Master.SiteId;
Context.Patient_Registration_Detail.Add(PatientRegDtl);
var PATIENTSTATUS = new PatientStatus();
PATIENTSTATUS.Visit_Date = DateTime.Now.Date;
PATIENTSTATUS.MR_NO = Appointment.Master.MR_NO;
PATIENTSTATUS.UIN = Appointment.Master.UIN;
PATIENTSTATUS.Assign_Doctor = "N";
PATIENTSTATUS.PurposeId = Appointment.EmrwfVisitPurposeServiceMaster.PurposeId;
PATIENTSTATUS.SiteId = Appointment.Master.SiteId;
Context.Patient_Status.Add(PATIENTSTATUS);
var opVisitDatewise = _context.Op_Visit_Datewise.Where(x => x.Date == DateTime.Now.Date && x.Patient_Class == Appointment.Master.Patient_Class).FirstOrDefault();
var isNewOpVisit = false;
if (opVisitDatewise == null)
{
isNewOpVisit = true;
opVisitDatewise = new OpVisitDatewise();
opVisitDatewise.Date = DateTime.Now.Date;
opVisitDatewise.Patient_Class = Appointment.Master.Patient_Class;
}
opVisitDatewise.Old += 1;
if (isNewOpVisit)
{
_context.Op_Visit_Datewise.Add(opVisitDatewise);
}
else
{
_context.Entry(opVisitDatewise).State = EntityState.Modified;
}
try
{
if (Context.SaveChanges() > 0)
{
return new
{
Success = true,
Message = "saved successfully"
}
}
;
}
catch (Exception ex)
{
Console.Write(ex);
}
return(new
{
Success = false,
Message = "Some data are Missing"
});
}
