public static List <hospitales_servicios> List()
{
List <hospitales_servicios> hospitales_serviciosList = new List <hospitales_servicios>();
SqlConnection connection = hospitalData.GetConnection();
String selectProcedure = "[camas_hospitales_serviciosSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
try
{
connection.Open();
SqlDataReader reader = selectCommand.ExecuteReader();
hospitales_servicios hospitales_servicios = new hospitales_servicios();
while (reader.Read())
{
hospitales_servicios = new hospitales_servicios();
hospitales_servicios.ID_hospitales_servicios = System.Convert.ToInt32(reader["ID_hospitales_servicios"]);
hospitales_servicios.CodigoRefer = Convert.ToString(reader["CodigoRefer"]);
hospitales_serviciosList.Add(hospitales_servicios);
}
reader.Close();
}
catch (SqlException)
{
return(hospitales_serviciosList);
}
finally
{
connection.Close();
}
return(hospitales_serviciosList);
}
public ActionResult Edit(hospitales_servicios hospitales_servicios)
{
hospitales_servicios ohospitales_servicios = new hospitales_servicios();
ohospitales_servicios.ID_hospitales_servicios = System.Convert.ToInt32(hospitales_servicios.ID_hospitales_servicios);
ohospitales_servicios = hospitales_serviciosData.Select_Record(hospitales_servicios);
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = hospitales_serviciosData.Update(ohospitales_servicios, hospitales_servicios);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Update");
}
}
// ComboBox
ViewData["Cod_hospital"] = new SelectList(hospitales_servicios_hospitalesData.List(), "Cod_hospital", "Nombre", hospitales_servicios.Cod_hospital);
ViewData["Id_servicio"] = new SelectList(hospitales_servicios_serviciosData.List(), "Id_servicio", "Nombre_servicio", hospitales_servicios.Id_servicio);
return(View(hospitales_servicios));
}
// GET: /hospitales_servicios/Edit/<id>
public ActionResult Edit(
Int32?ID_hospitales_servicios
)
{
if (
ID_hospitales_servicios == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
hospitales_servicios hospitales_servicios = new hospitales_servicios();
hospitales_servicios.ID_hospitales_servicios = System.Convert.ToInt32(ID_hospitales_servicios);
hospitales_servicios = hospitales_serviciosData.Select_Record(hospitales_servicios);
if (hospitales_servicios == null)
{
return(HttpNotFound());
}
// ComboBox
ViewData["Cod_hospital"] = new SelectList(hospitales_servicios_hospitalesData.List(), "Cod_hospital", "Nombre", hospitales_servicios.Cod_hospital);
ViewData["Id_servicio"] = new SelectList(hospitales_servicios_serviciosData.List(), "Id_servicio", "Nombre_servicio", hospitales_servicios.Id_servicio);
return(View(hospitales_servicios));
}
public ActionResult Create([Bind(Include =
"Cod_hospital"
+ "," + "Id_servicio"
+ "," + "CodigoRefer"
)] hospitales_servicios hospitales_servicios)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = hospitales_serviciosData.Add(hospitales_servicios);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["Cod_hospital"] = new SelectList(hospitales_servicios_hospitalesData.List(), "Cod_hospital", "Nombre", hospitales_servicios.Cod_hospital);
ViewData["Id_servicio"] = new SelectList(hospitales_servicios_serviciosData.List(), "Id_servicio", "Nombre_servicio", hospitales_servicios.Id_servicio);
return(View(hospitales_servicios));
}
public static bool Delete(hospitales_servicios hospitales_servicios)
{
SqlConnection connection = hospitalData.GetConnection();
string deleteProcedure = "[hospitales_serviciosDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
deleteCommand.Parameters.AddWithValue("@OldID_hospitales_servicios", hospitales_servicios.ID_hospitales_servicios);
if (hospitales_servicios.Cod_hospital.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldCod_hospital", hospitales_servicios.Cod_hospital);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCod_hospital", DBNull.Value);
}
if (hospitales_servicios.Id_servicio.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldId_servicio", hospitales_servicios.Id_servicio);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldId_servicio", DBNull.Value);
}
if (hospitales_servicios.CodigoRefer != null)
{
deleteCommand.Parameters.AddWithValue("@OldCodigoRefer", hospitales_servicios.CodigoRefer);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldCodigoRefer", 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();
}
}
public ActionResult DeleteConfirmed(
Int32?ID_hospitales_servicios
)
{
hospitales_servicios hospitales_servicios = new hospitales_servicios();
hospitales_servicios.ID_hospitales_servicios = System.Convert.ToInt32(ID_hospitales_servicios);
hospitales_servicios = hospitales_serviciosData.Select_Record(hospitales_servicios);
bool bSucess = false;
bSucess = hospitales_serviciosData.Delete(hospitales_servicios);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
// GET: /hospitales_servicios/Delete/<id>
public ActionResult Delete(
Int32?ID_hospitales_servicios
)
{
if (
ID_hospitales_servicios == null
)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
A17dthospitales = hospitales_servicios_hospitalesData.SelectAll();
A18dtservicios = hospitales_servicios_serviciosData.SelectAll();
hospitales_servicios hospitales_servicios = new hospitales_servicios();
hospitales_servicios.ID_hospitales_servicios = System.Convert.ToInt32(ID_hospitales_servicios);
hospitales_servicios = hospitales_serviciosData.Select_Record(hospitales_servicios);
hospitales_servicios.hospitales = new hospitales()
{
Cod_hospital = (Int32)hospitales_servicios.Cod_hospital
, Nombre = (from DataRow A17rowhospitales in A17dthospitales.Rows
where hospitales_servicios.Cod_hospital == (int)A17rowhospitales["Cod_hospital"]
select(String) A17rowhospitales["Nombre"]).FirstOrDefault()
};
hospitales_servicios.servicios = new servicios()
{
Id_servicio = (Int32)hospitales_servicios.Id_servicio
, Nombre_servicio = (from DataRow A18rowservicios in A18dtservicios.Rows
where hospitales_servicios.Id_servicio == (int)A18rowservicios["Id_servicio"]
select(String) A18rowservicios["Nombre_servicio"]).FirstOrDefault()
};
if (hospitales_servicios == null)
{
return(HttpNotFound());
}
return(View(hospitales_servicios));
}
public static hospitales_servicios Select_Record(hospitales_servicios hospitales_serviciosPara)
{
hospitales_servicios hospitales_servicios = new hospitales_servicios();
SqlConnection connection = hospitalData.GetConnection();
string selectProcedure = "[hospitales_serviciosSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@ID_hospitales_servicios", hospitales_serviciosPara.ID_hospitales_servicios);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
hospitales_servicios.ID_hospitales_servicios = System.Convert.ToInt32(reader["ID_hospitales_servicios"]);
hospitales_servicios.Cod_hospital = reader["Cod_hospital"] is DBNull ? null : (Int32?)reader["Cod_hospital"];
hospitales_servicios.Id_servicio = reader["Id_servicio"] is DBNull ? null : (Int32?)reader["Id_servicio"];
hospitales_servicios.CodigoRefer = reader["CodigoRefer"] is DBNull ? null : reader["CodigoRefer"].ToString();
}
else
{
hospitales_servicios = null;
}
reader.Close();
}
catch (SqlException)
{
return(hospitales_servicios);
}
finally
{
connection.Close();
}
return(hospitales_servicios);
}
