示例#1
0
        private void btnNew_Click(object sender, EventArgs e)
        {
            if (tbCustomer.Text != "")
            {
                InvoiceNumber = Invoice_DbCommunication.GetInvoiceNumber();
                InvoiceCounter++;

                Invoice_DbCommunication.AddInvoice(Customer_DbCommunication.GetCustomerDBID(CustomerPick.selectecCustomerInfo.Name), InvoiceCounter, mtbDate.Text, tbValuta.Text, cbDocType.SelectedItem.ToString(), tbDescription.Text);

                dgvInvoices.DataSource = DbCommunication.DisplayData(SearchQuery);

                ResetBoxes();
                SetInvoiceNumberTextBox();
            }
            else
            {
                MessageBox.Show
                (
                    "Одберете купувач (F1).",
                    "Грешка",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error
                );
            }
        }
示例#2
0
        private void dgvCustomers_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            // If a valid row is selected       If the last row is not selected (because it's empty)
            if (e.RowIndex != -1 && e.RowIndex != dgvCustomers.Rows.Count - 1)
            {
                string    TaxNum = dgvCustomers.Rows[e.RowIndex].Cells[1].Value.ToString();
                string    query  = $"SELECT * FROM Customers WHERE Даночен_број='{TaxNum}'";
                DataTable dt     = DbCommunication.DisplayData(query);

                tbName.Text           = dt.Rows[0].ItemArray[1].ToString();
                tbTaxNum.Text         = dt.Rows[0].ItemArray[2].ToString();
                tbEMBS.Text           = dt.Rows[0].ItemArray[3].ToString();
                tbBankNum1.Text       = dt.Rows[0].ItemArray[4].ToString();
                tbBankNum2.Text       = dt.Rows[0].ItemArray[5].ToString();
                cbBank.SelectedIndex  = cbBank.FindString(dt.Rows[0].ItemArray[6].ToString());
                tbAddress.Text        = dt.Rows[0].ItemArray[7].ToString();
                tbContactPerson1.Text = dt.Rows[0].ItemArray[8].ToString();
                tbContactPerson2.Text = dt.Rows[0].ItemArray[9].ToString();
                tbPhone1.Text         = dt.Rows[0].ItemArray[10].ToString();
                tbPhone2.Text         = dt.Rows[0].ItemArray[11].ToString();
                tbEmail.Text          = dt.Rows[0].ItemArray[12].ToString();
                tbCity.Text           = dt.Rows[0].ItemArray[13].ToString();
                tbZipCode.Text        = dt.Rows[0].ItemArray[14].ToString();
                tbDescription.Text    = dt.Rows[0].ItemArray[15].ToString();

                Customer.SetCustomer(tbName.Text, tbTaxNum.Text, tbEMBS.Text, tbBankNum1.Text, tbBankNum2.Text, cbBank.SelectedItem.ToString(), tbAddress.Text, tbCity.Text, tbZipCode.Text, tbContactPerson1.Text, tbContactPerson2.Text, tbPhone1.Text, tbPhone2.Text, tbEmail.Text, tbDescription.Text);
            }
            else
            {
                ClearTextBoxes();
            }
        }
示例#3
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (DbCommunication.Exists("Products", "Шифра", mtbCode.Text) == 1)
            {
                DbCommunication.Delete("Products", "Шифра", mtbCode.Text);
                UpdateTable();

                MessageBox.Show
                (
                    "Артиклот е успешно избришан!",
                    "Избриши",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Information
                );
            }
            else
            {
                MessageBox.Show
                (
                    "Тој артикл не постои!",
                    "Грешка",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error
                );
            }
        }
示例#4
0
        private void dgvProducts_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != -1)
            {
                string Code = dgvProducts.Rows[e.RowIndex].Cells[0].Value.ToString();
                //SQLiteCommand cmd = new SQLiteCommand($"SELECT * FROM Products WHERE Шифра='{Code}'", connection);
                DataTable dt = DbCommunication.DisplayData($"SELECT * FROM Products WHERE Шифра='{Code}'");

/*                connection.Open();
 *
 *              DataTable dt = new DataTable();
 *              SQLiteDataAdapter adapter = new SQLiteDataAdapter(cmd);
 *              adapter.Fill(dt);*/

                item.Code = dt.Rows[0].ItemArray[1].ToString();
                item.Name = dt.Rows[0].ItemArray[2].ToString();
                item.Unit = dt.Rows[0].ItemArray[3].ToString();
                item.Tax  = decimal.Parse(dt.Rows[0].ItemArray[4].ToString());

                if (dt.Rows[0].ItemArray[7].ToString() != "")   // Цената на артиклот земена од база
                {
                    item.Price = decimal.Parse(dt.Rows[0].ItemArray[7].ToString());
                }

                if (dt.Rows[0].ItemArray[11].ToString() != "")  // Залихата на артиклот земена од база
                {
                    item.Quantity = 1;
                }

                //connection.Close();

                this.Close();
            }
        }
示例#5
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (DbCommunication.Exists("Customers", "Даночен_број", tbTaxNum.Text) == 1)
            {
                DbCommunication.Delete("Customers", "Даночен_број", tbTaxNum.Text);
                UpdateTable();

                MessageBox.Show
                (
                    "Коминтентот е успешно избришан!",
                    "Избриши",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Information
                );
            }
            else
            {
                MessageBox.Show
                (
                    "Тој коминтент не постои!",
                    "Грешка",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error
                );
            }
        }
示例#6
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (DbCommunication.Exists("Employees", "ЕМБГ", mtbEMBG.Text) == 1)
            {
                DbCommunication.Delete("Employees", "ЕМБГ", mtbEMBG.Text);
                UpdateTable();

                MessageBox.Show
                (
                    "Вработениот е успешно избришан!",
                    "Избриши",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Information
                );
            }
            else
            {
                MessageBox.Show
                (
                    "Toj вработен не постои!",
                    "Грешка",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error
                );
            }
        }
示例#7
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if ((DbCommunication.Exists("Invoices", "InvNumber", InvoiceNumber.ToString()) == 1) && (InvoiceNumber == InvoiceCounter))
            {
                DbCommunication.Delete("Invoices", "InvNumber", InvoiceNumber.ToString());
                DbCommunication.Delete("InvoiceItems", "Invoice_ID", InvoiceNumber.ToString());

                dgvInvoices.DataSource = DbCommunication.DisplayData(SearchQuery);
                InvoiceNumber          = Invoice_DbCommunication.GetInvoiceNumber();
                InvoiceCounter         = InvoiceNumber;

                MessageBox.Show
                (
                    "Фактурата е успешно избришана!",
                    "Избриши",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Information
                );
            }
            else
            {
                MessageBox.Show
                (
                    "Таа фактура не може да се избрише!",
                    "Грешка",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error
                );
            }
        }
示例#8
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (tbTaxNum.Text == "" || tbAddress.Text == "" || tbCity.Text == "" || tbName.Text == "")
            {
                errorProviderTaxNum.SetError(tbTaxNum, "Задолжително внесете даночен број");
                errorProviderAddress.SetError(tbAddress, "Задолжително внесете адреса и град");
                errorProviderName.SetError(tbName, "Задолжително внесете назив на коминтент");
            }
            else
            {
                errorProviderTaxNum.SetError(tbTaxNum, null);

                if (DbCommunication.Exists("Customers", "Даночен_број", tbTaxNum.Text) < 1)
                {
                    Customer_DbCommunication.AddCustomer
                    (
                        tbName.Text,
                        tbTaxNum.Text,
                        tbEMBS.Text,
                        tbBankNum1.Text,
                        tbBankNum2.Text,
                        cbBank.GetItemText(cbBank.SelectedItem),
                        tbAddress.Text,
                        tbCity.Text,
                        tbZipCode.Text,
                        tbContactPerson1.Text,
                        tbContactPerson2.Text,
                        tbPhone1.Text,
                        tbPhone2.Text,
                        tbEmail.Text,
                        tbDescription.Text
                    );

                    UpdateTable();

                    MessageBox.Show
                    (
                        "Коминтентот е успешно додаден!",
                        "Сними",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Information
                    );
                }
                else
                {
                    MessageBox.Show
                    (
                        "Тој коминтент веќе постои!",
                        "Грешка",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Error
                    );
                }
            }
        }
示例#9
0
        private void OutgoingInvoices_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            selectedCustomer = new CustomerInfo();

            InitDefaultSettings();
            InvoiceNumber  = Invoice_DbCommunication.GetInvoiceNumber();
            InvoiceCounter = InvoiceNumber;
            SetInvoiceNumberTextBox();

            dgvInvoices.DataSource = DbCommunication.DisplayData(SearchQuery);
        }
示例#10
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (dgvInvoiceItems.SelectedCells.Count == 1)
            {
                if (InvoiceItems_DbCommunication.Exists("Invoice_ID", selectedItemID, "Item_ID", tbCode.Text) == 1)
                {
                    InvoiceItems_DbCommunication.Delete("Invoice_ID", selectedItemID, "Item_ID", tbCode.Text);
                    dgvInvoiceItems.DataSource = DbCommunication.DisplayData(SearchQuery);

                    ClearTextBoxes();
                }
            }
        }
示例#11
0
 private void btnInvoiceItems_Click(object sender, EventArgs e)
 {
     if (dgvInvoices.SelectedCells.Count == 1)
     {
         Form invoiceItems = new InvoiceItems();
         if (invoiceItems.ShowDialog() == DialogResult.Cancel)
         {
             SetPriceSumTextBoxes();
             Invoice_DbCommunication.SetPricesForInvoice(decimal.Parse(tbPriceWithoutTax.Text), decimal.Parse(tbTax.Text), decimal.Parse(tbTotalPrice.Text), InvoiceNumber);
             dgvInvoices.DataSource = DbCommunication.DisplayData(SearchQuery);
         }
     }
     else
     {
         MessageBox.Show("Одберете фактура.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
示例#12
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            if (dgvInvoiceItems.SelectedCells.Count == 1)
            {
                InvoiceItems_DbCommunication.EditInvoiceItem(OutgoingInvoices.InvoiceNumber, tbCode.Text, decimal.Parse(tbQuantity.Text), decimal.Parse(tbPrice.Text));

                MessageBox.Show
                (
                    "Артиклот е успешно променет!",
                    "Промени",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Information
                );

                dgvInvoiceItems.DataSource = DbCommunication.DisplayData(SearchQuery);
            }
        }
示例#13
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (tbName.Text == "" || tbLastname.Text == "" || mtbEMBG.Text.Length < 13 || mtbPhone.Text.Length < 11 || tbIdNumber.Text.Length < 8)
            {
                errorProviderEMBG.SetError(mtbEMBG, "Полето за ЕМБГ е задолжително");
                errorProviderName.SetError(tbName, "Полето за Име е задолжително");
                errorProviderLastname.SetError(tbLastname, "Полето за Презиме е задолжително");
                errorProviderPhone.SetError(mtbPhone, "Полето за Телефон е задолжително");
                errorProviderIdNumber.SetError(tbIdNumber, "Полето за Број на Лична Карта е задолжително");
            }
            else
            {
                if (DbCommunication.Exists("Employees", "ЕМБГ", mtbEMBG.Text) < 1)
                {
                    string Start = dtpStart.Value.ToString("HH:mm:ss - dd MMM, yyyy");
                    Employee_DbCommunication.AddEmployee(tbName.Text, tbLastname.Text, mtbEMBG.Text, tbSalary.Text, Start, tbAddress.Text, tbPosition.Text, tbIdNumber.Text, mtbPhone.Text, tbBank.Text, mtbBankNumber.Text, rtbNote.Text);

                    UpdateTable();

                    MessageBox.Show
                    (
                        "Вработениот е успешно додаден!",
                        "Сними",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Information
                    );

                    errorProviderEMBG.Clear();
                    errorProviderName.Clear();
                    errorProviderLastname.Clear();
                    errorProviderPhone.Clear();
                    errorProviderIdNumber.Clear();
                }
                else
                {
                    MessageBox.Show
                    (
                        "Тој вработен веќе постои!",
                        "Грешка",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Error
                    );
                }
            }
        }
示例#14
0
        private void dgvInvoices_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex != dgvInvoices.Rows.Count - 1 && e.RowIndex != -1)
            {
                InvoiceNumber = int.Parse(dgvInvoices.Rows[e.RowIndex].Cells[2].Value.ToString().Substring(0, 5));
                string customerName = dgvInvoices.Rows[e.RowIndex].Cells[0].Value.ToString();

                DataTable dt = Invoice_DbCommunication.DisplayCustomerData(customerName);

                selectedCustomer.Name    = dt.Rows[0].ItemArray[0].ToString();
                selectedCustomer.Address = dt.Rows[0].ItemArray[1].ToString();
                selectedCustomer.City    = dt.Rows[0].ItemArray[2].ToString();

                tbCustomer.Text = selectedCustomer.Name;

                SetInvoiceNumberTextBox();
                SetPriceSumTextBoxes();
                dgvInvoices.DataSource = DbCommunication.DisplayData(SearchQuery);
            }
        }
示例#15
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            if (mtbCode.Text == "" || tbProductName.Text == "" || cbUnit.SelectedIndex == -1 || cbTaxGroup.SelectedIndex == -1)
            {
                errorProviderCode.SetError(mtbCode, "Полето за шифра е задолжително");
                errorProviderProduct.SetError(tbProductName, "Полето за назив на артиклот е задолжително");
                errorProviderUnit.SetError(cbUnit, "Одберете единица мерка");
                errorProviderTaxGroup.SetError(cbTaxGroup, "Одберете даночна група");
            }
            else
            {
                if (DbCommunication.Exists("Products", "Шифра", mtbCode.Text) < 1)
                {
                    Product_DbCommunication.AddProduct(mtbCode.Text, tbProductName.Text, cbUnit.GetItemText(cbUnit.SelectedItem), cbTaxGroup.GetItemText(cbTaxGroup.SelectedItem), mtbGroupCode.Text, mtbHelpCode.Text, tbPrice.Text, tbOrigin.Text, tbDescription.Text, cbDDV.Checked == true ? 1 : 0, tbQuantity.Text);
                    UpdateTable();

                    MessageBox.Show
                    (
                        "Артиклот е успешно додаден!",
                        "Сними",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Information
                    );

                    errorProviderCode.Clear();
                    errorProviderProduct.Clear();
                    errorProviderUnit.Clear();
                    errorProviderTaxGroup.Clear();
                }
                else
                {
                    MessageBox.Show
                    (
                        "Тој артикл веќе постои!",
                        "Грешка",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Error
                    );
                }
            }
        }
示例#16
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            decimal ItemTrueQuantity = Product_DbCommunication.GetProductQuantity(item.Code);

            if (item.Quantity <= ItemTrueQuantity)
            {
                if (!DuplicateItem(item.Code))
                {
                    InvoiceItems_DbCommunication.AddInvoiceItem(OutgoingInvoices.InvoiceNumber, item.Code, item.Quantity, item.Price);

                    dgvInvoiceItems.DataSource = DbCommunication.DisplayData(SearchQuery);
                    ClearTextBoxes();
                    Product_DbCommunication.DecreaseQuantity(ItemTrueQuantity - item.Quantity, item.Code);
                }
                else
                {
                    MessageBox.Show
                    (
                        "Ставката веќе постои.",
                        "Грешка",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Information
                    );
                }
            }
            else
            {
                MessageBox.Show
                (
                    "Нема доволно залиха.",
                    "Грешка",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error
                );
            }
        }
示例#17
0
 // Start is called before the first frame update
 void Start()
 {
     dbCommunication = GameObject.FindGameObjectWithTag("dbHandler").GetComponent <DbCommunication>();
 }
示例#18
0
 private void UpdateTable()
 {
     dgvEmployees.DataSource = DbCommunication.DisplayData(SearchQuery);
 }
    protected void GoPayment(string strBankName, string strKey, string strSalt)
    {
        try
        {
            string   strTxnId;
            DateTime dtNow = DateTime.Now;
            strTxnId = dtNow.ToString("yyyyMMdd") + "_" + dtNow.ToString("HHmmssfff") + "_" + Session["ReferenceNo"];

            string[] hashVarsSeq = ConfigurationManager.AppSettings["PAYU_HASH"].Split('|');
            string   hash_string = string.Empty;
            hash_string = "";

            string strAmount      = "1";
            string strProductInfo = "Testing";
            string strFirstName   = "firstname";
            string strLastName    = "lastName";
            string strEmail       = "*****@*****.**";
            string strPhone       = "9999999999";
            string strAddress1    = "address1";
            string strAddress2    = "address2";
            string strUdf1        = "udf1";
            string strUdf2        = "udf2";
            string strUdf3        = "udf3";
            string strUdf4        = "udf4";
            string strUdf5        = "udf5";
            foreach (string hash_var in hashVarsSeq)
            {
                if (hash_var == "key")
                {
                    hash_string = hash_string + strKey;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "txnid")
                {
                    hash_string = hash_string + strTxnId;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "amount")
                {
                    hash_string = hash_string + strAmount;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "productinfo")
                {
                    hash_string = hash_string + strProductInfo;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "firstname")
                {
                    hash_string = hash_string + strFirstName;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "email")
                {
                    hash_string = hash_string + strEmail;//"*****@*****.**";//
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "phone")
                {
                    hash_string = hash_string + strPhone;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "udf2")
                {
                    hash_string = hash_string + strUdf2;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "udf3")
                {
                    hash_string = hash_string + strUdf3;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "udf4")
                {
                    hash_string = hash_string + strUdf4;
                    hash_string = hash_string + '|';
                }
                else if (hash_var == "udf5")
                {
                    hash_string = hash_string + strUdf5;
                    hash_string = hash_string + '|';
                }
                else
                {
                    hash_string = hash_string + (Request.Form[hash_var] != null ? Request.Form[hash_var] : "");// isset if else
                    hash_string = hash_string + '|';
                }
            }

            hash_string += strSalt;// appending SALT

            string hash       = new PayuCommunication().Generatehash512(hash_string).ToLower();
            string strFullUrl = HttpContext.Current.Request.Url.AbsoluteUri;
            string strAction  = ConfigurationManager.AppSettings["PAYU_BASE_URL"];

            System.Collections.Hashtable data = new System.Collections.Hashtable(); // adding values in hash table for data post
            data.Add("hash", hash);
            data.Add("key", strKey);
            data.Add("txnid", strTxnId);
            data.Add("amount", strAmount);
            data.Add("productinfo", strProductInfo);
            data.Add("firstname", strFirstName);
            data.Add("lastname", strLastName);
            data.Add("email", strEmail);
            data.Add("phone", strPhone);
            data.Add("address1", strAddress1);
            data.Add("address2", strAddress2);
            data.Add("city", strFullUrl);
            data.Add("udf2", strUdf2);
            data.Add("udf3", strUdf3);
            data.Add("udf4", strUdf4);
            data.Add("udf5", strUdf5);
            data.Add("surl", "http://localhost:49253/PayuResponse.aspx");
            data.Add("furl", "http://localhost:49253/PayuResponse.aspx");
            data.Add("curl", "http://localhost:49253/PayuResponse.aspx");

            string query   = "INSERT INTO PayuRequestLog(TxnId,InstituteId,PayuId,BankRefNo, RequestTime, Status) VALUES('" + strTxnId + "','" + strFirstName + "','','', 'getdate()', 'IN_PROGESS')";
            int    iResult = new DbCommunication().ExecuteQuery(query);

            string strForm = new PayuCommunication().PostFormSeamless(strAction, data);
            Page.Controls.Add(new LiteralControl(strForm));
        }
        catch (Exception ex)
        {
        }
    }
示例#20
0
 private void DisplayData()
 {
     dgvProducts.DataSource = DbCommunication.DisplayData("SELECT Шифра, Артикл, Мерка, Даночна_група, Групна_шифра, Помошна_шифра, Цена, Потекло, Забелешка, Залиха FROM Products");
 }
示例#21
0
 private void InvoiceItems_Load(object sender, EventArgs e)
 {
     dgvInvoiceItems.DataSource = DbCommunication.DisplayData(SearchQuery);
     tbQuantity.Text            = "1";
 }