protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DirectorMN = new ModeloNegocio.Director();
DirectorLN = new LogicaNegocio.Director();
DirectorMN.id = Convert.ToInt32(Request.Params["director_id"]);
DirectorLN.getDirector(ref DirectorMN);
txtCodigo.Text = DirectorMN.Codigo;
txtNombreApellido.Text = DirectorMN.FullName;
txtCorreo.Text = DirectorMN.Email;
txtTelefono.Text = DirectorMN.Telefono;
txtCorreo.Text = DirectorMN.Email;
ObjSchoolLN = new LogicaNegocio.School();
ddlEscuela.DataSource = ObjSchoolLN.getAllSchoolNoSelect();
ddlEscuela.DataValueField = "id";
ddlEscuela.DataTextField = "nombre";
ddlEscuela.DataBind();
ListItem item = ddlEscuela.Items.FindByValue(Convert.ToString(DirectorMN.School_id));
if (item != null)
{
item.Selected = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
LogicaNegocio.Director users = new LogicaNegocio.Director();
List <ModeloNegocio.Director> listUsuario = new List <ModeloNegocio.Director>();
//-------------Inicio Paginador
UscPaginador.caragaPaginador(20, Convert.ToInt32(Request.Params["pagina"]), users.countRows(9));
int NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar;
//---------------Fin Paginador
listUsuario = users.getAllDirector(20, UscPaginador.RegistrosAEmpezar, 9);
foreach (ModeloNegocio.Director director in listUsuario)
{
NumRegistrosEmpezar++;
FilasListaDocente.Text += "<tr id='" + director.School_id + "'>";
FilasListaDocente.Text += "<th scope=row>" + NumRegistrosEmpezar + "</th>";
FilasListaDocente.Text += "<td>" + director.Codigo + "</td>";
FilasListaDocente.Text += "<td>" + director.FullName + "</td>";
FilasListaDocente.Text += "<td>" + director.FechaCreado + "</td>";
FilasListaDocente.Text += "<td>";
FilasListaDocente.Text += "<a href='" + "Admin-EditSubDirector.aspx?subdirector_id=" + director.School_id + "&id=5'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar Director'></span></a>";
// FilasListaDocente.Text += "<a href='" + "#" + "'><span class='glyphicon glyphicon-user' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver datos de Asesor'></span></a>";
FilasListaDocente.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar a <b>" + director.FullName + "</b> ','" + director.School_id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar Director'></span></a>";
FilasListaDocente.Text += "<a href='" + "Admin-PasswordUser.aspx?id=5&user_id=" + director.School_id + "&password=subdirector'><span class='glyphicon glyphicon-lock' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Cambiar/Editar Pasword'></span></a>";
FilasListaDocente.Text += "</td></tr>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
LogicaNegocio.Director users = new LogicaNegocio.Director();
List<ModeloNegocio.Director> listUsuario = new List<ModeloNegocio.Director>();
//-------------Inicio Paginador
UscPaginador.caragaPaginador(20, Convert.ToInt32(Request.Params["pagina"]), users.countRows(8));
int NumRegistrosEmpezar = UscPaginador.RegistrosAEmpezar;
//---------------Fin Paginador
listUsuario = users.getAllDirector(20, UscPaginador.RegistrosAEmpezar,8);
foreach (ModeloNegocio.Director director in listUsuario)
{
NumRegistrosEmpezar++;
FilasListaDocente.Text += "<tr id='" + director.School_id + "'>";
FilasListaDocente.Text += "<th scope=row>" + director.School_id + "</th>";
FilasListaDocente.Text += "<td>" + director.Codigo + "</td>";
FilasListaDocente.Text += "<td>" + director.FullName + "</td>";
FilasListaDocente.Text += "<td>" + director.FechaCreado + "</td>";
FilasListaDocente.Text += "<td>";
FilasListaDocente.Text += "<a href='" + "Admin-EditDirector.aspx?director_id=" + director.School_id + "&id=4'><span class='glyphicon glyphicon-pencil' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Editar Director'></span></a>";
// FilasListaDocente.Text += "<a href='" + "#" + "'><span class='glyphicon glyphicon-user' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Ver datos de Asesor'></span></a>";
FilasListaDocente.Text += "<a href='" + "#" + "' onClick=\"javascript:showMyModalSetTitle('Eliminar', 'Está seguro que desea eliminar a <b>" + director.FullName + "</b> ','" + director.School_id + "')\"'><span class='glyphicon glyphicon-remove' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Eliminar Director'></span></a>";
FilasListaDocente.Text += "<a href='" + "Admin-PasswordUser.aspx?id=4&user_id=" + director.School_id + "&password=director'><span class='glyphicon glyphicon-lock' aria-hidden='true' data-toggle='tooltip' data-placement='bottom' title='Cambiar/Editar Pasword'></span></a>";
FilasListaDocente.Text += "</td></tr>";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DirectorMN = new ModeloNegocio.Director();
DirectorLN = new LogicaNegocio.Director();
DirectorMN.id = Convert.ToInt32(Request.Params["subdirector_id"]);
DirectorLN.getDirector(ref DirectorMN);
txtCodigo.Text = DirectorMN.Codigo;
txtNombreApellido.Text = DirectorMN.FullName;
txtCorreo.Text = DirectorMN.Email;
txtTelefono.Text = DirectorMN.Telefono;
txtCorreo.Text = DirectorMN.Email;
ObjSchoolLN = new LogicaNegocio.School();
ddlEscuela.DataSource = ObjSchoolLN.getAllSchoolNoSelect();
ddlEscuela.DataValueField = "id";
ddlEscuela.DataTextField = "nombre";
ddlEscuela.DataBind();
ListItem item = ddlEscuela.Items.FindByValue(Convert.ToString(DirectorMN.School_id));
if (item != null)
{
item.Selected = true;
}
}
}
protected void cmdGuardar_Click(object sender, EventArgs e)
{
ObjDirectorMN = new ModeloNegocio.Director();
ObjDirectorLN = new LogicaNegocio.Director();
ObjDirectorMN.Codigo = txtCodigo.Text;
ObjDirectorMN.FullName = txtNombreApellido.Text;
ObjDirectorMN.Email = txtCorreo.Text;
ObjDirectorMN.Type = 8;
ObjDirectorMN.Telefono = txtTelefono.Text;
//ObjDirectorMN.TypeContract = Convert.ToString(ddlContrato.SelectedItem);
ObjDirectorMN.School_id = ObjDirectorLN.insertDirector(ObjDirectorMN);
ObjUserSchoolMN = new ModeloNegocio.UserSchool();
ObjUserSchoolLN = new LogicaNegocio.UserSchool();
ObjUserSchoolMN.UserAsesorId = ObjDirectorMN.School_id;
ObjUserSchoolMN.UserSchoolId = Convert.ToInt32(ddlEscuela.SelectedValue);
ObjUserSchoolLN.insertUserSchool(ObjUserSchoolMN);
string strRedirect;
strRedirect = "Admin-ListDirector.aspx?id=4";
Response.Redirect(strRedirect, true);
}
protected void cmdGuardar_Click(object sender, EventArgs e)
{
ObjDirectorMN = new ModeloNegocio.Director();
ObjDirectorLN = new LogicaNegocio.Director();
ObjDirectorMN.Codigo = txtCodigo.Text;
ObjDirectorMN.FullName = txtNombreApellido.Text;
ObjDirectorMN.Email = txtCorreo.Text;
ObjDirectorMN.Type = 8;
ObjDirectorMN.Telefono = txtTelefono.Text;
//ObjDirectorMN.TypeContract = Convert.ToString(ddlContrato.SelectedItem);
ObjDirectorMN.School_id = ObjDirectorLN.insertDirector(ObjDirectorMN);
ObjUserSchoolMN = new ModeloNegocio.UserSchool();
ObjUserSchoolLN = new LogicaNegocio.UserSchool();
ObjUserSchoolMN.UserAsesorId = ObjDirectorMN.School_id;
ObjUserSchoolMN.UserSchoolId = Convert.ToInt32(ddlEscuela.SelectedValue);
ObjUserSchoolLN.insertUserSchool(ObjUserSchoolMN);
string strRedirect;
strRedirect = "Admin-ListDirector.aspx?id=4";
Response.Redirect(strRedirect, true);
}
protected void btnReport_Click(object sender, EventArgs e)
{
LogicaNegocio.Director docente = new LogicaNegocio.Director();
// List<ModeloNegocio.Asesor> listUsuario = new List<ModeloNegocio.Asesor>();
// NOW ASSIGN DATA TO A DATAGRID.
DataGrid dg = new DataGrid();
dg.DataSource = docente.getReportAllDirector();
dg.DataBind();
// THE EXCEL FILE.
string sFileName = "Director-" + System.DateTime.Now.Date + "-.xls";
sFileName = sFileName.Replace("/", "");
// SEND OUTPUT TO THE CLIENT MACHINE USING "RESPONSE OBJECT".
Encoding encoding = Encoding.UTF8;
Response.ClearContent();
Response.Buffer = true;
//Response.Charset = encoding.EncodingName;
//Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Charset = encoding.EncodingName;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("Windows-1252");
Response.AddHeader("content-disposition", "attachment; filename=" + sFileName);
Response.ContentType = "application/vnd.ms-excel";
//Response.ContentType = "application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
//Response.AppendHeader("content-disposition", "attachment; filename=myfile.xlsx");
EnableViewState = false;
System.IO.StringWriter objSW = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter objHTW = new System.Web.UI.HtmlTextWriter(objSW);
dg.HeaderStyle.Font.Bold = true; // SET EXCEL HEADERS AS BOLD.
dg.HeaderStyle.ForeColor = Color.White;
dg.HeaderStyle.BackColor = Color.Blue;
dg.RenderControl(objHTW);
// STYLE THE SHEET AND WRITE DATA TO IT.
Response.Write("<style> TABLE { border:solid 1px #999; } " +
"TD { border:solid 1px #000000; text-align:center } </style>");
Response.Write(objSW.ToString());
// ADD A ROW AT THE END OF THE SHEET SHOWING A RUNNING TOTAL OF PRICE.
//Response.Write("<table><tr><td><b>Total: </b></td><td></td><td><b>" +
//dTotalPrice.ToString("N2") + "</b></td></tr></table>");
Response.End();
}
protected void btnReport_Click(object sender, EventArgs e)
{
LogicaNegocio.Director docente = new LogicaNegocio.Director();
// List<ModeloNegocio.Asesor> listUsuario = new List<ModeloNegocio.Asesor>();
// NOW ASSIGN DATA TO A DATAGRID.
DataGrid dg = new DataGrid();
dg.DataSource = docente.getReportAllDirector();
dg.DataBind();
// THE EXCEL FILE.
string sFileName = "Director-" + System.DateTime.Now.Date + "-.xls";
sFileName = sFileName.Replace("/", "");
// SEND OUTPUT TO THE CLIENT MACHINE USING "RESPONSE OBJECT".
Encoding encoding = Encoding.UTF8;
Response.ClearContent();
Response.Buffer = true;
//Response.Charset = encoding.EncodingName;
//Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Charset = encoding.EncodingName;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("Windows-1252");
Response.AddHeader("content-disposition", "attachment; filename=" + sFileName);
Response.ContentType = "application/vnd.ms-excel";
//Response.ContentType = "application/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
//Response.AppendHeader("content-disposition", "attachment; filename=myfile.xlsx");
EnableViewState = false;
System.IO.StringWriter objSW = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter objHTW = new System.Web.UI.HtmlTextWriter(objSW);
dg.HeaderStyle.Font.Bold = true; // SET EXCEL HEADERS AS BOLD.
dg.HeaderStyle.ForeColor = Color.White;
dg.HeaderStyle.BackColor = Color.Blue;
dg.RenderControl(objHTW);
// STYLE THE SHEET AND WRITE DATA TO IT.
Response.Write("<style> TABLE { border:solid 1px #999; } " +
"TD { border:solid 1px #000000; text-align:center } </style>");
Response.Write(objSW.ToString());
// ADD A ROW AT THE END OF THE SHEET SHOWING A RUNNING TOTAL OF PRICE.
//Response.Write("<table><tr><td><b>Total: </b></td><td></td><td><b>" +
//dTotalPrice.ToString("N2") + "</b></td></tr></table>");
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
visitaMN = new ModeloNegocio.VisitaIE();
visitaLN = new LogicaNegocio.VisitaIE();
visitaMN.Id = Convert.ToInt32(Request.Params["visita_id"]);
visitaMN = visitaLN.getVisitaId(visitaMN.Id);
txtFecha.Text = visitaMN.Fecha.ToString("yyyy-MM-dd");
asesorLN = new LogicaNegocio.Asesor();
asesorMN = new ModeloNegocio.Asesor();
asesorMN = asesorLN.getAsesorId(visitaMN.Asesor_id);
txtAsesor.Text = asesorMN.FullName;
directorLN = new LogicaNegocio.Director();
directorMN = new ModeloNegocio.Director();
directorMN = directorLN.getDirectorId(visitaMN.Director_id);
txtDirector.Text = directorMN.FullName;
docenteLN = new LogicaNegocio.Docente();
docenteMN = new ModeloNegocio.Docente();
docenteMN = docenteLN.getDocenteId(visitaMN.Docente_id);
txtDocente.Text = docenteMN.FullName;
schoolLN = new LogicaNegocio.School();
schoolMN = new ModeloNegocio.School();
//schoolMN = schoolLN.getDocenteId(visitaMN.Docente_id);
schoolMN = schoolLN.getSchool(visitaMN.School_id);
txtSchool.Text = schoolMN.Nombre.ToString();
txtMotivoVisita.Text = visitaMN.MotivoVisita;
txtObservacion.Text = visitaMN.Observacion;
TxtPendientes.Text = visitaMN.Pendientes;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
visitaMN = new ModeloNegocio.VisitaIE();
visitaLN = new LogicaNegocio.VisitaIE();
visitaMN.Id = Convert.ToInt32(Request.Params["visita_id"]);
visitaMN = visitaLN.getVisitaId(visitaMN.Id);
txtFecha.Text = visitaMN.Fecha.ToString("yyyy-MM-dd");
asesorLN = new LogicaNegocio.Asesor();
asesorMN = new ModeloNegocio.Asesor();
asesorMN = asesorLN.getAsesorId(visitaMN.Asesor_id);
txtAsesor.Text = asesorMN.FullName;
directorLN = new LogicaNegocio.Director();
directorMN = new ModeloNegocio.Director();
directorMN=directorLN.getDirectorId(visitaMN.Director_id);
txtDirector.Text = directorMN.FullName;
docenteLN = new LogicaNegocio.Docente();
docenteMN = new ModeloNegocio.Docente();
docenteMN = docenteLN.getDocenteId(visitaMN.Docente_id);
txtDocente.Text = docenteMN.FullName;
schoolLN = new LogicaNegocio.School();
schoolMN = new ModeloNegocio.School();
//schoolMN = schoolLN.getDocenteId(visitaMN.Docente_id);
schoolMN = schoolLN.getSchool(visitaMN.School_id);
txtSchool.Text = schoolMN.Nombre.ToString();
txtMotivoVisita.Text = visitaMN.MotivoVisita;
txtObservacion.Text = visitaMN.Observacion;
TxtPendientes.Text = visitaMN.Pendientes;
}
}
