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