public ActionResult DeleteConfirmed(string id)
{
Pest_Solution pest_Solution = db.Pest_Solutions.Find(id);
db.Pest_Solutions.Remove(pest_Solution);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "PSol_ID,P_ID,Sol_ID")] Pest_Solution pest_Solution)
{
if (ModelState.IsValid)
{
db.Entry(pest_Solution).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.P_ID = new SelectList(db.Pests, "P_ID", "Name", pest_Solution.P_ID);
ViewBag.Sol_ID = new SelectList(db.Solutions, "Sol_ID", "Description", pest_Solution.Sol_ID);
return(View(pest_Solution));
}
// GET: Pest_Solution/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Pest_Solution pest_Solution = db.Pest_Solutions.Find(id);
if (pest_Solution == null)
{
return(HttpNotFound());
}
return(View(pest_Solution));
}
// GET: Pest_Solution/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Pest_Solution pest_Solution = db.Pest_Solutions.Find(id);
if (pest_Solution == null)
{
return(HttpNotFound());
}
ViewBag.P_ID = new SelectList(db.Pests, "P_ID", "Name", pest_Solution.P_ID);
ViewBag.Sol_ID = new SelectList(db.Solutions, "Sol_ID", "Description", pest_Solution.Sol_ID);
return(View(pest_Solution));
}
public ActionResult Create([Bind(Include = "PSol_ID,P_ID,Sol_ID")] Pest_Solution pest_Solution)
{
var query = db.Pest_Solutions.Count() + 1;
string temp = "PSO-" + query;
bool exist = false;
try
{
var search = db.Pest_Solutions.Where(c => c.PSol_ID == temp).Single();
exist = true;
}
catch
{
exist = false;
}
if (exist)
{
var all = db.Pest_Solutions.ToList();
var dis = all.Last();
pest_Solution.PSol_ID = "PSO-" + DataModel.Constants.NextNumber(dis.PSol_ID);
}
else
{
pest_Solution.PSol_ID = temp;
}
if (ModelState.IsValid)
{
db.Pest_Solutions.Add(pest_Solution);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.P_ID = new SelectList(db.Pests, "P_ID", "Name", pest_Solution.P_ID);
ViewBag.Sol_ID = new SelectList(db.Solutions, "Sol_ID", "Description", pest_Solution.Sol_ID);
return(View(pest_Solution));
}
