//private AppDbContext db;// = new AppDbContext();
#endregion
#region WrongSegment
/// <summary>
/// Inserts a new row in the MdmDQQue table.
/// </summary>
/// <param name="mdmque">A MdmDQQue object.</param>
/// <returns>An updated MdmDQQue object.</returns>
public WrongSegment InsertWrongSegment(WrongSegment mdmdque)
{
using (var db = new AppDbContext())
{
db.Set <WrongSegment>().Add(mdmdque);
db.SaveChanges();
return(mdmdque);
}
}
/// <summary>
/// Updates an existing row in the mdmdque table.
/// </summary>
/// <param name="mdmdque">A mdmdque entity object.</param>
public void UpdateWrongSegment(WrongSegment mdmdque)
{
using (var db = new AppDbContext())
{
var entry = db.Entry <WrongSegment>(mdmdque);
// Re-attach the entity.
entry.State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Updates the queitem
/// </summary>
/// <param name="queitem">queitem</param>
public virtual void UpdateWrongSegment(WrongSegment queitem)
{
if (queitem == null)
{
throw new ArgumentNullException("queitem");
}
_wsDAC.UpdateWrongSegment(queitem);
//event notification
//_eventPublisher.EntityUpdated(vendor);
}
/// <summary>
/// Delete an item
/// </summary>
/// <param name="queitem">QueItem</param>
public virtual void DeleteQueItem(WrongSegment queitem)
{
if (queitem == null)
{
throw new ArgumentNullException("queitem");
}
UpdateWrongSegments(queitem);
//event notification
//_eventPublisher.EntityDeleted(vendor);
}
public virtual ActionResult ExportExcelAll(WrongSegment model)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var items = _dqQueService.GetAllWrongSegments(model.ORGKEY, model.ACCOUNTNO, model.CUST_FIRST_NAME, model.CUST_MIDDLE_NAME, model.CUST_LAST_NAME, model.PRIMARY_SOL_ID);
try
{
byte[] bytes = _exportManager.ExportDocumentsToXlsx(items);
identity = ((CustomPrincipal)User).CustomIdentity;
_messagingService.SaveUserActivity(identity.ProfileId, "Downloaded Segment Subsegment Mapping Report", DateTime.Now);
return(File(bytes, MimeTypes.TextXlsx, "wrongSegment.xlsx"));
}
catch (Exception exc)
{
ErrorNotification(exc);
return(RedirectToAction("List"));
}
}
