public CostoInterNacional BuscarCostoInterNacional(System.Int32 iddia, System.Int32 idtramo, System.Int32 idtarifa, System.Int32 idservicio, System.Int32 idareapais)
{
CostoInterNacional _CostoInterNacional = new CostoInterNacional();
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_CostoInterNacional_Search", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@iddia", iddia);
SqlCmd.Parameters.AddWithValue("@idtramo", idtramo);
SqlCmd.Parameters.AddWithValue("@idtarifa", idtarifa);
SqlCmd.Parameters.AddWithValue("@idservicio", idservicio);
SqlCmd.Parameters.AddWithValue("@idareapais", idareapais);
SqlDataReader rdr = SqlCmd.ExecuteReader();
while (rdr.Read())
{
_CostoInterNacional.iddia = (System.Int32)rdr["iddia"];
_CostoInterNacional.idtramo = (System.Int32)rdr["idtramo"];
_CostoInterNacional.idtarifa = (System.Int32)rdr["idtarifa"];
_CostoInterNacional.idservicio = (System.Int32)rdr["idservicio"];
_CostoInterNacional.idareapais = (System.Int32)rdr["idareapais"];
_CostoInterNacional.costo = (System.Double)rdr["costo"];
}
Base.CerrarConexion(SqlCnn);
return(_CostoInterNacional);
}
catch (SqlException XcpSQL)
{
foreach (SqlError se in XcpSQL.Errors)
{
if (se.Number <= 50000)
{
throw new Exception(se.Message);
}
else
{
throw new Exception("Error en Operacion en Busqueda de Datos");
}
}
return(_CostoInterNacional);
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public IEnumerable <CostoInterNacional> ConsultarCostoInterNacional()
{
List <CostoInterNacional> lstCostoInterNacional = new List <CostoInterNacional>();
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_CostoInterNacional_Select", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = SqlCmd.ExecuteReader();
while (rdr.Read())
{
CostoInterNacional _CostoInterNacional = new CostoInterNacional();
_CostoInterNacional.iddia = (System.Int32)rdr["iddia"];
_CostoInterNacional.idtramo = (System.Int32)rdr["idtramo"];
_CostoInterNacional.idtarifa = (System.Int32)rdr["idtarifa"];
_CostoInterNacional.idservicio = (System.Int32)rdr["idservicio"];
_CostoInterNacional.idareapais = (System.Int32)rdr["idareapais"];
_CostoInterNacional.costo = (System.Double)rdr["costo"];
lstCostoInterNacional.Add(_CostoInterNacional);
}
Base.CerrarConexion(SqlCnn);
return(lstCostoInterNacional);
}
catch (SqlException XcpSQL)
{
foreach (SqlError se in XcpSQL.Errors)
{
if (se.Number <= 50000)
{
throw new Exception(se.Message);
}
else
{
throw new Exception("Error en Operacion de Consulta de Datos");
}
}
return(lstCostoInterNacional);
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public ActionResult ActualizarCostoInterNacional(CostoInterNacional _CostoInterNacional)
{
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_CostoInterNacional_Update", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@iddia", _CostoInterNacional.iddia);
SqlCmd.Parameters.AddWithValue("@idtramo", _CostoInterNacional.idtramo);
SqlCmd.Parameters.AddWithValue("@idtarifa", _CostoInterNacional.idtarifa);
SqlCmd.Parameters.AddWithValue("@idservicio", _CostoInterNacional.idservicio);
SqlCmd.Parameters.AddWithValue("@idareapais", _CostoInterNacional.idareapais);
SqlCmd.Parameters.AddWithValue("@costo", _CostoInterNacional.costo);
SqlCmd.ExecuteNonQuery();
Base.CerrarConexion(SqlCnn);
return(Ok("Operacion realizada correctamente"));
}
catch (SqlException XcpSQL)
{
foreach (SqlError se in XcpSQL.Errors)
{
if (se.Number <= 50000)
{
return(BadRequest(se.Message));
}
else
{
return(BadRequest("Error en Operacion de Actualizacion de Datos"));
}
}
}
catch (Exception Ex)
{
return(BadRequest(Ex.Message));
}
return(Ok(""));
}
public ActionResult EliminarCostoInterNacional([FromBody] CostoInterNacional data)
{
return(objCostoInterNacional.EliminarCostoInterNacional(data));
}
public ActionResult ActualizarCostoInterNacional([FromBody] CostoInterNacional data)
{
return(objCostoInterNacional.ActualizarCostoInterNacional(data));
}
public ActionResult InsertarCostoInterNacional([FromBody] CostoInterNacional data)
{
return(objCostoInterNacional.InsertarCostoInterNacional(data));
}
