public bool SaveProductionStockInByProductionRequistion(long reqId, string status, long orgId, long userId)
{
var reqInfo = _requsitionInfoBusiness.GetRequisitionById(reqId, orgId);
var reqDetail = _requsitionDetailBusiness.GetRequsitionDetailByReqId(reqId, orgId).ToList();
if (reqInfo != null && reqInfo.StateStatus == "Approved" && reqDetail.Count > 0)
{
List <ProductionStockDetailDTO> productionStockDetailDTOs = new List <ProductionStockDetailDTO>();
foreach (var item in reqDetail)
{
ProductionStockDetailDTO productionStockDetailDTO = new ProductionStockDetailDTO
{
WarehouseId = reqInfo.WarehouseId,
ItemTypeId = item.ItemTypeId,
ItemId = item.ItemId,
OrganizationId = orgId,
EUserId = userId,
UnitId = item.UnitId,
StockStatus = "Stock-In",
Remarks = item.Remarks,
Quantity = (int)item.Quantity.Value,
RefferenceNumber = reqInfo.ReqInfoCode
};
productionStockDetailDTOs.Add(productionStockDetailDTO);
}
if (SaveProductionStockIn(productionStockDetailDTOs, userId, orgId) == true)
{
return(_requsitionInfoBusiness.SaveRequisitionStatus(reqId, status, orgId));
}
}
return(false);
}
public bool SaveWarehouseStockOutByProductionRequistion(long reqId, string status, long orgId, long userId)
{
var reqInfo = _requsitionInfoBusiness.GetRequisitionById(reqId, orgId);
var reqDetail = _requsitionDetailBusiness.GetRequsitionDetailByReqId(reqId, orgId);
if (reqInfo != null && reqDetail.Count() > 0)
{
List <WarehouseStockDetailDTO> stockDetailDTOs = new List <WarehouseStockDetailDTO>();
foreach (var item in reqDetail)
{
WarehouseStockDetailDTO stockDetailDTO = new WarehouseStockDetailDTO
{
WarehouseId = reqInfo.WarehouseId,
ItemTypeId = item.ItemTypeId.Value,
ItemId = item.ItemId,
UnitId = item.UnitId.Value,
OrganizationId = item.OrganizationId,
Quantity = (int)item.Quantity.Value,
EUserId = userId,
EntryDate = DateTime.Now,
Remarks = "Stock Out By Production Requistion " + "(" + reqInfo.ReqInfoCode + ")",
RefferenceNumber = reqInfo.ReqInfoCode,
StockStatus = "Stock-Out"
};
stockDetailDTOs.Add(stockDetailDTO);
}
if (SaveWarehouseStockOut(stockDetailDTOs, userId, orgId, "Production Requistion") == true)
{
return(_requsitionInfoBusiness.SaveRequisitionStatus(reqId, status, orgId));
}
}
return(false);
}
// Used By GetReqInfoList
public ActionResult GetReqInfoParitalList(string reqCode, long?warehouseId, string status, long?line, string fromDate, string toDate)
{
IEnumerable <RequsitionInfoDTO> requsitionInfoDTO = _requsitionInfoBusiness.GetAllReqInfoByOrgId(OrgId).Where(req => (req.StateStatus == "Pending" || req.StateStatus == "Accepted" || req.StateStatus == "Decline")
&&
(reqCode == null || reqCode.Trim() == "" || req.ReqInfoCode.Contains(reqCode))
&&
(warehouseId == null || warehouseId <= 0 || req.WarehouseId == warehouseId)
&&
(status == null || status.Trim() == "" || req.StateStatus == status.Trim())
&&
(line == null || line <= 0 || req.LineId == line)
&&
(
(fromDate == null && toDate == null)
||
(fromDate == "" && toDate == "")
||
(fromDate.Trim() != "" && toDate.Trim() != "" &&
req.EntryDate.Value.Date >= Convert.ToDateTime(fromDate).Date&&
req.EntryDate.Value.Date <= Convert.ToDateTime(toDate).Date)
||
(fromDate.Trim() != "" && req.EntryDate.Value.Date == Convert.ToDateTime(fromDate).Date)
||
(toDate.Trim() != "" && req.EntryDate.Value.Date == Convert.ToDateTime(toDate).Date)
)
).Select(info => new RequsitionInfoDTO
{
ReqInfoId = info.ReqInfoId,
ReqInfoCode = info.ReqInfoCode,
LineId = info.LineId,
LineNumber = (_productionLineBusiness.GetProductionLineOneByOrgId(info.LineId, OrgId).LineNumber),
StateStatus = info.StateStatus,
Remarks = info.Remarks,
OrganizationId = info.OrganizationId,
EntryDate = info.EntryDate,
WarehouseId = info.WarehouseId,
WarehouseName = (_warehouseBusiness.GetWarehouseOneByOrgId(info.WarehouseId, OrgId).WarehouseName),
Qty = _requsitionDetailBusiness.GetRequsitionDetailByReqId(info.ReqInfoId, OrgId).Select(s => s.ItemId).Distinct().Count(),
}).ToList();
List <RequsitionInfoViewModel> requsitionInfoViewModels = new List <RequsitionInfoViewModel>();
AutoMapper.Mapper.Map(requsitionInfoDTO, requsitionInfoViewModels);
return(PartialView(requsitionInfoViewModels));
}