public DataTable GetData(DRegimenSalud entiti) { DataTable dt; using (SqlConnection cnn = RConexion.Getconectar()) { cnn.Open(); cmd = null; SqlDataAdapter da = new SqlDataAdapter(); using (cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandText = "SP_SHOW_REG_SALUD"; cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; using (dt = new DataTable()) { da.Fill(dt); da.Dispose(); } } } return(dt); }
public String GuardarCambios() { DRegimenSalud dregsalud = new DRegimenSalud(); dregsalud.Id_regimen_salud = Id_regimen_salud; dregsalud.Cod_regi_salud = Cod_regi_salud; dregsalud.Descripcion = Descripcion; switch (state) { case EntityState.Guardar: Rregsalud.Add(dregsalud); mensaje = dregsalud.mensaje; break; case EntityState.Modificar: Rregsalud.Edit(dregsalud); mensaje = "¡Modificado!"; break; case EntityState.Remover: Rregsalud.Delete(dregsalud); mensaje = dregsalud.mensaje; break; } return(mensaje); }
public int Delete(DRegimenSalud entiti) { result = 0; using (SqlConnection conn = RConexion.Getconectar()) { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SP_DELETE_REGSALUD"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id_regimen_salud", entiti.Id_regimen_salud); cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString(); cmd.Parameters.Clear(); } } return(result); }
public int Edit(DRegimenSalud entiti) { result = 0; using (SqlConnection cnn = RConexion.Getconectar()) { cnn.Open(); cmd = null; using (cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandText = "SP_UPDATE_REG_SALUD"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id_regimen_salud", entiti.Id_regimen_salud); cmd.Parameters.AddWithValue("@cod_regimen_salud", entiti.Cod_regi_salud); cmd.Parameters.AddWithValue("@descripcion_rsalud", entiti.Descripcion); result = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(result); } } }
public int Add(DRegimenSalud entiti) { result = 0; using (SqlConnection conn = RConexion.Getconectar()) { conn.Open(); cmd = null; using (cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SP_ADD_REG_SAL"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cod_regi_salud", entiti.Cod_regi_salud); cmd.Parameters.AddWithValue("@descripcion_rsalud", entiti.Descripcion); cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString(); cmd.Parameters.Clear(); } } return(result); }