Exemple #1
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            Manage_Student ms = new Manage_Student();

            this.Hide();
            ms.Show();
        }
Exemple #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con        = new SqlConnection(conStr);
            SqlCommand    checkExist = new SqlCommand("select count(*) from Student where RegistrationNo=@registrationNo", con);

            checkExist.Parameters.AddWithValue("@registrationNo", txtRegNo.Text);
            // checkExist.CommandType = System.Data.CommandType.Text;
            con.Open();
            int asdas = (int)checkExist.ExecuteScalar();

            if (txtRegNo.Text == "" || txtFName.Text == "" || txtLName.Text == "" || txtContact.Text == "" || txtEmail.Text == "" || txtGender.Text == "")
            {
                label8.Visible = true;
                label8.Text    = "Please fill the Required Field....";
            }
            else if (txtRegNo.Text.Count() != 11 || txtRegNo.Text.Split('-')[0].Any(char.IsLetter) || txtRegNo.Text[4] != '-' ||
                     txtRegNo.Text[5] != 'C' || txtRegNo.Text[6] != 'S' || txtRegNo.Text[7] != '-')
            {
                txtRegNo.Focus();
                label8.Visible = true;
                label8.Text    = "i.e 2016-CS-315";
            }
            else if (txtContact.Text.Count() != 12 || txtContact.Text[4] != '-' || txtContact.Text.Any(char.IsLetter) == true)
            {
                label8.Text = "";
                txtContact.Focus();
                lbContact.Text      = "i.e 0123-3456789";
                lbContact.ForeColor = Color.Red;
            }
            else if (isEdit)
            {
                //if (asdas > 0)
                //{
                //    label8.Visible = true;
                //    label8.Text = "Registration No already exist";
                //}
                //else
                //{
                string update = string.Format("update Person set FirstName='{0}', LastName='{1}', Contact='{2}',Email='{3}',DateOfBirth='{4}', Gender=(select Id from Lookup where Value='{5}') where Id='{6}'", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text, id);
                DatabaseConnection.getInstance().executeQuery(update);
                string updateStudent = string.Format("update Student set RegistrationNo='{0}' where Id='{1}'", txtRegNo.Text, id);
                DatabaseConnection.getInstance().executeQuery(updateStudent);
                MessageBox.Show("Data Updated Successfully...");
                txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
                Manage_Student ms = new Manage_Student();
                this.Hide();
                ms.Show();
                //}
            }

            else if (asdas > 0)
            {
                label8.Visible = true;
                label8.Text    = "Registration No already exist";
                con.Close();
            }
            else
            {
                try
                {
                    string countMaxId = string.Format("select max(Id) from Person");
                    var    re         = DatabaseConnection.getInstance().readData(countMaxId);
                    int    count      = 0;
                    while (re.Read())
                    {
                        count = re.GetInt32(0);
                    }
                    string query = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text);
                    DatabaseConnection.getInstance().executeQuery(query);
                    string qwrt = "insert into Student(Id, RegistrationNo) values('" + (count + 1) + "','" + txtRegNo.Text + "')";
                    DatabaseConnection.getInstance().executeQuery(qwrt);
                    MessageBox.Show("Data Inserted Successfully!");
                    txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
                    Manage_Student ms = new Manage_Student();
                    this.Hide();
                    ms.Show();
                }
                catch
                {
                    int    count = 1;
                    string query = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))", txtFName.Text, txtLName.Text, txtContact.Text, txtEmail.Text, Convert.ToDateTime(txtDOB.Value), txtGender.Text);
                    DatabaseConnection.getInstance().executeQuery(query);
                    string qwrt = "insert into Student(Id, RegistrationNo) values('" + count + "','" + txtRegNo.Text + "')";
                    DatabaseConnection.getInstance().executeQuery(qwrt);
                    MessageBox.Show("Data Inserted Successfully!");
                    txtRegNo.Text = ""; txtFName.Text = ""; txtLName.Text = ""; txtContact.Text = ""; txtEmail.Text = ""; txtGender.Text = ""; label8.Text = "";
                    Manage_Student ms = new Manage_Student();
                    this.Hide();
                    ms.Show();
                }
            }
        }