public override int Delete(Entity entity, DataTransaction tran) { Entities.FwkUsuarios item = entity as Entities.FwkUsuarios; DataEntities.SpFwkUsuariosDel sp = new DataEntities.SpFwkUsuariosDel(); sp.IdUsuario = item.ID; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public override int Insert(Entity entity, DataTransaction tran) { Entities.FwkUsuarios item = entity as Entities.FwkUsuarios; DataEntities.SpFwkUsuariosIns sp = new DataEntities.SpFwkUsuariosIns(); sp.IdUsuario = item.ID; sp.NomUsuario = item.Nombre; sp.Password = item.Password; sp.Email = item.Email; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public List <Entities.FwkUsuarios> ListarFwkUsuarios(Entities.JQXGridSettings settings, string IdUsuario) { DataEntities.SpFwkUsuariosGrd sp = new DataEntities.SpFwkUsuariosGrd(); List <Entities.FwkUsuarios> list = new List <Entities.FwkUsuarios>(); sp.IdUsuario = IdUsuario; this.ConfigurePagedStoredProcedure(sp, settings); DataTable dt = sp.GetDataTable(this.ConnectionString); foreach (DataRow dr in dt.Rows) { Entities.FwkUsuarios item = new Entities.FwkUsuarios(true); item.ID = Utils.GetDataRowValue(dr, "IdUsuario", ""); this.SetWebEntityGridValues(item, dr); list.Add(item); } return(list); }
public List <Exception> Eliminar(string[] ids) { List <Exception> list = new List <Exception>(); if (ids != null && ids.Length > 0) { foreach (string id in ids) { Entities.FwkUsuarios item = new Entities.FwkUsuarios(true); item.ID = Utils.IsNull(id, ""); try { this.Data.Delete(item); } catch (Exception ex) { list.Add(ex); } } } return(list); }