/// <summary>
/// Guarda en la base de datos la modificación realizada en las existencias del subartículo.
/// </summary>
public void insert(string reason)
{
BatchPOJO newBatch = new BatchPOJO();
newBatch.Date = DateTime.Now;
newBatch.Reason = reason;
newBatch.Quantity = int.Parse((spnInputOutput.Value) + "");
BatchDAO.insertBatch(newBatch);
batchesList = BatchDAO.getAll();
BatchDAO.insertDetailBatch(selectedSubarticle.IdSubarticle, batchesList[(batchesList.Count) - 1].IdBatch);
updateQuantity(newBatch.Quantity);
}
/// <summary>
/// Elimina todas las modificaciones registradas en la base de datos que involucren al subartículo
/// seleccionado.
/// </summary>
private void btnClean_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("¿Está seguro que desea eliminar los registros?", "Info",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.No)
{
return;
}
BatchDAO.deleteAllById(selectedSubarticle.IdSubarticle, batchesList);
updateTable();
btnClean.Enabled = false;
}
public async Task <ResultEnum> DeleteBatch(Batch batch)
{
ResultEnum result = ResultEnum.Success;
try
{
BatchDAO dao = new BatchDAO();
await dao.DeleteBatchASYNC(batch);
}
catch
{
result = ResultEnum.Fail;
}
return(result);
}
public ResultEnum UpdateBatch(Batch batch)
{
ResultEnum result = ResultEnum.Success;
try
{
BatchDAO dao = new BatchDAO();
dao.UpdateBatch(batch);
}
catch
{
result = ResultEnum.Fail;
}
return(result);
}
public async Task <Result <DataTable> > FindBatchesByAny(string findString)
{
//null result
Result <DataTable> result = new Result <DataTable>();
result.Status = ResultEnum.Success;
try
{
BatchDAO dao = new BatchDAO();
result.Data = await dao.FindBatchesDtASYNC(findString);
}
catch
{
result.Status = ResultEnum.Fail;
}
return(result);
}
/// <summary>
/// Actualiza los datos mostrados en la lista del formulario para que coincida con la base de datos actual.
/// </summary>
public void updateTable()
{
dgvModify.Rows.Clear();
batchesList = BatchDAO.getAllById(selectedSubarticle.IdSubarticle);
for (int i = 0; i < batchesList.Count; i++)
{
dgvModify.Rows.Add(batchesList[i].Date, batchesList[i].Reason, batchesList[i].Quantity);
}
if (batchesList.Count == 0)
{
btnClean.Enabled = false;
}
else
{
dgvModify.Rows[0].Selected = true;
}
}
public async Task <Result <DataTable> > GetAllBatchedDtASYNC()
{
//null result
Result <DataTable> result = new Result <DataTable>();
result.Status = ResultEnum.Success;
try
{
BatchDAO dao = new BatchDAO();
result.Data = await dao.GetAllBatchesASYNC();
DataColumn column0 = result.Data.Columns[0];
column0.Caption = "Job No";
}
catch
{
result.Status = ResultEnum.Fail;
}
return(result);
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="hostingEnvironment"></param>
public ImageController(IHostingEnvironment hostingEnvironment)
{
_fileDAO = new FileDAO(hostingEnvironment.WebRootPath);
_batchDAO = new BatchDAO();
_logger = new Logger("ImageController");
}
public BatchServiceImpl(BatchDAO batchDAO, UserDAO userDAO, VehicleDAO vehicleDAO)
{
this.userDAO = userDAO;
this.batchDAO = batchDAO;
this.vehicleDAO = vehicleDAO;
}
