public ActionResult DeleteConfirmed(int id)
{
MdmDQQue mdmDQQue = db.MdmDQQues.Find(id);
db.MdmDQQues.Remove(mdmDQQue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//private AppDbContext db;// = new AppDbContext();
#endregion
/// <summary>
/// Inserts a new row in the MdmDQQue table.
/// </summary>
/// <param name="mdmque">A MdmDQQue object.</param>
/// <returns>An updated MdmDQQue object.</returns>
public MdmDQQue Insert(MdmDQQue mdmdque)
{
using (var db = new AppDbContext())
{
db.Set <MdmDQQue>().Add(mdmdque);
db.SaveChanges();
return(mdmdque);
}
}
/// <summary>
/// Updates the queitem
/// </summary>
/// <param name="queitem">queitem</param>
public virtual void UpdateQueItem(MdmDQQue queitem)
{
if (queitem == null)
{
throw new ArgumentNullException("queitem");
}
//_dqqueRepository.Update(queitem);
//event notification
//_eventPublisher.EntityUpdated(vendor);
}
//private readonly IRepository<MdmDQQue> _dqqueRepository;
#endregion
/// <summary>
/// Delete an item
/// </summary>
/// <param name="queitem">QueItem</param>
public virtual void DeleteQueItem(MdmDQQue queitem)
{
if (queitem == null)
{
throw new ArgumentNullException("queitem");
}
UpdateQueItem(queitem);
//event notification
//_eventPublisher.EntityDeleted(vendor);
}
/// <summary>
/// Inserts a queitem
/// </summary>
/// <param name="queitem">Queitem</param>
public virtual void InsertQueItem(MdmDQQue queitem)
{
if (queitem == null)
{
throw new ArgumentNullException("queitem");
}
_dqqueDAC.Insert(queitem);
//event notification
//_eventPublisher.EntityInserted(vendor);
}
/// <summary>
/// Updates an existing row in the mdmdque table.
/// </summary>
/// <param name="mdmdque">A mdmdque entity object.</param>
public void Update(MdmDQQue mdmdque)
{
using (var db = new AppDbContext())
{
var entry = db.Entry <MdmDQQue>(mdmdque);
// Re-attach the entity.
entry.State = EntityState.Modified;
db.SaveChanges();
}
}
public ActionResult Edit([Bind(Include = "RECORD_ID,DATA_SOURCE,CATALOG_NAME,ERROR_CODE,ERROR_DESC,DQ_PROCESS_NAME,IMPACT_LEVEL,PRIORITY,QUE_STATUS,CREATED_BY,CREATED_DATE")] MdmDQQue mdmDQQue)
{
if (ModelState.IsValid)
{
db.Entry(mdmDQQue).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IMPACT_LEVEL = new SelectList(db.MdmDQImpacts, "IMPACT_CODE", "IMPACT_DESCRIPTION", mdmDQQue.IMPACT_LEVEL);
ViewBag.PRIORITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDQQue.PRIORITY);
ViewBag.QUE_STATUS = new SelectList(db.MdmDQQueStatuses, "STATUS_CODE", "STATUS_DESCRIPTION", mdmDQQue.QUE_STATUS);
return(View(mdmDQQue));
}
// GET: MdmDQQues/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MdmDQQue mdmDQQue = db.MdmDQQues.Find(id);
if (mdmDQQue == null)
{
return(HttpNotFound());
}
return(View(mdmDQQue));
}
public ActionResult Create(MdmDQQue mdmDQQue)
{
if (ModelState.IsValid)
{
db.MdmDQQues.Add(mdmDQQue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IMPACT_LEVEL = new SelectList(db.MdmDQImpacts, "IMPACT_CODE", "IMPACT_DESCRIPTION", mdmDQQue.IMPACT_LEVEL);
ViewBag.PRIORITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDQQue.PRIORITY);
ViewBag.QUE_STATUS = new SelectList(db.MdmDQQueStatuses, "STATUS_CODE", "STATUS_DESCRIPTION", mdmDQQue.QUE_STATUS);
return(View(mdmDQQue));
}
// GET: MdmDQQues/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MdmDQQue mdmDQQue = db.MdmDQQues.Find(id);
if (mdmDQQue == null)
{
return(HttpNotFound());
}
ViewBag.IMPACT_LEVEL = new SelectList(db.MdmDQImpacts, "IMPACT_CODE", "IMPACT_DESCRIPTION", mdmDQQue.IMPACT_LEVEL);
ViewBag.PRIORITY = new SelectList(db.MdmDQPriorities, "PRIORITY_CODE", "PRIORITY_DESCRIPTION", mdmDQQue.PRIORITY);
ViewBag.QUE_STATUS = new SelectList(db.MdmDQQueStatuses, "STATUS_CODE", "STATUS_DESCRIPTION", mdmDQQue.QUE_STATUS);
return(View(mdmDQQue));
}
