public async Task <IActionResult> GetTodos(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", Route = "todos")] HttpRequest req,
[HttpQuery] TicketQuery query,
[AzureSearch] ISearchIndexClient todo,
ILogger logger)
{
try
{
var searchParams = new SearchParameters
{
IncludeTotalResultCount = true,
Filter = query.Filter,
Select = query.Fields?.Split(",").Append(nameof(Ticket.Id).ToLower()).Distinct().ToArray(),
Skip = query.PageSize * (query.PageNumber - 1),
Top = query.PageSize,
};
if (logger.IsEnabled(LogLevel.Debug))
{
logger.LogDebug($@"Searching {
JsonConvert.SerializeObject(new
{
SelectedFields = searchParams.Select,
searchParams.Filter,
searchParams.Skip,
Take = searchParams.Top
}, Formatting.Indented)}");
}
var docs = await todo.Documents
.SearchAsync <Ticket>(
searchText : "*",
searchParameters : searchParams)
.ConfigureAwait(false);
string Route(string queryString) => queryString != null ? $"/api/todos?{queryString}" : null;
// ReSharper disable once PossibleInvalidOperationException - cannot happen
var totalPages = (int)Math.Ceiling(decimal.Divide(docs.Count.Value, query.PageSize));
return(new OkObjectResult(new
{
tickets = docs.Results.Select(r => r.Document),
docs.ContinuationToken,
Pagination = new
{
totalPages,
Previous = Route(query.PreviousPage()),
Next = Route(query.NextPage(totalPages)),
First = Route(query.FirstPage()),
Last = Route(query.LastPage(totalPages))
}
}).StripNull());
}
catch (CloudException e) when(e.Response.StatusCode == HttpStatusCode.BadRequest)
{
return(new BadRequestObjectResult(new { error = e.Message }));
}
}
private static string ToQueryString(this TicketQuery @this, int pageNumber, int pageSize)
{
var newTicketQuery = @this.NewPageNumber(pageNumber).NewPageSize(pageSize);
var propertiesQuery =
from p in newTicketQuery.GetType().GetProperties()
where p.GetValue(newTicketQuery, null) != null
select $"{p.Name}={HttpUtility.UrlEncode(p.GetValue(newTicketQuery, null).ToString())}";
return(new StringBuilder().AppendJoin("&", propertiesQuery).ToString());
}
static void Main(string[] args)
{
RegisterMappings.Register();
var categories = new CategoryQuery().GetAll();
Console.WriteLine("Categories");
foreach (var category in categories)
{
Console.WriteLine($"\t{category.Id} | {category.Description}");
}
var people = new PersonQuery().GetAll();
Console.WriteLine("People and categories");
foreach (var person in people)
{
Console.WriteLine($"\t{person.Id} | {person.Name} | {person.Age} | {person.CategoryId} | {person.Category.Description}");
}
var peopleProjects = new PersonQuery().GetAllWithProjects();
Console.WriteLine("People and projects");
foreach (var person in peopleProjects)
{
Console.WriteLine($"\t{person.Id} | {person.Name}");
if (person.Projects != null)
{
foreach (var project in person.Projects)
{
Console.WriteLine($"\t\t{project.Id} | {project.Name}");
}
}
else
{
Console.WriteLine($"\t\tNo projects");
}
}
var priorities = new PriorityQuery().GetAll();
Console.WriteLine("Priorities");
foreach (var priority in priorities)
{
Console.WriteLine($"\t{priority.Id} | {priority.Description}");
}
var tickets = new TicketQuery().GetAll();
Console.WriteLine("Tickets");
foreach (var ticket in tickets)
{
Console.WriteLine($"\t{ticket.Description} | {ticket.PersonId} | {(ticket.Person?.Name ?? "No requester")} | {(ticket.Person?.CategoryId.ToString() ?? "No category id")} | {(ticket.Person?.Category?.Description ?? "No category")} | {(ticket.PriorityId.ToString() ?? "No priority Id")} | {(ticket.Priority?.Description ?? "No Priority")}");
}
}
public async Task <BacklogResponse <int> > GetTicketCountAsync(TicketQuery query = null)
{
query = query ?? new TicketQuery();
query.Project(this);
var response = await Client.GetAsync("/api/v2/issues/count", query.Build()).ConfigureAwait(false);
return(await Client.CreateResponseAsync <int, _Count>(
response,
HttpStatusCode.OK,
data => data.count).ConfigureAwait(false));
}
public void table_Clickedone(object sender, EventArgs e)
{
if (CrossConnectivity.Current.IsConnected)
{
try
{
int numb = 0;
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//TempTbl tbr = new TempTbl();
//s.Table<TempTbl>();
//s.DeleteAll<TempTbl>();
TicketQuery y = new TicketQuery();
SQLiteConnection d;
d = DependencyService.Get <ISQLite>().GetConnection();
d.Table <TicketNumber>();
d.DeleteAll <TicketNumber>();
SQLiteConnection r;
r = DependencyService.Get <ISQLite>().GetConnection();
TotalTbl tota = new TotalTbl();
r.Table <TotalTbl>();
r.DeleteAll <TotalTbl>();
if (JsonTable.resul == 3)
{
int flagyes = 4;
// Navigation.PushAsync(new Dashboard());
Navigation.PushAsync(new MainVedioPage(flagyes));
}
else
{
Navigation.PushAsync(new JsonTable(numb));
}
// Navigation.PushAsync(new Dashboard());
tabdone.Clicked -= table_Clickedone;
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
public async Task <BacklogResponse <Ticket[]> > GetTicketsAsync(TicketQuery query = null)
{
query = query ?? new TicketQuery();
query.Project(this);
var response = await Client.GetAsync("/api/v2/issues", query.Build()).ConfigureAwait(false);
return(await Client.CreateResponseAsync <Ticket[], List <_Ticket> >(
response,
HttpStatusCode.OK,
data => data.Select(x => Client.ItemsCache.Update(x.id, () => new Ticket(x, this, Client))).ToArray()
).ConfigureAwait(false));
}
/// <summary>
/// Retrieve all tickets from a department of Parature minus archived and deleted tickets.
/// </summary>
/// <param name="creds"></param>
/// <returns></returns>
public static List <Ticket> GetAllTickets(ParaCredentials creds)
{
var tq = new TicketQuery();
tq.RetrieveAllRecords = true;
var tickets = Service.GetList <Ticket>(tq);
if (tickets.ApiCallResponse.HasException)
{
throw new Exception(tickets.ApiCallResponse.ExceptionDetails);
}
return(tickets.ToList());
}
/// <summary>
/// Retrieve all tickets that belong to an organization minus archived and deleted tickets
/// </summary>
/// <param name="creds"></param>
/// <param name="accountId">Account ID of the organization. Not to be confused with Instance ID. Use the Account APIs to determine the account ID</param>
/// <returns></returns>
public static List <ParatureSDK.ParaObjects.Ticket> GetAllTicketsForAccount(ParaCredentials creds, long accountId)
{
var tq = new TicketQuery();
//Add an account filter: https://support.parature.com/public/doc/api.html#ticket-list
tq.AddStaticFieldFilter(TicketQuery.TicketStaticFields.Account, ParaEnums.QueryCriteria.Equal, accountId.ToString());
tq.RetrieveAllRecords = true;
var tickets = Service.GetList <Ticket>(tq);
if (tickets.ApiCallResponse.HasException)
{
throw new Exception(tickets.ApiCallResponse.ExceptionDetails);
}
return(tickets.ToList());
}
//private async void Current_ConnectivityChanged(object sender, Plugin.Connectivity.Abstractions.ConnectivityChangedEventArgs e)
//{
// if (!e.IsConnected)
// {
// await DisplayAlert("fail", "No Internet Connection. Offline Menu activated", "Ok");
// await Navigation.PushAsync(new MainTabbed());
// }
// else
// {
// // await DisplayAlert("sucess", " Network Is Available.", "Ok");
// // sendJSON();
// GetJSON();
// }
//}
//protected async override void OnAppearing()
//{
// base.OnAppearing();
// if (!CrossConnectivity.Current.IsConnected)
// {
// await DisplayAlert("fail", "No Internet Connection.Offline Menu Activated", "Ok");
// await Navigation.PushAsync(new MainTabbed());
// }
// else
// {
// // await DisplayAlert("sucess", " Network Is Available.", "Ok");
// // sendJSON();
// GetJSON();
// }
//}
//public ObservableCollection<JsonCartone> YourList
//{
// get
// {
// return itemsList;
// }
// set
// {
// itemsList = value;
// //RaisePropertyChanged();
// //NotifyPropertyChanged("YourList");
// }
//}
public async void GetJSON()
{
//TableQuery p = new TableQuery();
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//s.Table<TempTbl>();
//var count = s.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl");
// tablenow.Text = count;
TicketQuery y = new TicketQuery();
SQLiteConnection d;
d = DependencyService.Get <ISQLite>().GetConnection();
d.Table <TicketNumber>();
var tikcount = d.ExecuteScalar <string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1");
// ticketnow.Text = tikcount;
var client = new HttpClient();
var postData = new List <KeyValuePair <string, string> >();
// postData.Add(new KeyValuePair<string, string>("TestTicket", tikcount.Replace("\r\n", "")));
postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount));
var content = new FormUrlEncodedContent(postData);
// var response = await client.PostAsync("http://192.168.43.226/cardorderGetNew.php", content);
var response = await client.PostAsync(RestService.ipupdate + "cardorderGetNew.php", content);
string contactsJson = response.Content.ReadAsStringAsync().Result;
JsonCartone ObjContactList = new JsonCartone();
if (response.IsSuccessStatusCode)
{
ObjContactList = JsonConvert.DeserializeObject <JsonCartone>(contactsJson);
// itemCartList = JsonConvert.DeserializeObject<JsonCartone>(contactsJson);
cartone.ItemsSource = ObjContactList.CartDetails;
foreach (JsonCart t in ObjContactList.CartDetails)
{
newtot = t.Total + newtot;
//FlagNu = t.FlagNum;
}
}
total.Text = Convert.ToString(newtot);
// gandtot.Text = Convert.ToString(newtot + tax);
gandtot.Text = Convert.ToString(newtot);
GC.Collect(1);
// super.finalize();
}
public void KOT_btn_Clicked(object sender, EventArgs e)
{
if (CrossConnectivity.Current.IsConnected)
{
try
{
//TableQuery p = new TableQuery();
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//s.Table<TempTbl>();
//var count = s.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl");
TicketQuery y = new TicketQuery();
SQLiteConnection d;
d = DependencyService.Get <ISQLite>().GetConnection();
d.Table <TicketNumber>();
var tikcount = d.ExecuteScalar <string>("SELECT TicketNum FROM TicketNumber");
//ticketnow.Text = tikcount;
//string flag = "1";
var client = new HttpClient();
var postData = new List <KeyValuePair <string, string> >();
postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount.Replace("\r\n", "")));
postData.Add(new KeyValuePair <string, string>("IsReadyToKot", Convert.ToString(1)));
var content = new FormUrlEncodedContent(postData);
// var response = client.PostAsync("http://192.168.43.226/ConfirmKOTready.php", content);
var response = client.PostAsync(RestService.ipupdate + "ConfirmKOTready.php", content);
DisplayAlert("YOUR ORDER CONFIRMED AND SENT TO KOT", "thank you", "OK");
Navigation.PushAsync(new KOTsendPage());
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
public void OnTicketClicked(object sender, EventArgs e)
{
if (CrossConnectivity.Current.IsConnected)
{
try
{
var GroupTik = (sender as Button).BindingContext as TicketGroupModel;
TicketNumber tik = new TicketNumber();
SQLiteConnection s;
s = DependencyService.Get <ISQLite>().GetConnection();
s.Table <TicketNumber>();
tik.TicketNum = Convert.ToString(GroupTik.TicketID);
//tbr.TblName = Convert.ToString(data.ID);
TicketQuery c = new TicketQuery();
c.InsertDetails(tik);
//TicketQuery y = new TicketQuery();
//SQLiteConnection d;
//d = DependencyService.Get<ISQLite>().GetConnection();
//d.Table<TicketNumber>();
// var tikcount = s.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber WHERE max(Id)");
var tikcount = s.ExecuteScalar <string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1");
// DisplayAlert("ticket", tikcount, "ok");
// GroupTik.TicketID;
decimal toti = 0;
Navigation.PushAsync(new OnlineCart(toti));
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
public async void GetTicketinfo()
{
var TicketNu = 0;
var FlagNu = 0;
int tablupdate = 3;
long LocationId = OnlineLoginPage.LocationDetail;
var client = RestService.HttpClient;
var postData = new List <KeyValuePair <string, string> >();
postData.Add(new KeyValuePair <string, string>("LocationId", Convert.ToString(LocationId)));
postData.Add(new KeyValuePair <string, string>("TableID", tikettable));////////
postData.Add(new KeyValuePair <string, string>("IdentityID", Convert.ToString(tablupdate)));
var content = new FormUrlEncodedContent(postData);
// var response = await client.PostAsync("http://192.168.43.226/GetTicketNew.php", content);
var response = await client.PostAsync(RestService.ipupdate + "GetTicketNew.php", content);
JsonTicketNewNum ObjContactList = new JsonTicketNewNum();
if (response.IsSuccessStatusCode)
{
string JsonTiket = response.Content.ReadAsStringAsync().Result;
ObjContactList = JsonConvert.DeserializeObject <JsonTicketNewNum>(JsonTiket);
foreach (TiketViewModel t in ObjContactList.TicketInfo)
{
TicketNu = t.TiketNumb;
FlagNu = t.FlagNum;
}
}
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
TicketNumber tik = new TicketNumber();
SQLiteConnection s;
s = DependencyService.Get <ISQLite>().GetConnection();
s.Table <TicketNumber>();
tik.TicketNum = Convert.ToString(TicketNu);
//tbr.TblName = Convert.ToString(data.ID);
TicketQuery c = new TicketQuery();
c.InsertDetails(tik);
}
public async void GetJSON()
{
//Check network status
//if (NetworkCheck.IsNetworkConnected()) //{
//TableQuery p = new TableQuery();
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//s.Table<TempTbl>();
//var count = s.ExecuteScalar<string>("SELECT TblName FROM TempTbl");
TicketQuery y = new TicketQuery();
SQLiteConnection d;
d = DependencyService.Get <ISQLite>().GetConnection();
d.Table <TicketNumber>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var tikcount = d.ExecuteScalar <string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1");
// ticketnow.Text = tikcount;
// string flag = "1";
var client = new System.Net.Http.HttpClient();
var postData = new List <KeyValuePair <string, string> >();
//postData.Add(new KeyValuePair<string, string>("TestTicket", tikcount));
postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount));
// postData.Add(new KeyValuePair<string, string>("Flag", flag));
var content = new FormUrlEncodedContent(postData);
var response = await client.PostAsync(RestService.ipupdate + "KOTCheckNew.php", content);
string contactsJson = response.Content.ReadAsStringAsync().Result;
JsonCartone ObjContactList = new JsonCartone();
if (response.IsSuccessStatusCode)
{
ObjContactList = JsonConvert.DeserializeObject <JsonCartone>(contactsJson);
cartwo.ItemsSource = ObjContactList.CartDetails;
}
}
public static string PreviousPage(this TicketQuery @this) => @this.PageNumber > 1 ? @this.ToQueryString(@this.PageNumber - 1, @this.PageSize) : null;
public void Addr_btn_Clicked(object sender, EventArgs e)
{
if (CrossConnectivity.Current.IsConnected)
{
try
{
Navigation.PopModalAsync(true);
//FoodTabPage.imagedeta = null;
//GC.Collect();
//TableQuery p = new TableQuery();
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//s.Table<TempTbl>();
//var count = s.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl");
TicketQuery y = new TicketQuery();
SQLiteConnection d;
d = DependencyService.Get <ISQLite>().GetConnection();
d.Table <TicketNumber>();
var tikcount = d.ExecuteScalar <string>("SELECT max(TicketNum) FROM TicketNumber");
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber ORDER BY Id DESC LIMIT 1");
// DisplayAlert("tick", tikcount, "ok");
// ticketnow.Text = tikcount;
IPQuery IPR = new IPQuery();
SQLiteConnection IPK;
IPK = DependencyService.Get <ISQLite>().GetConnection();
IPK.Table <IPaddressDB>();
// var tikcount = d.ExecuteScalar<string>("SELECT TicketNum FROM TicketNumber");
var TerminalNo = IPK.ExecuteScalar <string>("SELECT Terminal FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
var OrderCounterNu = IPK.ExecuteScalar <string>("SELECT Counter FROM IPaddressDB ORDER BY Id DESC LIMIT 1");
// long itmID = Convert.tolo ItemID.Text;
decimal qty = Convert.ToDecimal(Qty.Text);
decimal total = Convert.ToDecimal(Price.Text);
decimal Total = (qty * total);
int BatchNo = Convert.ToInt16(Batch.Text);
long LocationDetail = OnlineLoginPage.LocationDetail;
//Total =+Total;
// tablenow.Text = count;
if (StuwardSelect.StuwardNme == null)
{
UsorSt = "GUEST";
StuwardSelect.StuwardIDn = 19834000000000;
}
else
{
UsorSt = StuwardSelect.StuwardNme;
StuwardSelect.StuwardIDn = StuwardSelect.StuwardIDn;
}
//if (StuwardSelect.StuwardIDn == null)
//{
// UsortStNum = 10834000000000;
//}
//else
//{
// UsorSt = StuwardSelect.StuwardNme;
//}
//var client = RestService.HttpClient;
var client = new HttpClient();
var postData = new List <KeyValuePair <string, string> >();
string name = OnlineLoginPage.UserName;
long UserIDn = OnlineLoginPage.UserID;
// string uid = OnlineLoginPage.us
int fromApp = 1;
int NoRadyKOT = 0;
var deviceID = TestProject.Data.Hardware.Default.DeviceId;
// var device = Resolver.Resolve<IDevice>();
// var table = s.Table<CartRecord>();
// foreach (var item in table)
if (BatchNo < 1)
{
DisplayAlert("Wrong entry", "Invalid", "OK");
}
else
{
postData.Add(new KeyValuePair <string, string>("Language", Convert.ToString(1))); //Language
postData.Add(new KeyValuePair <string, string>("Company", Convert.ToString(1))); //Company
postData.Add(new KeyValuePair <string, string>("Branch", Convert.ToString(1))); //Branch
postData.Add(new KeyValuePair <string, string>("Location", Convert.ToString(LocationDetail))); //Location
postData.Add(new KeyValuePair <string, string>("ItemID", Convert.ToString(itId))); //ItemID
postData.Add(new KeyValuePair <string, string>("ItemCode", codedetails.Text)); //ItemCode
postData.Add(new KeyValuePair <string, string>("Name", Name.Text));
postData.Add(new KeyValuePair <string, string>("CostPrice", CostPriceDetail.Text)); //CostPrice
postData.Add(new KeyValuePair <string, string>("Price", Price.Text));
postData.Add(new KeyValuePair <string, string>("Quantity", Qty.Text));
postData.Add(new KeyValuePair <string, string>("Transaction", Convert.ToString(1))); //Transaction ????
postData.Add(new KeyValuePair <string, string>("Reciptno", Convert.ToString(1))); //Reciptno ??????
postData.Add(new KeyValuePair <string, string>("UserID", Convert.ToString(UserIDn))); //UserID
postData.Add(new KeyValuePair <string, string>("UserName", name)); //UserName
postData.Add(new KeyValuePair <string, string>("Unit", Convert.ToString(0))); //Unit////////////////////was 1 ?????
postData.Add(new KeyValuePair <string, string>("Terminal", Convert.ToString(TerminalNo))); //Terminal
postData.Add(new KeyValuePair <string, string>("IsServiceChargeOnItem", isservicechargeinfo.Text)); ///////
postData.Add(new KeyValuePair <string, string>("TransID", Convert.ToString(1))); //TransctionTYP/////////chamge from 1 ?????
postData.Add(new KeyValuePair <string, string>("SaleTypeId", Convert.ToString(1))); // ????????????????????????????
postData.Add(new KeyValuePair <string, string>("UnitOfMeasureId", Convert.ToString(0))); //// not ????????????????????????????
postData.Add(new KeyValuePair <string, string>("BatchNumber", Convert.ToString(BatchNo))); //BatchNumber
postData.Add(new KeyValuePair <string, string>("ExpiryDate", Convert.ToString(null)));
postData.Add(new KeyValuePair <string, string>("TaxOne", Convert.ToString(0))); //TaxOne ??????????????????
postData.Add(new KeyValuePair <string, string>("TaxTwo", Convert.ToString(0))); //TaxTwo ??????????????????
postData.Add(new KeyValuePair <string, string>("TaxThree", Convert.ToString(0))); //TaxThree ?????????????????
postData.Add(new KeyValuePair <string, string>("TaxFour", Convert.ToString(0))); //TaxFour ?????????????????
postData.Add(new KeyValuePair <string, string>("TaxFive", Convert.ToString(0))); //TaxFive ????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentOne", Convert.ToString(0.00))); //TaxpersentOne ????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentTwo", Convert.ToString(0.00))); //TaxpersentTwo ?????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentThree", Convert.ToString(0.00))); //TaxpersentThree ?????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentFour", Convert.ToString(0))); //TaxpersentFour ????????????????????
postData.Add(new KeyValuePair <string, string>("TaxpersentFive", Convert.ToString(0))); //TaxpersentFive ???????????????????
postData.Add(new KeyValuePair <string, string>("CustomerID", Convert.ToString(1))); //CustomerID bigint//// ???????????
postData.Add(new KeyValuePair <string, string>("Customer", "Sam")); //CustomerName varchar/////////////// ????????????????
postData.Add(new KeyValuePair <string, string>("CustomerType", Convert.ToString(0))); //CustomerTyp int/////////// ??????????????
postData.Add(new KeyValuePair <string, string>("LoyaltyType", Convert.ToString(0))); //LoyaltyType int/////////////**************???????????
postData.Add(new KeyValuePair <string, string>("IsPromotion", Convert.ToString(0))); //Ispromotion bit/////// ???????????????????
postData.Add(new KeyValuePair <string, string>("FixedDiscount", Convert.ToString(0.00))); /// not ????????????????
postData.Add(new KeyValuePair <string, string>("FixedDiscountPercentage", Convert.ToString(0.00))); //// not ?????????????????
postData.Add(new KeyValuePair <string, string>("PromotionID", Convert.ToString(0))); //IspromotionID bigint////////----was 1 ?????????????
postData.Add(new KeyValuePair <string, string>("OrderCounter", Convert.ToString(3))); //OrderCounter///////////////////changes req/////////////////////////default need to be 1////????????????
postData.Add(new KeyValuePair <string, string>("Ticket", Convert.ToString(thiTable)));
postData.Add(new KeyValuePair <string, string>("KotBotCounterId", Convert.ToString(0))); ///??????????????????
postData.Add(new KeyValuePair <string, string>("TestTicket", tikcount.Replace("\r\n", "")));
postData.Add(new KeyValuePair <string, string>("OrderNum", Convert.ToString(3))); //OrderNum ///???????????????
postData.Add(new KeyValuePair <string, string>("IsNew", Convert.ToString(1))); ///////????????????????????
postData.Add(new KeyValuePair <string, string>("StuwardID", Convert.ToString(StuwardSelect.StuwardIDn))); //StuwardID
postData.Add(new KeyValuePair <string, string>("StuwardName", UsorSt)); // StuwardSelect.StuwardNme));//StuwardName
postData.Add(new KeyValuePair <string, string>("CurrentRowNo", Convert.ToString(0))); // not ????????????????????????????
postData.Add(new KeyValuePair <string, string>("IsAddonApplicable", Convert.ToString(0))); ////IsAddOnApplicable ?????????????????????????????????
postData.Add(new KeyValuePair <string, string>("IsAddonItem", Convert.ToString(0))); //////???????????????????????????????
postData.Add(new KeyValuePair <string, string>("IsRetailItem", Convert.ToString(0))); ///////////////?????????????????????
postData.Add(new KeyValuePair <string, string>("BasedAddOnItemId", Convert.ToString(0))); //////????????????????????????
postData.Add(new KeyValuePair <string, string>("IsStaffDiscount", Convert.ToString(0))); ///IsStaffDiscount /////////????????????????
postData.Add(new KeyValuePair <string, string>("IsGuideCommission", Convert.ToString(0))); ///IsStaffDiscount ///////////////?????????????????????
postData.Add(new KeyValuePair <string, string>("IsTakeAway", Convert.ToString(0))); ///IsStaffDiscount /////////////????????
postData.Add(new KeyValuePair <string, string>("PPno", "")); //PPnumber varchar(30)////////??????????????????????
postData.Add(new KeyValuePair <string, string>("BPno", "")); //BPnumber varchar(30)///////////???????????????????????
postData.Add(new KeyValuePair <string, string>("FLNo", "")); //BPnumber varchar(30)///////////FLNo???????????????????????
postData.Add(new KeyValuePair <string, string>("IsReadyToKot", Convert.ToString(NoRadyKOT)));
postData.Add(new KeyValuePair <string, string>("IsFromApp", Convert.ToString(fromApp))); //fromApp
var content = new FormUrlEncodedContent(postData);
// var response = client.PostAsync("http://192.168.43.226/cartorderInsertNew.php", content);// correct one 1
// var response = client.PostAsync("http://192.168.43.226/CartOrderInsert.php", content);
// var response = client.PostAsync("http://192.168.43.226/InsertSPNewCart.php", content); // test for SP in php
// var response = client.PostAsync("http://192.168.43.226/cartorderInsertNewSP.php", content); // correct two sp test//////////////////
var response = client.PostAsync(RestService.ipupdate + "cartorderInsertNewSP.php", content); // correct two sp test//////////////////
// http://192.168.43.226/cartorderInsertNewSP.php
Navigation.PushAsync(new OnlineCart(Total));
}
// Image.Source = null;
// Xamarin.Forms.Application.Current.MainPage.Navigation.RemovePage(FoodTabbedPage);
// Navigation.PopAsync().ConfigureAwait(false);
//var MyAppsFirstPage = new contentpage();
//Application.Current.MainPage = new NavigationPage(MyAppsFirstPage);
//Application.Current.MainPage.Navigation.PushAsync(FoodTabbedPage);
//Navigation.PopAsync();
// Navigation.RemovePage(FoodTabbedPage);
///////----- end of modification --------------------------
////Device.BeginInvokeOnMainThread(async () => await Navigation.PopModalAsync());
//if (BatchNo < 1)
//{
// DisplayAlert("Wrong entry", "Invalid", "OK");
//}
//else
//{
// Navigation.PushAsync(new OnlineCart(Total));
//}
GC.Collect(1);
// await _navigation.PushAsync(new Page2(argument_goes_here));
//for (int PageIndex = Navigation.NavigationStack.Count; PageIndex >= 2; PageIndex--)
//{
// Navigation.RemovePage(Navigation.NavigationStack[PageIndex]);
//}
//string name = OnlineLoginPage.UserName;
// FoodTabPage.imagedeta= null;
// clearImag.
}
catch (Exception ex)
{
// Console.WriteLine("An error occurred: '{0}'", ex);
}
}
else
{
// write your code if there is no Internet available
DisplayAlert("NETWORK ERROR", "SYSTEM IS OFFLINE", "Ok");
}
}
public static async Task <Ticket[]> BatchGetTicketsAsync(this Project project, TicketQuery query = null, ErrorHandler onError = null)
{
query = query ?? new TicketQuery();
var countResponse = await project.GetTicketCountAsync(query).ConfigureAwait(false);
if (!countResponse.CanContinueBatchJobs(onError))
{
return(Array.Empty <Ticket>());
}
var ticketCount = countResponse.Content;
var tickets = new List <Ticket>();
while (tickets.Count < ticketCount)
{
var count = Math.Min(ticketCount - tickets.Count, TicketQuery.MaxCount);
query.Offset(tickets.Count).Count(count);
var ticketsResponse = await project.GetTicketsAsync(query).ConfigureAwait(false);
if (!ticketsResponse.CanContinueBatchJobs(onError))
{
break;
}
tickets.AddRange(ticketsResponse.Content);
}
return(tickets.ToArray());
}
public static string FirstPage(this TicketQuery @this) => @this.PageNumber != 1 ? @this.ToQueryString(1, @this.PageSize) : null;
public static string NextPage(this TicketQuery @this, int totalPages) => @this.PageNumber < totalPages? @this.ToQueryString(@this.PageNumber + 1, @this.PageSize) : null;
public static string LastPage(this TicketQuery @this, int totalPages) => @this.PageNumber != totalPages? @this.ToQueryString(totalPages, @this.PageSize) : null;
public async void GetTicketinfo()
{
TableQuery p = new TableQuery();
SQLiteConnection r;
r = DependencyService.Get <ISQLite>().GetConnection();
r.Table <TempTbl>();
var count = r.ExecuteScalar <string>("SELECT max(TblName) FROM TempTbl");
// await DisplayAlert("tableID", count, "OK");
var TicketNu = 0;
var FlagNu = 0;
long LocationId = OnlineLoginPage.LocationDetail;
var client = new HttpClient();
var postData = new List <KeyValuePair <string, string> >();
postData.Add(new KeyValuePair <string, string>("LocationId", Convert.ToString(LocationId)));
postData.Add(new KeyValuePair <string, string>("TableID", Convert.ToString(JsonTable.tablenew)));////////
postData.Add(new KeyValuePair <string, string>("IdentityID", Convert.ToString(2)));
var content = new FormUrlEncodedContent(postData);
// var response = await client.PostAsync("http://192.168.43.226/GetTicketNew.php", content);
var response = await client.PostAsync(RestService.ipupdate + "GetTicketNew.php", content);
JsonTicketNewNum ObjContactList = new JsonTicketNewNum();
if (response.IsSuccessStatusCode)
{
string JsonTiket = response.Content.ReadAsStringAsync().Result;
ObjContactList = JsonConvert.DeserializeObject <JsonTicketNewNum>(JsonTiket);
foreach (TiketViewModel t in ObjContactList.TicketInfo)
{
TicketNu = t.TiketNumb;
FlagNu = t.FlagNum;
}
}
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
TicketNumber tik = new TicketNumber();
SQLiteConnection s;
s = DependencyService.Get <ISQLite>().GetConnection();
s.Table <TicketNumber>();
tik.TicketNum = Convert.ToString(TicketNu);
//tbr.TblName = Convert.ToString(data.ID);
TicketQuery c = new TicketQuery();
c.InsertDetails(tik);
decimal toti = 0;
if (FlagNu == 0)
{
//await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
// await Navigation.PushAsync(new OnlineTabbed());
await Navigation.PushAsync(new FoodTabbedPage());
}
else if (FlagNu == 1)
{
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
await Navigation.PushAsync(new OnlineCart(toti));
}
else
{
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
await Navigation.PushAsync(new CartTiketsPage());
}
}
//public async void Higlight()
//{
// if (Newtab == Usetab)
// //{
// await DisplayAlert("ocupied tables are", Convert.ToString(Usetab), "OK");
// // //Button btn = new Button();
// // //btn.BackgroundColor = Color.FromHex("#22ac38");
// //}
//}
public async void GetTicketinfo()
{
//TableQuery p = new TableQuery();
//SQLiteConnection r;
//r = DependencyService.Get<ISQLite>().GetConnection();
//r.Table<TempTbl>();
//var count = r.ExecuteScalar<string>("SELECT max(TblName) FROM TempTbl");
// await DisplayAlert("tableID", count, "OK");
var TicketNu = 0;
var FlagNu = 0;
long LocationId = OnlineLoginPage.LocationDetail;
var client = RestService.HttpClient;
var postData = new List <KeyValuePair <string, string> >();
postData.Add(new KeyValuePair <string, string>("LocationId", Convert.ToString(LocationId)));
postData.Add(new KeyValuePair <string, string>("TableID", Convert.ToString(tablenew)));////////
postData.Add(new KeyValuePair <string, string>("IdentityID", Convert.ToString(resul)));
var content = new FormUrlEncodedContent(postData);
// var response = await client.PostAsync("http://192.168.43.226/GetTicketNew.php", content);
var response = await client.PostAsync(RestService.ipupdate + "GetTicketNew.php", content);
JsonTicketNewNum ObjContactList = new JsonTicketNewNum();
if (response.IsSuccessStatusCode)
{
string JsonTiket = response.Content.ReadAsStringAsync().Result;
ObjContactList = JsonConvert.DeserializeObject <JsonTicketNewNum>(JsonTiket);
foreach (TiketViewModel t in ObjContactList.TicketInfo)
{
TicketNu = t.TiketNumb;
FlagNu = t.FlagNum;
}
}
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
TicketNumber tik = new TicketNumber();
SQLiteConnection s;
s = DependencyService.Get <ISQLite>().GetConnection();
s.Table <TicketNumber>();
tik.TicketNum = Convert.ToString(TicketNu);
//tbr.TblName = Convert.ToString(data.ID);
TicketQuery c = new TicketQuery();
c.InsertDetails(tik);
TempTbl tbr = new TempTbl();
SQLiteConnection p;
p = DependencyService.Get <ISQLite>().GetConnection();
p.Table <TempTbl>();
tbr.TblNumbe = tablenew;
//tbr.TblName = itemSelectedData.Name;
TableQuery d = new TableQuery();
d.InsertDetails(tbr);
decimal toti = 0;
if (FlagNu == 0 && resul != 3)
{
//await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
// await Navigation.PushAsync(new OnlineTabbed());
await Navigation.PushAsync(new StuwardSelect());
}
else if (FlagNu == 1 && resul != 3)
{
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
await Navigation.PushAsync(new OnlineCart(toti));
}
else if (FlagNu > 1 || resul == 0)
{
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
await Navigation.PushAsync(new CartTiketsPage());
}
else if (FlagNu == 2 || resul == 2)
{
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
await Navigation.PushAsync(new FoodTabbedPage());
}
else if (FlagNu == 2 || resul == 3)
{
int flgyes = 3;
// await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
//await Navigation.PushAsync(new FoodTabbedPage());
await Navigation.PushAsync(new MainVedioPage(flgyes));
}
//TicketQuery y = new TicketQuery();
//SQLiteConnection d;
//d = DependencyService.Get<ISQLite>().GetConnection();
//d.Table<TicketNumber>();
//var tikcount = d.ExecuteScalar<string>("SELECT max(TicketNum) FROM TicketNumber");
//await DisplayAlert("tiket numb", tikcount, "OK");
//decimal toti = 0;
//if (FlagNu == 0)
//{
////await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
//// await Navigation.PushAsync(new OnlineTabbed());
//await Navigation.PushAsync(new StuwardSelect());
//}
//else if(FlagNu == 1)
// {
// // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
// await Navigation.PushAsync(new OnlineCart(toti));
// }
// else
// {
// // await DisplayAlert("ticket", Convert.ToString(TicketNu), "OK");
// await Navigation.PushAsync(new CartTiketsPage());
// }
}
