/// <summary>
/// Read all Purchase order details
/// </summary>
/// <returns>Returns List of Purchase order</returns>
public ActionResult Read()
{
List <POSModel> empList = new List <POSModel>();
empList = POSDal.Read();
return(View(empList));
}
/// <summary>
/// Gets the recent changes made in DB
/// </summary>
/// <param name="afterDate">Changes made in DB after the mentioned date</param>
/// <returns></returns>
public List <POSModel> GetRecentChanges(DateTime afterDate)
{
List <POSModel> list = new List <POSModel>();
POSDal posDal = new POSDal();
list = posDal.Notification(afterDate);
return(list);
}
/// <summary>
/// Get Recent changes through SqlCacheDependency
/// </summary>
/// <returns>Returns Partial view</returns>
public ActionResult Recent()
{
List <POSModel> empList = new List <POSModel>();
if (System.Web.HttpContext.Current.Cache["RecentPos"] != null)
{
empList = System.Web.HttpContext.Current.Cache["RecentPos"] as List <POSModel>;
}
else
{
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["POSConnection"].ConnectionString;
System.Web.Caching.SqlCacheDependencyAdmin.EnableNotifications(connStr);
System.Web.Caching.SqlCacheDependencyAdmin.EnableTableForNotifications(connStr, "PurchaseOrder");
SqlCacheDependency sqlDependency = new SqlCacheDependency("CachingPOS", "PurchaseOrder");
empList = POSDal.Recent();
System.Web.HttpContext.Current.Cache.Insert("RecentPos", empList, sqlDependency);
}
return(PartialView(empList));
}
public ActionResult Delete(int id)
{
POSModel.Id = id;
POSModel = POSDal.GetPurchaseOrder(POSModel);
return(View(POSModel));
}
/// <summary>
/// Edit Purchase order details for the given id
/// </summary>
/// <param name="posModel">POSModel object</param>
/// <returns>After successful updation redirects to Read method</returns>
public ActionResult Edit(POSModel posModel)
{
POSDal.Update(posModel);
return(RedirectToAction("Read"));
}
public ActionResult Edit(int id)
{
POSModel.Id = id;
POSModel = POSDal.GetPurchaseOrder(POSModel);
return(View("Create", POSModel));
}
public ActionResult Create(POSModel posModel)
{
POSDal.Create(posModel);
return(RedirectToAction("Read"));
}
