public ActionResult DeleteConfirmed(int id) { WorkOrderTest workOrderTest = db.workordertest.Find(id); db.workordertest.Remove(workOrderTest); db.SaveChanges(); return(RedirectToAction("Index")); }
public InvestigationFormData AddWorkOrderTest(OpdRegister OPDEntry, int serviceId, int billserviceId) { InvestigationFormData investigationFormData = new InvestigationFormData(); investigationFormData.TestBillServices = db.BillServices.Where(e => e.OPDNo == OPDEntry.Id && (e.Service.IsLAB || e.Service.IsXRAY)).ToList(); investigationFormData.Patient = OPDEntry.Patient; investigationFormData.OpdRegister = OPDEntry; var dep = db.Departments.FirstOrDefault(e => e.DepartmentName.ToLower().Trim().Equals("lab") || e.DepartmentName.ToLower().Trim().Equals("pathology")).Id; CareSoftLabsEntities labDb = new CareSoftLabsEntities(); var workOrder = labDb.WorkOrders.FirstOrDefault(e => e.OPDNo == OPDEntry.Id); if (workOrder == null) { //start new work order workOrder = new WorkOrder(); workOrder.OPDNo = OPDEntry.Id; workOrder.OPDType = "OPD"; if (OPDEntry.IsIPD) { workOrder.OPDType = "IPD"; } workOrder.BillPaid = 1; workOrder.Doctor = (int)Session["UserId"]; workOrder.CreatedUtc = DateTime.Now; workOrder.DepartmentRadPath = dep; workOrder.Accession_Status = labDb.Status.FirstOrDefault(e => e.StatusValue.ToLower().Trim().Equals("default")).Id; labDb.WorkOrders.Add(workOrder); labDb.SaveChanges(); } //add work order tests WorkOrderTest test = new WorkOrderTest(); test.WorkOrder = workOrder.Id; test.Test = (int)db.Services.Find(serviceId).LabId; test.BillPaid = false; test.Status = labDb.Status.FirstOrDefault(e => e.StatusValue.ToLower().Trim().Equals("default")).Id; test.CreatedUtc = DateTime.Now; labDb.WorkOrderTests.Add(test); labDb.SaveChanges(); var ser = db.BillServices.Find(billserviceId); ser.WorkOrderTestId = test.Id; db.SaveChanges(); hs.AttemptMarkPaid(billserviceId, 0); return(investigationFormData); }
public ActionResult Edit([Bind(Include = "WorkOrderTestID,WorkOrderAssayID,TestID,StatusID,TestResult,SampleConcentration,CustomerApproval,RawDataResult")] WorkOrderTest workOrderTest) { if (ModelState.IsValid) { db.Entry(workOrderTest).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.StatusID = new SelectList(db.status, "StatusID", "StatusDescription", workOrderTest.StatusID); ViewBag.TestID = new SelectList(db.test, "TestID", "TestName", workOrderTest.TestID); ViewBag.WorkOrderAssayID = new SelectList(db.workorderassay, "WorkOrderAssayID", "DateArrived", workOrderTest.WorkOrderAssayID); return(View(workOrderTest)); }
// GET: WorkOrderTests/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrderTest workOrderTest = db.workordertest.Find(id); if (workOrderTest == null) { return(HttpNotFound()); } return(View(workOrderTest)); }
// GET: WorkOrderTests/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkOrderTest workOrderTest = db.workordertest.Find(id); if (workOrderTest == null) { return(HttpNotFound()); } ViewBag.StatusID = new SelectList(db.status, "StatusID", "StatusDescription", workOrderTest.StatusID); ViewBag.TestID = new SelectList(db.test, "TestID", "TestName", workOrderTest.TestID); ViewBag.WorkOrderAssayID = new SelectList(db.workorderassay, "WorkOrderAssayID", "DateArrived", workOrderTest.WorkOrderAssayID); return(View(workOrderTest)); }