Ejemplo n.º 1
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "", string filterFecha = "", string sede = "")
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "QNominaMesAnio";
            String[] columnas     = { "tipo_transferencia", "tipo_pago", "fecha_de_pago", "id", "empleado", "importe", "importe_iva", "importe_iva_retenido", "importe_isr_retenido", "bancos" };
            String[] campos       = { "tipo_transferencia", "tipo_pago", "fecha_de_pago", "id", "empleado", "importe", "importe_iva", "importe_iva_retenido", "importe_isr_retenido", "bancos" };
            string[] campossearch = { "mes" };

            table.CAMPOS       = campos;
            table.COLUMNAS     = columnas;
            table.CAMPOSSEARCH = campossearch;

            if (!filterFecha.Equals(""))
            {
                table.TABLECONDICIONSQL = "fecha_de_pago = '" + filterFecha + "'" + " and sede='" + sede + "'";
            }

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "tipo_transferencia";

            table.enabledButtonControls = false;

            return(table.CreateDataTable(sesion));
        }
        public ActionResult Delete(PensionadosModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            try
            {
                if (model.Delete())
                {
                    Log.write(this, "Delete", LOG.BORRADO, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Succes("Beneficiario ELIMINADO con exito: " + model.IdPensionado) }));
                }
                else
                {
                    Log.write(this, "Delete", LOG.ERROR, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Error("Error al Eliminar la beneficiario = " + model.IdPensionado) }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Notification.Error(e.Message) }));
            }
        }
Ejemplo n.º 3
0
        public ActionResult Delete(BloqueosModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(Json(new { msg = Notification.notAccess() }));
            }

            try
            {
                if (model.Delete())
                {
                    Log.write(this, "Delete", LOG.BORRADO, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Succes("Bloqueo ELIMINADO con exito: " + model.Bloqueo) }));
                }
                else
                {
                    Log.write(this, "Delete", LOG.ERROR, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Error("Error al Eliminar el Bloqueo = " + model.Bloqueo) }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Notification.Error(e.Message) }));
            }
        }
Ejemplo n.º 4
0
        // GET: Impuestos
        public ActionResult Start()
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            Main view = new Main();

            ViewBag.MainUser  = view.CreateMenuInfoUser(sesion);
            ViewBag.sedes     = view.createSelectSedes("Sedes", sesion);
            ViewBag.Main      = view.createMenu("Administración", "Variables", sesion);
            ViewBag.DataTable = CreateDataTable(10, 1, null, "VARIABLE", "ASC", sesion);

            ViewBag.Scripts = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);


            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(View(Factory.View.NotAccess));
            }


            Log.write(this, "Impuestos asimilados Start", LOG.CONSULTA, "Ingresa variables asimilados", sesion);

            return(View(Factory.View.Access + "Administracion/Variables/Start.cshtml"));
        }
Ejemplo n.º 5
0
        public string getFechasdePagoEsquema(string EsquemaID = "", string FechaPago = "", string PersonaID = "")
        {
            ConceptosdePagoModel model = new ConceptosdePagoModel();

            model.EsquemaID = EsquemaID;
            model.PersonaID = PersonaID;

            SessionDB sesion = SessionDB.start(Request, Response, false, model.db, SESSION_BEHAVIOR.AJAX);

            if (sesion == null)
            {
                return("");
            }

            model.Usuario = sesion.pkUser.ToString();

            StringBuilder sb       = new StringBuilder();
            string        selected = "";

            sb.Append("<option value=\"\"></option>\n");
            foreach (KeyValuePair <string, string> pair in model.getFechasPago())
            {
                selected = (FechaPago == pair.Value) ? "selected" : "";
                sb.Append("<option value=\"").Append(pair.Key).Append("\" ").Append(selected).Append(">").Append(pair.Value).Append("</option>\n");
                selected = "";
            }
            return(sb.ToString());
        }
Ejemplo n.º 6
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "")
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "FORMATOCONTRATOS";
            String[] columnas     = { "Clave", "Contrato", "Descripción", "Usuario", "Fecha de Modificación" };
            String[] campos       = { "Cve_Contrato", "Contrato", "Contrato_Descripcion", "USUARIO", "FECHA_M" };
            string[] campossearch = { "Cve_Contrato", "Contrato", "Contrato_Descripcion" };

            table.CAMPOS       = campos;
            table.COLUMNAS     = columnas;
            table.CAMPOSSEARCH = campossearch;

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "Cve_Contrato";

            table.enabledButtonControls = false;

            table.addColumnFormat("Contrato", delegate(string Contrato, ResultSet res) {
                string retencion1 = "<a href=\"javascript:void(0)\" onClick=\"formPage.PrintPDF('" + res.Get("Cve_Contrato") + "');\"><i class=\"fa fa-print\"></i> " + Contrato + " </a>";
                return(retencion1);
            });

            return(table.CreateDataTable(sesion));
        }
        // GET: Tutoriales
        public ActionResult Start()
        {
            if ((sesion = SessionDB.start(Request, Response, false, db)) == null)
            {
                Response.Redirect("~/");
            }

            Main view = new Main();

            ViewBag.MainUser = view.CreateMenuInfoUser(sesion);
            ViewBag.Main     = view.createMenu(62, 0, sesion);
            ViewBag.Scripts  = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);

            //Intercom
            ViewBag.User     = sesion.nickName.ToString();
            ViewBag.Email    = sesion.nickName.ToString();
            ViewBag.FechaReg = DateTime.Today;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(View(Factory.View.NotAccess));
            }

            Log.write(this, "Start", LOG.CONSULTA, "Ingresa a pantalla 'Tutoriales' ", sesion);

            return(View(Factory.View.Access + "Tutoriales/Start.cshtml"));
        }
Ejemplo n.º 8
0
        public ActionResult Start()
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            Main view = new Main();

            ViewBag.MainUser    = view.CreateMenuInfoUser(sesion);
            ViewBag.sedes       = view.createSelectSedes("Sedes", sesion);
            ViewBag.Main        = view.createMenu("Catalogos por Sede", "Centros de costos", sesion);
            ViewBag.TipoFactura = ConsultaTipoFacturas();
            ViewBag.Escuelas    = ConsultaEscuelas();
            ViewBag.DataTable   = CreateDataTable(10, 1, null, "CVE_CENTRODECOSTOS", "ASC");
            ViewBag.Scripts     = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);

            //Intercom
            ViewBag.User     = sesion.nickName.ToString();
            ViewBag.Email    = sesion.nickName.ToString();
            ViewBag.FechaReg = DateTime.Today;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(View(Factory.View.NotAccess));
            }

            Log.write(this, "Bancos Start", LOG.CONSULTA, "Ingresa pantalla Bancos", sesion);

            return(View(Factory.View.Access + "CatalogosPorSede/CentroCostos/Start.cshtml"));
        }
Ejemplo n.º 9
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "", string filter = "")
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "QCentrodeCostos01";
            String[] columnas     = { "ID CC", "Clave", "Descripción", "Tipo Factura", "Tipo de Pago", "Cuenta", "Cuenta IVA", "Cuenta IVA Ret", "Cuenta ISR Ret", "Sede", "Escuela", "Programa", "Usuario", "Fecha modificación" };
            String[] campos       = { "ID_CENTRODECOSTOS", "CVE_CENTRODECOSTOS", "CENTRODECOSTOS", "TIPOFACTURA", "TIPODEPAGO", "CUENTA", "CUENTA_IVA", "CUENTA_RETIVA", "CUENTA_RETISR", "SEDE", "ESCUELA", "PROGRAMA", "USUARIO", "FECHA_M", "CVE_SEDE" };
            string[] campossearch = { "CVE_CENTRODECOSTOS", "CENTRODECOSTOS", "USUARIO", "TIPOFACTURA", "TIPODEPAGO", "CUENTA", "CUENTA_IVA", "CUENTA_RETIVA", "CUENTA_RETISR", "SEDE", "ESCUELA", "PROGRAMA", "FECHA_M" };
            string[] camposhiden  = { "CVE_SEDE" }; //"ID_CENTRODECOSTOS",

            table.CAMPOS            = campos;
            table.COLUMNAS          = columnas;
            table.CAMPOSSEARCH      = campossearch;
            table.CAMPOSHIDDEN      = camposhiden;
            table.TABLECONDICIONSQL = "CVE_SEDE = '" + filter + "'";

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "ID_CENTRODECOSTOS";

            table.enabledButtonControls = false;

            return(table.CreateDataTable(sesion));
        }
		public ActionResult Save(DatosPersonasModel model)
		{
			if (sesion == null) { sesion = SessionDB.start(Request, Response, false, db); }
			model.sesion = sesion;

			if (!sesion.permisos.havePermission(Privileges[0].Permiso))
				return Json(new { msg = Notification.notAccess() });
			try
			{
				if (model.Save())
				{
                    if (model.SaveTP())
                    {
                        Log.write(this, "Save", LOG.EDICION, "SQL:" + model.sql, sesion);
                        return Json(new { msg = Notification.Succes("Persona guardada con exito: " + model.Idsiu + " - " + model.Nombres + " " + model.Apellidos) });
                    } else
                    {
                        Log.write(this, "Save", LOG.EDICION, "SQL:" + model.sql, sesion);
                        return Json(new { msg = Notification.Warning("Persona guardada con exito: " + model.Idsiu + " - " + model.Nombres + " " + model.Apellidos + ", pero con errores en la PA (tipo de pago).") });
                    }
				}
				else
				{
					Log.write(this, "Save", LOG.ERROR, "SQL:" + model.sql, sesion);
					return Json(new { msg = Notification.Error(" Error al guardar Persona: " + model.Idsiu + " - " + model.Nombres + " " + model.Apellidos) });
				}
			}
			catch (Exception e)
			{
				return Json(new { msg = Notification.Error(e.Message) });

			}
		}
        public ActionResult Despublicar(GestiondePagosModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            /*
             *          if (!sesion.permisos.havePermission(Privileges[0].Permiso))
             *                  return Json(new { msg = Notification.notAccess() });
             *          //*/
            try
            {
                if (model.publicar())
                {
                    model.init();
                    Log.write(this, "Publicar", LOG.REGISTRO, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Succes("Despublicado(s) con exito ") }));
                }
                else
                {
                    model.init();
                    Log.write(this, "Publicar", LOG.ERROR, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Error(" Error al despublicar") }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Factory.Notification.Error(e.Message) }));
            }
        }
        public ActionResult getIdPersona(DatosPersonasModel model)
        {
            if ((sesion = SessionDB.start(Request, Response, false, db)) == null) { return Content("-1"); }

            if (model.getIdPersona())
            {
                if (model.Id_Persona != "-1")
                {
                    sesion.vdata["idPersona"] = model.Id_Persona;
                    sesion.saveSession();
                    return Json(new JavaScriptSerializer().Serialize(model));
                }
                else
                {
                    Log.write(this, "Buscar IDSIU en formulario DatosPersonas X", LOG.ERROR, "SQL:" + model.sql, sesion);
                    model.msg = Factory.Notification.Error(" La persona no existe en este contexto: " + model.Idsiu);
                    return Json(new JavaScriptSerializer().Serialize(model));
                }
            }
            else
            {
                Log.write(this, "Buscar IDSIU en formulario DatosPersonas Y", LOG.ERROR, "SQL:" + model.sql, sesion);
                model.msg = Factory.Notification.Error(" La persona no existe en este contexto: " + model.Idsiu);
                return Json(new JavaScriptSerializer().Serialize(model));
            }
            //return View();
        }
		public ActionResult Start()
		{
            if ((sesion = SessionDB.start(Request, Response, false, db)) == null) { return Content(""); }

			Main view = new Main();
			ViewBag.MainUser = view.CreateMenuInfoUser(sesion);
			ViewBag.sedes = view.createSelectSedes("Sedes", sesion);
			ViewBag.Main = view.createMenu("Personas", "Datos personas", sesion);
			ViewBag.DataTable = CreateDataTable(10, 1, null, "ID_PERSONA", "ASC", sesion);
            ViewBag.Scripts = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);

            //Intercom
            ViewBag.User = sesion.nickName.ToString();
            ViewBag.Email = sesion.nickName.ToString();
            ViewBag.FechaReg = DateTime.Today;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
				return View(Factory.View.NotAccess);

			ViewBag.ComboNAC = CreaCombo("Select * from NACIONALIDADES order by NACIONALIDAD", "NACIONALIDAD", "NACIONALIDAD", "MEXICANA",true);
			ViewBag.ComboTPA = CreaCombo("Select * from TIPOSDEPAGO order by TIPODEPAGO", "CVE_TIPODEPAGO", "TIPODEPAGO", "",true);
			ViewBag.ComboORI = CreaCombo("Select * from ORIGENPERSONA order by ORIGEN", "CVE_ORIGEN", "ORIGEN", "");
			ViewBag.ComboBAN = CreaCombo("Select * from BANCOS order by CVE_BANCO", "CVE_BANCO", "BANCO", "",true);
            ViewBag.ComboBANCO = CreaCombo("Select * from BANCOS order by CVE_BANCO", "CVE_BANCO", "BANCO", "",true);

            Log.write(this, "DatosPersonas Start", LOG.CONSULTA, "Ingresa Pantalla DatosPersonas", sesion);

			return View(Factory.View.Access + "Personas/DatosPersonas/Start.cshtml");
		}
Ejemplo n.º 14
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "", SessionDB sesion = null)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "TiposFactura";
            String[] columnas     = { "Clave", "Tipo de Factura", "Descripción", "Usuario", "Fecha modificación" };
            String[] campos       = { "CVE_TIPOFACTURA", "TIPOFACTURA", "TIPOFACTURADESCRIPCION", "USUARIO", "FECHA_M" };
            string[] campossearch = { "CVE_TIPOFACTURA", "TIPOFACTURA", "TIPOFACTURADESCRIPCION", "USUARIO", "FECHA_M" };

            table.CAMPOS       = campos;
            table.COLUMNAS     = columnas;
            table.CAMPOSSEARCH = campossearch;

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "CVE_TIPOFACTURA";

            table.enabledButtonControls = false;

            table.addBtnActions("Editar", "editarTiposFactura");

            return(table.CreateDataTable(sesion));
        }
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "")
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "BANCOS";
            String[] columnas     = { "Clave", "Banco", "Transferencias", "Usuario", "Fecha modificación" };
            String[] campos       = { "CVE_BANCO", "BANCO", "TRANSFERENCIAS", "USUARIO", "FECHA_M" };
            string[] campossearch = { "CVE_BANCO", "BANCO", "TRANSFERENCIAS" };

            table.CAMPOS       = campos;
            table.COLUMNAS     = columnas;
            table.CAMPOSSEARCH = campossearch;

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "CVE_BANCO";

            table.enabledButtonControls = false;
            table.addBtnActions("Editar", "editarBanco");

            return(table.CreateDataTable(sesion));
        }
Ejemplo n.º 16
0
        public string Generar(string ids)
        {
            PAModel model = new PAModel();

            //if ((model.sesion = SessionDB.start(Request, Response, false, model.db, SESSION_BEHAVIOR.AJAX)) == null)
            //return string.Empty;

            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&oacute;n completa (" + registradosPA + " / " + totalPA + " registros generados)"));
            }
        }
Ejemplo n.º 17
0
        public ActionResult Save(ContratosWebModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(Json(new { msg = Notification.notAccess() }));
            }

            try
            {
                if (model.Save())
                {
                    Log.write(this, "Save", LOG.EDICION, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Succes("Contrato guardado con exito: " + model.Contrato) }));
                }
                else
                {
                    Log.write(this, "Save", LOG.ERROR, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Error(" Error al GUARDAR: " + model.Contrato) }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Notification.Error(e.Message) }));
            }
        }
Ejemplo n.º 18
0
        public string getCampusPA()
        {
            PAModel model = new PAModel();

            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(pair.Value).Append("</option>\n");
                sb.Append("<option value=\"").Append(pair.Key).Append("\" ").Append(selected).Append(">").Append(pair.Value).Append("</option>\n");
                selected = "";
            }
            return(sb.ToString());
        }
Ejemplo n.º 19
0
        // GET: CalendariodePago
        public ActionResult Start()
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            Main view = new Main();

            ViewBag.MainUser = view.CreateMenuInfoUser(sesion);
            ViewBag.Main     = view.createMenu("Reportes", "Poliza contable por FD", sesion);
            ViewBag.sedes    = view.createSelectSedes("Sedes", sesion);
            ViewBag.Scripts  = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);

            //Intercom
            ViewBag.User     = sesion.nickName.ToString();
            ViewBag.Email    = sesion.nickName.ToString();
            ViewBag.FechaReg = DateTime.Today;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(View(Factory.View.NotAccess));
            }

            Log.write(this, "Start", LOG.CONSULTA, "Ingresa a pantalla 'Nómina por Año y Mes' ", sesion);

            return(View(Factory.View.Access + "Reports/ReportePolizaFD/Start.cshtml"));
        }
        public bool Validate_Usuario_Admin(string client_user, string client_password, LoginModel model)
        {
            bool _valido = false;

            if (client_password != "")
            {
                string server_password = model.consultaPassword(client_user);
                string password        = EncryptX.Decode(server_password);

                if (EncryptX.check(server_password, client_password))
                {
                    database db = new database();
                    SessionDB.afterLogIn(client_user, db, Request, Response);
                    SessionDB sesion = SessionDB.start(Request, Response, false, db);

                    //Log.write(this, "Validate", LOG.CONSULTA, "Detalle x", sesion);

                    _valido = true;
                }
                else
                {
                    ViewBag.Mensaje = "Su password es incorrecto";
                }
            }
            else
            {
                ViewBag.Mensaje = "Ups, falta escribir su password";
            }

            return(_valido);
        }
Ejemplo n.º 21
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show, int pg, string search, string orderby, string sort, SessionDB sesion)
        {
            if (sesion == null)
            {
                if ((sesion = SessionDB.start(Request, Response, false, new database(), SESSION_BEHAVIOR.AJAX)) == null)
                {
                    return(string.Empty);
                }
            }

            DataTable table     = new DataTable();
            string    CheckIcon = "<i class=\"fa fa-check\"></i>";

            table.TABLE        = sesion.vdata["TABLE_CALENDARIORUA"];
            table.COLUMNAS     = new string[] { "Reg", "Año escolar", "Periodo", "Descripción", "Fecha Inicial", "Fecha Final", "Tipo de periodo" };
            table.CAMPOS       = new string[] { "REGISTRADO", "CVE_CICLO", "PERIODO", "DESCRIPCION", "FECHA_INICIAL", "FECHA_FINAL", "TIPOPERIODO" };
            table.CAMPOSSEARCH = new string[] { "CVE_CICLO", "PERIODO", "DESCRIPCION", "FECHA_INICIAL", "FECHA_FINAL", "TIPOPERIODO" };
            table.dictColumnFormat["REGISTRADO"] = delegate(string str, ResultSet res) { return(str == "True" ? CheckIcon : ""); };

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "PERIODO";

            table.enabledCheckbox = true;

            return(table.CreateDataTable(sesion));
        }
Ejemplo n.º 22
0
        public ActionResult Delete(Models.RoleModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(Json(new { msg = Notification.notAccess() }));
            }
            try
            {
                if (model.Delete())
                {
                    return(Json(new { msg = Notification.Succes("Eliminado Role con exito: " + model.Role) }));
                }
                else
                {
                    return(Json(new { msg = Notification.Error(" Error al Eliminar: " + model.Role) }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Notification.Error(e.Message) }));
            }
        }
Ejemplo n.º 23
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "", SessionDB sesion = null)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "VARIABLES";
            String[] columnas     = { "Variable", "Valor", "Descripción", "Usuario", "Fecha Modificación" };
            String[] campos       = { "VARIABLE", "VALOR", "DESCRIPCION", "USUARIO", "FECHA_M" };
            string[] campossearch = { "VARIABLE", "VALOR", "DESCRIPCION" };

            table.CAMPOS       = campos;
            table.COLUMNAS     = columnas;
            table.CAMPOSSEARCH = campossearch;

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "VARIABLE";

            table.enabledButtonControls = false;

            //  table.addBtnActions("Editar", "editarImpuestos");

            return(table.CreateDataTable(sesion));
        }
        public ActionResult Start()
        {
            SessionDB sesion = SessionDB.start(Request, Response, false, db);
            Main      view   = new Main();

            ViewBag.MainUser  = view.CreateMenuInfoUser(sesion);
            ViewBag.sedes     = view.createSelectSedes("Sedes", sesion);
            ViewBag.Main      = view.createMenu("Catalogos Centrales", "Sedes", sesion);
            ViewBag.DataTable = CreateDataTable(10, 1, null, "Cve_Sede", "ASC", sesion);

            //Intercom
            ViewBag.User     = sesion.nickName.ToString();
            ViewBag.Email    = sesion.nickName.ToString();
            ViewBag.FechaReg = DateTime.Today;

            ViewBag.Scripts = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);
            ViewBag.ComboSO = CreaCombo("Select * from SOCIEDADES order by SOCIEDAD", "CVE_SOCIEDAD", "SOCIEDAD");
            ViewBag.ComboCA = CreaCombo("Select * from QCampus order by CAMPUSDESCRIPCION", "CAMPUS_INB", "CAMPUSDESCRIPCION");
            ViewBag.ComboTC = CreaCombo("Select * from QTiposContrato order by TIPOCONTRATODESCRIPCION", "TIPOCONTRATO_INB", "TIPOCONTRATODESCRIPCION");

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(View(Factory.View.NotAccess));
            }

            Log.write(this, "Sedes Start", LOG.CONSULTA, "Ingresa pantalla Sedes", sesion);

            return(View(Factory.View.Access + "CatalogosCentrales/Sedes/Start.cshtml"));
        }
        public ActionResult Save(PensionadosModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            /*
             * if (!sesion.permisos.havePermission(Privileges[0].Permiso))
             *      return Json(new { msg = Notification.notAccess() });
             * //*/
            try
            {
                if (model.Save())
                {
                    Log.write(this, "Save", LOG.EDICION, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Succes("Beneficiario guardado con exito") }));
                }
                else
                {
                    Log.write(this, "Save", LOG.ERROR, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Error(" Error al guardar beneficiario  ") }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Notification.Error(e.Message) }));
            }
        }
        //GET CREATE DATATABLE
        public string CreateDataTable(int show = 25, int pg = 1, string search = "", string orderby = "", string sort = "", SessionDB sesion = null)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }

            DataTable table = new DataTable();

            table.TABLE = "QSedes";
            String[] columnas     = { "Clave", "Sede", "Campus INB", "Tipo Contrato INB", "Usuario", "Fecha modificación" };
            String[] campos       = { "Cve_Sede", "Sede", "CAMPUSDESCRIPCION", "TIPOCONTRATODESCRIPCION", "USUARIO", "FECHA_M" };
            string[] campossearch = { "Sociedad", "CVE_Sede", "Sede", "CAMPUSDESCRIPCION", "TIPOCONTRATODESCRIPCION", "USUARIO", "FECHA_M" };

            table.CAMPOS       = campos;
            table.COLUMNAS     = columnas;
            table.CAMPOSSEARCH = campossearch;

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "Cve_Sede";

            table.enabledButtonControls = false;

            table.addBtnActions("Editar", "editarSedes");

            return(table.CreateDataTable(sesion));
        }
Ejemplo n.º 27
0
        public ActionResult Add(BloqueosModel model)
        {
            if (sesion == null)
            {
                sesion = SessionDB.start(Request, Response, false, db);
            }
            model.sesion = sesion;

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(Json(new { msg = Notification.notAccess() }));
            }

            try
            {
                if (model.Add())
                {
                    Log.write(this, "Add", LOG.REGISTRO, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Succes("Bloqueo agregado con exito: " + model.Bloqueo) }));
                }
                else
                {
                    Log.write(this, "Add", LOG.ERROR, "SQL:" + model.sql, sesion);
                    return(Json(new { msg = Notification.Error(" Error al agregar:" + model.Bloqueo) }));
                }
            }
            catch (Exception e)
            {
                return(Json(new { msg = Factory.Notification.Error(e.Message) }));
            }
        }
Ejemplo n.º 28
0
        //GET CREATE DATATABLE
        public string CreateDataTable(int show, int pg, string search, string orderby, string sort, SessionDB sesion)
        {
            if (sesion == null)
            {
                if ((sesion = SessionDB.start(Request, Response, false, new database(), SESSION_BEHAVIOR.AJAX)) == null)
                {
                    return(string.Empty);
                }
            }

            DataTable table     = new DataTable();
            string    CheckIcon = "<i class=\"fa fa-check\"></i>";

            table.TABLE        = sesion.vdata["TABLE_TIPOSCONTRATO"];
            table.COLUMNAS     = new string[] { "Reg", "Tipo de Contrato", "Descripción" };
            table.CAMPOS       = new string[] { "REGISTRADO", "TIPOCONTRATO_INB", "TIPOCONTRATODESCRIPCION" };
            table.CAMPOSSEARCH = new string[] { "TIPOCONTRATO_INB", "TIPOCONTRATODESCRIPCION" };
            table.dictColumnFormat["REGISTRADO"] = delegate(string str, ResultSet res) { return(str == "True" ? CheckIcon : ""); };
            //table.dictColumnFormat["IMPORTADO"] = delegate (string str) { return str == "True" ? CheckIcon : ""; };

            table.orderby  = orderby;
            table.sort     = sort;
            table.show     = show;
            table.pg       = pg;
            table.search   = search;
            table.field_id = "TIPOCONTRATO_INB";

            table.enabledCheckbox = true;

            return(table.CreateDataTable(sesion));
        }
Ejemplo n.º 29
0
        public ActionResult Start()
        {
            if ((sesion = SessionDB.start(Request, Response, false, db)) == null)
            {
                return(Content("-1"));
            }

            Main view = new Main();

            ViewBag.MainUser  = view.CreateMenuInfoUser(sesion);
            ViewBag.sedes     = view.createSelectSedes("Sedes", sesion);
            ViewBag.Main      = view.createMenu("Catalogos Centrales", "Bloqueos", sesion);
            ViewBag.DataTable = CreateDataTable(10, 1, null, "Cve_Bloqueo", "ASC", sesion);

            //Intercom
            ViewBag.User     = sesion.nickName.ToString();
            ViewBag.Email    = sesion.nickName.ToString();
            ViewBag.FechaReg = DateTime.Today;

            ViewBag.Scripts = Scripts.addScript() + Scripts.setPrivileges(Privileges, sesion);

            if (!sesion.permisos.havePermission(Privileges[0].Permiso))
            {
                return(View(Factory.View.NotAccess));
            }

            Log.write(this, "Bloqueos Start", LOG.CONSULTA, "Ingresa Pantalla Bloqueos", sesion);

            return(View(Factory.View.Access + "CatalogosCentrales/Bloqueos/Start.cshtml"));
        }
Ejemplo n.º 30
0
 public List<DBStruct> testSaveFeature()
 {
     SessionDB db = new SessionDB();
     db.saveSessionintoDB("C:\\",0,0);
     return db.getSavedSessions();
 }