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