public static PawnTicket Create(int pledgePeriod, int branchId, string managerName, int customerId,
IList <PawnItem> pawnItems, decimal totalWeight, decimal weight, int factSum, int creditSum,
decimal percentRate, int percentSum, decimal commissionRate, int guaranteeId, decimal guaranteeRate,
TicketNumber ticketNumber)
{
return(new PawnTicket
{
Uuid = Guid.NewGuid(),
IsRefund = false,
IsExpired = false,
IssueDate = DateTime.Now,
ExpireDate = DateTime.Today.AddDays(pledgePeriod),
RefundDate = DateTime.MinValue,
PledgePeriod = pledgePeriod,
BranchId = branchId,
ManagerName = managerName,
CustomerId = customerId,
PawnItems = pawnItems,
TotalWeight = totalWeight,
Weight = weight,
FactSum = factSum,
CreditSum = creditSum,
PercentRate = percentRate,
PercentSum = percentSum,
CommissionRate = commissionRate,
GuaranteeId = guaranteeId,
GuaranteeRate = guaranteeRate,
TicketNumber = ticketNumber
});
}
public async Task <string> GenerateTicketNumberAsync()
{
// Load ticket number counter
var ticketNumber = await _repository.GetSingleAsync();
if (ticketNumber is null)
{
// Create a new ticket number counter if it doesn't exist.
ticketNumber = new TicketNumber();
ticketNumber.CreateNewTicketNumberCounter();
await _repository.CreateAsync(ticketNumber);
// Return ticket number formated string.
return(ticketNumber.GetTicketNumberString());
}
else
{
// Get next ticket number and save it.
ticketNumber.CreateNextTicketNumber();
await _repository.UpdateAsync(ticketNumber);
// Return ticket number string.
return(ticketNumber.GetTicketNumberString());
}
}
//public void savebuton(object sender, EventArgs e)
//{
// DependencyService.Get<ISaveAndLoad>().SaveText("temp.txt", input.Text);
// DisplayAlert("text", input.Text, "OK");
//}
//public void load(object sender, EventArgs e)
//{
// output.Text = DependencyService.Get<ISaveAndLoad>().LoadText("temp.txt");
//}
//public void Login_btn_Clicked(object sender, EventArgs e)
//{
// Navigation.PushAsync(new Login());
//}
//public void Meals_btn_Clicked(object sender, EventArgs e)
//{
// Navigation.PushAsync(new Meals());
//}
//public void Item_Clicked(object sender, EventArgs e)
//{
// Navigation.PushAsync(new StuwardSelect());
//}
public void Cart_btn_Clicked(object sender, EventArgs e)
{
//SQLiteConnection s;
//s = DependencyService.Get<ISQLite>().GetConnection();
//TempTbl tbr = new TempTbl();
//s.Table<TempTbl>();
//if (TempT)
//s.DeleteAll<TempTbl>();
SQLiteConnection y;
y = DependencyService.Get <ISQLite>().GetConnection();
TicketNumber Ti = new TicketNumber();
y.Table <TicketNumber>();
y.DeleteAll <TicketNumber>();
SQLiteConnection r;
r = DependencyService.Get <ISQLite>().GetConnection();
TotalTbl tota = new TotalTbl();
r.Table <TotalTbl>();
r.DeleteAll <TotalTbl>();
//SQLiteConnection v;
//v = DependencyService.Get<ISQLite>().GetConnection();
//StuwardTbl knr = new StuwardTbl();
//v.Table<StuwardTbl>();
//v.DeleteAll<StuwardTbl>();
}
public ActionResult DeleteConfirmed(int id)
{
TicketNumber ticketNumber = db.TicketNumbers.Find(id);
db.TicketNumbers.Remove(ticketNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static TicketNumber GetInstance()
{
if (_instance == null)
{
_instance = new TicketNumber();
}
return(_instance);
}
private void TicketTextChanged()
{
if (TicketNumber.Length == 15)
{
var ticketNumber = TicketNumber.Replace(" ", string.Empty);
TicketProccess(ticketNumber);
}
}
void Init()
{
SQLiteConnection r;
r = DependencyService.Get <ISQLite>().GetConnection();
TicketNumber tota = new TicketNumber();
r.Table <TicketNumber>();
r.DeleteAll <TicketNumber>();
}
public ActionResult Edit([Bind(Include = "Id,Name")] TicketNumber ticketNumber)
{
if (ModelState.IsValid)
{
db.Entry(ticketNumber).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketNumber));
}
public ActionResult Create([Bind(Include = "Id,Name")] TicketNumber ticketNumber)
{
if (ModelState.IsValid)
{
db.TicketNumbers.Add(ticketNumber);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticketNumber));
}
public void Table_btn_Clicked(object sender, EventArgs e)
{
int newnumber = 0;
SQLiteConnection r;
r = DependencyService.Get <ISQLite>().GetConnection();
TicketNumber tota = new TicketNumber();
r.Table <TicketNumber>();
r.DeleteAll <TicketNumber>();
Navigation.PushAsync(new JsonTable(newnumber));
}
// GET: TicketNumbers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TicketNumber ticketNumber = db.TicketNumbers.Find(id);
if (ticketNumber == null)
{
return(HttpNotFound());
}
return(View(ticketNumber));
}
private void OnBackSpace(string obj)
{
if (TicketCode.Length == 0 && IsFocusedCode)
{
IsFocusedNumber = true;
}
if (TicketCode.Length > 0 && !IsFocusedCode && !IsFocusedNumber)
{
TicketCode = TicketCode.Remove(TicketCode.Length - 1);
}
else if (TicketNumber.Length > 0 && !IsFocusedCode && !IsFocusedNumber)
{
TicketNumber = TicketNumber.Remove(TicketNumber.Length - 1);
}
else
{
var key = Key.Back;
var target = System.Windows.Input.Keyboard.FocusedElement;
var routedEvent = System.Windows.Input.Keyboard.KeyDownEvent;
target.RaiseEvent(
new KeyEventArgs(
System.Windows.Input.Keyboard.PrimaryDevice,
PresentationSource.FromVisual(target as Visual),
0,
key)
{
RoutedEvent = routedEvent
}
);
var textBox = target as TextBox;
if (IsFocusedNumber)
{
if (textBox != null)
{
TicketNumber = textBox.Text;
}
}
if (IsFocusedCode)
{
if (textBox != null)
{
TicketCode = textBox.Text;
}
}
}
}
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);
}
private void SComponent_ValueChanged(object sender, EventArgs e)
{
if (TicketNumber.ObjectControl != null)
{
CurrentControl = TicketNumber.ObjectControl as IEntityBase;
RefreshControls();
TicketNumber.SComponent.BackColor = System.Drawing.Color.LightGreen;
UpdateReport();
}
else
{
var value = ((NumericUpDown)sender).Value;
CurrentControl = new ParkingInOut()
{
TicketNumber = value
};
RefreshControls();
TicketNumber.SComponent.BackColor = System.Drawing.Color.LightCoral;
TicketNumber.SetError("Registro não encontrado", -40);
TicketNumber.SetFocus();
}
}
/// <summary>
/// Gets the hash code
/// </summary>
/// <returns>Hash code</returns>
public override int GetHashCode()
{
unchecked // Overflow is fine, just wrap
{
var hashCode = 41;
// Suitable nullity checks etc, of course :)
if (AgentNumericCode != null)
{
hashCode = hashCode * 59 + AgentNumericCode.GetHashCode();
}
if (Code != null)
{
hashCode = hashCode * 59 + Code.GetHashCode();
}
if (FlightDate != null)
{
hashCode = hashCode * 59 + FlightDate.GetHashCode();
}
if (FlightLegs != null)
{
hashCode = hashCode * 59 + FlightLegs.GetHashCode();
}
if (InvoiceNumber != null)
{
hashCode = hashCode * 59 + InvoiceNumber.GetHashCode();
}
if (IsETicket != null)
{
hashCode = hashCode * 59 + IsETicket.GetHashCode();
}
if (IsRegisteredCustomer != null)
{
hashCode = hashCode * 59 + IsRegisteredCustomer.GetHashCode();
}
if (IsRestrictedTicket != null)
{
hashCode = hashCode * 59 + IsRestrictedTicket.GetHashCode();
}
if (IsThirdParty != null)
{
hashCode = hashCode * 59 + IsThirdParty.GetHashCode();
}
if (IssueDate != null)
{
hashCode = hashCode * 59 + IssueDate.GetHashCode();
}
if (MerchantCustomerId != null)
{
hashCode = hashCode * 59 + MerchantCustomerId.GetHashCode();
}
if (Name != null)
{
hashCode = hashCode * 59 + Name.GetHashCode();
}
if (PassengerName != null)
{
hashCode = hashCode * 59 + PassengerName.GetHashCode();
}
if (Passengers != null)
{
hashCode = hashCode * 59 + Passengers.GetHashCode();
}
if (PlaceOfIssue != null)
{
hashCode = hashCode * 59 + PlaceOfIssue.GetHashCode();
}
if (Pnr != null)
{
hashCode = hashCode * 59 + Pnr.GetHashCode();
}
if (PointOfSale != null)
{
hashCode = hashCode * 59 + PointOfSale.GetHashCode();
}
if (PosCityCode != null)
{
hashCode = hashCode * 59 + PosCityCode.GetHashCode();
}
if (TicketDeliveryMethod != null)
{
hashCode = hashCode * 59 + TicketDeliveryMethod.GetHashCode();
}
if (TicketNumber != null)
{
hashCode = hashCode * 59 + TicketNumber.GetHashCode();
}
if (TotalFare != null)
{
hashCode = hashCode * 59 + TotalFare.GetHashCode();
}
if (TotalFee != null)
{
hashCode = hashCode * 59 + TotalFee.GetHashCode();
}
if (TotalTaxes != null)
{
hashCode = hashCode * 59 + TotalTaxes.GetHashCode();
}
if (TravelAgencyName != null)
{
hashCode = hashCode * 59 + TravelAgencyName.GetHashCode();
}
return(hashCode);
}
}
} /* TOEGEVOEGD 'virtual' for lazy-loading, if enabled on context (default) */
public override int GetHashCode()
{
return(TicketNumber.GetHashCode());
}
//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());
// }
}
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());
}
}
private static void BuscarPróximoNumeroDeTicket()
{
var ticket = TicketNumber.GetInstance().GetNextTicket();
WriteLine($"Número do ticket: {ticket}");
}
/// <summary>
/// Returns true if AirlineData instances are equal
/// </summary>
/// <param name="other">Instance of AirlineData to be compared</param>
/// <returns>Boolean</returns>
public bool Equals(AirlineData other)
{
if (ReferenceEquals(null, other))
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return
((
AgentNumericCode == other.AgentNumericCode ||
AgentNumericCode != null &&
AgentNumericCode.Equals(other.AgentNumericCode)
) &&
(
Code == other.Code ||
Code != null &&
Code.Equals(other.Code)
) &&
(
FlightDate == other.FlightDate ||
FlightDate != null &&
FlightDate.Equals(other.FlightDate)
) &&
(
FlightLegs == other.FlightLegs ||
FlightLegs != null &&
FlightLegs.SequenceEqual(other.FlightLegs)
) &&
(
InvoiceNumber == other.InvoiceNumber ||
InvoiceNumber != null &&
InvoiceNumber.Equals(other.InvoiceNumber)
) &&
(
IsETicket == other.IsETicket ||
IsETicket != null &&
IsETicket.Equals(other.IsETicket)
) &&
(
IsRegisteredCustomer == other.IsRegisteredCustomer ||
IsRegisteredCustomer != null &&
IsRegisteredCustomer.Equals(other.IsRegisteredCustomer)
) &&
(
IsRestrictedTicket == other.IsRestrictedTicket ||
IsRestrictedTicket != null &&
IsRestrictedTicket.Equals(other.IsRestrictedTicket)
) &&
(
IsThirdParty == other.IsThirdParty ||
IsThirdParty != null &&
IsThirdParty.Equals(other.IsThirdParty)
) &&
(
IssueDate == other.IssueDate ||
IssueDate != null &&
IssueDate.Equals(other.IssueDate)
) &&
(
MerchantCustomerId == other.MerchantCustomerId ||
MerchantCustomerId != null &&
MerchantCustomerId.Equals(other.MerchantCustomerId)
) &&
(
Name == other.Name ||
Name != null &&
Name.Equals(other.Name)
) &&
(
PassengerName == other.PassengerName ||
PassengerName != null &&
PassengerName.Equals(other.PassengerName)
) &&
(
Passengers == other.Passengers ||
Passengers != null &&
Passengers.SequenceEqual(other.Passengers)
) &&
(
PlaceOfIssue == other.PlaceOfIssue ||
PlaceOfIssue != null &&
PlaceOfIssue.Equals(other.PlaceOfIssue)
) &&
(
Pnr == other.Pnr ||
Pnr != null &&
Pnr.Equals(other.Pnr)
) &&
(
PointOfSale == other.PointOfSale ||
PointOfSale != null &&
PointOfSale.Equals(other.PointOfSale)
) &&
(
PosCityCode == other.PosCityCode ||
PosCityCode != null &&
PosCityCode.Equals(other.PosCityCode)
) &&
(
TicketDeliveryMethod == other.TicketDeliveryMethod ||
TicketDeliveryMethod != null &&
TicketDeliveryMethod.Equals(other.TicketDeliveryMethod)
) &&
(
TicketNumber == other.TicketNumber ||
TicketNumber != null &&
TicketNumber.Equals(other.TicketNumber)
) &&
(
TotalFare == other.TotalFare ||
TotalFare != null &&
TotalFare.Equals(other.TotalFare)
) &&
(
TotalFee == other.TotalFee ||
TotalFee != null &&
TotalFee.Equals(other.TotalFee)
) &&
(
TotalTaxes == other.TotalTaxes ||
TotalTaxes != null &&
TotalTaxes.Equals(other.TotalTaxes)
) &&
(
TravelAgencyName == other.TravelAgencyName ||
TravelAgencyName != null &&
TravelAgencyName.Equals(other.TravelAgencyName)
));
}