/// <summary> /// llena una lista de patentes, con sus datos, a partir de una datatable /// </summary> /// <param name="collection">lis patentes</param> public void Fill(List <Entities.UFP.Patente> collection) { foreach (DataRow row in datosDT.Rows) { Entities.UFP.Patente _object = new Entities.UFP.Patente(); PatenteAdapter adapter = new PatenteAdapter(row); adapter.Fill(_object); collection.Add(_object); } }
/// <summary> /// elimina una patente /// </summary> /// <param name="_object">patente</param> public static void Delete(Entities.UFP.Patente _object) { try { Patente.Delete(_object); } catch (Exception ex) { throw ex; } }
/// <summary> /// inserta una patente /// </summary> /// <param name="_object">patente</param> public static void Insert(Entities.UFP.Patente _object) { try { Patente.Insert(_object); } catch (Exception ex) { throw ex; } }
/// <summary> /// llama a dal para eliminar una patente /// </summary> /// <param name="_object">patente</param> public static void Delete(Entities.UFP.Patente _object) { try { PatenteFacade.Delete(_object); } catch (Exception ex) { //GestorErrores.Execute(ex); throw; } }
private void btnAgregarPatente_Click(object sender, EventArgs e) { try { Entities.UFP.Patente patente = BLL.UFP.Patente.GetAdapted(ddlPatentes.SelectedValue.ToString()); usuario.Permisos.Add(patente); bind.Add(patente); 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); } }
/// <summary> /// elimina una patente /// </summary> /// <param name="_object">patente</param> public static void Delete(Entities.UFP.Patente _object) { using (SqlConnection conn = ConnectionBD.Instance().Conect()) { using (SqlCommand cmd = new SqlCommand("Patente_Delete @IdPatente", conn)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@IdPatente", _object.IdFamiliaElement); conn.Open(); cmd.ExecuteNonQuery(); } } //Database myDatabase = DatabaseFactory.CreateDatabase(); //DbCommand myCommand = myDatabase.GetStoredProcCommand("Patente_Delete"); //myDatabase.AddInParameter(myCommand, "@IdPatente", DbType.String, _object.IdFamiliaElement); //myDatabase.ExecuteNonQuery(myCommand); }
/// <summary> /// retorna uns patente /// </summary> /// <param name="IdFamiliaElement"></param> /// <returns>patente</returns> public static Entities.UFP.Patente GetAdapted(System.String IdFamiliaElement) { try { DataRow dr = Select(IdFamiliaElement); Adapters.PatenteAdapter adapter = new Adapters.PatenteAdapter(dr); //Instancio un objeto patente Entities.UFP.Patente _object = new Entities.UFP.Patente(); adapter.Fill(_object); return(_object); } catch (Exception ex) { throw ex; } }
/// <summary> /// llena una patente con su nombre y id, a partir de una datarows /// </summary> /// <param name="_object">patente</param> public void Fill(Entities.UFP.Patente _object) { _object.IdFamiliaElement = (System.String)row["IdPatente"]; _object.Nombre = (System.String)row["Nombre"]; }