public override void fillLst() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Cortina"); addParameters(0); this.dt = GenericDataAccess.ExecuteSelectCommand(comm); this._lst = new List <Cortina>(); foreach (DataRow dr in dt.Rows) { Cortina o = new Cortina(); int.TryParse(dr["id"].ToString(), out entero); o.Id = entero; entero = 0; if (dr["id_bodega"] != DBNull.Value) { int.TryParse(dr["id_bodega"].ToString(), out entero); o.Id_bodega = entero; entero = 0; } o.Nombre = dr["nombre"].ToString(); this._lst.Add(o); } } catch { throw; } }
public void selByIdBodegaAll() { try { this.comm = GenericDataAccess.CreateCommandSP("sp_Cortina"); addParameters(-3); this.dt = GenericDataAccess.ExecuteSelectCommand(comm); this._lst = new List <Cortina>(); foreach (DataRow dr in dt.Rows) { Cortina o = new Cortina(); int.TryParse(dr["id"].ToString(), out entero); o.Id = entero; entero = 0; if (dr["id_bodega"] != DBNull.Value) { int.TryParse(dr["id_bodega"].ToString(), out entero); o.Id_bodega = entero; entero = 0; } o.Nombre = dr["nombre"].ToString(); if (dr["IsActive"] != null) { bool.TryParse(dr["IsActive"].ToString(), out logica); o.IsActive = logica; } this._lst.Add(o); } } catch { throw; } }
public CortinaMng() { this._oCortina = new Cortina(); }