public IHttpActionResult PutOpdRegister(int id, OpdRegister opdRegister)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != opdRegister.Id)
{
return(BadRequest());
}
db.Entry(opdRegister).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OpdRegisterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutComplaint(int id, Complaint complaint)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != complaint.Id)
{
return(BadRequest());
}
db.Entry(complaint).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ComplaintExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "Id,ServiceName,DepartmentId,CashPrice, ServiceGroupId, IsIPD, IsOPD")] Service service)
{
service.DateAdded = DateTime.Now;
db.Services.Add(service);
db.SaveChanges();
return(Redirect("Index"));
}
public ActionResult Create([Bind(Include = "Id,TariffName,CompanyId,DateAdded")] Tariff tariff)
{
tariff.DateAdded = DateTime.Now;
//if (ModelState.IsValid)
//{
//}
try
{
db.Tariffs.Add(tariff);
db.SaveChanges();
return(RedirectToAction("Create"));
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var fullErrorMessage = string.Join("; ", errorMessages);
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
return(Content(exceptionMessage));
}
//ViewBag.CompanyId = new SelectList(db.Companies, "Id", "CompanyName", tariff.CompanyId);
//return Json(tariff);
}
public ActionResult AddNutritionAdultRegister(NutritionAdultRegister data)
{
db.NutritionAdultRegisters.Add(data);
db.SaveChanges();
return(View("Index"));
}
public ActionResult SavePatientProfile(RenalPatientProfile data)
{
data.UserId = (int)Session["UserId"];
data.BranchId = 1;
data.DateAdded = DateTime.Now;
db.RenalPatientProfiles.Add(data);
db.SaveChanges();
return(RedirectToAction("PatientProfile", new { id = data.OPDNo }));
}
public ActionResult SavePediatricAdmissionData(PedriaticAdmission data)
{
data.UserId = (int)Session["UserId"];
data.DateAdded = DateTime.Now;
data.BranchId = 1;
db.PedriaticAdmissions.Add(data);
db.SaveChanges();
return(RedirectToAction("Pedriatic"));
}
public ActionResult Create([Bind(Include = "Id,TableName,Field,Required")] FieldMeta fieldMeta)
{
if (ModelState.IsValid)
{
db.FieldMetas.Add(fieldMeta);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fieldMeta));
}
public ActionResult Create(Department department)
{
department.DateAdded = DateTime.Now;
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentType = new SelectList(db.DepartmentTypes, "Id", "DepartmnetType", department.DepartmentType);
return(View(department));
}
public ActionResult SaveAmbulanceMaster(AmbulanceMaster data)
{
data.UserId = (int)Session["UserId"];
data.BranchId = 1;
data.AddedOn = DateTime.Now;
data.Engaged = false;
db.AmbulanceMasters.Add(data);
db.SaveChanges();
return(RedirectToAction("AmbulanceMaster", new { id = data.Id }));
}
public ActionResult Create([Bind(Include = "Id,MedicalHistoryQuestionName")] MedicalHistoryQuestion medicalHistoryQuestion)
{
if (ModelState.IsValid)
{
medicalHistoryQuestion.BranchId = (int)Session["UserBranchId"];
medicalHistoryQuestion.UserId = int.Parse(Session["UserId"].ToString());
medicalHistoryQuestion.TimeAdded = DateTime.Now;
db.MedicalHistoryQuestions.Add(medicalHistoryQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(medicalHistoryQuestion));
}
// PUT: api/Patients/5
public HttpResponseMessage PutApplicant(int id, [FromBody] HRApplicant applicant)
{
if (applicant == null)
{
return(Request.CreateResponse(HttpStatusCode.OK, "no data sent"));
}
applicant.Id = id;
db.Entry(applicant).State = EntityState.Modified;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, applicant));
}
public ActionResult Create([Bind(Include = "Id,CategoryId,ParticularName")] SystemExamParticular systemExamParticular)
{
if (ModelState.IsValid)
{
systemExamParticular.BranchId = (int)Session["UserBranchId"];
systemExamParticular.UserId = int.Parse(Session["UserId"].ToString());
systemExamParticular.TimeAdded = DateTime.Now;
db.SystemExamParticulars.Add(systemExamParticular);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.SystemExamCategories, "Id", "CategoryName", systemExamParticular.CategoryId);
return(View(systemExamParticular));
}
public ActionResult Create([Bind(Include = "Id,CategoryName")] SystemExamCategory systemExamCategory)
{
if (ModelState.IsValid)
{
systemExamCategory.TimeAdded = DateTime.Now;
systemExamCategory.UserId = int.Parse(Session["UserId"].ToString());
systemExamCategory.BranchId = (int)Session["UserBranchId"];
db.SystemExamCategories.Add(systemExamCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(systemExamCategory));
}
public ActionResult Appointment(DoctorsSchedule doctorsSchedule)
{
doctorsSchedule.CreatedDate = DateTime.UtcNow.ToLocalTime();
if (ModelState.IsValid)
{//ToDo : select user from session
doctorsSchedule.UserId = (int)Session["UserId"];
db.DoctorsSchedules.Add(doctorsSchedule);
db.SaveChanges();
ViewBag.SucessFullySaved = true;
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public void setUpSettingsParameters()
{
//Theatre Marquee
var marq = new KeyValuePair
{
Key_ = "TheatreMarquee",
Value = "Enter Theatre Marquee",
Owner = "Theatre"
};
if (db.KeyValuePairs.Where(e => e.Key_ == marq.Key_ && e.Owner == marq.Owner) == null)
{
db.KeyValuePairs.Add(marq);
}
var depId = new KeyValuePair
{
Key_ = "TheatreDepartmentName",
Value = "Theatre",
Owner = "Theatre"
};
if (db.KeyValuePairs.Where(e => e.Key_ == marq.Key_ && e.Owner == marq.Owner) == null)
{
db.KeyValuePairs.Add(depId);
}
int res = db.SaveChanges();
}
public ActionResult CreateDepartment(Department department)
{
if (!Request.IsAjaxRequest())
{
Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest;
return(Content("Error" + Response.StatusCode));
}
try
{
if (!ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(Content("Record Added Successfully"));
}
}
catch (Exception ex)
{
Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest;
return(Content("Error" + ex.Message + Response.StatusCode));
}
return(View());
}
public int UpdateClaimNo(int id, string ClaimNumber)
{
var ClaimNo = db.PatientClaims.FirstOrDefault(e => e.OPDId == id);
if (ClaimNo != null)
{
ClaimNo.ClaimNumber = ClaimNumber;
ClaimNo.UserId = int.Parse(Session["UserId"].ToString());
}
else
{
db.PatientClaims.Add(new PatientClaim()
{
OPDId = id,
ClaimNumber = ClaimNumber,
UserId = int.Parse(Session["UserId"].ToString()),
BrunchId = db.Users.FirstOrDefault(e => e.Id.Equals((int)Session["UserId"])).Employee.Branch.Id,
});
}
int res = db.SaveChanges();
if (res > 0)
{
return(1);
}
else
{
return(0);
}
}
// GET: TurnAroundTime
public int insert(PatientTurnAroundTime aroundTime)
{
db.PatientTurnAroundTimes.Add(aroundTime);
var res = db.SaveChanges();
return(res);
}
public ActionResult Category(HSWardCategory category)
{
category.BranchId = (int)Session["UserBranchId"];
category.UserId = (int)Session["UserId"];
category.DateAdded = DateTime.Now;
db.HSWardCategories.Add(category);
db.SaveChanges();
return(RedirectToAction("Categories"));
}
public ActionResult PostReconciliation(int ShiftId, double ActualAmountCash, double ActualAmountCheque, double MpesaActualAmount, String ChequeNumbers)
{
var shift = db.Shifts.Find(ShiftId);
FinanceCashPointReconciliation entry = new FinanceCashPointReconciliation();
entry.ShiftId = ShiftId;
entry.CashActualAmount = ActualAmountCash;
entry.ChequeActualAmount = ActualAmountCheque;
entry.TimeAdded = DateTime.Now;
entry.UserId = 1; /*int.Parse(Session["UserId"].ToString());*/
entry.BranchId = 1;
entry.MpesaActualAmount = MpesaActualAmount;
entry.ChequeNumbers = ChequeNumbers;
db.FinanceCashPointReconciliations.Add(entry);
db.SaveChanges();
return(Json(new { Status = true }));
}
public ActionResult Delete(int id)
{
var loggedInUser = db.Users.Find(1);
var billItem = db.BillServices.Find(id);
if (billItem == null)
{
return(Json(new { Status = "success" }, JsonRequestBehavior.AllowGet));
}
var anyUserDeleteItems = true;
var usersDeleteUnpaidItems = db.KeyValuePairs.FirstOrDefault(e => e.Key_.ToLower().Trim() == "users_delete_unpaid_items");
if (usersDeleteUnpaidItems != null)
{
if (usersDeleteUnpaidItems.Value.Trim().ToLower() != "yes")
{
anyUserDeleteItems = false;
}
}
else
{
var keyValuePair = new KeyValuePair();
keyValuePair.Key_ = "users_delete_unpaid_items";
keyValuePair.Value = "NO";
db.KeyValuePairs.Add(keyValuePair);
db.SaveChanges();
}
if (billItem.IPDBillPartialPayments.Count() > 0 || billItem.Paid || billItem.Offered || billItem.Award > 0 || (billItem.WaivedAmount ?? 0) > 0)
{
return(Json(new { Status = "warning", Message = "Sorry. This item cannot be deleted. It has either been offered, paid for, awarded or waived." }, JsonRequestBehavior.AllowGet));
}
if (anyUserDeleteItems || billItem.UserId == loggedInUser.Id || loggedInUser.UserRole.RoleName.ToLower() == "sa" || loggedInUser.UserRole.RoleName.ToLower() == "admin")
{
db.BillServices.Remove(billItem);
db.SaveChanges();
return(Json(new { Status = "success" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { Status = "warning", Message = "Sorry. You are not allowed to delete this item. Only the person who added it can do so." }, JsonRequestBehavior.AllowGet));
}
}
public void AddKeyValue(String key, string value, string owner = null)
{
var k = db.KeyValuePairs.FirstOrDefault(e => e.Key_.ToLower().Trim() == key.ToLower().Trim() &&
e.Owner == owner);
if (k == null)
{
var keyvalue = new KeyValuePair();
keyvalue.Key_ = key.Trim();
keyvalue.Value = value.Trim();
keyvalue.Owner = owner;
db.KeyValuePairs.Add(keyvalue);
db.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "Id,MainCategory,SubCategory,salutation,FName,MName,LName,Gender,DOB,Religion,CorporateCompany,CorporateEmployeeId,ImageURL,ThumbNailURL,StreetAddress,Country,County,SubCounty,Village,NationalId,KinInitial,KinName,KinMobile,Email,BloodGroup,MaritalStatus,RegDate,RegTime,BranchId,Timestamp,RegNumber")] Patient patient)
{
if (ModelState.IsValid)
{
db.Entry(patient).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(patient));
}
public ActionResult AddNutritiondiet(NutritionDietchart diet)
{
ViewBag.OpdNo = diet.OPDIPDID;
int uid = Convert.ToInt32(Session["UserId"]);
diet.user_id = uid;
//diet.date_time = DateTime.Today;
if (ModelState.IsValid)
{
db.NutritionDietcharts.Add(diet);
db.SaveChanges();
ViewBag.success = true;
}
ViewBag.success = false;
return(RedirectToAction("Index", new { OpdNo = diet.OPDIPDID }));
}
public ActionResult SaveMorgAdmission(MorgAdmission morgAdmit)
{
morgAdmit.BranchId = (int)Session["UserBranchId"];
morgAdmit.UserId = (int)Session["UserId"];
morgAdmit.TimeAdded = DateTime.Now;
db.MorgAdmissions.Add(morgAdmit);
db.SaveChanges();
//if deceased was IPD, empty the bed
if (morgAdmit.PatientId.HasValue)
{
var pat = db.Patients.Find(morgAdmit.PatientId);
var lastVisit = pat.OpdRegisters.OrderByDescending(e => e.Id).FirstOrDefault();
if (lastVisit != null)
{
if (lastVisit.IsIPD)
{
lastVisit.Discharged = true;
lastVisit.DischargedAlive = false;
lastVisit.DischargeDate = morgAdmit.DateOfDeath;
db.SaveChanges();
}
}
}
//create an opd entry for the
return(Json(new { SerialNo = morgAdmit.Id.ToString().PadLeft(4, '0') }));
}
public ActionResult PostCampOrganizer(BloodBankCampOrganizer CampOrganizer)
{
if (ModelState.IsValid)
{
Session["UserId"] = CampOrganizer.Id;
CampOrganizer.Id = (int)Session["UserId"];
CampOrganizer.Date = DateTime.UtcNow;
db.BloodBankCampOrganizers.Add(CampOrganizer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public ActionResult Award100PercentToNHIF()
{
var x = 0;
var nhif = db.Companies.FirstOrDefault(e => e.CompanyName.ToLower().Trim() == "nhif");
var services = db.Services.ToList();
if (nhif != null)
{
foreach (var t in nhif.Tariffs)
{
db.ServicesPrices.RemoveRange(t.ServicesPrices);
db.SaveChanges();
foreach (var s in services)
{
var sp = new ServicesPrice();
sp.TariffId = t.Id;
sp.ServiceId = s.Id;
sp.Award = 100;
sp.AwardUnit = "Percent";
sp.DoctorFee = 0;
sp.DoctorFeeUnit = "Amount";
sp.DateAdded = DateTime.Now;
sp.BranchId = (int)Session["UserBranchId"];
sp.UserId = (int)Session["UserId"];
db.ServicesPrices.Add(sp);
x++;
}
db.SaveChanges();
}
}
return(Content("Updated " + x + " records"));
}
public ActionResult SaveAmbulanceRequest(AmbulanceRequest data)
{
//var OpdIpd = data.OpdRegisters.OrderByDescending(e => e.Id).FirstOrDefault();
data.UserId = (int)Session["UserId"];
var user = db.Users.Find(data.UserId);
data.RequestingNurse = user.Employee.FName + " " + user.Employee.OtherName + " ( " + user.Username + " ) ";
data.BranchId = 1;
data.AddedOn = DateTime.Now;
data.Assigned = false;
db.AmbulanceRequests.Add(data);
db.SaveChanges();
return(RedirectToAction("Index", new { id = data.Id }));
}
public string Migrate()
{
var data = db.OpdRegisters.ToList();
foreach (var i in data)
{
var opReg = db.OpdRegisters.Find(i.Id);
var branchini = db.KeyValuePairs.FirstOrDefault(e => e.Key_.ToLower().Equals("branchid"))?.Value ?? "0";
opReg.Id = branchini + "|" + i.Id;
db.SaveChanges();
if (opReg.AdmissionRecommendations.Count() > 0)
{
var lis = db.AdmissionRecommendations.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.AdmissionRecommendations.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.Allergies.Count() > 0)
{
var lis = db.Allergies.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.Allergies.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.AnaestheticRecords.Count() > 0)
{
var lis = db.AnaestheticRecords.Where(e => e.IPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.AnaestheticRecords.Find(u.Id);
ad.IPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.AssignmentDetails.Count() > 0)
{
var lis = db.AssignmentDetails.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.AssignmentDetails.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.BedShiftLogs.Count() > 0)
{
var lis = db.BedShiftLogs.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.BedShiftLogs.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.BillPayments.Count() > 0)
{
var lis = db.BillPayments.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.BillPayments.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.BillServices.Count() > 0)
{
var lis = db.BillServices.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.BillServices.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.BloodPressureCharts.Count() > 0)
{
var lis = db.BloodPressureCharts.Where(e => e.IPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.BloodPressureCharts.Find(u.Id);
ad.IPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.BloodSugarCharts.Count() > 0)
{
var lis = db.BloodSugarCharts.Where(e => e.IPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.BloodSugarCharts.Find(u.Id);
ad.IPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.Complaints.Count() > 0)
{
var lis = db.Complaints.Where(e => e.OpdIpdNumber == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.Complaints.Find(u.Id);
ad.OpdIpdNumber = opReg.Id;
db.SaveChanges();
}
}
if (opReg.CorneaClinicEntries.Count() > 0)
{
var lis = db.CorneaClinicEntries.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.CorneaClinicEntries.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.CSSDIssueToPatients.Count() > 0)
{
var lis = db.CSSDIssueToPatients.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.CSSDIssueToPatients.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.DeathCertificates.Count() > 0)
{
var lis = db.DeathCertificates.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.DeathCertificates.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.Deformities.Count() > 0)
{
var lis = db.Deformities.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.Deformities.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.DischargeRecommendations.Count() > 0)
{
var lis = db.DischargeRecommendations.Where(e => e.IpdNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.DischargeRecommendations.Find(u.Id);
ad.IpdNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.DoctorNotes.Count() > 0)
{
var lis = db.DoctorNotes.Where(e => e.IpdOpdNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.DoctorNotes.Find(u.Id);
ad.IpdOpdNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.FamilyHealthOverviews.Count() > 0)
{
var lis = db.FamilyHealthOverviews.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.FamilyHealthOverviews.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.FamilyMedicalHistoryResponses.Count() > 0)
{
var lis = db.FamilyMedicalHistoryResponses.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.FamilyMedicalHistoryResponses.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.Fibromyalgias.Count() > 0)
{
var lis = db.Fibromyalgias.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.Fibromyalgias.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.FitnessCertificates.Count() > 0)
{
var lis = db.FitnessCertificates.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.FitnessCertificates.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.GlucomaPerfomaEntries.Count() > 0)
{
var lis = db.GlucomaPerfomaEntries.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.GlucomaPerfomaEntries.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.HTCServiceSummaries.Count() > 0)
{
var lis = db.HTCServiceSummaries.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.HTCServiceSummaries.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.Hypermobilities.Count() > 0)
{
var lis = db.Hypermobilities.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.Hypermobilities.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.ImmunizationAdmins.Count() > 0)
{
var lis = db.ImmunizationAdmins.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.ImmunizationAdmins.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.InformedConsents.Count() > 0)
{
var lis = db.InformedConsents.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.InformedConsents.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
if (opReg.InfusionTherapies.Count() > 0)
{
var lis = db.InfusionTherapies.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.InfusionTherapies.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.InsuranceCards.Count() > 0)
{
var lis = db.InsuranceCards.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.InsuranceCards.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.InsuranceInvoices.Count() > 0)
{
var lis = db.InsuranceInvoices.Where(e => e.OpdId == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.InsuranceInvoices.Find(u.Id);
ad.OpdId = opReg.Id;
db.SaveChanges();
}
}
if (opReg.IntakeInputOutputs.Count() > 0)
{
var lis = db.IntakeInputOutputs.Where(e => e.OpdNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.IntakeInputOutputs.Find(u.Id);
ad.OpdNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.JPayAutoPayments.Count() > 0)
{
var lis = db.JPayAutoPayments.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.JPayAutoPayments.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.JPayments.Count() > 0)
{
var lis = db.JPayments.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.JPayments.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.LasikClinicEntries.Count() > 0)
{
var lis = db.LasikClinicEntries.Where(e => e.OPDNo == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.LasikClinicEntries.Find(u.Id);
ad.OPDNo = opReg.Id;
db.SaveChanges();
}
}
if (opReg.LeaveLetters.Count() > 0)
{
var lis = db.LeaveLetters.Where(e => e.OPDno == i.Id).ToList();
foreach (var u in lis)
{
var ad = db.LeaveLetters.Find(u.Id);
ad.OPDno = opReg.Id;
db.SaveChanges();
}
}
}
return("");
}
