public int insertMicroredDocente(ModeloNegocio.MicroredDocente ObjMicroredDocente)
{
AccesoDatos.MicroredDocente microred = new AccesoDatos.MicroredDocente();
//AccesoDatos.UserSchool userSchool = new AccesoDatos.UserSchool();
//return userSchool.updateSelectSchoolForIduser(idSchool, value);
return(microred.insertMicroredDocente(ObjMicroredDocente));
}
public List<ModeloNegocio.MicroredDocente> getAllMicroredDocenteForIdMicrored(int idMicrored)
{
List<ModeloNegocio.MicroredDocente> lista = new List<ModeloNegocio.MicroredDocente>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "PA_GET_MICRORED_DOCENTE_FOR_MICRORED_ID";
Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = idMicrored;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.MicroredDocente microredDocente = new ModeloNegocio.MicroredDocente();
microredDocente.Id = Convert.ToInt32(Dtr["id"]);
microredDocente.Docente_id = Convert.ToInt32(Dtr["docente_id"]);
microredDocente.Microred_id = Convert.ToInt32(Dtr["microred_id"]);
if (DBNull.Value.Equals(Dtr["created_at"])) microredDocente.Created_at = DateTime.Now; else microredDocente.Created_at = DateTime.Parse(Dtr["created_at"].ToString());
if (DBNull.Value.Equals(Dtr["updated_at"])) microredDocente.Updated_at = DateTime.Now; else microredDocente.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString());
lista.Add(microredDocente);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return lista;
}
public int insertMicroredDocente(ModeloNegocio.MicroredDocente ObjMicroredDocentel)
{
try
{
Cmd = new SqlCommand();
Cmd.Connection = Conn;
Cmd.Parameters.Clear();
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "PA_ING_MICRORED_DOCENTE";
Cmd.Parameters.Add("@docente_id", SqlDbType.Int).Value = ObjMicroredDocentel.Docente_id;
Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = ObjMicroredDocentel.Microred_id;
Cmd.Parameters.Add("@microred_docente_id", SqlDbType.Int).Direction = ParameterDirection.Output;
Cmd.ExecuteNonQuery();
ObjMicroredDocentel.Id = Convert.ToInt32(Cmd.Parameters["@microred_docente_id"].Value);
Conn.Close();
return(ObjMicroredDocentel.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.MicroredDocente> getAllMicroredDocenteForIdMicrored(int idMicrored)
{
List <ModeloNegocio.MicroredDocente> lista = new List <ModeloNegocio.MicroredDocente>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "PA_GET_MICRORED_DOCENTE_FOR_MICRORED_ID";
Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = idMicrored;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.MicroredDocente microredDocente = new ModeloNegocio.MicroredDocente();
microredDocente.Id = Convert.ToInt32(Dtr["id"]);
microredDocente.Docente_id = Convert.ToInt32(Dtr["docente_id"]);
microredDocente.Microred_id = Convert.ToInt32(Dtr["microred_id"]);
if (DBNull.Value.Equals(Dtr["created_at"]))
{
microredDocente.Created_at = DateTime.Now;
}
else
{
microredDocente.Created_at = DateTime.Parse(Dtr["created_at"].ToString());
}
if (DBNull.Value.Equals(Dtr["updated_at"]))
{
microredDocente.Updated_at = DateTime.Now;
}
else
{
microredDocente.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString());
}
lista.Add(microredDocente);
}
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;
}
}
