public ActionResult Save(TestDetail test)
{
bool status = false;
if (ModelState.IsValid)
{
using (CovidDbEntities dc = new CovidDbEntities())
{
if (test.TestDetailsId > 0)
{
//Edit
var v = dc.TestDetails.Where(a => a.TestDetailsId == test.TestDetailsId).FirstOrDefault();
if (v != null)
{
v.TestName = test.TestName;
v.TestDate = test.TestDate;
v.TestResult = test.TestResult;
v.TotalPrice = test.TotalPrice;
v.DoctorRemark = test.DoctorRemark;
}
}
else
{
//Save
dc.TestDetails.Add(test);
}
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { Status = status }
});
}
public ActionResult Save(int id)
{
using (CovidDbEntities dc = new CovidDbEntities())
{
var v = dc.TestDetails.Where(a => a.TestDetailsId == id).FirstOrDefault();
return(View(v));
}
}
public ActionResult GetTestDetailsreport()
{
using (CovidDbEntities dc = new CovidDbEntities())
{
List <TestDetail> lists = dc.TestDetails.OrderBy(a => a.TestName).ToList();
var testdetails = lists;
return(Json(new { data = testdetails }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetHospitalnames(int cityIds)
{
List <Hospital> hospitals = new List <Hospital>();
using (CovidDbEntities dc = new CovidDbEntities())
{
hospitals = dc.Hospitals.Where(a => a.CityId.Equals(cityIds)).OrderBy(a => a.HospitalName).ToList();
}
return(new JsonResult {
Data = hospitals, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GettHospitalCities()
{
List <City> cities = new List <City>();
using (CovidDbEntities dc = new CovidDbEntities())
{
cities = dc.Cities.OrderBy(a => a.CityName).ToList();
}
return(new JsonResult {
Data = cities, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Delete(int id)
{
using (CovidDbEntities dc = new CovidDbEntities())
{
var v = dc.TestDetails.Where(a => a.TestDetailsId == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult DeleteEmployee(int id)
{
bool status = false;
using (CovidDbEntities dc = new CovidDbEntities())
{
var v = dc.TestDetails.Where(a => a.TestDetailsId == id).FirstOrDefault();
if (v != null)
{
dc.TestDetails.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { Status = status }
});
}