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