//Actualizar Maquinaria
public TransactionResult update(SalidaCombustibleVo salida_vo)
{
SalidaCombustible salida = new SalidaCombustible();
if (salida_vo.timestamp != null || salida_vo.timestamp != "")
{
salida = SalidaCombustibleAdapter.voToObject(salida_vo);
}
else
{
salida_vo.timestamp = DateTime.Now.ToString();
}
salidas_repository.deleteDetallesByIdSalida(salida_vo.id);
foreach (DetalleSalidaCombustibleVo dvo in salida_vo.detalles)
{
dvo.salida_combustible_id = salida_vo.id;
var tr2 = TransactionResult.CREATED;
tr2 = salidas_repository.createDetalle(DetalleSalidaCombustibleAdapter.voToObject(dvo));
if (tr2 != TransactionResult.CREATED)
{
return(tr2);
}
}
return(salidas_repository.update(salida));
}
//Detail Maquinaria
public SalidaCombustible detail(int id)
{
SalidaCombustible salida = salidas_repository.detail(id);
salida.detalles = salidas_repository.getAllDetallesBySalidaId(salida.id);
return(salida);
}
public bool checkExists(SalidaCombustible salida)
{
SqlConnection connection = null;
using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Combustibles_DB"].ConnectionString))
{
try
{
int auxInsert = 0;
connection.Open();
SqlCommand command = new SqlCommand("sp_checkExistsSalida", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("odometro", salida.odometro));
command.Parameters.Add(new SqlParameter("turno", salida.turno));
command.Parameters.Add(new SqlParameter("maquinaria_id", salida.maquinaria.id));
command.Parameters.Add(new SqlParameter("compania_id", salida.compania.id));
command.Parameters.Add(new SqlParameter("operador_id", salida.operador.id));
command.Parameters.Add(new SqlParameter("subnivel_id", salida.subnivel.id));
command.Parameters.Add(new SqlParameter("fecha", salida.timestamp));
SqlDataAdapter data_adapter = new SqlDataAdapter(command);
DataSet data_set = new DataSet();
data_adapter.Fill(data_set);
DataRow row = data_set.Tables[0].Rows[0];
auxInsert = int.Parse(row[0].ToString());
if (auxInsert == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
if (connection != null)
{
connection.Close();
}
if (ex.Number == 2627)
{
return(false);
}
return(false);
}
catch
{
if (connection != null)
{
connection.Close();
}
return(false);
}
}
}
/// <summary>
/// Create new object on the db
/// </summary>
/// <param name="empleado"></param>
/// <returns></returns>
public int create(SalidaCombustible salida)
{
SqlConnection connection = null;
using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Combustibles_DB"].ConnectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand("sp_createSalidaCombustible", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("odometro", salida.odometro));
command.Parameters.Add(new SqlParameter("foto", salida.foto));
command.Parameters.Add(new SqlParameter("turno", salida.turno));
command.Parameters.Add(new SqlParameter("maquinaria_id", salida.maquinaria.id));
command.Parameters.Add(new SqlParameter("compania_id", salida.compania.id));
command.Parameters.Add(new SqlParameter("operador_id", salida.operador.id));
command.Parameters.Add(new SqlParameter("subnivel_id", salida.subnivel.id));
command.Parameters.Add(new SqlParameter("usuario_id", salida.despachador.id));
command.Parameters.Add(new SqlParameter("fecha", salida.timestamp));
SqlDataAdapter data_adapter = new SqlDataAdapter(command);
DataSet data_set = new DataSet();
data_adapter.Fill(data_set);
DataRow row = data_set.Tables[0].Rows[0];
return(int.Parse(row[0].ToString()));
}
catch (SqlException ex)
{
if (connection != null)
{
connection.Close();
}
if (ex.Number == 2627)
{
return(0);
}
return(0);
}
catch
{
if (connection != null)
{
connection.Close();
}
return(0);
}
}
}
public HttpResponseMessage detail(int id)
{
SalidaCombustible salida = salida_service.detail(id);
if (salida != null)
{
IDictionary <string, SalidaCombustible> data = new Dictionary <string, SalidaCombustible>();
data.Add("data", salida);
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
else
{
IDictionary <string, string> data = new Dictionary <string, string>();
data.Add("message", "Object not found.");
return(Request.CreateResponse(HttpStatusCode.BadRequest, data));
}
}
public TransactionResult update(SalidaCombustible salida)
{
SqlConnection connection = null;
using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Combustibles_DB"].ConnectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand("sp_updateSalidaCombustible", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("odometro", salida.odometro));
command.Parameters.Add(new SqlParameter("foto", salida.foto));
command.Parameters.Add(new SqlParameter("turno", salida.turno));
command.Parameters.Add(new SqlParameter("maquinaria_id", salida.maquinaria.id));
command.Parameters.Add(new SqlParameter("compania_id", salida.compania.id));
command.Parameters.Add(new SqlParameter("operador_id", salida.operador.id));
command.Parameters.Add(new SqlParameter("subnivel_id", salida.subnivel.id));
command.Parameters.Add(new SqlParameter("usuario_id", salida.despachador.id));
command.Parameters.Add(new SqlParameter("id", salida.id));
command.ExecuteNonQuery();
return(TransactionResult.OK);
}
catch (SqlException ex)
{
if (connection != null)
{
connection.Close();
}
if (ex.Number == 2627)
{
return(TransactionResult.EXISTS);
}
return(TransactionResult.NOT_PERMITTED);
}
catch
{
if (connection != null)
{
connection.Close();
}
return(TransactionResult.ERROR);
}
}
}
//Create Maquinaria
public TransactionResult create(SalidaCombustibleVo salida_vo)
{
if (checkExists(salida_vo))
{
return(TransactionResult.CREATED);
}
SalidaCombustible salida = new SalidaCombustible();
if (salida_vo.timestamp != null || salida_vo.timestamp != "")
{
salida = SalidaCombustibleAdapter.voToObject(salida_vo);
}
else
{
salida_vo.timestamp = DateTime.Now.ToString();
}
//return maquinaria_repository.create(maquina);
int id = salidas_repository.create(salida);
if (id > 0)
{
foreach (DetalleSalidaCombustibleVo dvo in salida_vo.detalles)
{
dvo.salida_combustible_id = id;
var tr2 = TransactionResult.CREATED;
tr2 = salidas_repository.createDetalle(DetalleSalidaCombustibleAdapter.voToObject(dvo));
if (tr2 != TransactionResult.CREATED)
{
return(tr2);
}
}
return(TransactionResult.CREATED);
}
return(TransactionResult.ERROR);
}
public static SalidaCombustibleVo objectToVo(SalidaCombustible obj)
{
return(new SalidaCombustibleVo
{
});
}
