public static List <historia_clinica> List()
{
List <historia_clinica> historia_clinicaList = new List <historia_clinica>();
SqlConnection connection = hospitalData.GetConnection();
String selectProcedure = "[Visita_medico_historia_clinica38Select]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
historia_clinica historia_clinica = new historia_clinica();
while (reader.Read())
{
historia_clinica = new historia_clinica();
historia_clinica.id_historia = System.Convert.ToInt32(reader["id_historia"]);
historia_clinica.Cedula = Convert.ToString(reader["Cedula"]);
historia_clinicaList.Add(historia_clinica);
}
reader.Close();
}
catch (SqlException)
{
return(historia_clinicaList);
}
finally
{
connection.Close();
}
return(historia_clinicaList);
}
public static historia_clinica Select_Record(historia_clinica historia_clinicaPara)
{
historia_clinica historia_clinica = new historia_clinica();
SqlConnection connection = hospitalData.GetConnection();
string selectProcedure = "[historia_clinicaSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@id_historia", historia_clinicaPara.id_historia);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
historia_clinica.id_historia = System.Convert.ToInt32(reader["id_historia"]);
historia_clinica.Cedula = reader["Cedula"] is DBNull ? null : reader["Cedula"].ToString();
historia_clinica.Apellido = reader["Apellido"] is DBNull ? null : reader["Apellido"].ToString();
historia_clinica.Nombre = reader["Nombre"] is DBNull ? null : reader["Nombre"].ToString();
historia_clinica.Fecha_nacim = reader["Fecha_nacim"] is DBNull ? null : (DateTime?)reader["Fecha_nacim"];
historia_clinica.Num_seguridad_social = reader["Num_seguridad_social"] is DBNull ? null : reader["Num_seguridad_social"].ToString();
}
else
{
historia_clinica = null;
}
reader.Close();
}
catch (SqlException)
{
return(historia_clinica);
}
finally
{
connection.Close();
}
return(historia_clinica);
}
public ActionResult DeleteConfirmed(
Int32?id_historia
)
{
historia_clinica historia_clinica = new historia_clinica();
historia_clinica.id_historia = System.Convert.ToInt32(id_historia);
historia_clinica = historia_clinicaData.Select_Record(historia_clinica);
bool bSucess = false;
bSucess = historia_clinicaData.Delete(historia_clinica);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
// GET: /historia_clinica/Delete/<id>
public ActionResult Delete(
Int32?id_historia
)
{
if (
id_historia == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
historia_clinica historia_clinica = new historia_clinica();
historia_clinica.id_historia = System.Convert.ToInt32(id_historia);
historia_clinica = historia_clinicaData.Select_Record(historia_clinica);
if (historia_clinica == null)
{
return(HttpNotFound());
}
return(View(historia_clinica));
}
public ActionResult Edit(historia_clinica historia_clinica)
{
historia_clinica ohistoria_clinica = new historia_clinica();
ohistoria_clinica.id_historia = System.Convert.ToInt32(historia_clinica.id_historia);
ohistoria_clinica = historia_clinicaData.Select_Record(historia_clinica);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = historia_clinicaData.Update(ohistoria_clinica, historia_clinica);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
return(View(historia_clinica));
}
public ActionResult Create([Bind(Include =
"Cedula"
+ "," + "Apellido"
+ "," + "Nombre"
+ "," + "Fecha_nacim"
+ "," + "Num_seguridad_social"
)] historia_clinica historia_clinica)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = historia_clinicaData.Add(historia_clinica);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
return(View(historia_clinica));
}
public static bool Delete(historia_clinica historia_clinica)
{
SqlConnection connection = hospitalData.GetConnection();
string deleteProcedure = "[historia_clinicaDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
deleteCommand.Parameters.AddWithValue("@Oldid_historia", historia_clinica.id_historia);
if (historia_clinica.Cedula != null)
{
deleteCommand.Parameters.AddWithValue("@OldCedula", historia_clinica.Cedula);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCedula", DBNull.Value);
}
if (historia_clinica.Apellido != null)
{
deleteCommand.Parameters.AddWithValue("@OldApellido", historia_clinica.Apellido);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldApellido", DBNull.Value);
}
if (historia_clinica.Nombre != null)
{
deleteCommand.Parameters.AddWithValue("@OldNombre", historia_clinica.Nombre);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldNombre", DBNull.Value);
}
if (historia_clinica.Fecha_nacim.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldFecha_nacim", historia_clinica.Fecha_nacim);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldFecha_nacim", DBNull.Value);
}
if (historia_clinica.Num_seguridad_social != null)
{
deleteCommand.Parameters.AddWithValue("@OldNum_seguridad_social", historia_clinica.Num_seguridad_social);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldNum_seguridad_social", DBNull.Value);
}
deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
deleteCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
