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));
}
