public async Task TotalCountBasics()
{
// Insert a few records
IMobileServiceTable <ToDo> table = GetClient().GetTable <ToDo>();
ToDo first = new ToDo {
Title = "ABC", Complete = false
};
await table.InsertAsync(first);
await table.InsertAsync(new ToDo { Title = "DEF", Complete = true });
await table.InsertAsync(new ToDo { Title = "GHI", Complete = false });
ITotalCountProvider countProvider = null;
IMobileServiceTableQuery <ToDo> query = table.Where(t => t.Id >= first.Id);
// Run a simple query and verify we get all 3 items, but the
// TotalCount is not provided.
List <ToDo> items = await query.ToListAsync();
countProvider = items as ITotalCountProvider;
Assert.AreEqual(3, items.Count);
Assert.IsNotNull(countProvider);
Assert.AreEqual(-1L, countProvider.TotalCount);
IEnumerable <ToDo> sequence = await query.ToEnumerableAsync();
countProvider = sequence as ITotalCountProvider;
Assert.IsNotNull(countProvider);
Assert.AreEqual(-1L, countProvider.TotalCount);
// Now use IncludeTotalCount and make sure we get the expected
// number of results
query = query.IncludeTotalCount();
items = await query.ToListAsync();
countProvider = items as ITotalCountProvider;
Assert.AreEqual(3, items.Count);
Assert.IsNotNull(countProvider);
Assert.AreEqual(3L, countProvider.TotalCount);
sequence = await query.ToEnumerableAsync();
countProvider = sequence as ITotalCountProvider;
Assert.IsNotNull(countProvider);
Assert.AreEqual(3L, countProvider.TotalCount);
// Verify that IncludeTotalCount is correctly propagated with
// projections
List <string> titles = await query.Select(t => t.Title).ToListAsync();
countProvider = titles as ITotalCountProvider;
Assert.AreEqual(3, titles.Count);
Assert.IsNotNull(countProvider);
Assert.AreEqual(3L, countProvider.TotalCount);
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <string> query = DataTable
.Where(ur => ur.ServiceProviderId == tempdata.Loginas)
.Select(ur => ur.QuotationSubject);
List <string> items = await query.ToListAsync();
SQuotationView.ItemsSource = items;
//finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
//----------------------------------------------------------------
IMobileServiceTableQuery <string> query2 = DataTable
.Where(ur => ur.ServiceProviderId == tempdata.received_quotationID)
.Select(ur => ur.QuotationSubject);
List <string> items2 = await query2.ToListAsync();
RQuotationView.ItemsSource = items2;
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <Quotation> query = DataTable
.Where(ur => ur.ServiceProviderId == tempdata.received_quotationID && ur.QuotationSubject == tempdata.selected_QuotationSubject);
// .Select(todoItem => todoItem.InvoiceSubject);
List <Quotation> items = await query.ToListAsync();
// EmployeeView.ItemsSource = items2;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
lb1.Text = string.Format("{0} :- {1}", "Subject", items[0].QuotationSubject);
lb2.Text = string.Format("{0} :- {1}", "Refference Id", items[0].RefferenceId);
lb6.Text = string.Format("{0} :- {1}", "WorkPlace", items[0].WorkPlace);
lb3.Text = string.Format("{0} :- {1}", "Job Description", items[0].JobDescription);
lb4.Text = string.Format("{0} :- {1}", "Estimated Service Fee", items[0].EstimatedServiceFee);
lb5.Text = string.Format("{0} :- {1}", "Estimated Other Fee", items[0].EstimatedOtherFee);
lb7.Text = string.Format("{0} :- {1}", "EstimatedTotal", items[0].EstimatedTotal);
lb8.Text = string.Format("{0} :- {1}", "Quotation Status", items[0].QuotationStatus);
tempdata.QuotationSubject = items[0].QuotationSubject;
tempdata.RefferenceId = items[0].RefferenceId;
tempdata.WorkPlace = items[0].WorkPlace;
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task <Users> GetUserInfo(string pass)
{
await Initialize();
try
{
await userTable.PullAsync("allUsers", userTable.CreateQuery());
IMobileServiceTableQuery <Users> query = userTable.Where(e => e.Password == pass);
var result = await query.ToListAsync();
var userDetails = result.FirstOrDefault();
return(userDetails);
} catch (NullReferenceException nre)
{
Debug.WriteLine("Error: " + nre.Message);
return(null);
} catch (ArgumentNullException nre)
{
Debug.WriteLine("Error: " + nre.Message);
return(null);
}
}
private async void GetReports()
{
//add Reports
//To Seed a report
//Report ds = new Report { Report_Id = 1, User_Id = 1, Customer_Id = 2, Equipment = "Laptop", Brand = "Lenovo", Accessories = "None", Description = "Malwayre", Finished = true, CompletedDate = "25/04/2016", Conclusion = "Cleaned Up", Cost = 20, Paid = true };
//await reportTbl.InsertAsync(ds);
IMobileServiceTableQuery <Report> query = reportTbl
.Where(cid => cid.Customer_Id == custId);
List <Report> reports = await query.ToListAsync();
foreach (var report in reports)
{
string rprt;
string status = "";
if (report.Finished == true)
{
status = "Complete";
}
else
{
status = "Un-Complete";
}
rprt = report.Report_Id + ". | " + report.Equipment + " | " + report.Brand + " | " + status;
lsbReports.Items.Add(rprt);
}
// lsbReports.ItemsSource = users;
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <UserReg> query = DataTable
.Where(ur => ur.Email == tempdata.Loginas);
// .Select(todoItem => todoItem.InvoiceSubject);
List <UserReg> items = await query.ToListAsync();
FirstName.Text = items[0].FirstName;
LastName.Text = items[0].LastName;
Email.Text = items[0].Email;
Address.Text = items[0].Address;
PhoneNumber.Text = items[0].PhoneNumber;
ServiceType.SelectedItem = Convert.ToString(items[0].ServiceType);
tempdata.uId2 = items[0].Id;
tempdata.pass = items[0].Password;
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
/*
*
* List<UserReg> items = await DataTable
* .Where(ur => ur.FirstName != null)
* .ToListAsync();
*
*
* //IEnumerable itemsControl = items;
* EmployeeView.ItemsSource = items;
*
*/
IMobileServiceTableQuery <string> query = DataTable
.Where(ur => ur.ServiceProvideId != tempdata.Loginas)
.Select(ur => ur.InvoiceSubject);
List <string> items2 = await query.ToListAsync();
EmployeeView.ItemsSource = items2;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
}
catch (Exception e) {
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <BankAcount> query = DataTable
.Where(ur => ur.ServiceProviderId == tempdata.Loginas && ur.AccountName == tempdata.selected_bankaccount);
// .Select(todoItem => todoItem.InvoiceSubject);
// EmployeeView.ItemsSource = items2;
List <BankAcount> items = await query.ToListAsync();
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
lb1.Text = string.Format("{0} :- {1}", "Account Name", items[0].AccountName);
lb2.Text = string.Format("{0} :- {1}", "Bank", items[0].Bank);
lb3.Text = string.Format("{0} :- {1}", "Branch", items[0].Branch);
lb4.Text = string.Format("{0} :- {1}", "Account Number", items[0].AccountNumber);
lb5.Text = string.Format("{0} :- {1}", "Other info", items[0].Info);
tempdata.uId = items[0].Id;
tempdata.uAccountName = items[0].AccountName;
tempdata.uBank = items[0].Bank;
tempdata.uBranch = items[0].Branch;
tempdata.uAccountNumber = items[0].AccountNumber;
tempdata.uInfo = items[0].Info;
}
catch (Exception e)
{
DisplayAlert("Erro", "connection lost", "Ok");
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <WorkOrder> query = DataTable
.Where(ur => ur.ServiceProviderID == tempdata.Loginas && ur.WorkOrderSubject == tempdata.selected_WorkOrderSubject);
// .Select(todoItem => todoItem.InvoiceSubject);
List <WorkOrder> items = await query.ToListAsync();
// EmployeeView.ItemsSource = items2;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
lb1.Text = string.Format("{0} :- {1}", "Subject", items[0].WorkOrderSubject);
lb2.Text = string.Format("{0} :- {1}", "DueDate", items[0].DueDate);
lb3.Text = string.Format("{0} :- {1}", "Workplace", items[0].Workplace);
lb4.Text = string.Format("{0} :- {1}", "Description", items[0].Description);
lb5.Text = string.Format("{0} :- {1}", "Current Status", items[0].Status);
wos = items[0].Workplace;
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <CallerTaskRecord> query = DataTable
.Where(ur => ur.pholdername == tempdata.selected_InvoiceSubject);
// .Select(todoItem => todoItem.InvoiceSubject);
List <CallerTaskRecord> items = await query.ToListAsync();
// EmployeeView.ItemsSource = items2;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
lb1.Text = string.Format("{0} :- {1}", "Holder Name", items[0].pholdername);
lb2.Text = string.Format("{0} :- {1}", "Address", items[0].Address);
lb3.Text = string.Format("{0} :- {1}", "Description", items[0].Description);
lb4.Text = string.Format("{0} :- {1}", "ServiceType", items[0].ServiceType);
lb5.Text = string.Format("{0} :- {1}", "Budget", items[0].Budget);
lb6.Text = string.Format("{0} :- {1}", "Due date", items[0].Duedate);
// lb7.Text = string.Format("{0} :- {1}", "Assign Status", items[0].AssignStatus);
tempdata.duedatevr = items[0].Duedate;
tempdata.WorkPlace = items[0].Address;
tempdata.servicetype = items[0].ServiceType;
tempdata.estimatedfee = items[0].Budget;
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
/*
*
* List<UserReg> items = await DataTable
* .Where(ur => ur.FirstName != null)
* .ToListAsync();
*
*
* //IEnumerable itemsControl = items;
* EmployeeView.ItemsSource = items;
*
*/
IMobileServiceTableQuery <Invoice> query = DataTable
.Where(ur => ur.ServiceProvideId == tempdata.Loginas && ur.InvoiceSubject == tempdata.selected_InvoiceSubject);
// .Select(todoItem => todoItem.InvoiceSubject);
List <Invoice> items = await query.ToListAsync();
// EmployeeView.ItemsSource = items2;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
lb1.Text = string.Format("{0} :- {1}", "Subject", items[0].InvoiceSubject);
lb2.Text = string.Format("{0} :- {1}", "WorkPlace", items[0].WorkPlace);
lb3.Text = string.Format("{0} :- {1}", "Description", items[0].Description);
lb4.Text = string.Format("{0} :- {1}", "Service Fee", items[0].ServiceFee);
lb5.Text = string.Format("{0} :- {1}", "Other Fee", items[0].OtherFee);
lb6.Text = string.Format("{0} :- {1}", "Total", items[0].Total);
string st;
if (items[0].InvoiceStatus == 0)
{
st = "Pending";
}
else if (items[0].InvoiceStatus == 1)
{
st = "Payment Accepted";
}
else
{
st = "Payment Rejected";
}
lb7.Text = string.Format("{0} :- {1}", "Payment Status", st);
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
private async void GetDetails()
{
IMobileServiceTableQuery <User> q = userTbl
.Where(c => c.Customer_id == custId);
List <User> users = await q.ToListAsync();
EachDetail(users);
}
private async void buttonEliminar_Click(object sender, RoutedEventArgs e)
{
if (comboBoxIdTecnicoEditar.SelectedItem != null)
{
string idTecnico;
object selectedItem = comboBoxIdTecnicoEditar.SelectedValue.ToString();
idTecnico = selectedItem.ToString();
var dialog = new MessageDialog("¿Esta seguro de eliminar al usuario?");
dialog.Title = "¿Esta seguro?";
dialog.Commands.Add(new UICommand {
Label = "Si", Id = 0
});
dialog.Commands.Add(new UICommand {
Label = "No", Id = 1
});
var result = await dialog.ShowAsync();
if ((int)result.Id == 0)
{
try
{
IMobileServiceTableQuery <Usuario> query = UsuariosTable.Where(Tecnico => Tecnico.id == idTecnico);
var res = await query.ToListAsync();
var item = res.First();
string idEliminar = item.id;
JObject tecnicoDelete = new JObject();
tecnicoDelete.Add("id", idEliminar);
await UsuariosTable.DeleteAsync(tecnicoDelete);
radioButtonEliminar.IsChecked = false;
buttonEliminar.Visibility = Visibility.Collapsed;
comboBoxIdTecnicoEditar.IsEnabled = false;
}
catch (MobileServiceInvalidOperationException ex)
{
exception = ex;
}
if (exception != null)
{
await new MessageDialog(exception.Message, "Error!").ShowAsync();
}
else
{
MessageDialog mensaje = new MessageDialog("Se elimino correctamente.", "Eliminación correcta");
await mensaje.ShowAsync();
limpiarTexBoxRegistroEditar();
disableTexBox();
radioButtonEliminar.IsChecked = false;
}
}
}
}
/// <summary>
/// generic method to get one row from table by ID
/// </summary>
/// <typeparam name="T">ID as string</typeparam>
/// <param name="ID"></param>
/// <returns>item of generic object</returns>
public static async Task <T> SelectOneItem <T>(string ID) where T : BaseModel
{
IMobileServiceSyncTable <T> Table;
Table = client.GetSyncTable <T>();
IMobileServiceTableQuery <T> query = Table.Where(x => x.ID == ID);
List <T> items = await query.ToListAsync();
return(items.FirstOrDefault());
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTable <Invoice> dsin = client.GetTable <Invoice>();
IMobileServiceTableQuery <string> query = dsin
.Where(ur => ur.ServiceProvideId != tempdata.Loginas)
.Select(ur => ur.InvoiceSubject);
List <string> listin = await query.ToListAsync();
//-- paind invoice--
IMobileServiceTable <Invoice> dsinp = client.GetTable <Invoice>();
IMobileServiceTableQuery <string> query4 = dsin
.Where(ur => ur.ServiceProvideId == tempdata.Loginas & ur.InvoiceStatus == 1)
.Select(ur => ur.InvoiceSubject);
List <string> listinp = await query4.ToListAsync();
//------------
IMobileServiceTable <Quotation> dsqu = client.GetTable <Quotation>();
IMobileServiceTableQuery <string> query2 = dsqu
.Where(ur => ur.ServiceProviderId == tempdata.received_quotationID)
.Select(ur => ur.QuotationSubject);
List <string> ilistqu = await query2.ToListAsync();
// --------------------
IMobileServiceTable <WorkOrder> dswork = client.GetTable <WorkOrder>();
IMobileServiceTableQuery <string> query3 = dswork
.Where(ur => ur.ServiceProviderID != tempdata.Loginas)
.Select(ur => ur.WorkOrderSubject);
List <string> listwkd = await query3.ToListAsync();
/*
* qno.Text = Convert.ToString(ilistqu.Count);
* inv.Text = Convert.ToString(listin.Count);
* wod.Text = Convert.ToString(listwkd.Count);
* pinv.Text = Convert.ToString(listinp.Count);
*/
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task <FeedBack> GetFeedback(string eventID)
{
await Initialize();
IMobileServiceTableQuery <FeedBack> query = feedbackTable.Where(e => e.EventID == eventID);
var result = await query.ToListAsync();
var feedback = result.FirstOrDefault();
return(feedback);
}
//Public Methods
public async Task <List <User> > GetUser(string userid)
{
if (string.IsNullOrEmpty(userid))
{
return(new List <User>());
}
await SyncAsync();
IMobileServiceTableQuery <User> query = _usersTable.Where(u => u.UserID == userid);
return(await query.ToListAsync());
}
public async Task <List <Comment> > GetComments(string imageid)
{
if (string.IsNullOrEmpty(imageid))
{
return(new List <Comment>());
}
await SyncAsync();
IMobileServiceTableQuery <Comment> query = _commsTable.Where(c => c.ImageID == imageid);
return(await query.ToListAsync());
}
public async Task <List <AlbumItem> > GetAllImages(string albumid, bool receipts)
{
if (string.IsNullOrEmpty(albumid))
{
return(new List <AlbumItem>());
}
await SyncAsync();
IMobileServiceTableQuery <AlbumItem> query = _albumTable.Where(a => a.Album == albumid && a.IsReceipt == receipts);
return(await query.ToListAsync());
}
public async Task <List <Card> > GetAllCards(string userid, bool all = false)
{
if (string.IsNullOrEmpty(userid))
{
return(new List <Card>());
}
await SyncAsync();
IMobileServiceTableQuery <Card> query = !all?_cardsTable.Where(c => c.UserID == userid && c.Active == true) : _cardsTable.Where(c => c.UserID == userid);
return((await query.ToListAsync()).OrderBy(c => c.User).ToList());
}
private async void LoginBtn_Clicked(object sender, EventArgs e)
{
// await Navigation.PushAsync(new HomePage(), true);
if (validate())
{
try
{
this.IsBusy = true;
LoginBtn.IsEnabled = false;
IMobileServiceTableQuery <string> query = DataTable
.Where(ur => ur.Email == usernameEntry.Text)
.Select(ur => ur.Password);
List <string> passlist = await query.ToListAsync();
string Encpass = passlist[0];
string Dcpass = passwordDecrypt(Encpass, EncryptionKey);
if (Dcpass == passwordEntry.Text) //validate()
{
// apiCall();
string nameis = string.Format("{0} {1}", "You are login as", usernameEntry.Text);
DisplayAlert("Login success!", nameis, "Ok");
tempdata.Loginas = usernameEntry.Text;
await Navigation.PushAsync(new HomePage(), true);
}
else
{
DisplayAlert("Login Fail!", "Please enter correct details ", "Ok");
this.IsBusy = false;
LoginBtn.IsEnabled = true;
}
}
catch (Exception ee)
{
Debug.WriteLine("" + ee);
}
}
}
/// <summary>
/// generic method to remove item form table by ID or by object
/// </summary>
/// <typeparam name="T">ID as string</typeparam>
/// <param name="ID"></param>
/// <returns></returns>
public static async Task RemoveASync <T>(string ID) where T : BaseModel
{
IMobileServiceSyncTable <T> Table;
Table = client.GetSyncTable <T>();
IMobileServiceTableQuery <T> query = Table.Where(x => x.ID == ID);
List <T> items = await query.ToListAsync();
var item = items.FirstOrDefault();
if (item != null)
{
await Table.DeleteAsync(item);
}
}
private async void findContainerOfUser()
{
IMobileServiceTableQuery <Container> query = containerTable.Where(Container => Container.Proprio == IdUser);
Containers.Clear();
IEnumerable <Container> items = await query.ToListAsync();
items = items.OrderBy(c => c.Name);
foreach (var item in items)
{
Containers.Add(item);
}
}
private async void GetDetails()
{
IMobileServiceTableQuery <User> q = userTbl
.Where(c => c.Customer_id == custId);
List <User> users = await q.ToListAsync();
foreach (var user in users)
{
tbFirstName.Text = user.FirstName;
tbSecondName.Text = user.SecondName;
tbAddress.Text += user.Address;
tbCounty.Text = user.County;
tbEmail.Text = user.Email;
tbMobile.Text = user.Mobile;
}
}
private async void comboBoxIdTecnicoEditar_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//Cargar detalles del tecnico
if (comboBoxIdTecnicoEditar.SelectedItem != null)
{
string idTecnico;
object selectedItem = comboBoxIdTecnicoEditar.SelectedValue.ToString();
idTecnico = selectedItem.ToString();
try
{
ProgressBarBefore();
IMobileServiceTableQuery <Usuario> query = UsuariosTable.Where(Tecnico => Tecnico.id == idTecnico);
var res = await query.ToListAsync();
var item = res.First();
string id = item.id;
string nombre = item.Nombre;
string appaterno = item.APaterno;
string apmaterno = item.AMaterno;
string fechaNacimiento = item.fechaNacimiento;
string correo = item.correo;
string telefono = item.telefono;
string direccion = item.direccion;
string contrasena = item.contrasena;
textBoxNombreUsuario.Text = id;
textBoxNombre.Text = nombre;
textBoxAPatrno.Text = appaterno;
textBoxAMaterno.Text = apmaterno;
dpFechaNac.Date = DateTime.Parse(fechaNacimiento);
//textBox.Text = fechaNacimiento.ToString();
textBoxCorreo.Text = correo;
textBoxTelefono.Text = telefono;
textBoxDireccion.Text = direccion;
passwordBox.Password = contrasena;
ProgressBarAfter();
}
catch (MobileServiceInvalidOperationException ex)
{
exception = ex;
}
if (exception != null)
{
await new MessageDialog(exception.Message, "Error!").ShowAsync();
}
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <string> query = DataTable
.Where(ur => ur.callerID == tempdata.Loginas)
.Select(ur => ur.pholdername);
List <string> items2 = await query.ToListAsync();
EmployeeView.ItemsSource = items2;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
}
catch (Exception e) {
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <string> query = DataTable
.Where(ur => ur.ServiceProviderID == tempdata.Loginas)
.Select(ur => ur.WorkOrderSubject);
List <string> items = await query.ToListAsync();
workorders.ItemsSource = items;
// finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task GetdataAsync()
{
try
{
IMobileServiceTableQuery <string> query = DataTable
.Where(ur => ur.ServiceProviderId == tempdata.Loginas)
.Select(ur => ur.QuotationSubject);
List <string> items = await query.ToListAsync();
SQuotationView.ItemsSource = items;
//finalname.Text = string.Format("{0}-{1}", items2[0].FirstName, items2[0].LastName);
//----------------------------------------------------------------
//get catagory
IMobileServiceTable <UserReg> dt = client.GetTable <UserReg>();
IMobileServiceTableQuery <UserReg> query4 = dt
.Where(ur => ur.Email == tempdata.Loginas);
// .Select(ur => ur.QuotationSubject);
List <UserReg> items23 = await query4.ToListAsync();
string servicetype = items23[0].ServiceType;
//end get cat
IMobileServiceTableQuery <string> query2 = DataTable
.Where(ur => ur.ServiceProviderId == tempdata.received_quotationID && ur.servicetype == servicetype)
.Select(ur => ur.QuotationSubject);
List <string> items2 = await query2.ToListAsync();
RQuotationView.ItemsSource = items2;
}
catch (Exception e)
{
Debug.WriteLine("Sync error: {0}", new[] { e.Message });
}
}
public async Task <List <Transaction> > GetAllTransactions(string cardid, bool all = false)
{
if (string.IsNullOrEmpty(cardid))
{
return(new List <Transaction>());
}
await SyncAsync();
IMobileServiceTableQuery <Transaction> query = all
? _transTable.OrderByDescending(t => t.TransDate)
.ThenByDescending(t => t.InternalDifference)
.Where(t => t.CardID == cardid)
: _transTable.OrderByDescending(t => t.TransDate)
.ThenByDescending(t => t.InternalDifference)
.Where(t => t.CardID == cardid && t.Description != "Card Load" && !t.Description.StartsWith("Card Transfer"));
return(await query.ToListAsync());
}
private async void comboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
//LoadChartContents();
MobileServiceInvalidOperationException exception = null;
string idDeshidratadora;
object selectedItem = comboBox.SelectedValue.ToString();
idDeshidratadora = selectedItem.ToString();
try
{
ProgressBarBefore();
DateTime date = DatePickerToChart.Date.DateTime;
LoadChartContents(date);
IMobileServiceTableQuery <Deshidratadora> query = DeshTable.Where(Desh => Desh.idDeshidratadora == idDeshidratadora);
var res = await query.ToListAsync();
falladesh = await FallaTableDesh
.Select(Falla => Falla)
.Where(Falla => Falla.idDeshidratadora == idDeshidratadora /*&& Falla.Fecha == date.ToString("yyyy-MM-dd") /*&& Falla.Atendido == "0"*/)
.ToCollectionAsync();
string cantFallas = falladesh.Count().ToString();
var item = res.First();
string marca = item.Marca;
string modelo = item.Modelo;
string sn = item.No_Serie;
textBlockMarca.Text = marca;
textBlockModelo.Text = modelo;
textBlockNoSerie.Text = sn;
textBlockTotalAlertas.Text = cantFallas;
ProgressBarAfter();
}
catch (MobileServiceInvalidOperationException ex)
{
exception = ex;
}
if (exception != null)
{
await new MessageDialog(exception.Message, "Error!").ShowAsync();
}
}