public async Task <IActionResult> GetStockDetailByMaterialNo(SF428SampleNoDetail sF428SampleNoDetail) { _logger.LogInformation(String.Format(@"****** WareHouseController GetStockDetailByMaterialNo fired!! ******")); var data = await _warehouseDao.GetStockDetailByMaterialNo(sF428SampleNoDetail); return(Ok(data)); }
public IActionResult ExportMaterialNoBySampleNoForWarehouse(SF428SampleNoDetail sF428SampleNoDetail) { _logger.LogInformation(String.Format(@"****** WareHouseController ExportMaterialNoBySampleNoForWarehouse fired!! ******")); // query data from database var data = _warehouseDao.GetMaterialNoBySampleNoForWarehouse(sF428SampleNoDetail); byte[] result = _excelService.CommonExportReport(data, "TempF428.xlsx"); return(File(result, "application/xlsx")); }
public IActionResult GetMaterialNoBySampleNoForWarehouse([FromQuery] SF428SampleNoDetail sF428SampleNoDetail) { _logger.LogInformation(String.Format(@"****** WareHouseController GetMaterialNoBySampleNoForWarehouse fired!! ******")); //sF428SampleNoDetail.SampleNo ="FW21-SMS-GZ7884-01"; var result = _warehouseDao.GetMaterialNoBySampleNoForWarehouse(sF428SampleNoDetail); Response.AddPagination(result.CurrentPage, result.PageSize, result.TotalCount, result.TotalPages); return(Ok(result)); }
public PagedList <F428SampleNoDetail> GetMaterialNoBySampleNoForWarehouse(SF428SampleNoDetail sF428SampleNoDetail) { List <SqlParameter> pc = new List <SqlParameter> { new SqlParameter("@SampleNo", sF428SampleNoDetail.SampleNo.Trim().ToUpper()) }; var data = _context.GetMaterialNoBySampleNoForWarehouseView .FromSqlRaw("EXECUTE dbo.GetMaterialNoBySampleNoForWarehouse @SampleNo", pc.ToArray()) .ToList(); return(PagedList <F428SampleNoDetail> .Create(data, sF428SampleNoDetail.PageNumber, sF428SampleNoDetail.PageSize, sF428SampleNoDetail.IsPaging)); }
public async Task <IActionResult> AddStockDetailByMaterialNo(SF428SampleNoDetail sF428SampleNoDetail) { SamPartB model = await _samPartBDAO.FindAll(x => x.SAMPLENO.Trim() == sF428SampleNoDetail.SampleNo.Trim() && x.MATERIANO == sF428SampleNoDetail.MaterialNo.Trim()).FirstOrDefaultAsync(); if (model != null) { model.STATUS = sF428SampleNoDetail.Status; model.CHKSTOCKNO = sF428SampleNoDetail.ChkStockNo; model.CHKUSR = sF428SampleNoDetail.loginUser; model.CHKTIME = DateTime.Now; _samPartBDAO.Update(model); } await _samPartBDAO.SaveAll(); return(Ok()); }
public IActionResult GetMaterialNoBySampleNoForWarehouse([FromQuery] SF428SampleNoDetail sF428SampleNoDetail) { try { //sF428SampleNoDetail.SampleNo ="FW21-SMS-GZ7884-01"; var result = _warehouseDao.GetMaterialNoBySampleNoForWarehouse(sF428SampleNoDetail); Response.AddPagination(result.CurrentPage, result.PageSize, result.TotalCount, result.TotalPages); return(Ok(result)); } catch (Exception ex) { return(StatusCode(500, $"Internal server error: {ex}.")); } }
public async Task <IActionResult> AddStockDetailByMaterialNo(SF428SampleNoDetail sF428SampleNoDetail) { _logger.LogInformation(String.Format(@"****** WareHouseController AddStockDetailByMaterialNo fired!! ******")); SamPartB model = await _samPartBDAO.FindAll(x => x.SAMPLENO.Trim() == sF428SampleNoDetail.SampleNo.Trim() && x.MATERIANO == sF428SampleNoDetail.MaterialNo.Trim()).FirstOrDefaultAsync(); if (model != null) { model.STATUS = sF428SampleNoDetail.Status; model.CHKSTOCKNO = sF428SampleNoDetail.ChkStockNo; model.CHKUSR = sF428SampleNoDetail.loginUser; model.CHKTIME = DateTime.Now; _samPartBDAO.Update(model); } await _samPartBDAO.SaveAll(); return(Ok()); }
public async Task <List <StockDetailByMaterialNo> > GetStockDetailByMaterialNo(SF428SampleNoDetail sF428SampleNoDetail) { List <SqlParameter> pc = new List <SqlParameter> { new SqlParameter("@SampleNo", sF428SampleNoDetail.SampleNo.Trim()), new SqlParameter("@MaterialNo", sF428SampleNoDetail.MaterialNo.Trim()) }; var data = await _context.GetStockDetailByMaterialNoView .FromSqlRaw("EXECUTE dbo.GetStockDetailByMaterialNo @SampleNo,@MaterialNo", pc.ToArray()) .ToListAsync(); return(data); }
public Task <List <F428SampleNoDetail> > GetMaterialNoBySampleNoForWarehouse4Excel(SF428SampleNoDetail sMaterialDetailBySampleNo) { throw new NotImplementedException(); }
public async Task <IActionResult> GetStockDetailByMaterialNo(SF428SampleNoDetail sF428SampleNoDetail) { var data = await _warehouseDao.GetStockDetailByMaterialNo(sF428SampleNoDetail); return(Ok(data)); }