public override void PrepareEntityForEdition(Entity entity)
{
Entities.Ciudad item = entity as Entities.Ciudad;
if (item != null && item.FromDataSource)
{
DataEntities.SpCiudadesSel sp = new DataEntities.SpCiudadesSel();
sp.ClaCiudad = item.ID;
sp.ClaEstado = item.ID;
sp.ClaPais = item.ID;
DataTable dt = sp.GetDataTable(this.ConnectionString);
if (dt != null && dt.Rows.Count == 1)
{
item.ID = Utils.GetDataRowValue(dt.Rows[0], "ClaCiudad", 0);
item.ID = Utils.GetDataRowValue(dt.Rows[0], "ClaEstado", 0);
item.ID = Utils.GetDataRowValue(dt.Rows[0], "ClaPais", 0);
item.Nombre = Utils.GetDataRowValue(dt.Rows[0], "NomCiudad", "");
}
}
}
public List <Entities.Campus> Combo()
{
List <Entities.Campus> list = new List <Entities.Campus>();
DataEntities.SpCiudadesSel sp = new DataEntities.SpCiudadesSel();
sp.ClaPais = -1;
sp.ClaEstado = -1;
sp.ClaCiudad = -1;
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Campus item = new Entities.Campus(true);
item.ID = Utils.GetDataRowValue(dr, "ClaCampus", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomCampus", "");
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
