using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace E_Fatura
{
    public partial class Form1 : Form
    {
        DBBaglanti dBBaglanti = new DBBaglanti();
        public string comheader;
        public string parametre;
        public string comdetail;
        public string parametrename;
        public string percent;
        public string percentname;
        public Form1()
        {
            InitializeComponent();
        }

        private void textBox1_Click(object sender, EventArgs e)
        {
            textBox1.Clear();
        }

        private void sorgu_btn_Click(object sender, EventArgs e)
        {

            DBBaglanti dBBaglanti = new DBBaglanti();
            parametre = textBox1.Text;
            if (hb_btn.Checked)
            {
                comheader = "[HB].[GetInvoiceHeader]";
                comdetail = "[HB].[GetInvoiceDetail]";
                parametrename = "@OrderID";
                dBBaglanti.DBInvoicedetail(comdetail, parametre, parametrename);
                dBBaglanti.DBInvoiceheader(comheader, parametre, parametrename);
            }
            else if (n11_btn.Checked)
            {
                comheader = "[N11].[GetInvoiceHeader]";
                comdetail = "[N11].[GetInvoiceDetail]";
                parametrename = "@CargoNumber";
                dBBaglanti.DBInvoicedetail(comdetail, parametre, parametrename);
                dBBaglanti.DBInvoiceheader(comheader, parametre, parametrename);
            }
            else if (ty_btn.Checked)
            {
                comdetail = "[trallesk_ayaz].[GetOrderInvoiceDetailByPackageID]";
                comheader = "[trallesk_ayaz].[GetOrderInvoiceHeaderByPackageID]";
                percent = percent_box.Text;
                parametrename = "@PackageID";
                dBBaglanti.DBInvoicedetail(comdetail, parametre, parametrename, percent);
                dBBaglanti.DBInvoiceheader(comheader, parametre, parametrename, percent);
            }
            else if (cs_btn.Checked)
            {
                comdetail = "[CicekSepeti].[GetInvoiceDetail]";
                comheader = "[CicekSepeti].[GetInvoiceHeader]";
                parametrename = "@partialNumber";
                dBBaglanti.DBInvoicedetail(comdetail, parametre, parametrename);
                dBBaglanti.DBInvoiceheader(comheader, parametre, parametrename);
            }
            //DBBaglanti dBBaglanti = new DBBaglanti();
            //dBBaglanti.DBInvoicedetail(comdetail, parametre, parametrename);
            //dBBaglanti.DBInvoiceheader(comheader, parametre, parametrename);
            txt_adres.Text = dBBaglanti.dbsorgu.Adres;
            txt_faturadi.Text = dBBaglanti.dbsorgu.Fatura_Adi;
            txt_il.Text = dBBaglanti.dbsorgu.Il;
            txt_ilce.Text = dBBaglanti.dbsorgu.Ilce;
            txt_vergidaire.Text = dBBaglanti.dbsorgu.Vergi_Dairesi;
            txt_vergino.Text = dBBaglanti.dbsorgu.Vergi_No;

            dataGridView1.DataSource = dBBaglanti.dbsorgu.Dbsorgu;

        }

        private void ty_btn_CheckedChanged(object sender, EventArgs e)
        {
            percent_box.Visible = true;
            label8.Text = "Paketid Giriniz..";
            label9.Text = "İndirim Yüzdesi";
        }

        private void cs_btn_CheckedChanged(object sender, EventArgs e)
        {
            label9.Text = "";
            percent_box.Visible = false;
            label8.Text = "Kargo No Giriniz..";
        }

        private void hb_btn_CheckedChanged(object sender, EventArgs e)
        {
            label9.Text = "";
            percent_box.Visible = false;
            label8.Text = "Order ID Giriniz..";
        }

        private void n11_btn_CheckedChanged(object sender, EventArgs e)
        {
            label9.Text = "";
            percent_box.Visible = false;
            label8.Text = "Kargo No Giriniz..";
        }
    }
    public class DBBaglanti
    {
        public DBitems.DBSorgu dbsorgu;
        public DBitems.DBSutunlar dbsutunlar;
        public DBBaglanti()
        {
            dbsorgu = new DBitems.DBSorgu();
        }
        public string Constring = "Server=185.210.95.230;Database=trallesk_db;User ID=sa;Password=1963ayaZ*";
        public void DBInvoicedetail(string comdetail, string parametre, string parametrename)
        {
            SqlConnection con = new SqlConnection(Constring);
            SqlCommand com = new SqlCommand(comdetail, con);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.Add(parametrename, SqlDbType.NVarChar).Value = parametre;
            con.Open();
            SqlDataReader data = com.ExecuteReader();
            if (comdetail == "[CicekSepeti].[GetInvoiceDetail]")
            {
                while (data.Read())
                {
                    dbsorgu.Dbsorgu.Add(new DBitems.DBSutunlar
                    {
                        Urun = data["IA_ItemName"].ToString(),
                        Adet = data["IA_Piece"].ToString(),
                        KDV_Haric = data["L_WithOutTaxPrice"].ToString(),
                        KDV = data["L_TAX"].ToString(),
                        KDV_Dahil = data["L_WithTax"].ToString()
                    });
                }
            }
            else if (comdetail == "[HB].[GetInvoiceDetail]")
            {
                while (data.Read())
                {
                    dbsorgu.Dbsorgu.Add(new DBitems.DBSutunlar
                    {
                        Urun = data["IA_ItemName"].ToString(),
                        Adet = data["IA_Piece"].ToString(),
                        KDV_Haric = data["L_WithOutTaxPrice"].ToString(),
                        KDV = data["L_TAX"].ToString(),
                        KDV_Dahil = data["L_WithTax"].ToString()
                    });
                }
            }
            else if (comdetail == "[N11].[GetInvoiceDetail]")
            {
                while (data.Read())
                {
                    dbsorgu.Dbsorgu.Add(new DBitems.DBSutunlar
                    {
                        Urun = data["IA_ItemName"].ToString(),
                        Adet = data["IA_Piece"].ToString(),
                        KDV_Haric = data["L_WithOutTaxPrice"].ToString(),
                        KDV = data["L_TAX"].ToString(),
                        KDV_Dahil = data["L_WithTax"].ToString()
                    });
                }
            }
            con.Close();
            //return dbsorgu.Dbsorgu.Count;
        }
        public void DBInvoicedetail(string comdetail, string parametre, string parametrename, string percent)
        {
            SqlConnection con = new SqlConnection(Constring);
            SqlCommand com = new SqlCommand(comdetail, con);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.Add(parametrename, SqlDbType.NVarChar).Value = parametre;
            com.Parameters.Add("@Percent", SqlDbType.Float).Value = percent;
            con.Open();
            SqlDataReader data = com.ExecuteReader();
            while (data.Read())
            {
                dbsorgu.Dbsorgu.Add(new DBitems.DBSutunlar
                {
                    Urun = data["L_productName"].ToString(),
                    Adet = data["L_quantity"].ToString(),
                    KDV_Haric = data["L_WithOutTaxPrice"].ToString(),
                    KDV = data["L_TAX"].ToString(),
                    KDV_Dahil = data["L_WithTax"].ToString()
                });
            }
            con.Close();
            //return dbsorgu.Dbsorgu.Count;
        }
        public void DBInvoiceheader(string comheader, string parametre, string parametrename)
        {
            SqlConnection con = new SqlConnection(Constring);
            SqlCommand com = new SqlCommand(comheader, con);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.Add(parametrename, SqlDbType.NVarChar).Value = parametre;
            con.Open();
            SqlDataReader data = com.ExecuteReader();
            if (comheader == "[CicekSepeti].[GetInvoiceHeader]")
            {
                while (data.Read())
                {
                    dbsorgu.Fatura_Adi = data["InvoiceFullName"].ToString();
                    dbsorgu.Vergi_No = data["TaxNo"].ToString();
                    dbsorgu.Vergi_Dairesi = data["buyer_taxOffice"].ToString();
                    dbsorgu.Adres = data["InvoiceAddress"].ToString();
                    dbsorgu.Il = data["city"].ToString();
                    dbsorgu.Ilce = data["district"].ToString();
                }
            }
            else if (comheader == "[HB].[GetInvoiceHeader]")
            {
                while (data.Read())
                {
                    dbsorgu.Fatura_Adi = data["InvoiceFullName"].ToString();
                    dbsorgu.Vergi_No = data["TaxNo"].ToString();
                    dbsorgu.Vergi_Dairesi = data["buyer_taxOffice"].ToString();
                    dbsorgu.Adres = data["InvoiceAddress"].ToString();
                    dbsorgu.Il = data["city"].ToString();
                    dbsorgu.Ilce = data["district"].ToString();
                }
            }
            else if (comheader == "[N11].[GetInvoiceHeader]")
            {
                while (data.Read())
                {
                    dbsorgu.Fatura_Adi = data["InvoiceFullName"].ToString();
                    dbsorgu.Vergi_No = data["TaxNo"].ToString();
                    dbsorgu.Vergi_Dairesi = data["buyer_taxOffice"].ToString();
                    dbsorgu.Adres = data["InvoiceAddress"].ToString();
                    dbsorgu.Il = data["city"].ToString();
                    dbsorgu.Ilce = data["district"].ToString();
                }
            }
            con.Close();
        }
        public void DBInvoiceheader(string comheader, string parametre, string parametrename, string percent)
        {
            SqlConnection con = new SqlConnection(Constring);
            SqlCommand com = new SqlCommand(comheader, con);
            com.CommandType = CommandType.StoredProcedure;
            com.Parameters.Add(parametrename, SqlDbType.NVarChar).Value = parametre;
            com.Parameters.Add("@Percent", SqlDbType.Float).Value = percent;
            con.Open();
            SqlDataReader data = com.ExecuteReader();

            while (data.Read())
            {
                dbsorgu.Fatura_Adi = data["IA_fullName"].ToString();
                dbsorgu.Vergi_No = data["C_tcIdentityNumber"].ToString();
                dbsorgu.Vergi_Dairesi = data["IA_district"].ToString();
                dbsorgu.Adres = data["IA_fullAddress"].ToString();
                dbsorgu.Il = data["IA_city"].ToString();
                dbsorgu.Ilce = data["IA_district"].ToString();
            }
            con.Close();
        }
    }
}