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);
}
}
}
}
