public List <Exception> Eliminar(string[] ids) { List <Exception> list = new List <Exception>(); if (ids != null && ids.Length > 0) { foreach (string id in ids) { Entities.FwkObjetos item = new Entities.FwkObjetos(true); item.FwkAplicacion.ClaAplicacion = Utils.IsNull(id, 0); item.FwkModulo.ClaModulo = Utils.IsNull(id, 0); try { this.Data.Delete(item); } catch (Exception ex) { list.Add(ex); } } } return(list); }
public List <Entities.FwkObjetos> ListarFwkObjetos(InglesIndividual.Entities.JQXGridSettings settings, int claAplicacion, int claModulo, int claObjeto, string ClaObjeto, string nomObjetos, string url) { List <Entities.FwkObjetos> list = new List <Entities.FwkObjetos>(); DataEntities.SpFwkObjetosGrd sp = new DataEntities.SpFwkObjetosGrd(); sp.ClaAplicaion = claAplicacion; sp.ClaModulo = claModulo; sp.ClaObjeto = claObjeto; sp.ClaveObjeto = ClaObjeto; sp.NomObjeto = nomObjetos; sp.Url = url; this.ConfigurePagedStoredProcedure(sp, settings); DataTable dt = sp.GetDataTable(this.ConnectionString); foreach (DataRow dr in dt.Rows) { Entities.FwkObjetos item = new Entities.FwkObjetos(true); item.FwkAplicacion = new Entities.FwkAplicaciones(); item.FwkAplicacion.ClaAplicacion = Utils.GetDataRowValue(dr, "ClaAplicacion", 0); item.FwkModulo = new Entities.FwkModulos(); item.FwkModulo.ClaModulo = Utils.GetDataRowValue(dr, "ClaModulo", 0); item.ClaObjeto = Utils.GetDataRowValue(dr, "ClaObjeto", 0); item.ClaveObjeto = Utils.GetDataRowValue(dr, "ClaveObjeto", ""); item.NomObjeto = Utils.GetDataRowValue(dr, "NomObjetos", ""); item.Url = Utils.GetDataRowValue(dr, "Url", ""); this.SetWebEntityGridValues(item, dr); list.Add(item); } return(list); }
public override int Delete(Entity entity, DataTransaction tran) { Entities.FwkObjetos item = entity as Entities.FwkObjetos; DataEntities.SpFwkObjetoDel sp = new DataEntities.SpFwkObjetoDel(); sp.ClaAplicaion = item.FwkAplicacion.ClaAplicacion; sp.ClaModulo = item.FwkModulo.ClaModulo; sp.ClaObjeto = item.ClaObjeto; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public override int Insert(Entity entity, DataTransaction tran) { Entities.FwkObjetos item = entity as Entities.FwkObjetos; DataEntities.SpFwkObjetosIns sp = new DataEntities.SpFwkObjetosIns(); sp.ClaAplicaion = item.FwkAplicacion.ClaAplicacion; sp.ClaModulo = item.FwkAplicacion.ClaAplicacion; sp.ClaObjeto = item.ClaObjeto; sp.ClaveObjeto = item.ClaveObjeto; sp.NomObjeto = item.NomObjeto; sp.Url = item.Url; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }