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); }
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)); }
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)); }
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)); }
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)); }
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"); }
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)); }
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); }
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."); }
//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); }
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; }
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)); }
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); }
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; }
public CinarDataReader(List<Hashtable> list, ListSelect fieldNames, List<Type> fieldTypes) { this.currentIndex = -1; this.list = list; this.fieldNames = fieldNames; this.fieldTypes = fieldTypes; }
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; }
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; }
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; }
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); }
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; } }
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; }
internal List<Hashtable> GetData(Context context, Expression where, ListSelect fieldNames) { List<Hashtable> list = getFileList(context, where, fieldNames, path); return list; }
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; }
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(); } } }