public ActionResult DeleteConfirmed(int id)
{
CompoundStatus compoundStatus = db.CompoundStatuses.Find(id);
db.CompoundStatuses.Remove(compoundStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,CompoundId,StatusId,StatusDate")] CompoundStatus compoundStatus)
{
if (ModelState.IsValid)
{
db.Entry(compoundStatus).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StatusId = new SelectList(db.Statuses, "StatusId", "StatusName", compoundStatus.StatusId);
return(View(compoundStatus));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CompoundStatus compoundStatus = db.CompoundStatuses.Find(id);
if (compoundStatus == null)
{
return(HttpNotFound());
}
return(View(compoundStatus));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CompoundStatus compoundStatus = db.CompoundStatuses.Find(id);
if (compoundStatus == null)
{
return(HttpNotFound());
}
ViewBag.StatusId = new SelectList(db.Statuses, "StatusId", "StatusName", compoundStatus.StatusId);
return(View(compoundStatus));
}
public ActionResult Create([Bind(Include = "Id,CompoundId,StatusId,StatusDate")] CompoundStatus compoundStatus)
{
if (ModelState.IsValid)
{
db.Database.ExecuteSqlCommand(
$"INSERT INTO Compound_Status (StatusId, CompoundId, StatusDate) " +
$"VALUES ({compoundStatus.StatusId}, {compoundStatus.CompoundId}, '{compoundStatus.StatusDate}')");
//db.CompoundStatuses.Add(compoundStatus);
var associatedClient = db.Clients.SqlQuery(@"SELECT TOP 1 Client.* FROM Compound CD
INNER JOIN Work_Order WO ON WO.OrderId = CD.OrderId
INNER JOIN Client ON Client.ClientId = WO.ClientId
WHERE CD.CompoundId = " + compoundStatus.CompoundId).ToList <Client>()[0];
var associatedCompound = db.Compounds.SqlQuery("SELECT TOP 1 * FROM Compound WHERE CompoundId = " + compoundStatus.CompoundId).ToList <Compound>()[0];
SendCompoundUpdatedEmail(associatedClient, associatedCompound);
//db.SaveChanges();
return(RedirectToAction("Details", new { Controller = "Compounds", Id = compoundStatus.CompoundId }));
}
ViewBag.StatusId = new SelectList(db.Statuses, "StatusId", "StatusName", compoundStatus.StatusId);
return(View(compoundStatus));
}
