public ActionResult ViewOrder(int id)
{
using (var cRepository = new CollateralRepository())
{
return(View(viewName: "NewViewOrder", model: cRepository.GetPendingOrder(id, true)));
}
}
public ActionResult ShipOrder(int id)
{
using (var cRepository = new CollateralRepository())
{
return(View(cRepository.GetPendingOrder(id, false)));
}
}
public ActionResult EditOrder(int id)
{
using (var cRepository = new CollateralRepository())
{
return(View(cRepository.GetOrderInformation(id)));
}
}
public ActionResult ViewShipment(int id)
{
using (var cRepository = new CollateralRepository())
{
return(View(cRepository.GetOrderShipment(id)));
}
}
public JsonResult CancelOrder(int id)
{
using (var cRepository = new CollateralRepository())
{
return(Json(cRepository.CancelOrder(id), JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrder()
{
using (var cRepository = new CollateralRepository())
{
return(View(viewName: "NewAddOrder", model: cRepository.BlankOrderInformation()));
}
}
public ActionResult AddShipment(List <CollateralShipmentDetail> theList)
{
using (var cRepository = new CollateralRepository())
{
cRepository.AddCollateralShipment(theList);
return(RedirectToAction("Manage"));
}
}
public ActionResult EditGroup(int id)
{
using (var cRepository = new CollateralRepository())
{
var cInfo = cRepository.GetCollateralGroup(id);
return(View(cInfo));
}
}
public JsonResult UserHomePageList(int itemCount)
{
using (var cRepository = new CollateralRepository())
{
var results = cRepository.GetHomePageOrderList(itemCount);
return(Json(results, JsonRequestBehavior.AllowGet));
}
}
public static IEnumerable <SelectListItem> GetProductDDList(int?itemId = null)
{
using (var cRepository = new CollateralRepository())
{
return(cRepository.GetCollateralList(false).Select(c => new SelectListItem()
{
Value = c.Key.ToString(), Text = c.Value, Selected = (c.Key == (itemId ?? 0))
}));
}
}
public static IEnumerable <SelectListItem> GetCollateralTypeDDList()
{
using (var cRepository = new CollateralRepository())
{
return(cRepository.GetCollateralTypeList().Select(u => new SelectListItem()
{
Value = u.Key.ToString(), Text = u.Value
}));
}
}
public ActionResult EditOrder(NewOrderInformation orderInfo)
{
if (ModelState.IsValid)
{
using (var cRepository = new CollateralRepository())
{
cRepository.UpdateCollateralOrder(orderInfo);
return(RedirectToAction("Orders"));
}
}
return(View(orderInfo));
}
public ActionResult ShipOrder(int id, PendingOrderInformation.ShipmentSummary summary)
{
using (var cRepository = new CollateralRepository())
{
if (ModelState.IsValid)
{
cRepository.AddOrderShipment(id, summary);
return(RedirectToAction("ShipOrder", new { id = id }));
}
return(View(cRepository.GetPendingOrder(id, false)));
}
}
public static IEnumerable <CollateralTypeDetail> GetCollateralTypeTabList()
{
using (var cRepo = new CollateralRepository())
{
var theList = cRepo.GetCollateralTypeOrderedList();
theList.Add(new CollateralTypeDetail()
{
name = "Bundle", id = -1, order = -1
});
theList.Sort(delegate(CollateralTypeDetail x, CollateralTypeDetail y)
{
return(x.order.CompareTo(y.order));
});
return(theList);
}
}
public ActionResult AddGroup(CollateralGroupInformation cInfo, HttpPostedFileBase CollateralImage)
{
if (ModelState.IsValid)
{
using (var cRepository = new CollateralRepository())
{
cRepository.AddCollateral(cInfo,
CollateralImage != null ? CollateralImage.InputStream : null,
CollateralImage != null ? CollateralImage.FileName : null);
return(RedirectToAction("Manage"));
}
}
return(View(cInfo));
}
public JsonResult FullCollateralOrderListForUser(CollateralOrderTableParams param)
{
int totalCount = 0, filteredCount = 0;
using (var cRepository = new CollateralRepository())
{
var results = cRepository.GetFullCollateralOrderListForUser(
param, out totalCount, out filteredCount);
return(Json(new
{
sEcho = param.sEcho,
iTotalRecords = totalCount,
iTotalDisplayRecords = filteredCount,
aaData = results
},
JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrder(NewOrderInformation orderInfo)
{
if (ModelState.IsValid)
{
using (var cRepository = new CollateralRepository())
{
cRepository.AddCollateralOrder(orderInfo);
if (PaoliWebUser.CurrentUser.CanManageOrders)
{
return(RedirectToAction("Orders"));
}
return(RedirectToAction("ViewOrders"));
}
}
return(View(viewName: "NewAddOrder", model: orderInfo));
}
public UnitOfWork(CorpCommDbContext db)
{
_db = db;
Brand = new BrandRepository(_db);
StationType = new StationTypeRepository(_db);
Unit = new UnitRepository(_db);
Department = new DepartmentRepository(_db);
Status = new StatusRepository(_db);
Size = new SizeRepository(_db);
Email = new EmailRepository(_db);
Location = new LocationRepository(_db);
Event = new EventRepository(_db);
Station = new StationRepository(_db);
Collateral = new CollateralRepository(_db);
OrderDetails = new OrderDetailsRepository(_db);
OrderHeader = new OrderHeaderRepository(_db);
ShoppingCart = new ShoppingCartRepository(_db);
History = new HistoryRepository(_db);
SP_Call = new SP_Call(_db);
}
public FileStreamResult CollateralOrderList()
{
using (CollateralRepository cRepo = new CollateralRepository())
{
var theData = cRepo.GetExportList();
var theItems = cRepo.GetOrderDetailNameList();
using (var memoryStream = new MemoryStream())
{
using (var streamWriter = new StreamWriter(memoryStream))
{
using (var csvWriter = new CsvWriter(streamWriter))
{
csvWriter.WriteField("OrderID");
csvWriter.WriteField("OrderDate");
csvWriter.WriteField("Status");
csvWriter.WriteField("CreatedByUserName");
csvWriter.WriteField("CreatedByCompany");
csvWriter.WriteField("RequestingParty");
csvWriter.WriteField("RPUserName");
csvWriter.WriteField("RPCompany");
csvWriter.WriteField("EndUserFirstName");
csvWriter.WriteField("EndUserLastName");
csvWriter.WriteField("EndUserPhoneNumber");
csvWriter.WriteField("EndUserEMailAddress");
csvWriter.WriteField("ShippingType");
csvWriter.WriteField("SPUserName");
csvWriter.WriteField("SPCompany");
csvWriter.WriteField("ShippingAttn");
csvWriter.WriteField("ShippingCompanyName");
csvWriter.WriteField("ShippingAddress1");
csvWriter.WriteField("ShippingAddress2");
csvWriter.WriteField("ShippingCity");
csvWriter.WriteField("ShippingState");
csvWriter.WriteField("ShippingZip");
csvWriter.WriteField("ShippingPhoneNumber");
csvWriter.WriteField("ShippingEmailAddress");
csvWriter.WriteField("CanceledByUserName");
csvWriter.WriteField("CanceledOnDateTime");
foreach (var header in theItems)
{
csvWriter.WriteField(header);
}
csvWriter.NextRecord();
foreach (var item in theData)
{
csvWriter.WriteField(item.OrderID);
csvWriter.WriteField(item.OrderDate);
csvWriter.WriteField(item.Status);
csvWriter.WriteField(item.CreatedByUserName);
csvWriter.WriteField(item.CreatedByCompany);
csvWriter.WriteField(item.RequestingParty);
csvWriter.WriteField(item.RPUserName);
csvWriter.WriteField(item.RPCompany);
csvWriter.WriteField(item.EndUserFirstName);
csvWriter.WriteField(item.EndUserLastName);
csvWriter.WriteField(item.EndUserPhoneNumber);
csvWriter.WriteField(item.EndUserEMailAddress);
csvWriter.WriteField(item.ShippingType);
csvWriter.WriteField(item.SPUserName);
csvWriter.WriteField(item.SPCompany);
csvWriter.WriteField(item.ShippingAttn);
csvWriter.WriteField(item.ShippingCompanyName);
csvWriter.WriteField(item.ShippingAddress1);
csvWriter.WriteField(item.ShippingAddress2);
csvWriter.WriteField(item.ShippingCity);
csvWriter.WriteField(item.ShippingState);
csvWriter.WriteField(item.ShippingZip);
csvWriter.WriteField(item.ShippingPhoneNumber);
csvWriter.WriteField(item.ShippingEmailAddress);
csvWriter.WriteField(item.CanceledByUserName);
csvWriter.WriteField(item.CanceledOnDateTime);
foreach (var header in theItems)
{
csvWriter.WriteField(item.ItemNames.Keys.Contains(header) ? item.ItemNames[header].ToString() : null);
}
csvWriter.NextRecord();
}
streamWriter.Flush();
return(new FileStreamResult(new MemoryStream(memoryStream.ToArray()), "text/csv")
{
FileDownloadName = "collateralorders.csv"
});
}
}
}
}
}
