Пример #1
0
        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";
        }
Пример #2
0
        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);
        }
Пример #3
0
        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";
                }
            }
        }
Пример #4
0
 public bool Update(models.Payment entity)
 {
     throw new NotImplementedException();
 }
Пример #5
0
 public int Save(models.Payment entity)
 {
     return(_paymentRepository.Save(entity));
 }