private void BtnEliminar_Click(object sender, EventArgs e) { if (metroGrid1.SelectedRows.Count > 0) { Entities.UFP.Familia familia = BLL.UFP.Familia.GetAdapted(GetId()); try { DialogResult confirmation = new Notifications.FrmQuestion(Helps.Language.SearchValue("preguntaEliminar")).ShowDialog(); if (confirmation == DialogResult.OK) { BLL.UFP.Familia.Delete(familia); InvokeCommand.InsertLog().Execute(CreateLog.Clog(ETipoLog.Delete, 1, this.GetType().FullName, MethodInfo.GetCurrentMethod().Name, "Familia: " + familia.Nombre, "", "")); RefrescarTabla(); Notifications.FrmSuccess.SuccessForm(Helps.Language.SearchValue("eliminadoOK")); } } catch (Exception ex) { InvokeCommand.InsertLog().Execute(CreateLog.Clog(ETipoLog.DeleteError, 1, ex.TargetSite.DeclaringType.FullName, ex.TargetSite.Name, "Familia: " + familia.Nombre, ex.StackTrace, ex.Message)); RefrescarTabla(); Notifications.FrmError.ErrorForm(Helps.Language.SearchValue("eliminadoError") + "\n" + ex.Message); } RefrescarTabla(); } else { Notifications.FrmInformation.InformationForm(Helps.Language.SearchValue("infoSelecEliminar")); } }
/// <summary> /// elimina una familia /// </summary> /// <param name="_object">familia</param> public static void Delete(Entities.UFP.Familia _object) { if (_object.Accesos != null) { DeleteAccesos(_object); } using (SqlConnection conn = ConnectionBD.Instance().Conect()) { using (SqlCommand cmd = new SqlCommand("Familia_Delete @IdFamiliaElement", conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdFamiliaElement", _object.IdFamiliaElement); conn.Open(); cmd.ExecuteNonQuery(); } } //Database myDatabase = DatabaseFactory.CreateDatabase(); //DbCommand myCommand = myDatabase.GetStoredProcCommand("Familia_Delete"); //myDatabase.AddInParameter(myCommand, "@IdFamilia", DbType.String, _object.IdFamiliaElement); //myDatabase.ExecuteNonQuery(myCommand); }
/// <summary> /// llena las familias de una lista de familias, con los componentes que le correspondan /// </summary> /// <param name="collection"></param> public void Fill(List <Entities.UFP.Familia> collection) { foreach (DataRow row in datosDT.Rows) { Entities.UFP.Familia _object = new Entities.UFP.Familia(); FamiliaAdapter adapter = new FamiliaAdapter(row); adapter.Fill(_object); collection.Add(_object); } }
/// <summary> /// delete familia /// </summary> /// <param name="_object">familia</param> public static void Delete(Entities.UFP.Familia _object) { try { Familia.Delete(_object); } catch (Exception ex) { throw ex; } }
/// <summary> /// insert familia /// </summary> /// <param name="_object">familia</param> public static void Insert(Entities.UFP.Familia _object) { try { Familia.Insert(_object); } catch (Exception ex) { throw ex; } }
/// <summary> /// llama a dal para eliminar una familia /// </summary> /// <param name="_object"></param> public static void Delete(Entities.UFP.Familia _object) { try { FamiliaFacade.Delete(_object); } catch (Exception ex) { //GestorErrores.Execute(ex); throw; } }
/// <summary> /// obtiene una familia con sus accesos /// </summary> /// <param name="IdFamiliaElement">string</param> /// <returns>familia</returns> public static Entities.UFP.Familia GetAdapted(System.String IdFamiliaElement) { try { Adapters.FamiliaAdapter adapter = new Adapters.FamiliaAdapter(Select(IdFamiliaElement)); Entities.UFP.Familia _object = new Entities.UFP.Familia(); adapter.Fill(_object); return(_object); } catch (Exception ex) { throw ex; } }
private void btnAgregarFamilia_Click(object sender, EventArgs e) { try { Entities.UFP.Familia familia = BLL.UFP.Familia.GetAdapted(ddlFamilias.SelectedValue.ToString()); usuario.Permisos.Add(familia); bind.Add(familia); MostrarPermisosEstructura(); } catch (Exception ex) { InvokeCommand.InsertLog().Execute(CreateLog.Clog(ETipoLog.Error, 1, ex.TargetSite.DeclaringType.FullName, ex.TargetSite.Name, "Error carga de datos", ex.StackTrace, ex.Message)); Notifications.FrmError.ErrorForm(Language.SearchValue("errorBuscarDatos") + "\n" + ex.Message); } }
private void BtnDetalle_Click(object sender, EventArgs e) { if (metroGrid1.SelectedRows.Count > 0) { Entities.UFP.Familia familia = BLL.UFP.Familia.GetAdapted(GetId()); string estructura = BLL.UFP.Usuario.MostrarEstructura(familia.Accesos); richTextBox1.Text = estructura; } else { Notifications.FrmInformation.InformationForm(Helps.Language.SearchValue("infoSelecDetalle")); } }
/// <summary> /// llena una familia con los componentes que puea tener /// </summary> /// <param name="_object">familia</param> public void Fill(Entities.UFP.Familia _object) { _object.IdFamiliaElement = (System.String)row["IdFamilia"]; _object.Nombre = (System.String)row["Nombre"]; //Traigo accesos de familia DataTable relacionesFamilia = Familia.GetAccesos(_object.IdFamiliaElement); foreach (DataRow rowAccesos in relacionesFamilia.Rows) { _object.Add(FamiliaFacade.GetAdapted((System.String)rowAccesos["IdFamiliaHijo"])); } //Traigo accesos de patentes DataTable relacionesPatentes = Familia_Patente.GetAccesos(_object.IdFamiliaElement); foreach (DataRow rowAccesos in relacionesPatentes.Rows) { _object.Add(PatenteFacade.GetAdapted((System.String)rowAccesos["IdPatente"])); } }
/// <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); } } } }