public ActionResult Edit([Bind(Include = "TransID,MarketModelId,ForYear,DoneFlag,NotAvailableFlag,BacklogInfo,ReleaseInfo")] ModelYearDeclaration modelYearDeclaration)
{
if (ModelState.IsValid)
{
db.Entry(modelYearDeclaration).State = EntityState.Modified;
db.SaveChanges();
SqlParameter release = new SqlParameter("@release", modelYearDeclaration.ReleaseInfo);
SqlParameter releaseNull = new SqlParameter("@release", "empty");
SqlParameter transid = new SqlParameter("@TransId", modelYearDeclaration.TransID);
SqlParameter doneflag = new SqlParameter("@done", modelYearDeclaration.DoneFlag);
SqlParameter naflag = new SqlParameter("@na", modelYearDeclaration.NotAvailableFlag);
SqlParameter user = new SqlParameter("@User", User.Identity.Name);
if (String.IsNullOrEmpty(modelYearDeclaration.ReleaseInfo))
{
db.Database.ExecuteSqlCommand("sp_UICoverageUpdateAdmin @TransId, @done, @na, @release, @User",
transid, doneflag, naflag, releaseNull, user);
}
else
{
db.Database.ExecuteSqlCommand("sp_UICoverageUpdateAdmin @TransId, @done, @na, @release, @User",
transid, doneflag, naflag, release, user);
}
}
return(RedirectToAction("Index", "SalesModels"));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ModelYearDeclaration modelYearDeclaration = db.ModelYearDeclarations.Find(id);
if (modelYearDeclaration == null)
{
return(HttpNotFound());
}
return(PartialView("_UpdateCoveragePartial", modelYearDeclaration));
}
