public List<ModeloNegocio.MicroredSchool> getAllMicroredSchoolForIdMicrored(int idMicrored) { List<ModeloNegocio.MicroredSchool> lista = new List<ModeloNegocio.MicroredSchool>(); Cmd = new SqlCommand(); Cmd.Connection = Conn; try { Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "PA_GET_MICRORED_SCHOOL_FOR_MICRORED_ID"; Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = idMicrored; Dtr = Cmd.ExecuteReader(); while (Dtr.Read()) { ModeloNegocio.MicroredSchool microredSchool = new ModeloNegocio.MicroredSchool(); microredSchool.Id = Convert.ToInt32(Dtr["id"]); microredSchool.School_id = Convert.ToInt32(Dtr["school_id"]); microredSchool.Microred_id = Convert.ToInt32(Dtr["microred_id"]); if (DBNull.Value.Equals(Dtr["created_at"])) microredSchool.Created_at = DateTime.Now ; else microredSchool.Created_at = DateTime.Parse(Dtr["created_at"].ToString()); if (DBNull.Value.Equals(Dtr["updated_at"])) microredSchool.Updated_at = DateTime.Now ; else microredSchool.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString()); lista.Add(microredSchool); } Conn.Close(); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } return lista; }
public int insertMicroredSchool(ModeloNegocio.MicroredSchool ObjMicroredSchool) { AccesoDatos.MicroredSchool microred = new AccesoDatos.MicroredSchool(); //AccesoDatos.UserSchool userSchool = new AccesoDatos.UserSchool(); //return userSchool.updateSelectSchoolForIduser(idSchool, value); return(microred.insertMicroredSchool(ObjMicroredSchool)); }
public int insertMicroredSchool(ModeloNegocio.MicroredSchool ObjMicroredSchool) { try { Cmd = new SqlCommand(); Cmd.Connection = Conn; Cmd.Parameters.Clear(); Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "PA_ING_MICRORED_SCHOOL"; Cmd.Parameters.Add("@school_id", SqlDbType.Int).Value = ObjMicroredSchool.School_id; Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = ObjMicroredSchool.Microred_id; Cmd.Parameters.Add("@microred_school_id", SqlDbType.Int).Direction = ParameterDirection.Output; Cmd.ExecuteNonQuery(); ObjMicroredSchool.Id = Convert.ToInt32(Cmd.Parameters["@microred_school_id"].Value); Conn.Close(); return(ObjMicroredSchool.Id); } catch (Exception e) { // Console.WriteLine("{0} Problem insert.", e); //throw new Exception("Error en Acceso a Datos: InsertarMonto.", e); return(0); } //throw new NotImplementedException(); }
public List <ModeloNegocio.MicroredSchool> getAllMicroredSchoolForIdMicrored(int idMicrored) { List <ModeloNegocio.MicroredSchool> lista = new List <ModeloNegocio.MicroredSchool>(); Cmd = new SqlCommand(); Cmd.Connection = Conn; try { Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "PA_GET_MICRORED_SCHOOL_FOR_MICRORED_ID"; Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = idMicrored; Dtr = Cmd.ExecuteReader(); while (Dtr.Read()) { ModeloNegocio.MicroredSchool microredSchool = new ModeloNegocio.MicroredSchool(); microredSchool.Id = Convert.ToInt32(Dtr["id"]); microredSchool.School_id = Convert.ToInt32(Dtr["school_id"]); microredSchool.Microred_id = Convert.ToInt32(Dtr["microred_id"]); if (DBNull.Value.Equals(Dtr["created_at"])) { microredSchool.Created_at = DateTime.Now; } else { microredSchool.Created_at = DateTime.Parse(Dtr["created_at"].ToString()); } if (DBNull.Value.Equals(Dtr["updated_at"])) { microredSchool.Updated_at = DateTime.Now; } else { microredSchool.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString()); } lista.Add(microredSchool); } Conn.Close(); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } return(lista); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { microredMN = new ModeloNegocio.Microred(); microredLN = new LogicaNegocio.Microred(); int microred_id = Convert.ToInt32(Request.Params["microred_id"]); microredMN = microredLN.getMicroredId(microred_id); txtFecha.Text = microredMN.Fecha.ToString("yyyy-MM-dd"); asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(microredMN.User_id); txtAsesor.Text = asesorMN.FullName; microredDocenteMN = new ModeloNegocio.MicroredDocente(); microredDocenteLN = new LogicaNegocio.MicroredDocente(); List<ModeloNegocio.MicroredDocente> listaMicroredDocente =new List<ModeloNegocio.MicroredDocente>(); listaMicroredDocente = microredDocenteLN.getAllMicroredDocenteForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredDocente microredDocente in listaMicroredDocente) { docenteLN = new LogicaNegocio.Docente(); docenteMN = new ModeloNegocio.Docente(); docenteMN = docenteLN.getDocenteId(microredDocente.Docente_id); ddlDocente.Items.Add(new ListItem(docenteMN.FullName,docenteMN.id.ToString() )); } microredSchoolMN = new ModeloNegocio.MicroredSchool(); microredSchoolLN = new LogicaNegocio.MicroredSchool(); List<ModeloNegocio.MicroredSchool> listaMicroredSchool = new List<ModeloNegocio.MicroredSchool>(); listaMicroredSchool = microredSchoolLN.getAllMicroredSchoolForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredSchool microredSchool in listaMicroredSchool) { schoolLN = new LogicaNegocio.School(); schoolMN = new ModeloNegocio.School(); schoolMN = schoolLN.getSchool(microredSchool.School_id); ddlSchool.Items.Add(new ListItem(schoolMN.Nombre, schoolMN.id.ToString())); } txtMircrored.Text = microredMN.MicroredName; txtSesion.Text = microredMN.Lugar_sesion; txtInicio.Text = microredMN.H_inicio.ToString("hh:mm:ss"); txtTermino.Text = microredMN.H_termino.ToString("hh:mm:ss"); txtParticipante.Text = Convert.ToString(microredMN.Num_participantes); txtEducacion.Text = microredMN.Educ_financiera; txtEnfoque.Text = microredMN.Enfoques_edu; txtProgramacion.Text = microredMN.Programacion_ped; txtHabilidades.Text = microredMN.Habilidad_ped; txtTrabajo.Text = microredMN.Trabajo_grupal; txtParticipativo.Text = microredMN.Participativo; txtExpositivo.Text = microredMN.Expositivo; txtDinamicas.Text = microredMN.Dinamicas_ludicas; txtRecursos.Text = microredMN.Recursos_informaticos; txtAudiovisuales.Text = microredMN.Recursos_audiovisuales; txtMateriales.Text = microredMN.Materiales_didaticos; txtObservacion.Text = microredMN.Observacion; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { microredMN = new ModeloNegocio.Microred(); microredLN = new LogicaNegocio.Microred(); int microred_id = Convert.ToInt32(Request.Params["microred_id"]); microredMN = microredLN.getMicroredId(microred_id); txtFecha.Text = microredMN.Fecha.ToString("yyyy-MM-dd"); asesorLN = new LogicaNegocio.Asesor(); asesorMN = new ModeloNegocio.Asesor(); asesorMN = asesorLN.getAsesorId(microredMN.User_id); txtAsesor.Text = asesorMN.FullName; microredDocenteMN = new ModeloNegocio.MicroredDocente(); microredDocenteLN = new LogicaNegocio.MicroredDocente(); List <ModeloNegocio.MicroredDocente> listaMicroredDocente = new List <ModeloNegocio.MicroredDocente>(); listaMicroredDocente = microredDocenteLN.getAllMicroredDocenteForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredDocente microredDocente in listaMicroredDocente) { docenteLN = new LogicaNegocio.Docente(); docenteMN = new ModeloNegocio.Docente(); docenteMN = docenteLN.getDocenteId(microredDocente.Docente_id); ddlDocente.Items.Add(new ListItem(docenteMN.FullName, docenteMN.id.ToString())); } microredSchoolMN = new ModeloNegocio.MicroredSchool(); microredSchoolLN = new LogicaNegocio.MicroredSchool(); List <ModeloNegocio.MicroredSchool> listaMicroredSchool = new List <ModeloNegocio.MicroredSchool>(); listaMicroredSchool = microredSchoolLN.getAllMicroredSchoolForIdMicrored(microred_id); foreach (ModeloNegocio.MicroredSchool microredSchool in listaMicroredSchool) { schoolLN = new LogicaNegocio.School(); schoolMN = new ModeloNegocio.School(); schoolMN = schoolLN.getSchool(microredSchool.School_id); ddlSchool.Items.Add(new ListItem(schoolMN.Nombre, schoolMN.id.ToString())); } txtMircrored.Text = microredMN.MicroredName; txtSesion.Text = microredMN.Lugar_sesion; txtInicio.Text = microredMN.H_inicio.ToString("hh:mm:ss"); txtTermino.Text = microredMN.H_termino.ToString("hh:mm:ss"); txtParticipante.Text = Convert.ToString(microredMN.Num_participantes); txtEducacion.Text = microredMN.Educ_financiera; txtEnfoque.Text = microredMN.Enfoques_edu; txtProgramacion.Text = microredMN.Programacion_ped; txtHabilidades.Text = microredMN.Habilidad_ped; txtTrabajo.Text = microredMN.Trabajo_grupal; txtParticipativo.Text = microredMN.Participativo; txtExpositivo.Text = microredMN.Expositivo; txtDinamicas.Text = microredMN.Dinamicas_ludicas; txtRecursos.Text = microredMN.Recursos_informaticos; txtAudiovisuales.Text = microredMN.Recursos_audiovisuales; txtMateriales.Text = microredMN.Materiales_didaticos; txtObservacion.Text = microredMN.Observacion; } }