private void button4_Click(object sender, EventArgs e)
        {
            FormCollection fc = System.Windows.Forms.Application.OpenForms;

            bool kq = false;

            foreach (Form frm in fc)
            {
                if (frm.Text == "kaPriod and Customer code picker")
                {
                    kq = true;
                    frm.Focus();
                }
            }

            if (!kq)
            {
                View.kaPriodandcustomerpicker kaPriodpicker = new View.kaPriodandcustomerpicker();

                //   Datepick
                kaPriodpicker.ShowDialog();
                string priod        = kaPriodpicker.priod;
                string customercode = kaPriodpicker.customercode;

                DateTime fromdate = kaPriodpicker.fromdate;
                DateTime todate   = kaPriodpicker.todate;
                bool     chon     = kaPriodpicker.kq;


                if (chon)
                {
                    string connection_string = Utils.getConnectionstr();
                    LinqtoSQLDataContext dc  = new LinqtoSQLDataContext(connection_string);


                    #region  // view sales volume

                    var rs33 = from tbl_kasale in dc.tbl_kasales
                               where tbl_kasale.Priod == priod &&
                               tbl_kasale.Sold_to == double.Parse(customercode) &&
                               tbl_kasale.Cogs != null
                               select new
                    {
                        tbl_kasale.Priod,


                        tbl_kasale.Sold_to,
                        tbl_kasale.Sales_Org,
                        tbl_kasale.Sales_District,
                        tbl_kasale.Sales_District_desc,

                        tbl_kasale.Cust_Name,
                        tbl_kasale.Outbound_Delivery,

                        tbl_kasale.Delivery_Date,

                        tbl_kasale.Invoice_Doc_Nr,
                        tbl_kasale.Invoice_Date,

                        tbl_kasale.Key_Acc_Nr,
                        ///tbl_kasale.c,

                        tbl_kasale.Mat_Group,
                        tbl_kasale.Mat_Group_Text,
                        tbl_kasale.Mat_Number,
                        tbl_kasale.Mat_Text,

                        tbl_kasale.Currency,


                        PCs = tbl_kasale.EC,
                        tbl_kasale.UoM,
                        //    tbl_kasalesTemp.EmptyCountValue,
                        COGS = tbl_kasale.Cogs,
                        //     tbl_kasalesTemp.Litter,
                        //    tbl_kasalesTemp.NETP,
                        //   tbl_kasalesTemp.NSR,
                        //    tbl_kasalesTemp.
                        //    EC = tbl_kasalesTemp.PC,

                        //     tbl_kasalesTemp.UC,

                        UserUpdate = tbl_kasale.Username,
                        tbl_kasale.id,
                    };



                    if (rs33.Count() >= 0)
                    {
                        Viewtable viewtbl = new Viewtable(rs33, dc, "COGS DATA PRIOD: " + priod + " OF CUSTOMER CODE " + customercode, 00);// view code 22 la can viet cogs

                        viewtbl.ShowDialog();
                        //    viewtbl.Focus();
                    }

                    #endregion
                }
            }
        }
        private void button3_Click_1(object sender, EventArgs e)
        {
            //     kaPriodandcustomerpicker
            // XmlReadMode



            FormCollection fc = System.Windows.Forms.Application.OpenForms;

            bool kq = false;

            foreach (Form frm in fc)
            {
                if (frm.Text == "kaPriod and Customer code picker")
                {
                    kq = true;
                    frm.Focus();
                }
            }

            if (!kq)
            {
                string connection_string = Utils.getConnectionstr();

                LinqtoSQLDataContext dc = new LinqtoSQLDataContext(connection_string);
                dc.CommandTimeout = 0;

                View.kaPriodandcustomerpicker kaPriodpicker = new View.kaPriodandcustomerpicker();


                kaPriodpicker.ShowDialog();

                string priod        = kaPriodpicker.priod;
                string customercode = kaPriodpicker.customercode;
                string fromcode     = kaPriodpicker.fromcode;
                string tocode       = kaPriodpicker.tocode;
                bool   onlycust     = kaPriodpicker.onlycust;
                bool   fromcodeto   = kaPriodpicker.fromcodeto;



                bool chon = kaPriodpicker.kq;
                if (chon & onlycust == true)
                {
                    #region show so da chon



                    var rs = from tbl_kasale in dc.tbl_kasales
                             where tbl_kasale.Priod == priod &&
                             tbl_kasale.Sold_to == double.Parse(customercode)

                             select new
                    {
                        tbl_kasale.Priod,
                        tbl_kasale.Sales_District,
                        tbl_kasale.Sales_District_desc,
                        tbl_kasale.Sales_Org,
                        tbl_kasale.Sold_to,
                        tbl_kasale.Cust_Name,
                        tbl_kasale.Outbound_Delivery,
                        tbl_kasale.Key_Acc_Nr,
                        tbl_kasale.Delivery_Date,
                        tbl_kasale.Invoice_Doc_Nr,
                        tbl_kasale.Invoice_Date,
                        tbl_kasale.Currency,
                        tbl_kasale.Mat_Group,
                        tbl_kasale.Mat_Group_Text,
                        tbl_kasale.Mat_Number,
                        tbl_kasale.Mat_Text,

                        PCs = tbl_kasale.EC,
                        tbl_kasale.UoM,
                        EC = tbl_kasale.PC,

                        tbl_kasale.UC,
                        tbl_kasale.Litter,
                        tbl_kasale.GSR,

                        tbl_kasale.NSR,



                        tbl_kasale.Username,
                        tbl_kasale.id
                    };

                    Viewtable viewtbl = new Viewtable(rs, dc, "SALES DATA PRIOD: " + priod + " OF CUSTOMER " + customercode, 55);// view code 1 la can viet them lenh

                    viewtbl.ShowDialog();
                    #endregion
                }

                if (chon & fromcodeto == true)
                {
                    #region show so da chon



                    var rs = from tbl_kasale in dc.tbl_kasales
                             where tbl_kasale.Priod == priod &&
                             tbl_kasale.Sold_to >= double.Parse(fromcode) &&
                             tbl_kasale.Sold_to <= double.Parse(tocode)

                             select new
                    {
                        tbl_kasale.Priod,
                        tbl_kasale.Sales_District,
                        tbl_kasale.Sales_District_desc,
                        tbl_kasale.Sales_Org,
                        tbl_kasale.Sold_to,
                        tbl_kasale.Cust_Name,
                        tbl_kasale.Outbound_Delivery,
                        tbl_kasale.Key_Acc_Nr,
                        tbl_kasale.Delivery_Date,
                        tbl_kasale.Invoice_Doc_Nr,
                        tbl_kasale.Invoice_Date,
                        tbl_kasale.Currency,
                        tbl_kasale.Mat_Group,
                        tbl_kasale.Mat_Group_Text,
                        tbl_kasale.Mat_Number,
                        tbl_kasale.Mat_Text,

                        PCs = tbl_kasale.EC,
                        tbl_kasale.UoM,
                        EC = tbl_kasale.PC,

                        tbl_kasale.UC,
                        tbl_kasale.Litter,
                        tbl_kasale.GSR,

                        tbl_kasale.NSR,



                        tbl_kasale.Username,
                        tbl_kasale.id
                    };

                    Viewtable viewtbl = new Viewtable(rs, dc, "SALES DATA PRIOD: " + priod + " FROM CODE " + fromcode + " TO CODE " + tocode, 55);// view code 1 la can viet them lenh

                    viewtbl.ShowDialog();
                    #endregion
                }
            }
        }