/// <summary> /// busca la primer row del datatable de familia patente cuando se selecciona una familia_patente /// </summary> /// <param name="IdFamiliaElement">string</param> /// <returns>data row</returns> public static DataRow Select(System.String IdFamiliaElement) { try { return(Familia_Patente.Select(IdFamiliaElement).Tables[0].Rows[0]); } catch (Exception ex) { throw ex; } }
/// <summary> /// inserta una familia /// </summary> /// <param name="_object">familia</param> public static void Insert(Entities.UFP.Familia _object) { using (SqlConnection conn = ConnectionBD.Instance().Conect()) { using (SqlCommand cmd = new SqlCommand("Familia_Insert @IdFamilia, @Nombre", conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdFamilia", _object.IdFamiliaElement); cmd.Parameters.AddWithValue("@Nombre", _object.Nombre); conn.Open(); cmd.ExecuteNonQuery(); } } //Database myDatabase = DatabaseFactory.CreateDatabase(); //DbCommand myCommand = myDatabase.GetStoredProcCommand("Familia_Insert"); //myDatabase.AddInParameter(myCommand, "@IdFamilia", DbType.String, _object.IdFamiliaElement); //myDatabase.AddInParameter(myCommand, "@Nombre", DbType.String, _object.Nombre); //myDatabase.ExecuteNonQuery(myCommand); if (_object.Accesos != null) { DeleteAccesos(_object); Familia_Patente.DeleteAccesos(_object); foreach (Entities.UFP.FamiliaElement _tipo in _object.Accesos) { if (_tipo.GetType().Name == "Familia") { using (SqlConnection conn = ConnectionBD.Instance().Conect()) { using (SqlCommand cmd = new SqlCommand("Familia_Familia_Insert @IdFamilia, @IdFamiliaHijo", conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdFamilia", _object.IdFamiliaElement); cmd.Parameters.AddWithValue("@IdFamiliaHijo", _tipo.IdFamiliaElement); conn.Open(); cmd.ExecuteNonQuery(); } } //DbCommand myCommandAccesos = myDatabase.GetStoredProcCommand("Familia_Familia_Insert"); //myDatabase.AddInParameter(myCommandAccesos, "@IdFamilia", DbType.String, _object.IdFamiliaElement); //myDatabase.AddInParameter(myCommandAccesos, "@IdFamiliaHijo", DbType.String, _tipo.IdFamiliaElement); //myDatabase.ExecuteNonQuery(myCommandAccesos); } else { using (SqlConnection conn = ConnectionBD.Instance().Conect()) { using (SqlCommand cmd = new SqlCommand("Familia_Patente_Insert @IdFamilia, @IdPatente", conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdFamilia", _object.IdFamiliaElement); cmd.Parameters.AddWithValue("@IdPatente", _tipo.IdFamiliaElement); conn.Open(); cmd.ExecuteNonQuery(); } } //DbCommand myCommandAccesos = myDatabase.GetStoredProcCommand("Familia_Patente_Insert"); //myDatabase.AddInParameter(myCommandAccesos, "@IdFamilia", DbType.String, _object.IdFamiliaElement); //myDatabase.AddInParameter(myCommandAccesos, "@IdPatente", DbType.String, _tipo.IdFamiliaElement); //myDatabase.ExecuteNonQuery(myCommandAccesos); } } } }