public IActionResult Upsert(int?id)
{
UserDetails();
CartCount();
CollateralVM collateralVM = new CollateralVM()
{
Collateral = new Collateral(),
SizeList = _unitOfWork.Size.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
}),
UnitList = _unitOfWork.Unit.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
}),
BrandList = _unitOfWork.Brand.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
}),
LocationList = _unitOfWork.Location.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
})
};
if (id == null)
{
// for create
return(View(collateralVM));
}
collateralVM.Collateral = _unitOfWork.Collateral.Get(id.GetValueOrDefault());
if (collateralVM.Collateral == null)
{
return(NotFound());
}
return(View(collateralVM));
}
public IActionResult Transfer(int?id)
{
UserDetails();
CartCount();
CollateralVM collateralVM = new CollateralVM()
{
LocationList = _unitOfWork.Location.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
})
};
collateralVM.Collateral = _unitOfWork.Collateral.Get(id.GetValueOrDefault());
SD.collateralName = collateralVM.Collateral.Location.Name;
SD.collateralLoc = collateralVM.Collateral.Name;
SD.collateralLocId = collateralVM.Collateral.LocationId;
return(View(collateralVM));
}
public IActionResult Upsert(CollateralVM collateralVM)
{
UserDetails();
CartCount();
if (ModelState.IsValid)
{
string webRootPath = _hostEnvironment.WebRootPath;
var files = HttpContext.Request.Form.Files;
if (files.Count > 0)
{
string fileName = Guid.NewGuid().ToString();
var uploads = Path.Combine(webRootPath, @"img\CorpComm\Collaterals");
var extension = Path.GetExtension(files[0].FileName);
if (collateralVM.Collateral.ImgUrl != null)
{
// this is an edit and we need to remove old image
var imagePath = Path.Combine(webRootPath, collateralVM.Collateral.ImgUrl.TrimStart('\\'));
if (System.IO.File.Exists(imagePath))
{
System.IO.File.Delete(imagePath);
}
}
using (var fileStreams = new FileStream(Path.Combine(uploads, fileName + extension), FileMode.Create))
{
files[0].CopyTo(fileStreams);
}
collateralVM.Collateral.ImgUrl = @"\img\CorpComm\Collaterals\" + fileName + extension;
}
else
{
// only for update when they do not change the image
if (collateralVM.Collateral.Id != 0)
{
Collateral objFromDb = _unitOfWork.Collateral.Get(collateralVM.Collateral.Id);
collateralVM.Collateral.ImgUrl = objFromDb.ImgUrl;
}
}
if (collateralVM.Collateral.Id == 0)
{
_unitOfWork.Collateral.Add(collateralVM.Collateral);
}
else
{
_unitOfWork.Collateral.Update(collateralVM.Collateral);
}
_unitOfWork.Save();
return(RedirectToAction(nameof(Index)));
}
else
{
collateralVM.SizeList = _unitOfWork.Size.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
});
collateralVM.UnitList = _unitOfWork.Unit.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
});
collateralVM.BrandList = _unitOfWork.Brand.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
});
collateralVM.LocationList = _unitOfWork.Location.GetAll().Select(i => new SelectListItem
{
Text = i.Name,
Value = i.Id.ToString()
});
if (collateralVM.Collateral.Id != 0)
{
collateralVM.Collateral = _unitOfWork.Collateral.Get(collateralVM.Collateral.Id);
}
}
return(View(collateralVM));
}
public IActionResult Transfer(CollateralVM collateralVM, int qtyfrom)
{
Collateral objMinusItem = _unitOfWork.Collateral.Get(collateralVM.Collateral.Id);
objMinusItem.Count -= qtyfrom;
History histMinus = new History();
if (collateralVM.Collateral.Id != 0)
{
histMinus.LoginUser = ViewBag.DisplayName;
histMinus.CollateralId = objMinusItem.Id;
histMinus.CollateralName = objMinusItem.Name;
histMinus.Quantity = qtyfrom;
histMinus.RequestDate = DateTime.Now;;
if (SD.collateralName == SD.DO_Edsa)
{
histMinus.ReconRemarks = "Transfered (" + qtyfrom + ") to " + SD.DO_LKG;
}
if (SD.collateralName == SD.DO_LKG)
{
histMinus.ReconRemarks = "Transfered (" + qtyfrom + ") to " + SD.DO_Edsa;
}
_unitOfWork.History.Add(histMinus);
_unitOfWork.Save();
}
if (SD.collateralName == SD.DO_LKG)
{
Collateral collateral = _unitOfWork.Collateral.GetFirstOrDefault(c => c.Name == SD.collateralLoc && c.LocationId != SD.collateralLocId);
collateral.Count += qtyfrom;
History histPlusEdsa = new History();
if (collateralVM.Collateral.Id != 0)
{
histPlusEdsa.LoginUser = ViewBag.DisplayName;
histPlusEdsa.CollateralId = collateral.Id;
histPlusEdsa.CollateralName = collateral.Name;
histPlusEdsa.Quantity = qtyfrom;
histPlusEdsa.RequestDate = DateTime.Now;;
histPlusEdsa.ReconRemarks = "Transfered (" + qtyfrom + ") from " + SD.DO_LKG;
_unitOfWork.History.Add(histPlusEdsa);
_unitOfWork.Save();
}
}
if (SD.collateralName == SD.DO_Edsa)
{
Collateral collateral = _unitOfWork.Collateral.GetFirstOrDefault(c => c.Name == SD.collateralLoc && c.LocationId != SD.collateralLocId);
collateral.Count += qtyfrom;
History histPlusLKG = new History();
if (collateralVM.Collateral.Id != 0)
{
histPlusLKG.LoginUser = ViewBag.DisplayName;
histPlusLKG.CollateralId = collateral.Id;
histPlusLKG.CollateralName = collateral.Name;
histPlusLKG.Quantity = qtyfrom;
histPlusLKG.RequestDate = DateTime.Now;;
histPlusLKG.ReconRemarks = "Transfered (" + qtyfrom + ") from " + SD.DO_Edsa;
_unitOfWork.History.Add(histPlusLKG);
_unitOfWork.Save();
}
_unitOfWork.Save();
}
return(RedirectToAction(nameof(Index)));
}
