public ActionResult SaveForm(TransferOrderViewModel TransferOrderViewModel)
{
if (Session["strUserId"] == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
LoadSession();
TransferOrderViewModel.TransferOrderReceiveby = strUserId;
if (TransferOrderViewModel.TransferOrderList != null)
{
TransferOrderViewModel.TransferOrderList.RemoveAll(x => !x.IsChecked);
if (TransferOrderViewModel.TransferOrderList.Any())
{
TransferOrderServices.Receivetransferorder(TransferOrderViewModel);
TempData["message"] = "Successfully Received Order";
ModelState.Clear();
}
}
TransferOrderViewModel.TransferOrderList = TransferOrderServices.LoadOrderPendingInformation(strStoreId);
return(View("TransferOrderReceive", TransferOrderViewModel));
}
}
public TransferOrders()
: base()
{
InitializeComponent();
this.toolstripChild = this.toolStripChildForm;
this.fastListIndex = this.fastTransferOrderIndex;
this.transferOrderAPIs = new TransferOrderAPIs(CommonNinject.Kernel.Get <ITransferOrderAPIRepository>());
this.transferOrderViewModel = CommonNinject.Kernel.Get <TransferOrderViewModel>();
this.transferOrderViewModel.PropertyChanged += new PropertyChangedEventHandler(ModelDTO_PropertyChanged);
this.baseDTO = this.transferOrderViewModel;
}
public JsonResult GetInventoryItemInformation(TransferOrderViewModel TransferOrderViewModel)
{
if (Session["strUserId"] == null)
{
return(Json(new
{
redirectUrl = Url.Action("Login", "Account"),
isRedirect = true
}));
}
else
{
var data = TransferOrderServices.GetInventoryItemInformation(TransferOrderViewModel);
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public void Canceltransferorder(TransferOrderViewModel TransferOrderViewModel)
{
for (int i = 0; i < TransferOrderViewModel.TransferOrderList.Count; i++)
{
var id = TransferOrderViewModel.TransferOrderList[i].TransferOrderId;
var result = unitOfWork.TransferOrderRepository.Get().SingleOrDefault(b => b.TransferOrderId == id);
if (result != null)
{
result.OrderRecieve = "Canceled";
result.TransferOrderReceiveby = TransferOrderViewModel.TransferOrderReceiveby;
result.TransferOrderReceiveDate = DateTime.Now.Date;
unitOfWork.Save();
}
}
}
public ActionResult Search(TransferOrderViewModel transferOrderViewModel)
{
if (Session["strUserId"] == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
LoadSession();
transferOrderViewModel.FromStoreId = Convert.ToInt32(strStoreId);
TransferOrderViewModel TransferOrderViewModel = new TransferOrderViewModel();
TransferOrderViewModel.TransferOrderList = new List <TransferOrderViewModel>();
TransferOrderViewModel.TransferOrderList = TransferOrderServices.GetSearchInformation(transferOrderViewModel);
ModelState.Clear();
LoadAll(strStoreId);
return(View(TransferOrderViewModel));
}
}
public ActionResult TransferOrderReceive()
{
if (Session["strUserId"] == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
LoadSession();
ViewBag.Pending = TransferOrderServices.LoadOrderPending(strStoreId);
TransferOrderViewModel TransferOrderViewModel = new TransferOrderViewModel();
TransferOrderViewModel.TransferOrderList = new List <TransferOrderViewModel>();
TransferOrderViewModel.TransferOrderList = TransferOrderServices.LoadOrderPendingInformation(strStoreId);
return(View(TransferOrderViewModel));
}
}
public ActionResult Search()
{
if (Session["strUserId"] == null)
{
return(RedirectToAction("Login", "Account"));
}
else
{
LoadSession();
LoadAll(strStoreId);
ViewBag.Orderlist = TransferOrderServices.CountOrderInformattion(strStoreId);
ViewBag.Receivelist = TransferOrderServices.CountOrderReceiveInformattion(strStoreId);
ViewBag.Pendinglist = TransferOrderServices.CountOrderPendingInformattion(strStoreId);
ViewBag.Cancellist = TransferOrderServices.CountOrderCancelInformattion(strStoreId);
//ViewBag.Orderlist = TransferOrderServices.CountOrderInformattion(strStoreId);
TransferOrderViewModel TransferOrderViewModel = new TransferOrderViewModel();
TransferOrderViewModel.TransferOrderList = new List <TransferOrderViewModel>();
TransferOrderViewModel.TransferOrderList = TransferOrderServices.LoadOrderInformation(strStoreId);
return(View(TransferOrderViewModel));
}
}
public void BuildSelectLists(TransferOrderViewModel transferOrderViewModel)
{
transferOrderViewModel.ApproverDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), transferOrderViewModel.UserID);
transferOrderViewModel.PreparedPersonDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), transferOrderViewModel.UserID);
}
public WizardMaster(TransferOrderViewModel transferOrderViewModel)
{
InitializeComponent();
this.transferOrderViewModel = transferOrderViewModel;
}
public List <TransferOrderViewModel> GetSearchInformation(TransferOrderViewModel transferOrderViewModel)
{
var S = (from s in unitOfWork.StoreRepository.Get()
select new
{
SID = s.StoreId,
Name = s.StoreName
}).Union(
(from s in unitOfWork.SubStoreRepository.Get()
select new
{
SID = s.SubStoreId,
Name = s.SubStoreName,
})).Union(
(from s in unitOfWork.SubSubStoreRepository.Get()
select new
{
SID = s.SubSubStoreId,
Name = s.SubSubStoreName,
})).Union(
(from s in unitOfWork.SubSubSubStoreRepository.Get()
select new
{
SID = s.SubSubSubStoreId,
Name = s.SubSubSubStoreName,
})).Union(
(from s in unitOfWork.SubSubSubSubStoreRepository.Get()
select new
{
SID = s.SubSubSubSubStoreId,
Name = s.SubSubSubSubStoreName,
}));
var r = (from s in unitOfWork.TransferOrderRepository.Get()
join store in S on s.FromStoreId equals store.SID
join tstore in S on s.ToStoreId equals tstore.SID
join item in unitOfWork.ItemRepository.Get() on s.ItemId equals item.ItemId
join unit in unitOfWork.UnitRepository.Get() on s.UnitId equals unit.UnitId
join c in unitOfWork.ConditionOfItemRepository.Get() on s.ConditionOfItemId equals c.ConditionOfItemId
where s.FromStoreId == transferOrderViewModel.FromStoreId
select new TransferOrderViewModel
{
TransferOrderId = s.TransferOrderId,
FromStoreId = s.FromStoreId,
FromStoreName = store.Name,
ToStoreId = s.ToStoreId,
ToStoreName = tstore.Name,
ItemId = s.ItemId,
ItemName = item.ItemName,
TransactionQuantity = s.TransactionQuantity,
UnitId = s.UnitId,
UnitName = unit.UnitName,
TransferTypeId = s.TransferTypeId,
TransferTypeName = s.TransferType.TransferTypeName,
TransferOrderdate = s.TransferOrderdate,
TransferOrderDeliverydate = s.TransferOrderDeliverydate,
ConditionOfItemId = s.ConditionOfItemId,
ConditionOfItemName = c.ConditionOfItemName,
OrderRecieve = s.OrderRecieve
});
if (transferOrderViewModel.ToStoreId > 0)
{
r = r.Where(p => p.ToStoreId == transferOrderViewModel.ToStoreId);
}
if (transferOrderViewModel.ItemId > 0)
{
r = r.Where(p => p.ItemId == transferOrderViewModel.ItemId);
}
if (transferOrderViewModel.ConditionOfItemId > 0)
{
r = r.Where(p => p.ConditionOfItemId == transferOrderViewModel.ConditionOfItemId);
}
if (transferOrderViewModel.TransferTypeId > 0)
{
r = r.Where(p => p.TransferTypeId == transferOrderViewModel.TransferTypeId);
}
//if (transferOrderViewModel.FromDate!=null && transferOrderViewModel.ToDate!= null)
// r =r.Where(p =>Convert.ToDateTime( p.TransferOrderdate) >= Convert.ToDateTime(transferOrderViewModel.FromDate) && Convert.ToDateTime(p.TransferOrderdate) <= Convert.ToDateTime(transferOrderViewModel.ToDate));
//if (transferOrderViewModel.FromDate!=null && transferOrderViewModel.ToDate != null)
// r =r.Where(p => DateTime.ParseExact(p.TransferOrderdate, "MM/dd/yyyy", CultureInfo.InvariantCulture) >= transferOrderViewModel.FromDate && DateTime.ParseExact(p.TransferOrderdate, "MM/dd/yyyy", CultureInfo.InvariantCulture) <= transferOrderViewModel.ToDate);
//if (transferOrderViewModel.FromDate!=null)
// r = r.Where(p => Convert.ToDateTime(p.TransferOrderdate) <= transferOrderViewModel.ToDate);
if (transferOrderViewModel.TransferCriteria == "Received")
{
r = r.Where(p => p.OrderRecieve == "Received");
}
if (transferOrderViewModel.TransferCriteria == "Pending")
{
r = r.Where(p => p.OrderRecieve == "Pending");
}
if (transferOrderViewModel.TransferCriteria == "Canceled")
{
r = r.Where(p => p.OrderRecieve == "Canceled");
}
if (transferOrderViewModel.FromDate != null && transferOrderViewModel.ToDate != null)
{
r = r.Where(p => p.TransferOrderdate >= transferOrderViewModel.FromDate && p.TransferOrderdate <= transferOrderViewModel.ToDate);
}
var data = r.ToList();
return(data);
}
public int GetInventoryItemInformation(TransferOrderViewModel TransferOrderViewModel)
{
int count = (from x in unitOfWork.StoreRepository.Get() where x.StoreId == TransferOrderViewModel.ToStoreId select x.StoreId).Count();
if (count == 1)
{
// Calculating the total Available quantity for Transfer Store
var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get()
join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID
where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == TransferOrderViewModel.ToStoreId && IM.SubStoreId == null && IM.SubSubStoreId == null && IM.SubSubSubStoreId == null && IM.SubSubSubSubStoreId == null
select(int?) ID.AvailableQty).Sum() ?? 0;
return(TotalAvailable);
}
int count2 = (from x in unitOfWork.SubStoreRepository.Get() where x.SubStoreId == TransferOrderViewModel.ToStoreId select x.SubStoreId).Count();
if (count2 == 1)
{
var storeid = unitOfWork.SubStoreRepository.Get().Where(a => a.SubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single();
// Calculating the total Available quantity for Transfer Store
var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get()
join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID
where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == TransferOrderViewModel.ToStoreId && IM.SubSubStoreId == null && IM.SubSubSubStoreId == null && IM.SubSubSubSubStoreId == null
select(int?) ID.AvailableQty).Sum() ?? 0;
return(TotalAvailable);
}
int count3 = (from x in unitOfWork.SubSubStoreRepository.Get() where x.SubSubStoreId == TransferOrderViewModel.ToStoreId select x.SubSubStoreId).Count();
if (count3 == 1)
{
var storeid = unitOfWork.SubSubStoreRepository.Get().Where(a => a.SubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single();
var substoreid = unitOfWork.SubSubStoreRepository.Get().Where(a => a.SubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single();
// Calculating the total Available quantity for Transfer Store
var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get()
join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID
where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == substoreid && IM.SubSubStoreId == TransferOrderViewModel.ToStoreId && IM.SubSubSubStoreId == null && IM.SubSubSubSubStoreId == null
select(int?) ID.AvailableQty).Sum() ?? 0;
return(TotalAvailable);
}
int count4 = (from x in unitOfWork.SubSubSubStoreRepository.Get() where x.SubSubSubStoreId == TransferOrderViewModel.ToStoreId select x.SubSubSubStoreId).Count();
if (count4 == 1)
{
var storeid = unitOfWork.SubSubSubStoreRepository.Get().Where(a => a.SubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single();
var substoreid = unitOfWork.SubSubSubStoreRepository.Get().Where(a => a.SubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single();
var subsubstoreid = unitOfWork.SubSubSubStoreRepository.Get().Where(a => a.SubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single();
// Calculating the total Available quantity for Transfer Store
var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get()
join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID
where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == substoreid && IM.SubSubStoreId == subsubstoreid && IM.SubSubSubStoreId == TransferOrderViewModel.ToStoreId && IM.SubSubSubSubStoreId == null
select(int?) ID.AvailableQty).Sum() ?? 0;
return(TotalAvailable);
}
int count5 = (from x in unitOfWork.SubSubSubSubStoreRepository.Get() where x.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId select x.SubSubSubSubStoreId).Count();
if (count5 == 1)
{
var storeid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single();
var substoreid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single();
var subsubstoreid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single();
var subsubsubstoreid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single();
// Calculating the total Available quantity for Transfer Store
var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get()
join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID
where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == substoreid && IM.SubSubStoreId == subsubstoreid && IM.SubSubSubStoreId == subsubsubstoreid && IM.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId
select(int?) ID.AvailableQty).Sum() ?? 0;
return(TotalAvailable);
}
return(0);
}
public void BuildSelectLists(TransferOrderViewModel transferOrderViewModel)
{
transferOrderViewModel.ApproverDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), transferOrderViewModel.UserID);
transferOrderViewModel.PreparedPersonDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), transferOrderViewModel.UserID);
}
