public ActionResult EliminarSMDR(SMDR _SMDR)
{
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_SMDR_Delete", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@idllamada", _SMDR.idllamada);
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 <SMDR> ConsultarSMDR()
{
List <SMDR> lstSMDR = new List <SMDR>();
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_SMDR_Select", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = SqlCmd.ExecuteReader();
while (rdr.Read())
{
SMDR _SMDR = new SMDR();
_SMDR.idllamada = (System.Guid)rdr["idllamada"];
_SMDR.idestado = (System.Int32)rdr["idestado"];
_SMDR.codigo = (System.String)rdr["codigo"];
_SMDR.fecha = !rdr.IsDBNull(3) ? (System.String)rdr["fecha"] : "";
_SMDR.hora = !rdr.IsDBNull(4) ? (System.String)rdr["hora"] : "";
_SMDR.duracion = !rdr.IsDBNull(5) ? (System.String)rdr["duracion"] : "";
_SMDR.linea = !rdr.IsDBNull(6) ? (System.String)rdr["linea"] : "";
_SMDR.interno = !rdr.IsDBNull(7) ? (System.String)rdr["interno"] : "";
_SMDR.cuenta = !rdr.IsDBNull(8) ? (System.String)rdr["cuenta"] : "";
_SMDR.numero = !rdr.IsDBNull(9) ? (System.String)rdr["numero"] : "";
lstSMDR.Add(_SMDR);
}
Base.CerrarConexion(SqlCnn);
return(lstSMDR);
}
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(lstSMDR);
}
catch (Exception Ex)
{
throw new Exception(Ex.Message);
}
}
public ActionResult ActualizarSMDR(SMDR _SMDR)
{
try
{
SqlConnection SqlCnn;
SqlCnn = Base.AbrirConexion();
SqlCommand SqlCmd = new SqlCommand("Proc_SMDR_Update", SqlCnn);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@idllamada", _SMDR.idllamada);
SqlCmd.Parameters.AddWithValue("@idestado", _SMDR.idestado);
SqlCmd.Parameters.AddWithValue("@codigo", _SMDR.codigo);
SqlCmd.Parameters.AddWithValue("@fecha", _SMDR.fecha);
SqlCmd.Parameters.AddWithValue("@hora", _SMDR.hora);
SqlCmd.Parameters.AddWithValue("@duracion", _SMDR.duracion);
SqlCmd.Parameters.AddWithValue("@linea", _SMDR.linea);
SqlCmd.Parameters.AddWithValue("@interno", _SMDR.interno);
SqlCmd.Parameters.AddWithValue("@cuenta", _SMDR.cuenta);
SqlCmd.Parameters.AddWithValue("@numero", _SMDR.numero);
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 EliminarSMDR([FromBody] SMDR data)
{
return(objSMDR.EliminarSMDR(data));
}
public ActionResult ActualizarSMDR([FromBody] SMDR data)
{
return(objSMDR.ActualizarSMDR(data));
}
public ActionResult InsertarSMDR([FromBody] SMDR data)
{
return(objSMDR.InsertarSMDR(data));
}
