public ActionResult EliminarTarifa(Tarifa _Tarifa)
{
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_Tarifa_Delete", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@idtarifa", _Tarifa.idtarifa);
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 Eliminacion de Datos"));
}
}
}
catch (Exception Ex)
{
return(BadRequest(Ex.Message));
}
return(Ok(""));
}
public IEnumerable <Tarifa> ConsultarTarifa()
{
List <Tarifa> lstTarifa = new List <Tarifa>();
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_Tarifa_Select", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = SqlCmd.ExecuteReader();
while (rdr.Read())
{
Tarifa _Tarifa = new Tarifa();
_Tarifa.idtarifa = (System.Int32)rdr["idtarifa"];
_Tarifa.idservicio = (System.Int32)rdr["idservicio"];
_Tarifa.descripcion = (System.String)rdr["descripcion"];
_Tarifa.idciudad = (System.Int32)rdr["idciudad"];
_Tarifa.idpais = !rdr.IsDBNull(4) ? (System.Int32)rdr["idpais"] : (System.Int32) 0;
_Tarifa.etiqueta = !rdr.IsDBNull(5) ? (System.String)rdr["etiqueta"] : "";
lstTarifa.Add(_Tarifa);
}
Base.CerrarConexion(SqlCnn);
return(lstTarifa);
}
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(lstTarifa);
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public Tarifa BuscarTarifa(System.Int32 idtarifa)
{
Tarifa _Tarifa = new Tarifa();
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_Tarifa_Search", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@idtarifa", idtarifa);
SqlDataReader rdr = SqlCmd.ExecuteReader();
while (rdr.Read())
{
_Tarifa.idtarifa = (System.Int32)rdr["idtarifa"];
_Tarifa.idservicio = (System.Int32)rdr["idservicio"];
_Tarifa.descripcion = (System.String)rdr["descripcion"];
_Tarifa.idciudad = (System.Int32)rdr["idciudad"];
_Tarifa.idpais = !rdr.IsDBNull(4) ? (System.Int32)rdr["idpais"] : (System.Int32) 0;
_Tarifa.etiqueta = !rdr.IsDBNull(5) ? (System.String)rdr["etiqueta"] : "";
}
Base.CerrarConexion(SqlCnn);
return(_Tarifa);
}
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(_Tarifa);
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public ActionResult InsertarTarifa(Tarifa _Tarifa)
{
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_Tarifa_Insert", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter pIDTarifa = new SqlParameter();
pIDTarifa.ParameterName = "@IDTarifa";
pIDTarifa.Value = 0;
SqlCmd.Parameters.Add(pIDTarifa);
pIDTarifa.Direction = System.Data.ParameterDirection.Output;
SqlCmd.Parameters.AddWithValue("@idservicio", _Tarifa.idservicio);
SqlCmd.Parameters.AddWithValue("@descripcion", _Tarifa.descripcion);
SqlCmd.Parameters.AddWithValue("@idciudad", _Tarifa.idciudad);
SqlCmd.Parameters.AddWithValue("@idpais", _Tarifa.idpais);
SqlCmd.Parameters.AddWithValue("@etiqueta", _Tarifa.etiqueta);
SqlCmd.ExecuteNonQuery();
_Tarifa.idtarifa = (System.Int32)pIDTarifa.Value;
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 Insercion de Datos"));
}
}
}
catch (Exception Ex)
{
return(BadRequest(Ex.Message));
}
return(Ok(""));
}
public ActionResult EliminarTarifa([FromBody] Tarifa data)
{
return(objTarifa.EliminarTarifa(data));
}
public ActionResult ActualizarTarifa([FromBody] Tarifa data)
{
return(objTarifa.ActualizarTarifa(data));
}
public ActionResult InsertarTarifa([FromBody] Tarifa data)
{
return(objTarifa.InsertarTarifa(data));
}