private void button2_Click(object sender, EventArgs e)
{
button2.BackColor = Color.LightSkyBlue;
string user = textBox1.Text;
string password = pass1.Text;
string userdb, passworddb;
returnclass rc = new returnclass();
userdb = rc.scalarReturn("select count(ad_id) from administator where ad_name='" + user + "'");
if (userdb.Equals("0"))
{
MessageBox.Show("Invalid user name!");
}
else
{
passworddb = rc.scalarReturn("select ad_password from administator where ad_name='" + user + "'");
if (passworddb.Equals(password))
{
fk_ad = rc.scalarReturn("select ad_id from administator where ad_name='" + user + "'");
Dashboard f = new Dashboard();
f.Show();
}
else
{
MessageBox.Show("Invalid Password!");
}
}
}
private void button1_Click(object sender, EventArgs e)
{
student s = new student();
// s.sfk = Form1.fk_ad;
s.sfk = "1";
s.sdate = System.DateTime.Now.ToShortDateString();
s.sname = textBox1.Text;
s.sfname = textBox2.Text;
if (radioButton1.Checked == true)
{
s.sgender = "male";
}
else if (radioButton2.Checked == true)
{
s.sgender = "female";
}
else
{
MessageBox.Show("Please select gender!");
}
s.saddress = richTextBox1.Text;
MessageBox.Show(i.insert_srecord(s));
student_status sa = new student_status();
sa.year = System.DateTime.Now.Year.ToString();
sa.class_id = Convert.ToInt16(comboBox1.SelectedValue.ToString());
sa.status_student_id = Convert.ToInt32(r.scalarReturn("select max(std_id) from student"));
i.insert_StudentStatus(sa);
textBox5.Text = r.scalarReturn("select max(std_id) from student");
textBox4.Text = textBox5.Text;
} //submit tbn ends
private void button1_Click(object sender, EventArgs e)
{
button1.BackColor = Color.LightGreen;
q = "select s.std_id as 'id',s.std_name as 'Name',s.std_fname AS 'Father name',s.std_gender as 'Gender',s.std_address as 'Address',s.std_admissiondate as 'Admission Date' ,a.ad_name as 'Admin Name' from student s inner join administator a on a.ad_id=s.std_ad_fk_id where s.std_id=" + textBox2.Text;
dataGridView1.DataSource = vc.showrecord(q);
returnclass rc = new returnclass();
string pathquerry = rc.scalarReturn("select img_path from student_img where img_fk=" + textBox2.Text);
if (pathquerry == " ")
{
pictureBox1.Image = Image.FromFile(@"C:\Users\salman\documents\visual studio 2013\Projects\WindowsFormsApplication4\WindowsFormsApplication4\Resources\profile.jpg");
}
else
{
pictureBox1.Image = Image.FromFile(pathquerry);
}
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
private void textBox3_KeyUp(object sender, KeyEventArgs e)
{
textBox1.Text = " ";
textBox2.Text = " ";
radioButton1.Checked = false;
radioButton2.Checked = false;
richTextBox1.Text = " ";
SqlConnection connection = new SqlConnection(connstring);
string sql = "select std_name,std_fname,std_gender,std_address,student_status from student where std_id=" + textBox3.Text;
try
{
connection.Open();
SqlCommand cmd = new SqlCommand(sql, connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader.GetValue(4).ToString().Equals("0"))
{
MessageBox.Show("Student Left!");
}
else if (reader.GetValue(4).ToString().Equals("1"))
{
textBox1.Text = reader.GetValue(0).ToString();
textBox2.Text = reader.GetValue(1).ToString();
if (reader.GetValue(2).ToString().Equals("male"))
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
richTextBox1.Text = reader.GetValue(3).ToString();
// for image
returnclass rc = new returnclass();
string pathquerry = rc.scalarReturn("select img_path from student_img where img_fk=" + textBox3.Text);
if (pathquerry != " ")
{
pictureBox1.Image = Image.FromFile(pathquerry);
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
else
{
// pictureBox1.Image = Image.FromFile(@"C:\Users\Nida\Desktop\Passportsizephoto.JPG");
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
}
button1.Enabled = true;
}
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show("No RECORDS WERE FOUND!");
}
}
private void button1_Click(object sender, EventArgs e)
{
button1.BackColor = Color.LightSteelBlue;
SqlConnection connection = new SqlConnection(connstring);
string sql = "select s.std_id,s.std_name,sa.SA_ID,SA_Class_id,sa.sa_year,c.classname,c.fees from student s inner join STUDENT_STATUS sa on sa.SA_ST_ID=s.std_id inner join classes c on c.class_id=sa.SA_Class_id where sa.sa_year='" + System.DateTime.Now.Year + "' and s.std_id=" + textBox1.Text;
try
{
label2.Text = " ";
label3.Text = " ";
label4.Text = " ";
label5.Text = " ";
connection.Open();
SqlCommand cmd = new SqlCommand(sql, connection);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
button2.Enabled = true;
while (reader.Read())
{
label2.Text = reader.GetValue(1).ToString();
label3.Text = reader.GetValue(5).ToString();
label4.Text = reader.GetValue(6).ToString();
label5.Text = reader.GetValue(2).ToString();
}
string pathquerry = rc.scalarReturn("select img_path from student_img where img_fk=" + textBox1.Text);
if (pathquerry == " ")
{
pictureBox1.Image = Image.FromFile(@"C:\Users\salman\documents\visual studio 2013\Projects\WindowsFormsApplication4\WindowsFormsApplication4\Resources\profile.jpg");
}
else
{
pictureBox1.Image = Image.FromFile(pathquerry);
}
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
string s = rc.scalarReturn("select count(fee_id) from fees where fee_fk_st_id=" + textBox1.Text + " and monthx='" + System.DateTime.Now.Month.ToString() + "'");
if (s.Equals("0"))
{
button2.Enabled = true;
label10.Text = "Unpaid!";
label10.ForeColor = System.Drawing.Color.Red;
}
else
{
label10.Text = "paid!";
button2.Enabled = false;
label10.ForeColor = System.Drawing.Color.Green;
}
}
else
{
MessageBox.Show("no records were found! ");
button2.Enabled = false;
}
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show("No RECORDS WERE FOUND!");
}
}
