예제 #1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            panel1.BackColor = Color.FromArgb(130, 11, 19, 43);
            panel3.BackColor = Color.FromArgb(200, 11, 19, 43);
            panel2.BackColor = Color.FromArgb(200, 28, 37, 65);
            panel6.BackColor = Color.FromArgb(255, 39, 40, 56);
            back.BackColor   = Color.FromArgb(100, 139, 40, 56);

            // display date & time

            date.Text = DateTime.Now.ToString("dddd, dd MMMM yyyy");



            panel2.Controls.Add(Dashboard.Instance);
            Dashboard.Instance.Dock = DockStyle.Fill;
            Dashboard.Instance.BringToFront();

            // passing value from login;
            con = new dbconfig();
            con.query("select * from employee_acc where id ='" + identity.Text + "'");
            DataRow row;

            row         = con.queryEx().Rows[0];
            label4.Text = row[1].ToString().Trim() + " " + row[2].ToString().Trim();
            label5.Text = row[15].ToString();
        }
예제 #2
0
 private void Send_message_Load(object sender, EventArgs e)
 {
     con = new dbconfig();
     con.query("select * from employee_acc");
     comboBox1.Items.Clear();
     foreach (DataRow dr in con.queryEx().Rows)
     {
         comboBox1.Items.Add(dr[9].ToString());
     }
 }
예제 #3
0
        private void Create_acc_Load(object sender, EventArgs e)
        {
            con = new dbconfig();
            con.query("Select count(*) from create_acc");
            DataRow row;

            row = con.queryEx().Rows[0];
            textBox4.Enabled = false;
            int    ac = 121122001 + Int32.Parse(row[0].ToString());
            string Ac = Convert.ToString(ac);

            textBox4.Text = Ac;
        }
예제 #4
0
 private void Login_page_Load(object sender, EventArgs e)
 {
     panel1.BackColor        = Color.FromArgb(70, 205, 83, 52);
     panel5.BackColor        = Color.FromArgb(230, 0, 0, 0);
     panel6.BackColor        = Color.FromArgb(100, 0, 0, 0);
     textBox1.SelectionStart = 0;
     comboBox1.Items.Clear();
     comboBox1.SelectedText = "Select type";
     con = new dbconfig();
     con.query("select * from employee_acc");
     foreach (DataRow dr in con.queryEx().Rows)
     {
         comboBox1.Items.Add(dr[15].ToString());
     }
 }
예제 #5
0
 private void button3_Click(object sender, EventArgs e)
 {
     if (textBox8.Text == "" || textBox7.Text == "" || textBox6.Text == "" || textBox5.Text == "" || textBox12.Text == "" || textBox11.Text == "" || textBox14.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox10.Text == "")
     {
         label23.Text      = "*** All feild filup required";
         label23.ForeColor = Color.Red;
     }
     else
     {
         if (button1.Text == "Upload" || button2.Text == "Upload")
         {
             label23.Text      = "*** Upload photo & sinature";
             label23.ForeColor = Color.Red;
         }
         else
         {
             if (comboBox1.Text == "" || comboBox2.Text == "")
             {
                 label23.Text      = "*** Select gander or acount type";
                 label23.ForeColor = Color.Red;
             }
             else
             {
                 if (dateTimePicker1.Value.ToString() == " " || dateTimePicker2.Value.ToString() == " ")
                 {
                     label23.Text = "date of birth & select type";
                 }
                 else
                 {
                     con = new dbconfig();
                     con.query("insert into create_acc(first_name, last_name, father_name, mother_name, mobile_number, email, nid_student_id, gander, dob, address, photo, signature, account_no, opening_date, acount_type, password,employee_id) values('" + textBox8.Text + "','" + textBox7.Text + "','" + textBox6.Text + "','" + textBox5.Text + "','" + textBox12.Text + "','" + textBox11.Text + "','" + textBox14.Text + "','" + comboBox1.Text.ToString() + "','" + dateTimePicker1.Value.ToString() + "','" + textBox3.Text + "',@pic,@pic2,'" + textBox4.Text.ToString() + "','" + dateTimePicker1.Value.ToString() + "','" + comboBox1.Text.ToString() + "','" + textBox10.Text + "','" + identity.Text + "')");
                     con.cmd.Parameters.AddWithValue("@pic", textBox4.Text + ".jpg");
                     con.cmd.Parameters.AddWithValue("@pic2", "s-" + textBox4.Text + ".jpg");
                     con.querynonEx();
                     SaveFileDialog s = new SaveFileDialog();
                     s.Filter = "JPG(*.JPG)|*.jpg|PNG(*.png)|*.png";
                     picture.Save(@"C:\\Users\\vesper\\Desktop\\DBMS project\\Mobile_Banking_System\\Mobile_Banking_System\\Resorces\\UserImage\\" + textBox4.Text + ".jpg", ImageFormat.Jpeg);
                     picture2.Save(@"C:\\Users\\vesper\\Desktop\\DBMS project\\Mobile_Banking_System\\Mobile_Banking_System\\Resorces\\signature\\s-" + textBox4.Text + ".jpg", ImageFormat.Png);
                     MessageBox.Show("Account open seccessfully");
                 }
             }
         }
     }
 }