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);
}
