public ListSelect getPage(SearchModel model)
        {
            ListSelect list = new ListSelect();
            var        data = _context.Blog.Include(x => x.IdSanPhamNavigation).ToList();

            if (!String.IsNullOrEmpty(model.sSearch))
            {
                data = data.Where(x => x.TieuDe.ToLower().Contains(model.sSearch.ToLower()) ||
                                  x.IdSanPhamNavigation.Ten.ToLower().Contains(model.sSearch.ToLower())).ToList();
            }
            list.total = data.Count;
            data       = data.OrderBy(x => x.ThoiGianTao).Skip(model.pageIndex * model.pageSize).Take(model.pageSize).ToList();
            list.List  = data.Select(x => new
            {
                Id             = x.Id,
                TieuDe         = x.TieuDe,
                TieuDeKhongDau = x.TieuDeKhongDau,
                //NoiDung = x.NoiDung,
                Link        = x.Link,
                Active      = x.Active,
                ThoiGianTao = x.ThoiGianTao,
                SanPham     = x.IdSanPhamNavigation != null ? x.IdSanPhamNavigation.Ten : ""
            });
            return(list);
        }
Exemple #2
0
        public async Task <ActionResult> getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.CmtuDien.Include(x => x.LoaiTuDien).ToListAsync();

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                search.sSearch = search.sSearch.ToLower();
                data           = data.Where(x => x.Ten.ToLower().Contains(search.sSearch)).ToList();
            }
            if (search.LoaiTuDienId != null)
            {
                data = data.Where(x => x.LoaiTuDienId == search.LoaiTuDienId).ToList();
            }
            listData.total = data.Count();
            data           = data.Skip((search.pageIndex - 1) * search.pageSize).Take(search.pageSize).OrderBy(x => x.LoaiTuDienId).ToList();
            listData.List  = data.Select(x => new TuDienModel
            {
                Id           = x.Id,
                TenNgan      = x.TenNgan,
                Ten          = x.Ten,
                MaTuDien     = x.MaTuDien,
                GhiChu       = x.GhiChu,
                Active       = x.Active.Value,
                UuTien       = x.UuTien.Value,
                LoaiTuDien   = x.LoaiTuDien.Ten,
                LoaiTuDienId = x.LoaiTuDien.Id
            });
            return(Ok(listData));
        }
Exemple #3
0
        public async Task <ActionResult> getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.DmtinhThanh.ToListAsync();

            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            var query = from ltt in data
                        select ltt;

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                search.sSearch = search.sSearch.ToLower();
                query          = query.Where(x => x.Ten.ToLower().Contains(search.sSearch));
            }

            listData.List = query.Select(x => new DmtinhThanh {
                Id                        = x.Id,
                Active                    = x.Active,
                IdLoaiTinhThanh           = x.IdLoaiTinhThanh,
                MoTa                      = x.MoTa,
                ParentId                  = x.ParentId,
                Ten                       = x.Ten,
                UuTien                    = x.UuTien,
                Parent                    = _context.DmtinhThanh.Find(x.ParentId),
                IdLoaiTinhThanhNavigation = _context.CmtuDien.Find(x.IdLoaiTinhThanh)
            });
            return(Ok(listData));
        }
Exemple #4
0
        public async Task <ActionResult> getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.CMTuDiens.ToListAsync();

            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            var query = from td in data
                        join ltd in _context.CMLoaiTuDiens on td.CMLoaiTuDien.Id equals ltd.Id
                        select(td, ltd);

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                search.sSearch = search.sSearch.ToLower();
                query          = query.Where(x => x.td.Ten.ToLower().Contains(search.sSearch));
            }

            listData.List = query.Select(x => new TuDienModel
            {
                Id         = x.td.Id,
                TenNgan    = x.td.TenNgan,
                Ten        = x.td.Ten,
                MaTuDien   = x.td.MaTuDien,
                GhiChu     = x.td.GhiChu,
                Active     = x.td.Active,
                UuTien     = x.td.UuTien,
                LoaiTuDien = x.ltd.Ten
            });
            return(Ok(listData));
        }
        public async Task <ActionResult> getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.DmcauHinh.ToListAsync();

            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            var query = from ltt in data
                        join cm in _context.CmtuDien on ltt.LoaiCauHinhId equals cm.Id
                        select(ltt, cm);

            //if (!String.IsNullOrEmpty(search.sSearch))
            //{
            //    search.sSearch = search.sSearch.ToLower();
            //    query = query.Where(x => x.Ten.ToLower().Contains(search.sSearch));
            //}

            listData.List = query.Select(x => new DmcauHinh
            {
                Id              = x.ltt.Id,
                Ten             = x.ltt.Ten,
                Code            = x.ltt.Code,
                ManHinh         = x.ltt.ManHinh,
                Cpu             = x.ltt.Cpu,
                Pin             = x.ltt.Pin,
                Mota            = x.ltt.Mota,
                Ngaysx          = x.ltt.Ngaysx,
                Ram             = x.ltt.Ram,
                ThoiGianBaoHanh = x.ltt.ThoiGianBaoHanh,
                Dungluong       = x.ltt.Dungluong,
                LoaiCauHinhId   = x.ltt.LoaiCauHinhId,
                LoaiCauHinh     = x.cm
            });
            return(Ok(listData));
        }
Exemple #6
0
        public ListSelect getPage(SearchModel search)
        {
            var data = _context.Htmenu.ToList();

            if (search.sSearch != "")
            {
                data = data.Where(x => x.Ten.ToLower().Contains(search.sSearch.ToLower())).OrderBy(x => x.IdParent).ToList();
            }

            ListSelect list = new ListSelect();

            list.total = data.Count;
            data       = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            list.List  = data.Select(x => new {
                Id         = x.Id,
                Ten        = x.Ten,
                Icon       = x.Icon,
                IsParent   = x.IsParent,
                Link       = x.Link,
                MoTa       = x.Mota,
                Controller = x.Controller,
                IdParent   = x.IdParent,
                Cha        = x.IdParent != null ? _context.Htmenu.Find(x.IdParent).Ten : null
            }).OrderBy(x => x.IdParent);
            return(list);
        }
        public async Task <ActionResult> getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.DmnhaCungCap.ToListAsync();

            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            var query = from ltt in data
                        select ltt;

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                search.sSearch = search.sSearch.ToLower();
                query          = query.Where(x => x.Ten.ToLower().Contains(search.sSearch));
            }

            listData.List = query.Select(x => new DmnhaCungCap
            {
                Id     = x.Id,
                Active = x.Active,
                DiaChi = x.DiaChi,
                Mota   = x.Mota,
                Sdt    = x.Sdt,
                Ten    = x.Ten,
            });
            return(Ok(listData));
        }
Exemple #8
0
 public void PlayItems()
 {
     ListSelect.ClearItems();
     ListSelect.AddItem("Generate World", "Create a new world from scratch!");
     ListSelect.AddItem("Load World", "Load a continent from an existing file!");
     ListSelect.AddItem("Debug World", "Create a debug world");
     ListSelect.AddItem("Back", "Back to the Main Menu");
 }
Exemple #9
0
 public void DebugWorldItems()
 {
     ListSelect.ClearItems();
     ListSelect.AddItem("Hills World", "Create a hilly (Debug) world.");
     ListSelect.AddItem("Cliffs World", "Create a cliff-y (Debug) world.");
     ListSelect.AddItem("Flat World", "Create a flat (Debug) world.");
     ListSelect.AddItem("Ocean World", "Create an ocean (Debug) world.");
     ListSelect.AddItem("Back", "Back to the Main Menu");
 }
        public async Task <ActionResult <ListSelect> > showPageDanhMuc(SearchModel search)
        {
            if (search.GiaTu == null)
            {
                search.GiaTu = 0;
            }
            if (search.GiaDen == null)
            {
                search.GiaDen = 0;
            }
            ListSelect listData = new ListSelect();
            var        data     = await _context.DmsanPham.Include(x => x.LoaiSp).Include(x => x.CauHinh).Include(x => x.HangSx).ToListAsync();

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                data = data.Where(x => x.Ten.ToLower().Contains(search.sSearch.ToLower()) || x.HangSx.Ten.ToLower().Contains(search.sSearch.ToLower())).ToList();
            }
            if (!String.IsNullOrEmpty(search.LoaiSP))
            {
                data = data.Where(x => x.LoaiSp.MaTuDien.Equals(search.LoaiSP)).ToList();
            }
            if (!String.IsNullOrEmpty(search.HangSX))
            {
                data = data.Where(x => x.HangSx.MaTuDien.Equals(search.HangSX)).ToList();
            }
            if (search.GiaTu != 0 && search.GiaDen != 0)
            {
                data = data.Where(x => x.GiaMacDinh >= search.GiaTu && x.GiaMacDinh <= search.GiaDen).ToList();
            }
            if (!String.IsNullOrEmpty(search.Ram))
            {
                data = data.Where(x => x.CauHinh.Ram.Contains(search.Ram)).ToList();
            }
            if (!String.IsNullOrEmpty(search.DungLuong))
            {
                data = data.Where(x => x.CauHinh.Dungluong.Contains(search.DungLuong)).ToList();
            }
            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            listData.List  = data.Select(x => new
            {
                x.Id,
                x.Ten,
                x.GiaMacDinh,
                x.ImageUrl,
                x.MoTa,
                x.Rate,
                x.ViewCount,
                x.KhuyenMai,
                Ram       = x.CauHinh != null ? x.CauHinh.Ram : "",
                ManHinh   = x.CauHinh != null ? x.CauHinh.ManHinh : "",
                Dungluong = x.CauHinh != null ? x.CauHinh.Dungluong : "",
                Cpu       = x.CauHinh != null ? x.CauHinh.Cpu : ""
            });
            return(Ok(listData));
        }
Exemple #11
0
        public ListSelect getPage(string Search, int PageIndex, int PageSize)
        {
            ListSelect list = new ListSelect();
            var        data = _context.Dmkho.ToList();

            if (!String.IsNullOrEmpty(Search))
            {
                data = data.Where(x => x.Ten.ToLower().Contains(Search)).ToList();
            }
            list.total = data.Count;
            list.List  = data.OrderBy(x => x.Ten).Skip((PageIndex) * PageSize).Take(PageSize).ToList();
            return(list);
        }
Exemple #12
0
        public void DefaultItems()
        {
            ListSelect.ClearItems();

            if (IsGameRunning)
            {
                ListSelect.AddItem("Continue Game", "Keep playing DwarfCorp");
            }

            ListSelect.AddItem("New Game", "Start a new game of DwarfCorp.");
            ListSelect.AddItem("Load Game", "Load DwarfCorp game from a file.");
            ListSelect.AddItem("Options", "Change game settings.");
            ListSelect.AddItem("Quit", "Exit the game.");
        }
Exemple #13
0
    //public static ListSelect GetList()
    //{
    //    CtrTipo_Ejercicio objCtrTipo_Ejercicio = new CtrTipo_Ejercicio();
    //    var Tipoejercicio = objCtrTipo_Ejercicio.CargaDatosTEjercicio();
    //    CtrEjercicio objCtrEjercicio = new CtrEjercicio();
    //    var ejercicio = objCtrEjercicio.CargaDatosEjercicio();
    //    var a = ejercicio.AsEnumerable().ToList();
    //    List<DtoTipo_Ejercicio> listTipoEjercicio = Tipoejercicio.AsEnumerable().Select(m => new DtoTipo_Ejercicio()
    //    {
    //        PK_ITE_Cod = Convert.ToInt32(m.ItemArray[0]),
    //        VTE_Nombre = m.ItemArray[1].ToString()
    //    }).ToList();
    //    List<DtoEjercicio> listEjercicio = ejercicio.AsEnumerable().Select(m => new DtoEjercicio()
    //    {
    //        PK_IE_Cod = Convert.ToInt32(m.ItemArray[0]),
    //        FK_ITE_Cod = Convert.ToInt32(m.ItemArray[2]),
    //        VE_Nombre = m.ItemArray[1].ToString(),
    //    }).ToList();
    //    var list = new ListSelect();
    //    list.dtoEjercicios = listEjercicio;
    //    list.dtoTipoEjercicios = listTipoEjercicio;
    //    return list;
    //}
    //[System.Web.Services.WebMethod]
    public static ListSelect GetEjercicioByTipoEjercicio(int idTipoUsuario)
    {
        CtrEjercicio        objCtrEjercicio = new CtrEjercicio();
        var                 ejercicio       = objCtrEjercicio.CargaDatosEjercicioXT(idTipoUsuario);
        List <DtoEjercicio> listEjercicio   = ejercicio.AsEnumerable().Select(m => new DtoEjercicio()
        {
            PK_IE_Cod  = Convert.ToInt32(m.ItemArray[0]),
            FK_ITE_Cod = Convert.ToInt32(m.ItemArray[2]),
            VE_Nombre  = m.ItemArray[1].ToString(),
        }).ToList();
        var list = new ListSelect();

        list.dtoEjercicios = listEjercicio;
        return(list);
    }
Exemple #14
0
        internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = new List<Hashtable>();

            foreach (FBPost item in GetData())
            {
                if (item.Filter(context, where))
                {
                    Hashtable ht = new Hashtable();
                    foreach (Select field in fieldNames)
                        ht[field.Alias] = field.Field.Calculate(context);
                    list.Add(ht);
                }
            }

            return list;
        }
Exemple #15
0
        public ActionResult GetOptionByHang(string MaHang, int PageIndex, int PageSize)
        {
            ListSelect listData = new ListSelect();
            var        data     = _context.OptionSanPham.ToList();
            var        query    = from o in data
                                  join s in _context.DmsanPham on o.SanPhamId equals s.Id
                                  join ch in _context.DmcauHinh on s.CauHinhId equals ch.Id
                                  join cm in _context.CmtuDien on s.HangSxid equals cm.Id
                                  where s.Active == true && (MaHang == null || cm.MaTuDien.Equals(MaHang))
                                  group o by new
            {
                o.SanPhamId,
                s.ImageUrl,
                s.Ten,
                s.Rate,
                s.GiaMacDinh,
                s.ViewCount,
                cm.TenNgan,
                ch.Dungluong,
                ch.Ram,
                ch.ManHinh,
                ch.Cpu
            } into gcs
            select(gcs);

            listData.total = query.Count();
            listData.List  = query.Select(x => new ViewSanPhamModel
            {
                Id        = x.Key.SanPhamId.Value,
                Ten       = x.Key.Ten,
                ImageUrl  = x.Key.ImageUrl,
                Rate      = x.Key.Rate.Value,
                ViewCount = x.Key.ViewCount.Value,
                Hang      = x.Key.TenNgan,
                Gia       = x.Key.GiaMacDinh,
                DungLuong = x.Key.Dungluong,
                Cpu       = x.Key.Cpu,
                ManHinh   = x.Key.ManHinh,
                Ram       = x.Key.Ram
            }).Skip((PageIndex - 1) * PageSize).Take(PageSize);
            return(Ok(listData.List));
        }
        public async Task <ActionResult <ListSelect> > getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.DmsanPham.Include(ch => ch.CauHinh).ToListAsync();

            if (search.sSearch.IsNotNullOrEmpty())
            {
                data = data.Where(x => x.Ten.ToLower().Contains(search.sSearch.ToLower())).ToList();
            }
            if (search.IdLoaiSanPham != null)
            {
                data = data.Where(x => x.LoaiSpid == search.IdLoaiSanPham).ToList();
            }
            if (search.IdHangSanXuat != null)
            {
                data = data.Where(x => x.HangSxid == search.IdHangSanXuat).ToList();
            }
            if (search.GiaTu != 0)
            {
                data = data.Where(x => x.GiaMacDinh >= search.GiaTu).ToList();
            }
            if (search.GiaDen != 0)
            {
                data = data.Where(x => x.GiaMacDinh <= search.GiaDen).ToList();
            }
            if (search.Active.IsNotNullOrEmpty() && search.Active != "2")
            {
                if (search.Active == "1")
                {
                    data = data.Where(x => x.Active == true).ToList();
                }
                else
                {
                    data = data.Where(x => x.Active == false).ToList();
                }
            }
            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            listData.List  = data;
            return(Ok(listData));
        }
Exemple #17
0
 private void button3_Click(object sender, EventArgs e)
 {
     if (ListSelect.SelectedIndex != -1)
     {
         ListAvailable.Items.Add(ListSelect.SelectedItem.ToString());
         int I = ListSelect.SelectedIndex;
         ListSelect.Items.RemoveAt(I);
         ListSelect.Focus();
         if (ListSelect.Items.Count > 0)
         {
             if (I < ListSelect.Items.Count)
             {
                 ListSelect.SetSelected(I, true);
             }
             else
             {
                 ListSelect.SetSelected(0, true);
             }
         }
     }
 }
        public async Task <ActionResult> ShowPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.Htuser.ToListAsync();

            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();

            var query = from td in data
                        join ur in _context.HtuserRole on td.Id equals ur.UserId
                        join rl in _context.Htrole on ur.RoleId equals rl.Id
                        where (search.RoleId is null || ur.RoleId.Equals(search.RoleId.Value))
                        select(td, rl);

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                search.sSearch = search.sSearch.ToLower();
                query          = query.Where(x => x.td.HoTen.ToLower().Contains(search.sSearch)).ToList();
            }
            listData.List = query.Select(x => new MyProfileModel
            {
                Id          = x.td.Id,
                DiaChi      = x.td.DiaChi,
                Email       = x.td.Email,
                HoTen       = x.td.HoTen,
                SoDienThoai = x.td.SoDienThoai,
                TenKhongDau = x.td.TenKhongDau,
                NgaySinh    = x.td.NgaySinh.GetValueOrDefault(),
                Username    = x.td.Username,
                GioiThieu   = x.td.GioiThieu,
                Role        = x.rl.Ten,
                RoleId      = x.rl.Id,
                Code        = x.rl.Code,
            }).ToList();
            return(Ok(listData));
        }
        public async Task <ActionResult> getPage(SearchModel search)
        {
            ListSelect listData = new ListSelect();
            var        data     = await _context.CmloaiTuDien.ToListAsync();

            listData.total = data.Count();
            data           = data.Skip((search.pageIndex) * search.pageSize).Take(search.pageSize).ToList();
            var query = from ltt in data
                        select ltt;

            if (!String.IsNullOrEmpty(search.sSearch))
            {
                search.sSearch = search.sSearch.ToLower();
                query          = query.Where(x => x.Ten.ToLower().Contains(search.sSearch) || x.MaLoai.Contains(search.sSearch));
            }

            listData.List = query.Select(x => new LoaiTuDienModel
            {
                Id     = x.Id,
                MaLoai = x.MaLoai,
                Ten    = x.Ten
            });
            return(Ok(listData));
        }
        public ListSelect getthongso(SearchModel model)
        {
            ListSelect list = new ListSelect();
            var        data = _context.DmsanPham.Include(x => x.LoaiSp).ToList();;

            if (!String.IsNullOrEmpty(model.sSearch))
            {
                data = data.Where(x => x.Ten.ToLower().Contains(model.sSearch.ToLower())).ToList();
            }
            if (model.IdLoaiSanPham != null)
            {
                data = data.Where(x => x.LoaiSpid == model.IdLoaiSanPham).ToList();
            }
            list.total = data.Count;
            data       = data.OrderBy(x => x.ThoiGianTao).Skip(model.pageIndex * model.pageSize).Take(model.pageSize).ToList();
            list.List  = data.Select(x => new
            {
                Id             = x.Id,
                Ten            = x.Ten,
                ThongSoKyThuat = x.ThongSoKyThuat,
                LoaiSP         = x.LoaiSp.Ten
            });
            return(list);
        }
Exemple #21
0
        private List<Hashtable> getColumnsOf(Type type, string tableName, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = new List<Hashtable>();
            foreach (PropertyInfo pi in type.GetProperties())
            {
                if (pi.PropertyType == typeof(string) || pi.PropertyType.IsValueType || pi.PropertyType==typeof(byte[]))
                {
                    if (pi.PropertyType.IsEnum) continue;

                    Variables["COLUMN_DEFAULT"] = "";
                    Variables["DATA_TYPE"] = pi.PropertyType.Name;
                    Variables["COLUMN_TYPE"] = pi.PropertyType.Name;
                    Variables["CHARACTER_MAXIMUM_LENGTH"] = 65532;
                    Variables["IS_NULLABLE"] = false;
                    Variables["COLUMN_NAME"] = pi.Name;
                    Variables["IS_AUTO_INCREMENT"] = false;
                    Variables["TABLE_NAME"] = tableName;

                    if (where==null || (bool)where.Calculate(this))
                    {
                        Hashtable ht = new Hashtable();
                        foreach (Select field in fieldNames)
                            ht[field.Alias] = field.Field.Calculate(this);//Variables[fieldName];
                        list.Add(ht);
                    }
                }
            }

            return list;
        }
Exemple #22
0
 public CinarDataReader(List<Hashtable> list, ListSelect fieldNames, List<Type> fieldTypes)
 {
     this.currentIndex = -1;
     this.list = list;
     this.fieldNames = fieldNames;
     this.fieldTypes = fieldTypes;
 }
Exemple #23
0
        internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = new List<Hashtable>();

            var client = new Pop3Client(userName, password, server);
            client.OpenInbox();
            while (client.NextEmail())
            {
                POP3Item item = new POP3Item(client.ReadAsMailMessage());
                if (item.Filter(context, where))
                {
                    Hashtable ht = new Hashtable();
                    foreach (Select field in fieldNames)
                        ht[field.Alias] = field.Field.Calculate(context);//context.Variables[fieldName];
                    list.Add(ht);
                }
            }
            client.CloseConnection();

            return list;
        }
Exemple #24
0
        internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames)
        {
            List<SocialMediaItem> items = new List<SocialMediaItem>();

            if (source == "All" || source.IndexOf("Facebook", StringComparison.InvariantCultureIgnoreCase) > -1)
                foreach (FBPost item in new FacebookProvider(query).GetData())
                    items.Add(new SocialMediaItem(item));
            if (source == "All" || source.IndexOf("Twitter", StringComparison.InvariantCultureIgnoreCase) > -1)
                foreach (Tweet item in new TwitterProvider(query, lang, page).GetData())
                    items.Add(new SocialMediaItem(item));
            if (source == "All" || source.IndexOf("Youtube", StringComparison.InvariantCultureIgnoreCase) > -1)
                foreach (RSSItem item in new YoutubeProvider(query).GetData())
                    items.Add(new SocialMediaItem(item));
            if (source == "All" || source.IndexOf("FriendFeed", StringComparison.InvariantCultureIgnoreCase) > -1)
                foreach (FriendFeedItem item in new FriendFeedProvider(query, lang).GetData())
                    items.Add(new SocialMediaItem(item));
            if (source == "All" || source.IndexOf("DailyMotion", StringComparison.InvariantCultureIgnoreCase) > -1)
                foreach (DailyMotionItem item in new DailyMotionProvider(query, lang).GetData())
                    items.Add(new SocialMediaItem(item));

            List<Hashtable> list = new List<Hashtable>();

            foreach (SocialMediaItem item in items)
            {
                if (item.Filter(context, where))
                {
                    Hashtable ht = new Hashtable();
                    foreach (Select field in fieldNames)
                        ht[field.Alias] = field.Field.Calculate(context);
                    list.Add(ht);
                }
            }

            return list;
        }
Exemple #25
0
        internal List<Hashtable> GetData(Join join, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = new List<Hashtable>();

            switch (join.TableName.ToLowerInvariant())
            {
                case "information_schema.tables":
                    {
                        list.Add(new Hashtable() { { "table_name", "Rss" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "Pop3" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "File" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "Facebook" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "Twitter" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "Youtube" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "SocialMedia" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "Yahoo" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "FriendFeed" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "DailyMotion" }, { "table_type", "table" } });
                        list.Add(new Hashtable() { { "table_name", "CSV" }, { "table_type", "table" } });
                        break;
                    }
                case "information_schema.columns":
                    {
                        list.AddRange(getColumnsOf(typeof(RSSItem), "Rss", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(POP3Item), "Pop3", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(FileItem), "File", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(FBPost), "Facebook", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(Tweet), "Twitter", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(RSSItem), "Youtube", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(SocialMediaItem), "SocialMedia", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(YahooResultItem), "Yahoo", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(FriendFeedItem), "FriendFeed", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(DailyMotionItem), "DailyMotion", where, fieldNames));
                        list.AddRange(getColumnsOf(typeof(CSVItem), "CSV", where, fieldNames));
                        break;
                    }
                case "file":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Path") || !join.CinarTableOptions.ContainsKey("Recursive"))
                            throw new Exception("Provide file path. Exp: select .. from FILE(Path='c:\\...', Recursive=false)");
                        string path = Convert.ToString(join.CinarTableOptions["Path"].Calculate(this));
                        bool recursive = Convert.ToBoolean(join.CinarTableOptions["Recursive"].Calculate(this));
                        FileProvider fileProvider = new FileProvider(path, recursive);
                        list.AddRange(fileProvider.GetData(this, where, fieldNames));
                        break;
                    }
                case "pop3":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Server") || !join.CinarTableOptions.ContainsKey("UserName") || !join.CinarTableOptions.ContainsKey("Password"))
                            throw new Exception("Provide mail settings. Exp: select .. from POP3(Server='', UserName='', Password='')");
                        string server = (string)join.CinarTableOptions["Server"].Calculate(this);
                        string userName = (string)join.CinarTableOptions["UserName"].Calculate(this);
                        string password = (string)join.CinarTableOptions["Password"].Calculate(this);
                        POP3Provider pop3Provider = new POP3Provider(server, userName, password);
                        list.AddRange(pop3Provider.GetData(this, where, fieldNames));
                        break;
                    }
                case "rss":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Url"))
                            throw new Exception("Provide url. Exp: select .. from RSS(Url='http://...')");
                        string url = (string)join.CinarTableOptions["Url"].Calculate(this);
                        RSSProvider rssProvider = new RSSProvider(url);
                        list.AddRange(rssProvider.GetData(this, where, fieldNames));
                        break;
                    }
                case "facebook":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Query"))
                            throw new Exception("Provide query. Exp: select .. from Facebook(Query='...')");
                        string query = (string)join.CinarTableOptions["Query"].Calculate(this);
                        FacebookProvider fbProvider = new FacebookProvider(query);
                        list.AddRange(fbProvider.GetData(this, where, fieldNames));
                        break;
                    }
                case "twitter":
                    {
                        string query2 = "", lang = "";
                        int page = 1;
                        if (join.CinarTableOptions.ContainsKey("Query"))
                        {
                            query2 = (string)join.CinarTableOptions["Query"].Calculate(this);
                            if (join.CinarTableOptions.ContainsKey("Lang"))
                                lang = (string)join.CinarTableOptions["Lang"].Calculate(this);
                            if (join.CinarTableOptions.ContainsKey("Page"))
                                page = Convert.ToInt32(join.CinarTableOptions["Page"].Calculate(this));
                            TwitterProvider twProvider = new TwitterProvider(query2, lang, page);
                            list.AddRange(twProvider.GetData(this, where, fieldNames));
                        }
                        else
                            throw new Exception("Provide query. Exp: select .. from Twitter(Query='...' [, Lang='tr'] [, Page=1])");
                        break;
                    }
                case "youtube":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Query"))
                            throw new Exception("Provide query. Exp: select .. from Youtube(Query='...')");
                        string query = (string)join.CinarTableOptions["Query"].Calculate(this);
                        YoutubeProvider ytProvider = new YoutubeProvider(query);
                        list.AddRange(ytProvider.GetData(this, where, fieldNames));
                        break;
                    }
                case "socialmedia":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Query"))
                            throw new Exception("Provide query. Exp: select .. from SocialMedia(Query='...' [, Lang='tr'] [, Source='Twitter,Facebook'] [, Page=1])");
                        string query = (string)join.CinarTableOptions["Query"].Calculate(this);
                        string lang = "";
                        if (join.CinarTableOptions.ContainsKey("Lang"))
                            lang = (string)join.CinarTableOptions["Lang"].Calculate(this);
                        string source = "All";
                        if (join.CinarTableOptions.ContainsKey("Source"))
                            source = (string)join.CinarTableOptions["Source"].Calculate(this);
                        int page = 1;
                        if (join.CinarTableOptions.ContainsKey("Page"))
                            page = Convert.ToInt32(join.CinarTableOptions["Page"].Calculate(this));
                        SocialMediaProvider provider = new SocialMediaProvider(query, lang, page, source);
                        list.AddRange(provider.GetData(this, where, fieldNames));
                        break;
                    }
                case "yahoo":
                    {
                        string query2 = "";
                        if (join.CinarTableOptions.ContainsKey("Query"))
                        {
                            query2 = (string)join.CinarTableOptions["Query"].Calculate(this);
                            YahooBossProvider twProvider = new YahooBossProvider(query2);
                            list.AddRange(twProvider.GetData(this, where, fieldNames));
                        }
                        else
                            throw new Exception("Provide query. Exp: select .. from Yahoo(Query='...')");
                        break;
                    }
                case "friendfeed":
                    {
                        string query2 = "";
                        if (join.CinarTableOptions.ContainsKey("Query"))
                        {
                            query2 = (string)join.CinarTableOptions["Query"].Calculate(this);
                            FriendFeedProvider twProvider = new FriendFeedProvider(query2, "");
                            list.AddRange(twProvider.GetData(this, where, fieldNames));
                        }
                        else
                            throw new Exception("Provide query. Exp: select .. from Yahoo(Query='...')");
                        break;
                    }
                case "dailymotion":
                    {
                        string query2 = "", lang = "";
                        if (join.CinarTableOptions.ContainsKey("Query"))
                        {
                            query2 = (string)join.CinarTableOptions["Query"].Calculate(this);
                            if (join.CinarTableOptions.ContainsKey("Lang"))
                                lang = (string)join.CinarTableOptions["Lang"].Calculate(this);
                            DailyMotionProvider twProvider = new DailyMotionProvider(query2, lang);
                            list.AddRange(twProvider.GetData(this, where, fieldNames));
                        }
                        else
                            throw new Exception("Provide query. Exp: select .. from Twitter(Query='...')");
                        break;
                    }
                case "csv":
                    {
                        if (!join.CinarTableOptions.ContainsKey("Path") || !join.CinarTableOptions.ContainsKey("Seperator"))
                            throw new Exception("Provide file path. Exp: select .. from CSV(Path='c:\\...', Seperator=';')");
                        string path = Convert.ToString(join.CinarTableOptions["Path"].Calculate(this));
                        char seperator = Convert.ToChar(join.CinarTableOptions["Seperator"].Calculate(this));
                        CSVProvider csvProvider = new CSVProvider(path, seperator);
                        list.AddRange(csvProvider.GetData(this, where, fieldNames));
                        break;
                    }
            }

            return list;
        }
Exemple #26
0
        async Task <SearchResult> query_item_by_name()
        {
            string itemName = null;

            while (string.IsNullOrEmpty(itemName))
            {
                using (InputBox input = new InputBox("Please enter the item name", false))
                    if (input.ShowDialog(this) == DialogResult.OK)
                    {
                        itemName = input.Value;
                    }

                if (string.IsNullOrEmpty(itemName))
                {
                    if (MessageBox.Show("You must enter an item name to continue!", "Empty Name", MessageBoxButtons.OKCancel, MessageBoxIcon.Hand) == DialogResult.Cancel)
                    {
                        break;
                    }
                }
            }

            string selectedName = null;

            if (string.IsNullOrEmpty(itemName))
            {
                MessageBox.Show("You have entered an invalid item name!", "Invalid Item Name", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                List <SearchResult> searchResults = await queryDBForItems(itemName);

                if (searchResults.Count == 0)
                {
                    MessageBox.Show("Failed to query items from the database!", "SQL Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    List <string> resultNames = searchResults.Select(r => r.Name).ToList();

                    if (resultNames.Count == 0)
                    {
                        MessageBox.Show("Failed to query item names from search results!", "Result Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    else
                    {
                        using (ListSelect listSelect = new ListSelect("Please select an item", resultNames))
                            if (listSelect.ShowDialog(this) == DialogResult.OK)
                            {
                                selectedName = listSelect.SelectedText;
                            }

                        if (string.IsNullOrEmpty(selectedName))
                        {
                            MessageBox.Show("Invalid selected name!", "Invalid Selection", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        }
                        else
                        {
                            return(searchResults.Find(r => r.Name == selectedName));
                        }
                    }
                }
            }

            return(null);
        }
Exemple #27
0
        internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = new List<Hashtable>();

            SyndicationFeed s = new SyndicationFeed();
            using (XmlTextReader reader = new XmlTextReader(url))
            {
                SyndicationFeed client = SyndicationFeed.Load(reader);

                foreach (SyndicationItem rItem in client.Items)
                {
                    RSSItem item = new RSSItem(rItem);
                    if (item.Filter(context, where))
                    {
                        Hashtable ht = new Hashtable();
                        foreach (Select field in fieldNames)
                            ht[field.Alias] = field.Field.Calculate(context);//context.Variables[fieldName];
                        list.Add(ht);
                    }
                }

                return list;
            }
        }
Exemple #28
0
 private List<Hashtable> getFileList(Context context, Expression where, ListSelect fieldNames, string dirPath)
 {
     List<Hashtable> list = new List<Hashtable>();
     DirectoryInfo di = new DirectoryInfo(dirPath);
     foreach (FileSystemInfo fi in di.GetDirectories())
     {
         FileItem item = new FileItem(fi);
         if (item.Filter(context, where))
         {
             Hashtable ht = new Hashtable();
             foreach (Select field in fieldNames)
                 ht[field.Alias] = field.Field.Calculate(context);//context.Variables[fieldName];
             list.Add(ht);
             if (recursive)
                 list.AddRange(getFileList(context, where, fieldNames, fi.FullName));
         }
     }
     foreach (FileSystemInfo fi in di.GetFiles())
     {
         FileItem item = new FileItem(fi);
         if (item.Filter(context, where))
         {
             Hashtable ht = new Hashtable();
             foreach (Select field in fieldNames)
                 ht[field.Alias] = field.Field.Calculate(context);//context.Variables[fieldName];
             list.Add(ht);
         }
     }
     return list;
 }
Exemple #29
0
        internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = getFileList(context, where, fieldNames, path);

            return list;
        }
Exemple #30
0
        internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames)
        {
            List<Hashtable> list = new List<Hashtable>();

            foreach (CSVItem item in File.ReadAllText(path).Split('\n').Select(line => new CSVItem(line.Split(seperator))))
            {
                if (item.Filter(context, where))
                {
                    Hashtable ht = new Hashtable();
                    foreach (Select field in fieldNames)
                        ht[field.Alias] = field.Field.Calculate(context);//context.Variables[fieldName];
                    list.Add(ht);
                }
            }

            return list;
        }
Exemple #31
0
        private void execute(Statement statement, Context context)
        {
            if (statement is SelectStatement)
            {
                // Join'den tabloları al
                // her bir kayıt için hashtable oluştur, context'e ekle, where expressionı üzerinde excute ettir. true ise listeye ekle.
                // falan filan uzun iş bu. niye yapıyorum ki ben bunu?

                SelectStatement ss = statement as SelectStatement;
                Expression filter = null;
                if (ss.From[0].On == null && ss.Where == null) filter = null;
                else if (ss.From[0].On != null && ss.Where != null) filter = new AndExpression(ss.From[0].On, ss.Where);
                else if (ss.From[0].On != null) filter = ss.From[0].On;
                else filter = ss.Where;

                this.FieldNames = ss.Select;
                this.ResultSet = context.GetData(ss.From[0], filter, ss.Select);
                this.FieldTypes = new List<Type>();
                if (this.ResultSet.Count > 0)
                {
                    foreach (Select key in ss.Select)
                        if (this.ResultSet[0][key.Alias] != null)
                            this.FieldTypes.Add(this.ResultSet[0][key.Alias].GetType());
                        else
                            this.FieldTypes.Add(typeof(string));
                }
                if (ss.OrderBy.Count > 0)
                {
                    IOrderedEnumerable<Hashtable> orderedList = this.ResultSet.OrderBy(ht=>1);
                    for (int i = 0; i < ss.OrderBy.Count; i++)
                    {
                        object orderBy = null;
                        if (ss.OrderBy[i].By is IntegerConstant)
                            orderBy = ((IntegerConstant)ss.OrderBy[i].By).Value;
                        else
                            orderBy = ((DbObjectName)ss.OrderBy[i].By).Name;

                        if (orderBy.GetType() == typeof(int))
                        {
                            int fieldNo = (int)orderBy - 1;
                            if (!(fieldNo < 0 || fieldNo >= FieldNames.Count))
                            {
                                if (ss.OrderBy[i].Desc)
                                    orderedList = orderedList.ThenByDescending(ht => ht[FieldNames[(int)fieldNo].Alias]);
                                else
                                    orderedList = orderedList.ThenBy(ht => ht[FieldNames[(int)fieldNo].Alias]);
                            }
                        }
                        else
                        {
                            string alias = orderBy.ToString();
                            if (FieldNames.IndexOf(alias) > -1)
                            {
                                if (ss.OrderBy[i].Desc)
                                    orderedList = orderedList.ThenByDescending(ht => ht[alias]);
                                else
                                    orderedList = orderedList.ThenBy(ht => ht[alias]);
                            }
                        }
                    }
                    this.ResultSet = orderedList.ToList();
                }

                if (ss.Limit != null)
                {
                    int offset = ss.Offset == null ? 0 : Convert.ToInt32(ss.Offset.Calculate(context));
                    int limit = Convert.ToInt32(ss.Limit.Calculate(context));
                    this.ResultSet = this.ResultSet.Skip(offset).Take(limit).ToList();
                }
            }
        }