public ActionResult Start()
{
ActualizaciondePAModel model = new ActualizaciondePAModel();
//PAModel model = new PAModel();
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
model.sesion = sesion;
Main view = new Main();
ViewBag.MainUser = view.CreateMenuInfoUser(sesion);
ViewBag.sedes = view.createSelectSedes("Sedes", sesion);
ViewBag.Main = view.createMenu("Pagos", "Actualización de la PA", sesion);
// ViewBag.Main = view.createMenu(7, 8, sesion);
//Intercom
ViewBag.User = sesion.nickName.ToString();
ViewBag.Email = sesion.nickName.ToString();
ViewBag.FechaReg = DateTime.Today;
sesion.vdata["TABLE_PA_UPDATE"] = "PA_UPDATE"; //"PA_TMP_UPDATE";
sesion.saveSession();
ViewBag.BlockingPanel_1 = Main.createBlockingPanel("blocking-panel-1");
ViewBag.BlockingPanel_2 = Main.createBlockingPanel("blocking-panel-2", false, "");
model.CleanPersona();
model.CleanPA();
ViewBag.DataTable = CreateDataTable(10, 1, null, "NRC", "ASC", sesion);
ViewBag.COMBO_CAMPUSPA = getCampusPA();
ViewBag.Scripts = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);
if (!sesion.permisos.havePermission(Privileges[0].Permiso))
{
return(View(Factory.View.NotAccess));
}
Log.write(this, "PA Start", LOG.CONSULTA, "Ingresa pantalla Actualizar PA", sesion);
return(View(Factory.View.Access + "Pagos/ActualizaciondePA/Start.cshtml"));
}
public string GenerarTodo(string sedesPersns)
{
ActualizaciondePAModel model = new ActualizaciondePAModel();
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
model.sesion = sesion;
if (model.GenerarTodo(sedesPersns, Convert.ToString(sesion.pkUser)))
{
Log.write(this, "GenerarTodo", LOG.EDICION, "Se han importado todos los registros", model.sesion);
return(Notification.Succes("Los datos se ha actualizado satisfactoriamente."));
}
else
{
return(Notification.Error("No se ha podido hacer la Generación completa."));
}
}
public string Generar(string ids)
{
ActualizaciondePAModel model = new ActualizaciondePAModel();
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
model.sesion = sesion;
int totalPA;
int registradosPA;
int registradosPersonas;
if (model.Generar(ids, out totalPA, out registradosPA, out registradosPersonas))
{
Log.write(this, "Generar", LOG.EDICION, "ids:" + ids, model.sesion);
return(Notification.Succes("Los datos se ha actualizado satisfactoriamente. " + registradosPA + "/" + totalPA + " registros (" + registradosPersonas + " personas)"));
}
else
{
return(Notification.Error("No se ha podido hacer la Generación completa (" + registradosPA + " / " + totalPA + " registros generados)"));
}
}
public string getCampusPA()
{
ActualizaciondePAModel model = new ActualizaciondePAModel();
SessionDB sesion = SessionDB.start(Request, Response, false, model.db, SESSION_BEHAVIOR.AJAX);
if (sesion == null)
{
return("");
}
StringBuilder sb = new StringBuilder();
string selected = "";
string IdCampus = sesion.vdata["Sede"];
foreach (KeyValuePair <string, string> pair in model.getCampusPA())
{
selected = (IdCampus == pair.Key) ? "selected" : "";
sb.Append("<option value=\"").Append(pair.Key).Append("\" ").Append(selected).Append(">").Append(pair.Value).Append("</option>\n");
selected = "";
}
return(sb.ToString());
}
public string getDetallesConflictoPA()
{
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
System.Data.DataTable dt = new System.Data.DataTable();
ActualizaciondePAModel model = new ActualizaciondePAModel();
string htmlTable = string.Empty;
try { dt = model.ConsultaDetallesConflicto(sesion.pkUser.ToString()); }
catch (Exception ex) { dt = null; }
if (dt.Rows.Count > 0 && dt != null)
{
htmlTable += "<table style='width: 100%; table-layout: fixed;'>"
+ "<tr><th style='width: 70px; background-color:#3E3D3E; color:#FF8520; overflow: hidden; word-wrap: break-word; vertical-align: top; text-align: left; padding: 8px;'>IDSIU</th>"
+ " <th style='width: 250px; background-color:#3E3D3E; color:#FF8520; overflow: hidden; word-wrap: break-word; vertical-align: top; text-align: left; padding: 8px;'>Nombre</th>"
+ " <th style='width: 500px; background-color:#3E3D3E; color:#FF8520; overflow: hidden; word-wrap: break-word; vertical-align: top; text-align: left; padding: 8px;'>Mensaje de error</th>"
+ " <th style='width: 4000px; background-color:#3E3D3E; color:#FF8520; overflow: hidden; word-wrap: break-word; vertical-align: top; text-align: left; padding: 8px;'>Query</th></tr>";
foreach (DataRow dr in dt.Rows)
{
htmlTable += "<tr><td style='width: 70px; overflow: hidden; word-wrap: break-word; vertical-align: top; border-bottom: 1px solid #ddd; text-align: left; padding: 8px;'>" + dr["IDSIU"] + "</td>"
+ " <td style='width: 250px; overflow: hidden; word-wrap: break-word; vertical-align: top; border-bottom: 1px solid #ddd; text-align: left; padding: 8px;'>" + dr["NOMBRE"] + "</td>"
+ " <td style='width: 500px; overflow: hidden; word-wrap: break-word; vertical-align: top; border-bottom: 1px solid #ddd; text-align: left; padding: 8px;'>" + dr["ERRMSG"] + "</td>"
+ " <td style='width: 4000px; overflow: hidden; word-wrap: break-word; vertical-align: top; border-bottom: 1px solid #ddd; text-align: left; padding: 8px;'>" + dr["QUERY"] + "</td></tr>";
}
htmlTable += "</table>";
}
else
{
htmlTable = "<p style='color:red;'>¡Ups! Disculpa, hay un error al consultar el detalle, favor de avisar al administrador.</p>";
}
return(htmlTable);
}
//#EXPORT EXCEL
public void ExportExcel()
{
ActualizaciondePAModel model = new ActualizaciondePAModel();
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
try
{
/*
* string[] columnas = {"", "ID SIU", "Docente(NOMBRE)", "Docente(Apellido)","Periodo", "NRC", "Materia","Nombre de Materia"
* ,"% de Responsabilidad","Horas a Pagar","Fecha Inicio","Fecha Fin","Indicador de sesión","Campus" };
*
*
* string[] campos = {"CASO", "IDSIU","NOMBRE","APELLIDOS","PERIODO", "NRC", "MATERIA","NOMBREMATERIA", "RESPONSABILIDAD","HORASAPAGAR"
* ,"FECHAINICIAL", "FECHAFINAL","INDICADORDESESION" ,"CAMPUS_INB","USUARIO"
* ,"CVE_ESCUELA","CVE_TIPODEDOCENTE","CVE_OPCIONDEPAGO", "INDICADOR", "ID_PA","CAMPOFI","CAMPOFF","CAMPOHRS","CAMPORESPONS","CAMPOINDS" };*/
System.Data.DataTable tbl = new System.Data.DataTable();
tbl.Columns.Add("Caso", typeof(string));
tbl.Columns.Add("IDSIU", typeof(string));
tbl.Columns.Add("Docente(NOMBRE)", typeof(string));
tbl.Columns.Add("Docente(Apellido)", typeof(string));
tbl.Columns.Add("Periodo", typeof(string));
tbl.Columns.Add("NRC", typeof(string));
tbl.Columns.Add("Materia", typeof(string));
tbl.Columns.Add("Nombre de Materia", typeof(string));
tbl.Columns.Add("% de Responsabilidad", typeof(string));
tbl.Columns.Add("Horas a Pagar", typeof(string));
tbl.Columns.Add("Fecha Inicio", typeof(string));
tbl.Columns.Add("Fecha Fin", typeof(string));
tbl.Columns.Add("Indicador de sesión", typeof(string));
tbl.Columns.Add("Campus", typeof(string));
ResultSet res = db.getTable("SELECT * FROM PA_UPDATE WHERE USUARIO = " + sesion.pkUser + " ORDER BY NRC");
string registro = "";
List <string> lcolorGreen = new List <string>();
List <string> lcolorYellow = new List <string>();
List <string> lcolorRed = new List <string>();
List <string> lcampoFI = new List <string>();
List <string> lcampoFIN = new List <string>();
List <string> lcampoHRS = new List <string>();
List <string> lcampoRES = new List <string>();
List <string> lcampoINDS = new List <string>();
int row = 2;
while (res.Next())
{
//registro = model.existExcel(false, res.Get("NRC"), res.Get("PERIODO"), res.Get("IDSIU"), res.Get("CAMPUS_INB")) ? "Sí" : "No";
// Here we add five DataRows.
tbl.Rows.Add("", res.Get("IDSIU"), res.Get("NOMBRE"), res.Get("APELLIDOS"), res.Get("PERIODO"), res.Get("NRC")
, res.Get("MATERIA"), res.Get("NOMBREMATERIA"), res.Get("RESPONSABILIDAD")
, res.Get("HORASAPAGAR"), res.Get("FECHAINICIAL"), res.Get("FECHAFINAL"), res.Get("INDICADORDESESION")
, res.Get("CAMPUS_INB"));
if (res.Get("CASO").Trim() == "N")
{
lcolorGreen.Add("A" + row + ":A" + row);
} //nuevo
if (res.Get("CASO").Trim() == "A")
{
lcolorYellow.Add("A" + row + ":A" + row);
if (res.GetBool("CAMPORESPONS"))
{
lcampoRES.Add("I" + row + ":I" + row);
}
if (res.GetBool("CAMPOHRS"))
{
lcampoHRS.Add("J" + row + ":J" + row);
}
if (res.GetBool("CAMPOFI"))
{
lcampoFI.Add("K" + row + ":K" + row);
}
if (res.GetBool("CAMPOFF"))
{
lcampoFIN.Add("L" + row + ":L" + row);
}
if (res.GetBool("CAMPOINDS"))
{
lcampoINDS.Add("M" + row + ":M" + row);
}
}//actualización
if (res.Get("CASO").Trim() == "B")
{
lcolorRed.Add("A" + row + ":A" + row);
} //baja
row++;
}
using (ExcelPackage pck = new ExcelPackage())
{
//Create the worksheet
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Actualización de programación Academica");
//Load the datatable into the sheet, starting from cell A1. Print the column names on row 1
ws.Cells["A1"].LoadFromDataTable(tbl, true);
//Format the header for column 1-3
using (ExcelRange rng = ws.Cells["A1:N1"])
{
rng.Style.Font.Bold = true;
rng.Style.Fill.PatternType = ExcelFillStyle.Solid; //Set Pattern for the background to Solid
rng.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(79, 129, 189)); //Set color to dark blue
rng.Style.Font.Color.SetColor(Color.White);
}
//
foreach (var x in lcolorGreen)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(0, 128, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
foreach (var x in lcolorYellow)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 255, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
foreach (var x in lcolorRed)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 0, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
/***/
foreach (var x in lcampoRES)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 255, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
foreach (var x in lcampoHRS)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 255, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
foreach (var x in lcampoFI)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 255, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
foreach (var x in lcampoFIN)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 255, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
foreach (var x in lcampoINDS)
{
using (ExcelRange rngX = ws.Cells[x])
{
rngX.Style.Fill.PatternType = ExcelFillStyle.Solid;
rngX.Style.Fill.BackgroundColor.SetColor(Color.FromArgb(255, 255, 0));
rngX.Style.Font.Color.SetColor(Color.Black);
}
}
//Example how to Format Column 1 as numeric
using (ExcelRange col = ws.Cells[2, 1, 2 + tbl.Rows.Count, 1])
{
col.Style.Numberformat.Format = "#,##0.00";
col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
}
//Write it back to the client
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=Propuesta_PA.xlsx");
Response.BinaryWrite(pck.GetAsByteArray());
}
Log.write(this, "Start", LOG.CONSULTA, "Exporta Excel Propuesta de programación Academica", sesion);
}
catch (Exception e)
{
ViewBag.Notification = Notification.Error(e.Message);
Log.write(this, "Start", LOG.ERROR, "Exporta Excel Propuesta de programación Academica" + e.Message, sesion);
}
}
public string Consultar(string Periodo, string TipoDeContrato, string TipoPago, string Escuela, string Campus, string CampusPA, string TipoDocente, string PartePeriodo)
{
//Antiguo servicio https://servicecloudappp.lcred.net:9099/wsProfesores/"
if (sesion == null)
{
sesion = SessionDB.start(Request, Response, false, db);
}
TipoDocenteController td = new TipoDocenteController();
TipoDocente = td.getTipoDocente();
TiposPagosController tp = new TiposPagosController();
TipoPago = tp.getTiposPagoV();
string paURL = ConfigurationManager.AppSettings["xURL"];
string paUser = ConfigurationManager.AppSettings["xUser"];
string paSecret = ConfigurationManager.AppSettings["xSecret"];
string paFormat = ConfigurationManager.AppSettings["xFormat"];
ConnectUrlToken.ConnectUrlToken con = new ConnectUrlToken.ConnectUrlToken(paURL, paUser, paSecret, paFormat);
JavaScriptSerializer serializer = new JavaScriptSerializer();
string str_json = serializer.Serialize(
new srvDatosProgramacionAcademica
{
periodo = Periodo,
escuela = Escuela,
tipoContrato = TipoDeContrato,
tipoDocente = TipoDocente,
campusPA = CampusPA,
campusVPDI = Campus,
tipoPago = TipoPago,
partePeriodo = PartePeriodo,
});
Token token = con.getToken();
int maxDatos = 0;
int agregados = 0;
try
{
ActualizaciondePAModel aux = new ActualizaciondePAModel();
aux.sesion = sesion;
// (aux as ActualizarIPersona).CleanPersona();
(aux as ActualizarIPA).CleanPA();
(aux as ActualizarIPA).CleanPA_UPDATE();//****
sesion.vdata["sesion_periodo"] = Periodo;
ActualizaciondePAModel[] models = con.connectX <ActualizaciondePAModel[]>(token, "srvDatosProgramacionAcademica", str_json);
maxDatos = models.Length;
agregados = ActualizaciondePAModel.Consultar(models, sesion);
sesion.vdata["TABLE_PA_UPDATE"] = "PA_UPDATE";
sesion.saveSession();
if (models.Length > 0)
{
ActualizaciondePAModel model = new ActualizaciondePAModel();
//comparar tabla 1.-caso PA_TMP_UPDATE vs PA
if (model.Comparar(Periodo, TipoDeContrato, TipoPago, Escuela, Campus, CampusPA, TipoDocente, PartePeriodo, model, sesion))
{
return(Notification.Succes("Termino consulta "));
}
/* if (models.Length == agregados)
* return Notification.Succes("Datos consultados: " + agregados + " / " + maxDatos);
* else
* return Notification.WarningDetail("Datos consultados: " + agregados + " / " + maxDatos);*/
}
else
{
return(Notification.Warning("No se han encontrado datos con los filtros especificados."));
}
}
catch (Exception ex)
{
Debug.WriteLine("Error." + ex.Message);
}
return(Notification.Error("Ocurrio un error al consultar la informacion. Registros consultados: " + agregados + " / " + maxDatos));
}
