Exemplo n.º 1
0
        public static List <IdName> GetEmpleadosDropDown()
        {
            var empleados = new List <IdName>();

            cn = DBConnection.MainConnection();
            try
            {
                cmd = new OleDbCommand("SELECT * FROM empleados;", cn);
                dr  = cmd.ExecuteReader();


                while (dr.Read())
                {
                    IdName temp = new IdName();

                    temp.ID   = dr["id"].ToString();
                    temp.Name = dr["nombre"].ToString();


                    empleados.Add(temp);
                }



                dr.Close();
                cn.Close();
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show("Error al obtener empleados para DropDown  " + ex);
            }


            return(empleados);
        }
Exemplo n.º 2
0
        public SubLocRgModel()
        {
            ResourceGroup = new ResourceGroup();

            _SubscripionIdName = new IdName();
            _LocationIdName    = new IdName();
        }
Exemplo n.º 3
0
        public async Task <List <IdName> > LoadMenuPermission()
        {
            //菜单
            var menus = await _menu.GetAllAsync(w => w.IsAllow == true, ob => ob.Sort);

            //权限
            var permissions = await _permission.GetAllAsync(w => menus.Select(s => s.Id).Contains(w.MenuId));

            List <IdName> names = new List <IdName>();

            //循环遍历所有菜单
            foreach (var item in menus)
            {
                IdName name = new IdName();
                name.Id       = item.Id;
                name.Name     = item.Name;
                name.Children = permissions
                                .Where(w => w.MenuId == item.Id)
                                .Select(s => new IdName {
                    Id = s.Id, Name = s.Name
                })
                                .ToList();
                if (item.Url == "/")
                {
                    name.IsHidden = false;
                }
                names.Add(name);
            }
            return(names);
        }
Exemplo n.º 4
0
        /// <summary>
        /// このクラスでの実行すること。
        /// </summary>
        /// <param name="runChildren"></param>
        public override void Run(bool runChildren)
        {
            var list = RawlerLib.MarkupLanguage.TagAnalyze.GetTag(GetText(), "dl").ToList();

            if (ClassName.IsNullOrEmpty() == false)
            {
                list = list.Where(n => n.Parameter.Contains("class=\"" + ClassName + "\"")).ToList();
            }
            if (IdName.IsNullOrEmpty() == false)
            {
                list = list.Where(n => n.Parameter.Contains("id=\"" + IdName + "\"")).ToList();
            }

            definitionList = new List <KeyValuePair <string, string> >();
            foreach (var item in list)
            {
                foreach (var item2 in RawlerLib.Web.GetTagContentList(item.Inner, "<dt", "</dd>", true))
                {
                    var key = RawlerLib.MarkupLanguage.TagAnalyze.GetTag(item2, "dt", true);
                    var val = RawlerLib.MarkupLanguage.TagAnalyze.GetTag(item2, "dd", true);
                    definitionList.Add(new KeyValuePair <string, string>(key.First().Inner, val.First().Inner));
                }
            }
            RunChildren(runChildren);
        }
Exemplo n.º 5
0
 public static SelectableData MapToSelectableData(this IdName entity)
 {
     return(new SelectableData
     {
         Id = entity.Id,
         Name = entity.Name
     });
 }
Exemplo n.º 6
0
        public RicEnterInFolderCommand(string idParent, string nameParent)
            : base()
        {
            IdName idName = new IdName(idParent, nameParent);

            _path.Add(idName);
            _currentPage = 1;
        }
Exemplo n.º 7
0
        public ActionResult Parents(string term, long?sinceid)
        {
            var options = new IdName();

            options.id   = sinceid.HasValue?sinceid.Value.ToString():"";
            options.name = term;
            return(View(options));
        }
Exemplo n.º 8
0
        public TDLEnterInFolderCommand(string idParent, string nameParent, string idTrasm) : base()
        {
            IdName idName = new IdName(idParent, nameParent);

            _path.Add(idName);
            _currentPage = 1;
            _idTrasm     = idTrasm;
        }
Exemplo n.º 9
0
        public ActionResult UploadAnswer(long id, string qqfile)
        {
            var length = long.Parse(Request.Params["CONTENT_LENGTH"]);

            var filename = Path.GetFileNameWithoutExtension(qqfile);
            var ext      = Path.GetExtension(qqfile);

            var  uploader = new FileHandler(filename.ToSafeUrl() + ext, UploaderType.HOMEWORK, sessionid);
            bool ok       = uploader.Save(Request.InputStream);

            if (!ok)
            {
                return(Json("An error has occurred. Unable to save file".ToJsonFail()));
            }

            // save to database
            var homeworkstudent = db.homework_students.SingleOrDefault(x => x.studentid == sessionid.Value && x.id == id);

            var answer = new homework_answer();

            answer.created    = DateTime.Now;
            answer.url        = uploader.url;
            answer.filename   = qqfile;
            answer.size       = uploader.size;
            answer.homeworkid = homeworkstudent.homeworkid;
            homeworkstudent.homework_answers.Add(answer);

            repository.Save();

            // notify teacher?
            if (homeworkstudent.homework.notifyme)
            {
                var viewmodel   = new NotificationSendViewModel();
                var studentname = homeworkstudent.user.ToName();
                viewmodel.message =
                    string.Format(
                        "An answer has been uploaded by <a href='http://wwww.ioschools.edu.my/users/{0}'>{1}</a>",
                        homeworkstudent.studentid, studentname);
                viewmodel.message += string.Format("<br/> To view your homeworks. <a href='http://wwww.ioschools.edu.my/homework'>Please follow this link</a>.");

                var teacher = homeworkstudent.homework.user;

                if (!string.IsNullOrEmpty(teacher.email))
                {
                    viewmodel.receiver = teacher.ToName();
                    this.SendEmailNow(
                        EmailViewType.HOMEWORK_NOTIFICATION,
                        viewmodel,
                        string.Format("Homework {0}: Answer uploaded by {1}", homeworkstudent.homework.title, studentname),
                        teacher.email,
                        viewmodel.receiver);
                }
            }

            var retVal = new IdName(answer.id, uploader.filename);

            return(Json(retVal.ToJsonOKData()));
        }
Exemplo n.º 10
0
        private IdName ToIdName(DataRow row)
        {
            IdName idname = new IdName();

            idname.Id       = (Guid)row["Id"];
            idname.Name     = (string)row["Name"];
            idname.Category = (string)row["Category"];
            return(idname);
        }
Exemplo n.º 11
0
        private string GetForm_d_ts_Process(string formXml)
        {
            if (Processes.Count == 0)
            {
                return(string.Empty);
            }
            var _d_ts = string.Empty;
            var part1 = string.Empty;

            foreach (var entity in Processes)
            {
                var xaml = entity.GetAttributeValue <string>("xaml");
                var name = entity.GetAttributeValue <string>("name");
                name   = Utility.SafeName(name);
                _d_ts += $"\t\tinterface Process{name} {{\r\n";
                var xdoc  = XDocument.Parse(xaml);
                var ns    = xdoc.Root?.GetNamespaceOfPrefix("mxswa");
                var rows2 = from x in xdoc.Descendants(ns + "Workflow").Elements(ns + "ActivityReference")
                            select new
                {
                    DisplayName = x.Attribute("DisplayName")?.Value,
                    InnerText   = x.ToString()
                };
                var fields = new List <IdName>();
                foreach (var row in rows2)
                {
                    var arr = row.DisplayName.Split(" ".ToCharArray());
                    if (arr.Length == 1)
                    {
                        continue;
                    }
                    const string pattern = @"DataFieldName=""\w*""";
                    foreach (Match m in Regex.Matches(row.InnerText, pattern))
                    {
                        var array     = m.Value.Split("=".ToCharArray());
                        var fieldName = array[1].Substring(1, array[1].Length - 2);
                        var field     = new IdName
                        {
                            ClassId   = ControlClassId.SINGLE_LINE_OF_TEXT,
                            Name      = fieldName,
                            Id        = null,
                            ControlId = null
                        };
                        fields.Add(field);
                    }
                }
                fields = fields.OrderBy(f => f.Name).ToList();
                _d_ts += Get_d_ts_ForListFields(formXml, fields);
                _d_ts += $"\t\t}}\r\n";
                part1 += $"\t\t\t{name}: Process{name};\r\n";
            }
            _d_ts += $"\t\tinterface Process extends DevKit.Form.Controls.IControlProcess {{\r\n";
            _d_ts += part1;
            _d_ts += $"\t\t}}\r\n";
            return(_d_ts);
        }
Exemplo n.º 12
0
 public Factura()
 {
     Empleado  = new IdName();
     Cliente   = new IdName();
     Emission  = DateTime.Today;
     Imp       = 0.00;
     Sub       = 0.00;
     Total     = 0.00;
     Descuento = 0.00;
 }
Exemplo n.º 13
0
        protected override bool ParseSelectorToken(IItemFactory itemFactory, ITextProvider text, ITokenStream stream)
        {
            var name = itemFactory.CreateSpecific<IdName>(this, text, stream);
            if (name.Parse(itemFactory, text, stream))
            {
                Name = name;
                Children.Add(name);
            }

            return Children.Count > 0;
        }
Exemplo n.º 14
0
        //显示所有
        public IdName[] ListAll()
        {
            DataTable table = SqlHelper.ExecuteDataTable("select * from T_IdName");

            IdName[] idname = new IdName[table.Rows.Count];
            for (int i = 0; i < table.Rows.Count; i++)
            {
                idname[i] = ToIdName(table.Rows[i]);
            }
            return(idname);
        }
Exemplo n.º 15
0
        protected override bool ParseSelectorToken(IItemFactory itemFactory, ITextProvider text, ITokenStream stream)
        {
            var name = itemFactory.CreateSpecific <IdName>(this, text, stream);

            if (name.Parse(itemFactory, text, stream))
            {
                Name = name;
                Children.Add(name);
            }

            return(Children.Count > 0);
        }
Exemplo n.º 16
0
 public async Task DoAsync(IdName arg)
 {
     await MarsConnection.ExecuteAsync(new CommandDefinition(@"update temptb
                                                               set Enable = @Enable
                                                               where Id = @Id",
                                                             new
     {
         Enable = true,
         arg.Id
     },
                                                             flags : CommandFlags.Pipelined));
 }
Exemplo n.º 17
0
        public async Task <List <IdName> > GetAuthorizedAccountsAsync(string id, string activityId, int currentRoleId)
        {
            if (string.IsNullOrEmpty(id))
            {
                return(null);
            }
            var WhereClause = new StringBuilder();
            var parameters  = new List <OracleParameter>();
            var param       = new OracleParameter {
                ParameterName = "PartnerId", OracleDbType = OracleDbType.Varchar2, Value = id
            };

            parameters.Add(param);

            var param2 = new OracleParameter {
                ParameterName = "activityId", OracleDbType = OracleDbType.Varchar2, Value = activityId
            };

            parameters.Add(param2);

            var param3 = new OracleParameter {
                ParameterName = "currentRoleId", OracleDbType = OracleDbType.Int32, Value = currentRoleId
            };

            parameters.Add(param3);

            var sql = $"Select partner_id, partner_acc, partner_name  from partner " +
                      $" where partner_id = :PartnerId and  partner.roleid in " +
                      $" (select det.toroleid  from V_PARTNER_ACTIVITY_DETAIL det where det.act_id = :activityId and det.fromroleid = :currentRoleId) " +
                      $" order by partner_acc desc";
            var dataTable = await this.db.GetDataAsync(sql, parameters);

            if (dataTable == null)
            {
                return(null);
            }
            if (dataTable.Rows.Count == 0)
            {
                return(null);
            }

            var partners = new List <IdName>();

            foreach (DataRow row in dataTable.Rows)
            {
                var account = new IdName();
                account.Id = row["partner_acc"] == DBNull.Value ? -1 : int.Parse(row["partner_acc"].ToString());
                var partnerName = row["partner_name"] == DBNull.Value ? string.Empty : row["partner_name"].ToString();
                account.Name = $"{account.Id} - {partnerName}";
                partners.Add(account);
            }
            return(partners);
        }
Exemplo n.º 18
0
        public static Exam ToMarksModel(this ioschools.DB.exam row)
        {
            var exam = new Exam();

            exam.maxMark  = row.maxMark;
            exam.id       = row.id;
            exam.name     = row.name;
            exam.date     = row.exam_date.ToString(Constants.DATETIME_SHORT_DATE);
            exam.subjects = row.exam_subjects.OrderBy(x => x.name).Select(x => new IdName(x.id, x.name)).ToArray();

            // gets student entries
            // sections = classes
            var sections = row.exam_classes.ToModel(row.year);

            foreach (var examSection in sections)
            {
                var section = new ExamSection();
                section.class_name = examSection.class_name;
                section.class_id   = examSection.class_id;
                foreach (var examMark in examSection.marks)
                {
                    var mark = new ExamMark();
                    mark.student = examMark.student;
                    foreach (var entry in exam.subjects)
                    {
                        var subject = entry;
                        var exist   = row.exam_marks
                                      .SingleOrDefault(x => x.studentid.ToString() == mark.student.id &&
                                                       x.exam_subjectid.ToString() == subject.id);
                        var newmark = new IdName();
                        if (exist != null)
                        {
                            // show x if student absent
                            if (exist.absent)
                            {
                                newmark = new IdName(exist.id, "x");
                            }
                            else
                            {
                                newmark = new IdName(exist.id, exist.mark);
                            }
                        }
                        mark.marks.Add(newmark);
                    }
                    section.marks.Add(mark);
                }
                section.marks = section.marks.OrderBy(x => x.student.name).ToList();
                exam.sections.Add(section);
            }

            return(exam);
        }
Exemplo n.º 19
0
        private void ParseIzvodjac(IViewModel input)
        {
            if (IzvodjaciId.Any(p => p == input.Id))
            {
                Console.Clear();
                Console.WriteLine("Izvodjac je vec unet!");
            }

            else
            {
                IzvodjaciId.Add(input.Id);
                IdName.Add(input.Id, input.Naziv);
                Console.Clear();
            }
        }
Exemplo n.º 20
0
 public void custom_mapper()
 {
     var custom = false;
     var d= _db.WithSql("select 1 as Id, 'test' as Name").Query(rd =>
                                                                    {
                                                                        var rez = new IdName();
                                                                        rez.Id = rd.GetInt32(0);
                                                                        rez.Name = rd.GetString(1);
                                                                        custom = true;
                                                                        return rez;
                                                                    }).First();
     Assert.True(custom);
     Assert.Equal(1,d.Id);
     Assert.Equal("test",d.Name);
 }
Exemplo n.º 21
0
        public bool Send(IdName dest, IdName src, string subject, string body, string cclist = null, string replyto = null)
        {
            // need to check for invalid email address
            if (!IsValidEmail(dest.id))
            {
                return(false);
            }

            var from = new MailAddress(src.id, src.name, Encoding.UTF8);
            var to   = new MailAddress(dest.id, dest.name, Encoding.UTF8);
            var msg  = new MailMessage(from, to)
            {
                Body            = body,
                IsBodyHtml      = true,
                BodyEncoding    = Encoding.UTF8,
                Subject         = subject,
                SubjectEncoding = Encoding.UTF8
            };

            if (!string.IsNullOrEmpty(replyto))
            {
                msg.ReplyToList.Add(replyto);
            }

            // cclist
            if (!string.IsNullOrEmpty(cclist))
            {
                msg.CC.Add(cclist);
            }

            bool success = true;

            try
            {
                smtp.Send(msg);
            }
            catch (SmtpFailedRecipientException ex)
            {
                Syslog.Write(ex);
            }
            catch (Exception ex)
            {
                Syslog.Write(ex);
                success = false;
            }

            return(success);
        }
Exemplo n.º 22
0
        public void custom_mapper()
        {
            var custom = false;
            var d      = _db.WithSql("select 1 as Id, 'test' as Name").ExecuteQuery(rd =>
            {
                var rez  = new IdName();
                rez.Id   = rd.GetInt32(0);
                rez.Name = rd.GetString(1);
                custom   = true;
                return(rez);
            }).First();

            Assert.True(custom);
            Assert.Equal(1, d.Id);
            Assert.Equal("test", d.Name);
        }
Exemplo n.º 23
0
        //根据Category获得IdName的数组
        public IdName[] GetByCategory(string category)
        {
            DataTable table = SqlHelper.ExecuteDataTable("select Id,Name from T_IdName where Category=@Category",
                                                         new SqlParameter("@Category", category));

            IdName[] items = new IdName[table.Rows.Count];
            for (int i = 0; i < table.Rows.Count; i++)
            {
                DataRow row    = table.Rows[i];
                IdName  idname = new IdName();
                idname.Id   = (Guid)row["Id"];
                idname.Name = (string)row["Name"];
                items[i]    = idname;
            }
            return(items);
        }
Exemplo n.º 24
0
        public static List <User> GetUsers()
        {
            var users = new List <User>();



            cn = DBConnection.MainConnection();
            try
            {
                cmd = new OleDbCommand("SELECT * FROM (usuarios INNER JOIN roles ON usuarios.id_rol = roles.id)" +
                                       "INNER JOIN empleados on empleados.id = usuarios.id_empleado", cn);
                dr = cmd.ExecuteReader();



                while (dr.Read())
                {
                    User   tempUser = new User();
                    Role   tempRole = new Role();
                    IdName empleado = new IdName();

                    tempUser.UserName = dr["usuario"].ToString();
                    tempRole.Id       = int.Parse(dr["roles.id"].ToString());
                    tempRole.RoleName = dr["roles.nombre"].ToString();
                    tempUser.Status   = Convert.ToBoolean(dr["status"]);
                    tempUser.id       = int.Parse(dr["usuarios.id"].ToString());
                    empleado.ID       = dr["id_empleado"].ToString();
                    empleado.Name     = dr["empleados.nombre"].ToString();


                    tempUser.UserRole = tempRole;
                    tempUser.Empleado = empleado;


                    users.Add(tempUser);
                }

                dr.Close();
                cn.Close();
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show("Error al obtener usuarios  " + ex);
            }

            return(users);
        }
Exemplo n.º 25
0
        /// <summary>
        /// Create an ACL item for an AND group.
        /// </summary>
        /// <param name="v">UserInfo objects</param>
        /// <param name="access">Access rights, AccessC.LUR_*</param>
        /// <returns>AclItem object</returns>
        public static AclItem CreateItem(UserInfo[] v, int access)
        {
            AclItem ai = CreateItem(v[0], access);

            if (v.Length > 1)
            {
                ai.andGroups = new IdName[v.Length - 1];
                for (int i = 0; i < ai.andGroups.Length; i++)
                {
                    IdName idn = ai.andGroups[i] = new IdName();
                    idn.id   = v[i + 1].id;
                    idn.name = v[i + 1].name;
                }
            }

            return(ai);
        }
Exemplo n.º 26
0
        public ActionResult Subjects(int id)
        {
            var result   = repository.GetSchoolSubjects(id);
            var subjects = new List <IdName>();

            foreach (var entry in result.OrderBy(x => x.name))
            {
                var subject = new IdName(entry.id, entry.name);
                subjects.Add(subject);
            }
            if (id == (int)Schools.Kindergarten)
            {
                var empty = new IdName("", "None");
                subjects.Insert(0, empty);
            }
            return(Json(subjects.ToJsonOKData()));
        }
        public static void Initialize(IPlaysContext context)
        {
            if (!context.Plays.Find(_ => true).Any())
            {
                var personGenerator = new PersonNameGenerator();

                var placeGenerator = new PlaceNameGenerator();

                var random = new Random(250);

                var plays = Enumerable.Range(1, 250)
                            .Select(i => new Play
                {
                    Game = new Game
                    {
                        Id    = Guid.NewGuid(),
                        Title = placeGenerator.GenerateRandomPlaceName()
                    },
                    Id           = Guid.NewGuid(),
                    Notes        = placeGenerator.GenerateRandomPlaceName(),
                    PlayedDate   = DateTime.Now.AddDays(-i),
                    PlayerScores = new PlayScore[]
                    {
                        new()
                        {
                            Player = new IdName(Guid.NewGuid(), personGenerator.GenerateRandomFirstAndLastName()),
                            Score  = random.Next()
                        },

                        new()
                        {
                            Player = new IdName(Guid.NewGuid(), personGenerator.GenerateRandomFirstAndLastName()),
                            Score  = random.Next()
                        },

                        new()
                        {
                            Player = new IdName(Guid.NewGuid(),
                                                personGenerator
                                                .GenerateRandomFirstAndLastName()),
                            Score = random.Next()
                        },
                    }
                });
Exemplo n.º 28
0
        public override bool Equals(object obj)
        {
            if (obj == null)
            {
                return(false);
            }
            if (ReferenceEquals(obj, this))
            {
                return(true);
            }
            if (obj.GetType() != GetType())
            {
                return(false);
            }

            IdName rhs = obj as IdName;

            return(Id == rhs.Id && Name == rhs.Name);
        }
Exemplo n.º 29
0
        public static List <IdName> getSubmenus()
        {
            List <IdName> Submenus = new List <IdName>();


            cn = DBConnection.MainConnection();

            try
            {
                cmd = new OleDbCommand("SELECT * from submenu;", cn);

                dr = cmd.ExecuteReader();



                while (dr.Read())
                {
                    IdName temp = new IdName();


                    temp.ID   = dr["id"].ToString();
                    temp.Name = dr["nombre_submenu"].ToString();


                    Submenus.Add(temp);

                    //System.Windows.MessageBox.Show("this is the name " + CurrentMenu[].MenuText);
                }



                dr.Close();
                cn.Close();
            }
            catch (Exception ex)
            {
                System.Windows.MessageBox.Show("Error al obtener los menus " + ex);
            }


            return(Submenus);
        }
Exemplo n.º 30
0
        public async Task OnSubscriptionChanged(IdName value)
        {
            if (value != null)
            {
                Model.SubcriptionId   = value?.Id;
                Model.SubcriptionName = value?.Name;
                LastVmStatus          = null;

                ShowLoading();
                await LoadRg(value?.Id);

                HideLoading();
            }
            else
            {
                Model.SubcriptionId   = null;
                Model.SubcriptionName = null;
                ClearSelection();
            }
        }
Exemplo n.º 31
0
        private void izbrisiIzvodjaca()
        {
            while (true)
            {
                Console.Clear();
                Console.WriteLine("-------------------------------------------------------------------------------------------");
                Stats.AddIzvodjacStats(IdName);
                Console.WriteLine("-------------------------------------------------------------------------------------------");
                Console.WriteLine("Unesite Id broj izvodjaca kog zelite da izbrisete sa liste i pritisnite Enter.\nZa povratak na prethodni meni ukucajte znak \'*\' i pritisnite Enter.");

                string unos = Console.ReadLine().ToLower().Replace(" ", "");

                int myId = 0;
                if (unos == "*")
                {
                    Console.Clear();
                    return;
                }

                if (int.TryParse(unos, out myId))
                {
                    if (IzvodjaciId.Any(p => p == myId))
                    {
                        IzvodjaciId.Remove(myId);
                        IdName.Remove(myId);
                    }
                    else
                    {
                        Console.Clear();
                        Console.WriteLine("Na listi nema izvodjaca sa tim Id brojem! Pritisnite Enter da pokusate ponovo!");
                        Console.ReadLine();
                    }
                }
                else
                {
                    Console.Clear();
                    Console.WriteLine("Neispravan unos! Pritisnite Enter da pokusate ponovo.");
                    Console.ReadLine();
                }
            }
        }
Exemplo n.º 32
0
        /// <summary>
        /// このクラスでの実行すること。
        /// </summary>
        /// <param name="runChildren"></param>
        public override void Run(bool runChildren)
        {
            var list = RawlerLib.MarkupLanguage.TagAnalyze.GetTag(GetText(), "dl").ToList();

            if (ClassName.IsNullOrEmpty() == false)
            {
                list = list.Where(n => n.Parameter.Contains("class=\"" + ClassName + "\"")).ToList();
            }
            if (IdName.IsNullOrEmpty() == false)
            {
                list = list.Where(n => n.Parameter.Contains("id=\"" + IdName + "\"")).ToList();
            }

            List <string> txtList = new List <string>();

            foreach (var item in list)
            {
                txtList.AddRange(RawlerLib.Web.GetTagContentList(item.Inner, "<dt", "</dd>", true));
            }
            base.RunChildrenForArray(true, txtList);
        }