public List <Entities.Salones> ListarSalones(InglesIndividual.Entities.JQXGridSettings settings, string nomSalon)
{
List <Entities.Salones> list = new List <Entities.Salones>();
DataEntities.SpSalonesGrd sp = new DataEntities.SpSalonesGrd();
sp.NomSalon = nomSalon;
this.ConfigurePagedStoredProcedure(sp, settings);
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Salones item = new Entities.Salones(true);
item.ID = Utils.GetDataRowValue(dr, "IdSalon", 0);
item.Campus = new Entities.Campus();
item.Campus.ID = Utils.GetDataRowValue(dr, "ClaCampus", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomSalon", "");
item.Capacidad = Utils.GetDataRowValue(dr, "Capacidad", 0);
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
public override int Update(Entity entity)
{
Entities.Salones item = entity as Entities.Salones;
DataEntities.SpSalonesUpd sp = new DataEntities.SpSalonesUpd();
sp.IdSalon = item.ID;
sp.NomSalon = item.Nombre;
sp.ClaCampus = item.Campus.ID;
sp.Capacidad = item.Capacidad;
return(sp.ExecuteNonQuery(this.ConnectionString));
}
public override int Insert(Entity entity, DataTransaction tran)
{
Entities.Salones item = entity as Entities.Salones;
DataEntities.SpSalonesIns sp = new DataEntities.SpSalonesIns();
sp.IdSalon = item.ID;
sp.ClaCampus = item.Campus.ID;
sp.NomSalon = item.Nombre;
sp.Capacidad = item.Capacidad;
return(sp.ExecuteNonQuery(this.ConnectionString));
}
public override void PrepareEntityForEdition(Entity entity)
{
Entities.Salones item = entity as Entities.Salones;
if (item != null && item.FromDataSource)
{
DataEntities.SpSalonesSel sp = new DataEntities.SpSalonesSel();
sp.IdSalon = item.ID;
DataTable dt = sp.GetDataTable(this.ConnectionString);
if (dt != null && dt.Rows.Count == 1)
{
item.ID = Utils.GetDataRowValue(dt.Rows[0], "IdSalon", 0);
item.Nombre = Utils.GetDataRowValue(dt.Rows[0], "NomSalon", "");
}
}
}
public override int Delete(Entity entity, DataTransaction tran)
{
Entities.Salones item = entity as Entities.Salones;
DataEntities.SpSalonesDel
sp = new DataEntities.SpSalonesDel();
sp.IdSalon = item.ID;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public List <Entities.Salones> Combo()
{
List <Entities.Salones> list = new List <Entities.Salones>();
DataEntities.SpSalonesSel sp = new DataEntities.SpSalonesSel();
sp.IdSalon = -1;
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Salones item = new Entities.Salones(true);
item.ID = Utils.GetDataRowValue(dr, "IdSalon", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomSalon", "");
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.Salones item = new Entities.Salones(true);
item.ID = Utils.IsNull(id, 0);
try
{
this.Data.Delete(item);
}
catch (Exception ex)
{
list.Add(ex);
}
}
}
return(list);
}
