postpaid.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace EWALLET
{
    public partial class postpaid : Form
    {
         int bal = 0;
        //public static string sname = "";
        public static string Email = "";
        OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\DOT.NET Practical\EWALLET.mdb");
       
        public postpaid()
        {
            InitializeComponent();
        }

        private void pictureBox3_Click(object sender, EventArgs e)
        {
            seemore s = new seemore();
            s.Show();
            this.Hide();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text.Length != 10)
            {
                MessageBox.Show("Invalid Mobile Number");
            }
            else
            {


                if (textBox1.Text == "" || textBox3.Text == "" || comboBox1.Text == "")
                {
                    MessageBox.Show("Some Data is Missing");
                }
                else
                {


                    pictureBox4.Location = new Point(150, 147);
                    con.Open();
                    OleDbCommand cmd = con.CreateCommand();
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = "Insert into Transcation values('"
                                        + login.Email + "','"
                                        + textBox1.Text + "','"
                                        + comboBox1.Text + "','"
                                        + textBox3.Text + "')";
                    cmd.ExecuteNonQuery();
                    con.Close();
                    //MessageBox.Show("1 record inserted");
                    pictureBox5.Visible = false;
                    pictureBox3.Visible = false;
                    pictureBox7.Visible = false;
                    pictureBox6.Visible = false;
                    pictureBox8.Visible = false;
                    pictureBox9.Visible = false;
                    button3.Visible = false;
                    label9.Text = textBox1.Text;
                    label10.Text = comboBox1.Text;
                    label12.Text = textBox3.Text;
                }
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {

        }

        private void pictureBox5_Click(object sender, EventArgs e)
        {
            textBox3.Text = "155";
        }

        private void pictureBox3_Click_1(object sender, EventArgs e)
        {
            textBox3.Text = "299";
        }

        private void pictureBox7_Click(object sender, EventArgs e)
        {
            textBox3.Text = "329";
        }

        private void pictureBox6_Click(object sender, EventArgs e)
        {
            textBox3.Text = "459";
        }

        private void pictureBox8_Click(object sender, EventArgs e)
        {
            textBox3.Text = "699";
        }

        private void pictureBox9_Click(object sender, EventArgs e)
        {
            textBox3.Text = "999";
        }

        private void button3_Click(object sender, EventArgs e)
        {
            pictureBox5.Visible = true;
            pictureBox3.Visible = true;
            pictureBox7.Visible = true;
            pictureBox6.Visible = true;
            pictureBox8.Visible = true;
            pictureBox9.Visible = true;
        }

        private void postpaid_Load(object sender, EventArgs e)
        {
            pictureBox2.Visible = false;
            pictureBox6.Visible = false;
            pictureBox5.Visible = false;
            pictureBox7.Visible = false;
            pictureBox8.Visible = false;
        }

        private void pictureBox10_Click(object sender, EventArgs e)
        {
            seemore s = new seemore();
            s.Show();
            this.Hide();
        }
        }
    }