示例#1
0
        private void pictureBox1_Click(object sender, EventArgs e)
        {
            DataTable dt = Bazaa.naplata(comboBox1.Text);


            string vremeDolaska = dt.Rows[0][2].ToString();
            string tiptreninga  = dt.Rows[0][3].ToString();

            MessageBox.Show("Cena po terminu" + "\n" + tiptreninga);

            vremeDolaska = vremeDolaska.Substring(0, 2);

            int vrDolaska = int.Parse(vremeDolaska.ToString());
            int razlika;

            DateTime vrOdlaska = DateTime.Now;

            string vremeOdlaska = vrOdlaska.ToString();


            var o   = vrOdlaska;
            var hmo = new DateTime(o.Year, o.Month, o.Day, o.Hour, o.Minute, 0);

            razlika = o.Hour - vrDolaska;

            if (razlika < 0)
            {
                razlika = razlika + 24;
            }

            MessageBox.Show("Vreme dolaska" + "\n" + razlika);

            switch (tiptreninga)
            {
            case "Individualni mesecni trening":
                id = 2;
                break;

            case "Grupni mesecni trening":
                id = 1;
                break;

            case "Grupni trening po terminu":
                id = 3;
                break;

            case "Individualni trening po terminu":
                id = 4;
                break;
            }

            DataTable df = Bazaa.naplata1(id);

            string cena        = df.Rows[0][0].ToString();
            int    cenaInt     = int.Parse(df.Rows[0][0].ToString());
            string imeiprezime = comboBox1.Text;

            try
            {
                SqlConnection con = new SqlConnection("data source=AMINA;initial catalog=Gym;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;");

                con.Open();
                SqlCommand sdae = new SqlCommand("Update termin set arhivirano='1' from termin where ImeiPrezime = '" + comboBox1.Text + "' ", con);
                sdae.ExecuteNonQuery();

                PrintDocument p = new PrintDocument();
                p.PrintPage += delegate(object sender1, PrintPageEventArgs e1)
                {
                    e1.Graphics.DrawString("Ime: " + imeiprezime + "\n" + "Tip treninga: " + tiptreninga + "\n" + " Cena: " + cena + "\n" + "Vreme dolaska:" + vrDolaska, new Font("Times New Roman", 12), new SolidBrush(Color.Black), new RectangleF(0, 0, p.DefaultPageSettings.PrintableArea.Width, p.DefaultPageSettings.PrintableArea.Height));
                };
                try
                {
                    p.Print();
                }
                catch (Exception ex)
                {
                    throw new Exception("Exception Occured While Printing", ex);
                }
                con.Close();
            }
            catch (Exception ex)
            {
                throw new Exception("Exception Occured While Printing", ex);
            }
        }