public IActionResult Put([FromODataUri] Guid key, MedicalTest medicaltest) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (var trans = context.Database.BeginTransaction()) { try { if (context.MedicalTests.Find(key) == null) { return(NotFound()); } //context = new ApplicationDbContext(context.Options); var local = context.MedicalTests.Local.FirstOrDefault(it => it.MedicalTestID.Equals(key)); if (local != null) { context.Entry(local).State = EntityState.Detached; } context.Entry(medicaltest).State = EntityState.Modified; context.SaveChanges(); trans.Commit(); return(Ok(medicaltest)); } catch (Exception ex) { trans.Rollback(); return(BadRequest(ex)); } } }
public void OnGet(int id) { using (var repo = new Repo(ConnectionStrings.Default)) { MedicalTest = repo.GetMedicalTest(id); } }
public ActionResult DeleteConfirmed(int id) { MedicalTest medicaltest = db.MedicalTests.Find(id); db.MedicalTests.Remove(medicaltest); db.SaveChanges(); return(RedirectToAction("Index")); }
// // GET: /MedicalTest/Delete/5 public ActionResult Delete(int id = 0) { MedicalTest medicaltest = db.MedicalTests.Find(id); if (medicaltest == null) { return(HttpNotFound()); } return(View(medicaltest)); }
public ActionResult Edit(MedicalTest medicaltest) { if (ModelState.IsValid) { db.Entry(medicaltest).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(medicaltest)); }
public ActionResult Edit([Bind(Include = "Id,MedicalTestName,MedicalTestDetails,MedicalTestAdvice,Note,Extra,IsActive,IsDeleted,NotDeletable,CreationDate,UpdateDate,UserId,CompanyId")] MedicalTest medicaltest) { if (ModelState.IsValid) { db.Entry(medicaltest).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(medicaltest)); }
public ActionResult Create(MedicalTest medicaltest) { if (ModelState.IsValid) { db.MedicalTests.Add(medicaltest); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(medicaltest)); }
public MedicalTest ConvertToModel(SqlDataReader dataReader) { MedicalTest medicalTest = new MedicalTest(); medicalTest.id = dataReader.GetGuid(dataReader.GetOrdinal("MedicalTestId")); medicalTest.patientID = dataReader.GetGuid(dataReader.GetOrdinal("PatientId")); medicalTest.results = dataReader.GetString(dataReader.GetOrdinal("Results")); medicalTest.date = dataReader.GetDateTime(dataReader.GetOrdinal("Date")); return(medicalTest); }
// GET: /MedicalTest/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MedicalTest medicaltest = db.MedicalTests.Find(id); if (medicaltest == null) { return(HttpNotFound()); } return(View(medicaltest)); }
public void Insert(MedicalTest medicalTest) { using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = MedicalTest_INSERT; command.Parameters.Add(new SqlParameter("@PatientId", medicalTest.patientID)); command.Parameters.Add(new SqlParameter("@Result", medicalTest.results)); command.Parameters.Add(new SqlParameter("@Date", medicalTest.date)); command.ExecuteNonQuery(); } } }
public MedicalTest GetMedicalTest(int id) { var cmd = connection.CreateCommand(); cmd.CommandText = @"SELECT * FROM (medical_test mt JOIN patient p) WHERE ((@MedicalTestID = mt.medical_test_id) AND (mt.patient_id = p.patient_id))"; cmd.Parameters.Add("@MedicalTestID", MySqlDbType.Int32).Value = id; cmd.ExecuteNonQuery(); var result = new MedicalTest(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var blood_type = Populate <MedicalTest>(reader); result = blood_type; } } return(result); }
public IActionResult Post(MedicalTest medicaltest) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (var trans = context.Database.BeginTransaction()) { try { context.MedicalTests.Add(medicaltest); context.SaveChanges(); trans.Commit(); return(Ok(medicaltest)); } catch (Exception ex) { trans.Rollback(); return(BadRequest(ex)); } } }
public void Insert(MedicalTest medicalTest) { _medicalTestDAL.Insert(medicalTest); }
public void Insert(MedicalTest medicalTest) { _blContext.MedicalTest.Insert(medicalTest); }