/// <summary>Cria um novo item e atribui à uma requisição</sumary>
public ObjResult Post(ItemProgress progress, int user_id, int item_id, int item_status_id)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
ItemProgressDao dao = new ItemProgressDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
progress.SetId(dao.Post(progress, user_id, item_id, item_status_id));
transaction.Commit();
result.Success();
result.SetData(progress.GetId());
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
/// <summary>Atualiza um item</sumary>
public ObjResult Update(int item_progress_id, ItemProgress progress)
{
connection = db.GetCon();
connection.Open();
NpgsqlTransaction transaction = connection.BeginTransaction();
ItemProgressDao dao = new ItemProgressDao(connection, transaction);
ObjResult result = new ObjResult();
try
{
item_progress_id = dao.Update(item_progress_id, progress);
transaction.Commit();
result.Success();
result.SetData(item_progress_id);
}
catch (Exception e)
{
transaction.Rollback();
throw new Exception(e.ToString());
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
/// <summary>Exclui um determinado progresso de item</sumary>
public ObjResult Delete(int item_progress_id)
{
connection = db.GetCon();
connection.Open();
ItemProgressDao dao = new ItemProgressDao(connection, null);
ObjResult result = new ObjResult();
try
{
item_progress_id = dao.Delete(item_progress_id);
result.SetData(item_progress_id);
result.Success();
}
finally
{
connection.Close();
db.Close();
}
return(result);
}
