public ActionResult cat_valor_rescate(int id)
{
ValoresRescate pValoresRescate = new ValoresRescate();
if (id == 0)
{
Console.WriteLine("ingresamos aqui");
pValoresRescate.fecha = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
pValoresRescate.fechafinal = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
pValoresRescate.descripcion = "";
pValoresRescate.id = 0;
pValoresRescate.activo = "Si";
pValoresRescate.fechahorasistema = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
}
else
{
pValoresRescate = _Valores_RescateLogica.Obtener(id);
}
return View(pValoresRescate);
}
public ValoresRescate Obtener(int AId)
{
ValoresRescate pResult = new ValoresRescate();
string pSentencia = "SELECT * FROM DRASVALORRESCATEM WHERE ID = @ID";
FbConnection con = _Conexiones.ObtenerConexion();
FbCommand com = new FbCommand(pSentencia, con);
com.Parameters.Add("@ID", FbDbType.Integer).Value = AId;
try
{
con.Open();
FbDataReader reader = com.ExecuteReader();
if (reader.Read())
{
ValoresRescate pValoresRescate = new ValoresRescate();
pValoresRescate.id = (reader["ID"] != DBNull.Value) ? (int)reader["ID"] : -1;
DateTime pFecha = (DateTime)reader["FECHA"];
pValoresRescate.fecha = pFecha.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
DateTime pFechaFinal = (DateTime)reader["FECHAFINAL"];
pValoresRescate.fechafinal = pFechaFinal.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
pValoresRescate.descripcion = (reader["DESCRIPCION"] != DBNull.Value) ? (string)reader["DESCRIPCION"] : "";
pValoresRescate.activo = (reader["ACTIVO"] != DBNull.Value) ? (string)reader["ACTIVO"] : "";
DateTime pFechaHoraSistema = (DateTime)reader["FECHAHORASISTEMA"];
pValoresRescate.fechahorasistema = pFechaHoraSistema.ToString("yyyy-MM-dd HH:mm:ss") + " -0700";
pResult = pValoresRescate;
}
}
finally
{
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
}
return pResult;
}
public List<ValoresRescate> obtener_lista_desc()
{
List<ValoresRescate> pResult = new List<ValoresRescate>();
string pSentencia = "SELECT * FROM DRASVALORRESCATEM ORDER BY ID DESC";
FbConnection con = _Conexiones.ObtenerConexion();
FbCommand com = new FbCommand(pSentencia, con);
try
{
con.Open();
FbDataReader reader = com.ExecuteReader();
while (reader.Read())
{
ValoresRescate pValoresRescate = new ValoresRescate();
pValoresRescate.id = (reader["ID"] != DBNull.Value) ? (int)reader["ID"] : -1;
DateTime pFecha = (DateTime)reader["FECHA"];
pValoresRescate.fecha = pFecha.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
DateTime pFechaFinal = (DateTime)reader["FECHAFINAL"];
pValoresRescate.fechafinal = pFechaFinal.ToString("yyyy-MM-dd") + " 00:00:00 -0700";
pValoresRescate.descripcion = (reader["DESCRIPCION"] != DBNull.Value) ? (string)reader["DESCRIPCION"] : "";
pValoresRescate.activo = (reader["ACTIVO"] != DBNull.Value) ? (string)reader["ACTIVO"] : "";
DateTime pFechaHoraSistema = (DateTime)reader["FECHAHORASISTEMA"];
pValoresRescate.fechahorasistema = pFechaHoraSistema.ToString("yyyy-MM-dd HH:mm:ss") + " -0700";
pResult.Add(pValoresRescate);
}
}
finally
{
if (con.State == System.Data.ConnectionState.Open)
{
con.Close();
}
}
return pResult;
}