/// /// /// private async Task <List <Movimientos> > MovementCase1(ModelHistorialCompleto modelhistorial) { // searching only by date var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.serie == modelhistorial.serie.ToString()).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase32(ModelHistorialCompleto modelhistorial) { // searching only by USER var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.usuario == modelhistorial.usuario).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase16(ModelHistorialCompleto modelhistorial) { // searching only idproduct var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.IdProducto == modelhistorial.IdProducto).ToListAsync(); return(table); }
private async void OnFieldEventAsync(object sender) { try { ModelHistorialCompleto modelhistorial = (ModelHistorialCompleto)sender; List <Movimientos> lista = await controllerhistorial.Search(modelhistorial); //List<Movimientos> lista = await MovementCase2(modelhistorial); //finciono //List<Movimientos> lista = await ControllerHistorialCompleto.searching(modelhistorial); funciono if (lista.Count == 0) { await DisplayAlert("Buscando", "Producto no encontrado", "Aceptar"); } postListView.ItemsSource = lista; Console.WriteLine("testing queries"); } catch { } }
private async Task <List <Movimientos> > MovementCase25(ModelHistorialCompleto modelhistorial) { // searching only by idproduct and movement and date var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.IdProducto == modelhistorial.IdProducto). Where(u => u.lugar == modelhistorial.lugar).Where(u => u.serie == modelhistorial.serie.ToString()).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase14(ModelHistorialCompleto modelhistorial) { // searching only by movimiendo, producto y modelo var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.lugar == modelhistorial.lugar). Where(u => u.producto == modelhistorial.producto).Where(u => u.modelo == modelhistorial.modelo).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase2(ModelHistorialCompleto modelhistorial) { // searching only by model var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.modelo == modelhistorial.modelo).ToListAsync(); Console.WriteLine("executing"); return(table); }
private async Task <List <Movimientos> > MovementCase41(ModelHistorialCompleto modelhistorial) { // searching only by USER and movimiento and date var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.usuario == modelhistorial.usuario). Where(u => u.movimiento == modelhistorial.movimiento).Where(u => u.fecha == modelhistorial.fecha.ToString()).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase7(ModelHistorialCompleto modelhistorial) { // searching only by model and date, product var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.producto == modelhistorial.producto). Where(u => u.modelo == modelhistorial.modelo).Where(u => u.fecha == modelhistorial.fecha.ToString()).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase62(ModelHistorialCompleto modelhistorial) { // searching only by USER and idproduct and movement and product and model var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.usuario == modelhistorial.usuario). Where(u => u.IdProducto == modelhistorial.IdProducto).Where(u => u.lugar == modelhistorial.lugar). Where(u => u.producto == modelhistorial.producto).Where(u => u.modelo == modelhistorial.modelo).ToListAsync(); return(table); }
private async Task <List <Movimientos> > MovementCase63(ModelHistorialCompleto modelhistorial) { // searching by everithing, user,idproduct,movimiento, producto, id producto, date var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.usuario == modelhistorial.usuario). Where(u => u.IdProducto == modelhistorial.IdProducto).Where(u => u.lugar == modelhistorial.lugar). Where(u => u.producto == modelhistorial.producto).Where(u => u.modelo == modelhistorial.modelo). Where(u => u.serie == modelhistorial.serie.ToString()).ToListAsync(); return(table); }
//bisquedas dependiando de resultado public static async Task <List <Movimientos> > searching(ModelHistorialCompleto modelhistorial) { try { var table = await App.MobileService.GetTable <Movimientos>().Where(u => u.modelo == modelhistorial.modelo).ToListAsync(); return(table); } catch { return(null); } }
public FormFieldsHistorial() { InitializeComponent(); modelhistorial = new ModelHistorialCompleto(); }
public async Task <List <Movimientos> > Search(ModelHistorialCompleto modelhistorial) { /* * try { * * List<Movimientos> lista = await MovementCase2(modelhistorial); * return lista; * } * catch * { * return null; * } */ List <Movimientos> lista = new List <Movimientos>(); try { if (modelhistorial.QueryStatus == 1) { lista = await MovementCase1(modelhistorial); } if (modelhistorial.QueryStatus == 2) { lista = await MovementCase2(modelhistorial); } if (modelhistorial.QueryStatus == 3) { lista = await MovementCase3(modelhistorial); } if (modelhistorial.QueryStatus == 4) { lista = await MovementCase4(modelhistorial); } if (modelhistorial.QueryStatus == 5) { lista = await MovementCase5(modelhistorial); } if (modelhistorial.QueryStatus == 6) { lista = await MovementCase6(modelhistorial); } if (modelhistorial.QueryStatus == 7) { lista = await MovementCase7(modelhistorial); } if (modelhistorial.QueryStatus == 8) { lista = await MovementCase8(modelhistorial); } if (modelhistorial.QueryStatus == 9) { lista = await MovementCase9(modelhistorial); } if (modelhistorial.QueryStatus == 10) { lista = await MovementCase10(modelhistorial); } if (modelhistorial.QueryStatus == 11) { lista = await MovementCase11(modelhistorial); } if (modelhistorial.QueryStatus == 12) { lista = await MovementCase12(modelhistorial); } if (modelhistorial.QueryStatus == 13) { lista = await MovementCase13(modelhistorial); } if (modelhistorial.QueryStatus == 14) { lista = await MovementCase14(modelhistorial); } if (modelhistorial.QueryStatus == 15) { lista = await MovementCase15(modelhistorial); } if (modelhistorial.QueryStatus == 16) { lista = await MovementCase16(modelhistorial); } if (modelhistorial.QueryStatus == 17) { lista = await MovementCase17(modelhistorial); } if (modelhistorial.QueryStatus == 18) { lista = await MovementCase18(modelhistorial); } if (modelhistorial.QueryStatus == 19) { lista = await MovementCase19(modelhistorial); } if (modelhistorial.QueryStatus == 20) { lista = await MovementCase20(modelhistorial); } if (modelhistorial.QueryStatus == 21) { lista = await MovementCase21(modelhistorial); } if (modelhistorial.QueryStatus == 22) { lista = await MovementCase22(modelhistorial); } if (modelhistorial.QueryStatus == 23) { lista = await MovementCase23(modelhistorial); } if (modelhistorial.QueryStatus == 24) { lista = await MovementCase24(modelhistorial); } if (modelhistorial.QueryStatus == 25) { lista = await MovementCase25(modelhistorial); } if (modelhistorial.QueryStatus == 26) { lista = await MovementCase26(modelhistorial); } if (modelhistorial.QueryStatus == 27) { lista = await MovementCase27(modelhistorial); } if (modelhistorial.QueryStatus == 28) { lista = await MovementCase28(modelhistorial); } if (modelhistorial.QueryStatus == 29) { lista = await MovementCase29(modelhistorial); } if (modelhistorial.QueryStatus == 30) { lista = await MovementCase30(modelhistorial); } if (modelhistorial.QueryStatus == 31) { lista = await MovementCase31(modelhistorial); } if (modelhistorial.QueryStatus == 32) { lista = await MovementCase32(modelhistorial); } if (modelhistorial.QueryStatus == 33) { lista = await MovementCase33(modelhistorial); } if (modelhistorial.QueryStatus == 34) { lista = await MovementCase34(modelhistorial); } if (modelhistorial.QueryStatus == 35) { lista = await MovementCase35(modelhistorial); } if (modelhistorial.QueryStatus == 36) { lista = await MovementCase36(modelhistorial); } if (modelhistorial.QueryStatus == 37) { lista = await MovementCase37(modelhistorial); } if (modelhistorial.QueryStatus == 38) { lista = await MovementCase38(modelhistorial); } if (modelhistorial.QueryStatus == 39) { lista = await MovementCase39(modelhistorial); } if (modelhistorial.QueryStatus == 40) { lista = await MovementCase40(modelhistorial); } if (modelhistorial.QueryStatus == 41) { lista = await MovementCase41(modelhistorial); } if (modelhistorial.QueryStatus == 42) { lista = await MovementCase42(modelhistorial); } if (modelhistorial.QueryStatus == 43) { lista = await MovementCase43(modelhistorial); } if (modelhistorial.QueryStatus == 44) { lista = await MovementCase44(modelhistorial); } if (modelhistorial.QueryStatus == 45) { lista = await MovementCase45(modelhistorial); } if (modelhistorial.QueryStatus == 46) { lista = await MovementCase46(modelhistorial); } if (modelhistorial.QueryStatus == 47) { lista = await MovementCase47(modelhistorial); } if (modelhistorial.QueryStatus == 48) { lista = await MovementCase48(modelhistorial); } if (modelhistorial.QueryStatus == 49) { lista = await MovementCase49(modelhistorial); } if (modelhistorial.QueryStatus == 50) { lista = await MovementCase50(modelhistorial); } if (modelhistorial.QueryStatus == 51) { lista = await MovementCase51(modelhistorial); } if (modelhistorial.QueryStatus == 52) { lista = await MovementCase52(modelhistorial); } if (modelhistorial.QueryStatus == 53) { lista = await MovementCase53(modelhistorial); } if (modelhistorial.QueryStatus == 54) { lista = await MovementCase54(modelhistorial); } if (modelhistorial.QueryStatus == 55) { lista = await MovementCase55(modelhistorial); } if (modelhistorial.QueryStatus == 56) { lista = await MovementCase56(modelhistorial); } if (modelhistorial.QueryStatus == 57) { lista = await MovementCase57(modelhistorial); } if (modelhistorial.QueryStatus == 58) { lista = await MovementCase58(modelhistorial); } if (modelhistorial.QueryStatus == 59) { lista = await MovementCase59(modelhistorial); } if (modelhistorial.QueryStatus == 60) { lista = await MovementCase60(modelhistorial); } if (modelhistorial.QueryStatus == 61) { lista = await MovementCase61(modelhistorial); } if (modelhistorial.QueryStatus == 62) { lista = await MovementCase62(modelhistorial); } if (modelhistorial.QueryStatus == 63) { lista = await MovementCase63(modelhistorial); } return(lista); } catch { return(null); } }