public static bool Add(camas camas)
{
SqlConnection connection = hospitalData.GetConnection();
string insertProcedure = "[camasInsert]";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (camas.Num_cama.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Num_cama", camas.Num_cama);
}
else
{
insertCommand.Parameters.AddWithValue("@Num_cama", DBNull.Value);
}
if (camas.Estado != null)
{
insertCommand.Parameters.AddWithValue("@Estado", camas.Estado);
}
else
{
insertCommand.Parameters.AddWithValue("@Estado", DBNull.Value);
}
if (camas.ID_hospitales_servicios.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@ID_hospitales_servicios", camas.ID_hospitales_servicios);
}
else
{
insertCommand.Parameters.AddWithValue("@ID_hospitales_servicios", DBNull.Value);
}
insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
insertCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
public ActionResult DeleteConfirmed(
Int32?id_cama
)
{
camas camas = new camas();
camas.id_cama = System.Convert.ToInt32(id_cama);
camas = camasData.Select_Record(camas);
bool bSucess = false;
bSucess = camasData.Delete(camas);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Delete");
}
return(null);
}
public static camas Select_Record(camas camasPara)
{
camas camas = new camas();
SqlConnection connection = hospitalData.GetConnection();
string selectProcedure = "[camasSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@id_cama", camasPara.id_cama);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
camas.id_cama = System.Convert.ToInt32(reader["id_cama"]);
camas.Num_cama = reader["Num_cama"] is DBNull ? null : (Int32?)reader["Num_cama"];
camas.Estado = reader["Estado"] is DBNull ? null : reader["Estado"].ToString();
camas.ID_hospitales_servicios = reader["ID_hospitales_servicios"] is DBNull ? null : (Int32?)reader["ID_hospitales_servicios"];
}
else
{
camas = null;
}
reader.Close();
}
catch (SqlException)
{
return(camas);
}
finally
{
connection.Close();
}
return(camas);
}
public ActionResult Create([Bind(Include =
"Num_cama"
+ "," + "Estado"
+ "," + "ID_hospitales_servicios"
)] camas camas)
{
if (ModelState.IsValid)
{
bool bSucess = false;
bSucess = camasData.Add(camas);
if (bSucess == true)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Can Not Insert");
}
}
// ComboBox
ViewData["ID_hospitales_servicios"] = new SelectList(camas_hospitales_serviciosData.List(), "ID_hospitales_servicios", "CodigoRefer", camas.ID_hospitales_servicios);
return(View(camas));
}
public static bool Update(camas oldcamas,
camas newcamas)
{
SqlConnection connection = hospitalData.GetConnection();
string updateProcedure = "[camasUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newcamas.Num_cama.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewNum_cama", newcamas.Num_cama);
}
else
{
updateCommand.Parameters.AddWithValue("@NewNum_cama", DBNull.Value);
}
if (newcamas.Estado != null)
{
updateCommand.Parameters.AddWithValue("@NewEstado", newcamas.Estado);
}
else
{
updateCommand.Parameters.AddWithValue("@NewEstado", DBNull.Value);
}
if (newcamas.ID_hospitales_servicios.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@NewID_hospitales_servicios", newcamas.ID_hospitales_servicios);
}
else
{
updateCommand.Parameters.AddWithValue("@NewID_hospitales_servicios", DBNull.Value);
}
updateCommand.Parameters.AddWithValue("@Oldid_cama", oldcamas.id_cama);
if (oldcamas.Num_cama.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldNum_cama", oldcamas.Num_cama);
}
else
{
updateCommand.Parameters.AddWithValue("@OldNum_cama", DBNull.Value);
}
if (oldcamas.Estado != null)
{
updateCommand.Parameters.AddWithValue("@OldEstado", oldcamas.Estado);
}
else
{
updateCommand.Parameters.AddWithValue("@OldEstado", DBNull.Value);
}
if (oldcamas.ID_hospitales_servicios.HasValue == true)
{
updateCommand.Parameters.AddWithValue("@OldID_hospitales_servicios", oldcamas.ID_hospitales_servicios);
}
else
{
updateCommand.Parameters.AddWithValue("@OldID_hospitales_servicios", DBNull.Value);
}
updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
updateCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException)
{
return(false);
}
finally
{
connection.Close();
}
}
