public int Insert(Ultrasound ultrasound)
{
InsertCommand.Parameters["@ItemName"].Value = ultrasound.ItemName;
InsertCommand.Parameters["@ServiceFee"].Value = ultrasound.ServiceFee;
InsertCommand.Parameters["@ReferFee"].Value = ultrasound.ReferFee;
InsertCommand.Parameters["@ReaderFee"].Value = ultrasound.ReaderFee;
InsertCommand.Parameters["@TechFee"].Value = ultrasound.TechFee;
InsertCommand.Parameters["@Total"].Value = ultrasound.Total;
InsertCommand.Parameters["@CreateDate"].Value = ultrasound.CreateDate;
InsertCommand.Parameters["@Status"].Value = ultrasound.Status;
int returnValue = -1;
try
{
InsertCommand.Connection.Open();
returnValue = (int)InsertCommand.ExecuteScalar();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
InsertCommand.Connection.Close();
}
return(returnValue);
}
public int Update(Ultrasound ultrasound)
{
UpdateCommand.Parameters["@ID"].Value = ultrasound.ID;
UpdateCommand.Parameters["@ItemName"].Value = ultrasound.ItemName;
UpdateCommand.Parameters["@ServiceFee"].Value = ultrasound.ServiceFee;
UpdateCommand.Parameters["@ReferFee"].Value = ultrasound.ReferFee;
UpdateCommand.Parameters["@ReaderFee"].Value = ultrasound.ReaderFee;
UpdateCommand.Parameters["@TechFee"].Value = ultrasound.TechFee;
UpdateCommand.Parameters["@Total"].Value = ultrasound.Total;
UpdateCommand.Parameters["@CreateDate"].Value = ultrasound.CreateDate;
UpdateCommand.Parameters["@Status"].Value = ultrasound.Status;
int returnValue = -1;
try
{
UpdateCommand.Connection.Open();
returnValue = UpdateCommand.ExecuteNonQuery();
}
catch (SqlException ex)
{
Logger.Write(ex);
}
finally
{
UpdateCommand.Connection.Close();
}
return(returnValue);
}
public ActionResult DeleteConfirmed(int id)
{
Ultrasound ultrasound = db.Ultrasounds.Find(id);
db.Ultrasounds.Remove(ultrasound);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "UltrasoundId,Date,Ultrasounds,Count,FollicleSize,Notes,ReptileId")] Ultrasound ultrasound)
{
if (ModelState.IsValid)
{
db.Entry(ultrasound).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ReptileId = new SelectList(db.Reptiles, "ReptileId", "SpeciesName", ultrasound.ReptileId);
return(View(ultrasound));
}
public async Task <ActionResult> Ultrasound([Bind(Include = "UltrasoundId,Date,Ultrasounds,Count,FollicleSize,Notes,ReptileId")] Ultrasound ultrasound)
{
if (ModelState.IsValid)
{
db.Ultrasounds.Add(ultrasound);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(ultrasound));
}
// GET: Ultrasounds/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ultrasound ultrasound = db.Ultrasounds.Find(id);
if (ultrasound == null)
{
return(HttpNotFound());
}
return(View(ultrasound));
}
// moved to reptile controller
// GET: Ultrasounds/Create
/* public ActionResult Create()
* {
* ViewBag.ReptileId = new SelectList(db.Reptiles, "ReptileId", "SpeciesName");
* return View();
* }
*
* // POST: Ultrasounds/Create
* // To protect from overposting attacks, please enable the specific properties you want to bind to, for
* // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
* [HttpPost]
* [ValidateAntiForgeryToken]
* public ActionResult Create([Bind(Include = "UltrasoundId,Date,Ultrasounds,Count,FollicleSize,Notes,ReptileId")] Ultrasound ultrasound)
* {
* if (ModelState.IsValid)
* {
* db.Ultrasounds.Add(ultrasound);
* db.SaveChanges();
* return RedirectToAction("Index");
* }
*
* ViewBag.ReptileId = new SelectList(db.Reptiles, "ReptileId", "SpeciesName", ultrasound.ReptileId);
* return View(ultrasound);
* }
*/
// GET: Ultrasounds/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Ultrasound ultrasound = db.Ultrasounds.Find(id);
if (ultrasound == null)
{
return(HttpNotFound());
}
ViewBag.ReptileId = new SelectList(db.Reptiles, "ReptileId", "SpeciesName", ultrasound.ReptileId);
return(View(ultrasound));
}
// GET: Ultrasounds/Create
public async Task <ActionResult> Ultrasound(string id, Ultrasound ultras)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reptile reptile = await db.Reptiles.FindAsync(id);
if (reptile == null)
{
return(HttpNotFound());
}
ultras.ReptileId = reptile.ReptileId;
return(View(ultras));
}
public void PointsCalculateCalculatesPoinsWhoseAreaIsTheRightSize(int offsetX, int offsetY, int rotate)
{
var w = World.Instance;
w.ControlledCar = new AutomatedCar.Models.AutomatedCar(50, 50, "car_1_white", 108, 240, new List <List <Point> >());
Ultrasound ultrasound = new Ultrasound(w.ControlledCar.VirtualFunctionBus, offsetX, offsetY, rotate);
ultrasound.Points = ultrasound.CalculatePoints();
double a = LineLenght(ultrasound.Points[0], ultrasound.Points[1]);
double b = LineLenght(ultrasound.Points[0], ultrasound.Points[2]);
double c = LineLenght(ultrasound.Points[2], ultrasound.Points[1]);
double s = (a + b + c) / 2;
double area = HeronFormula(s, a, b, c);
double expectedArea = ultrasound.range * (2 * ultrasound.range * Math.Tan(ultrasound.angleOfView / 2 * Math.PI / 180)) / 2;
Assert.Equal(Math.Round(area, 3), Math.Round(expectedArea, 3));
}
public ActionResult Edit(Ultrasound model)
{
try
{
obj.Update(model, out outmodel);
if (!outmodel.Error)
{
// TODO: Add update logic here
return(RedirectToAction("Index"));
}
else
{
return(View(model));
}
}
catch (Exception ex)
{
ex.Message.ToString();
return(View());
}
}
private Ultrasound DataTableToEntity(DataTable dt)
{
Ultrasound ultrasound = new Ultrasound();
if (Null.IsNotNull(dt) == true && dt.Rows.Count > 0)
{
if (Null.IsNotNull(dt.Rows[0]))
{
DataRow dr = dt.Rows[0];
if (Null.IsNotNull(dr["ID"]))
{
ultrasound.ID = Convert.ToInt32(dr["ID"]);
}
else
{
ultrasound.ID = 0;
}
if (Null.IsNotNull(dr["ItemName"]))
{
ultrasound.ItemName = Convert.ToString(dr["ItemName"]);
}
else
{
ultrasound.ItemName = string.Empty;
}
if (Null.IsNotNull(dr["ServiceFee"]))
{
ultrasound.ServiceFee = Convert.ToDecimal(dr["ServiceFee"]);
}
else
{
ultrasound.ServiceFee = 0.00m;
}
if (Null.IsNotNull(dr["ReferFee"]))
{
ultrasound.ReferFee = Convert.ToDecimal(dr["ReferFee"]);
}
else
{
ultrasound.ReferFee = 0.00m;
}
if (Null.IsNotNull(dr["ReaderFee"]))
{
ultrasound.ReaderFee = Convert.ToDecimal(dr["ReaderFee"]);
}
else
{
ultrasound.ReaderFee = 0.00m;
}
if (Null.IsNotNull(dr["TechFee"]))
{
ultrasound.TechFee = Convert.ToDecimal(dr["TechFee"]);
}
else
{
ultrasound.TechFee = 0.00m;
}
if (Null.IsNotNull(dr["Total"]))
{
ultrasound.Total = Convert.ToDecimal(dr["Total"]);
}
else
{
ultrasound.Total = 0.00m;
}
if (Null.IsNotNull(dr["CreateDate"]))
{
ultrasound.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
}
else
{
ultrasound.CreateDate = DateTime.Now;
}
if (Null.IsNotNull(dr["Status"]))
{
ultrasound.Status = Convert.ToString(dr["Status"]);
}
else
{
ultrasound.Status = string.Empty;
}
}
}
return(ultrasound);
}
public ActionResult Create(Ultrasound model)
{
var toReturn = obj.Save(model, out outmodel);
return(Json(new { mdl = outmodel, pa = toReturn }, JsonRequestBehavior.AllowGet));
}
