private void SendPay() { models.Payment payment = new models.Payment(); payment.id = 0; payment.account = account; payment.customer = user; payment.debt = deuda; payment.paid = deposito; payment.date = DateTime.Now.ToString("dd/MM/yyyy hh:mm"); SQLiteService sqlite = new SQLiteService(); if (sqlite.InsertPay(payment) == "OK") { MessageBox.Show("PAGO REGISTRADO"); } else { MessageBox.Show("ERROR DE SISTEMA"); } if (WebService.PostTransaction(payment.account, payment.paid) != "OK") { MessageBox.Show("ERROR EN SERVIDOR"); } device.Close(); this.Parent.Parent.Controls[1].Text = "welcome"; }
public string InsertPay(models.Payment payment) { string result = ""; try { string query = "INSERT INTO payments (customer, account, debt, paid, date) "; query = query + " VALUES ("; query = query + "'" + payment.customer + "', '" + payment.account + "',"; query = query + payment.debt + ", " + payment.paid + ", '" + payment.date + "');"; SqliteConnection sqlite = new SqliteConnection("Filename = " + DB_PATH); sqlite.Open(); SqliteCommand cmd = sqlite.CreateCommand(); cmd.CommandText = query; cmd.ExecuteNonQuery(); sqlite.Close(); result = "OK"; }catch (Exception e) { result = e.Message; } return(result); }
private void LoadView(object sender, EventArgs e) { if (lbMainControl.Text == "welcome") { lbMainData.Text = "data"; panelMain.Controls.Clear(); Home home = new Home(); panelMain.Controls.Add(home); gbMainButtons.Visible = false; btMainNext.Enabled = true; } else if (lbMainControl.Text == "account") { lbMainData.Text = "data"; panelMain.Controls.Clear(); Account account = new Account(); panelMain.Controls.Add(account); btMainPrev.Text = "< Cancelar"; btMainNext.Text = "Continuar >"; btMainNext.Enabled = true; gbMainButtons.Visible = true; } else if (lbMainControl.Text == "balance") { if (panelMain.Controls[0].Controls[11].Text == "") { MessageBox.Show("INGRESE UN NUMERO DE CUENTA"); lbMainControl.Text = "account"; } else { string account = panelMain.Controls[0].Controls[11].Text; string balance = WebService.GetBalance(account); if (Util.IsJsonObject(balance) && balance.Contains("user") && balance.Contains("debt")) { lbMainData.Text = balance; JObject obj = JObject.Parse(balance); float debt = float.Parse(obj.GetValue("debt").ToString()); if (debt <= 0.0f) { btMainNext.Enabled = false; } else { btMainNext.Enabled = true; } } if (Util.IsJsonObject(lbMainData.Text) && lbMainData.Text.Contains("user") && lbMainData.Text.Contains("debt")) { JObject obj = JObject.Parse(lbMainData.Text); if (!obj.ContainsKey("account")) { obj.Add("account", account); } lbMainData.Text = obj.ToString(); panelMain.Controls.Clear(); Balance _balance = new Balance(obj.ToString()); panelMain.Controls.Add(_balance); btMainPrev.Text = "< Volver"; btMainNext.Text = "Pagar >"; } else { MessageBox.Show("ERROR DE SERVIDOR"); lbMainControl.Text = "account"; } } } else if (lbMainControl.Text == "payment") { panelMain.Controls.Clear(); Payment payment = new Payment(lbMainData.Text); panelMain.Controls.Add(payment); btMainPrev.Text = "< Cancelar"; btMainNext.Text = "Abonar >"; } else if (lbMainControl.Text == "send_pay") { float deuda = 0.0f; float deposito = 0.0f; float restan = 0.0f; for (int i = 0; i < panelMain.Controls[0].Controls.Count; i++) { if (panelMain.Controls[0].Controls[i].Name == "tbPaymentDeuda") { deuda = float.Parse(panelMain.Controls[0].Controls[i].Text); } if (panelMain.Controls[0].Controls[i].Name == "tbPaymentDepo") { deposito = float.Parse(panelMain.Controls[0].Controls[i].Text); } if (panelMain.Controls[0].Controls[i].Name == "tbPaymentRest") { restan = float.Parse(panelMain.Controls[0].Controls[i].Text); } } if (Util.IsJsonObject(lbMainData.Text)) { JObject obj = JObject.Parse(lbMainData.Text); models.Payment paym = new models.Payment(); paym.id = 0; paym.account = obj.GetValue("account").ToString(); paym.customer = obj.GetValue("user").ToString();; paym.debt = restan; paym.paid = deposito; paym.date = DateTime.Now.ToString("dd/MM/yyyy hh:mm"); SQLiteService sqlite = new SQLiteService(); if (sqlite.InsertPay(paym) == "OK") { MessageBox.Show("PAGO REGISTRADO"); } else { MessageBox.Show("ERROR DE SISTEMA"); } if (WebService.PostTransaction(paym.account, paym.paid) != "OK") { MessageBox.Show("ERROR EN SERVIDOR"); } lbMainControl.Text = "welcome"; } } }
public bool Update(models.Payment entity) { throw new NotImplementedException(); }
public int Save(models.Payment entity) { return(_paymentRepository.Save(entity)); }