public List <Entities.FwkAcciones> ListarFwkAcciones(InglesIndividual.Entities.JQXGridSettings settings, string claAccion, string descripcion) { List <Entities.FwkAcciones> list = new List <Entities.FwkAcciones>(); DataEntities.SpFwkAccionesGrd sp = new DataEntities.SpFwkAccionesGrd(); sp.ClaAccion = claAccion; sp.Descripcion = descripcion; this.ConfigurePagedStoredProcedure(sp, settings); DataTable dt = sp.GetDataTable(this.ConnectionString); foreach (DataRow dr in dt.Rows) { Entities.FwkAcciones item = new Entities.FwkAcciones(true); item.ClaAccion = Utils.GetDataRowValue(dr, "ClaAccion", " "); item.Descripcion = Utils.GetDataRowValue(dr, "Descripcion", ""); this.SetWebEntityGridValues(item, dr); list.Add(item); } return(list); }
public override int Delete(Entity entity, DataTransaction tran) { Entities.FwkAcciones item = entity as Entities.FwkAcciones; DataEntities.spFwkAccionesDel sp = new DataEntities.spFwkAccionesDel(); sp.ClaAccion = item.ClaAccion; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public List <Exception> Eliminar(string[] ids) { List <Exception> list = new List <Exception>(); if (ids != null && ids.Length > 0) { foreach (string id in ids) { Entities.FwkAcciones item = new Entities.FwkAcciones(true); item.ClaAccion = Utils.IsNull(id, ""); try { this.Data.Delete(item); } catch (Exception ex) { list.Add(ex); } } } return(list); }