private void btnAddStudent_Click(object sender, EventArgs e) { if (radioMale.Checked) { 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='Male'))", txtFirstName.Text, txtLastName.Text, txtContact.Text, txtEmail.Text, txtDob.Text); DataBaseConnection.getInstance().executeQuery(query); } else { 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='Female'))", txtFirstName.Text, txtLastName.Text, txtContact.Text, txtEmail.Text, txtDob.Text); DataBaseConnection.getInstance().executeQuery(query); } string totalStudent = "select count(*) from Person "; var readPersonLen = DataBaseConnection.getInstance().getRowsCount(totalStudent); string query2 = string.Format("insert into Student(id,RegistrationNo) values('{0}','{1}')", readPersonLen, txtRegNo.Text); DataBaseConnection.getInstance().executeQuery(query2); txtRegNo.Text = ""; txtLastName.Text = ""; txtFirstName.Text = ""; txtEmail.Text = ""; txtDob.Text = ""; txtContact.Text = ""; radioFemale.Checked = false; radioMale.Checked = false; }
private void radioInActive_CheckedChanged(object sender, EventArgs e) { List <student> list_L = new List <student>(); if (radioInActive.Checked) { string query = "select GroupId,AssignmentDate,Student.RegistrationNo,Person.FirstName from GroupStudent join Student on Student.Id=GroupStudent.StudentId join Person on Student.Id=Person.Id where GroupStudent.Status=4"; var result = DataBaseConnection.getInstance().readData(query); while (result.Read()) { student s = new student(); s.GroupAssignmentDate = result.GetDateTime(1).ToString("dd-MM-yyyy"); s.GroupId = Convert.ToString(result.GetInt32(0)); s.Name = result.GetString(3); s.GroupStatus = "In Active"; s.RegistrationNumber = result.GetString(2); list_L.Add(s); } } list_M = list_L; dataGridView1.Visible = false; dgGroups.Visible = true; BindingSource source = new BindingSource(); source.DataSource = list_M; dgGroups.DataSource = source; }
public void Auto() { string st = string.Format("select RegistrationNo from Student left join GroupStudent on Student.Id=GroupStudent.StudentId where GroupStudent.StudentId is null "); da = DataBaseConnection.getInstance().getAllData(st); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { coll.Add(dt.Rows[i]["RegistrationNo"].ToString()); } } else { MessageBox.Show("No Free Student found"); } txtRegistrationSearch.AutoCompleteMode = AutoCompleteMode.Suggest; txtRegistrationSearch.AutoCompleteSource = AutoCompleteSource.CustomSource; txtRegistrationSearch.AutoCompleteCustomSource = coll; }
private void btnAddAdvisor_Click(object sender, EventArgs e) { string query = string.Format("insert into Advisor(Designation,Salary) values((select id from Lookup where Value='" + comboAddesig.Text + "'),'{0}')", txtAdSalary.Text); DataBaseConnection.getInstance().executeQuery(query); comboAddesig.Text = ""; txtAdSalary.Text = ""; }
private void addAdvisor_Load(object sender, EventArgs e) { string query = String.Format("select Value from Lookup where Category='DESIGNATION'"); var des = DataBaseConnection.getInstance().readData(query); while (des.Read()) { comboAddesig.Items.Add(des.GetString(0)); } }
private void btnSearch_Click(object sender, EventArgs e) { string query = string.Format("select id from Student where RegistrationNo='" + txtRegistrationSearch.Text + "'"); var getId = DataBaseConnection.getInstance().readData(query); while (getId.Read()) { stud_list.Add(getId.GetInt32(0)); } List <student> st_L = new List <student>(); foreach (int std in stud_list) { string query2 = string.Format("select Student.RegistrationNo , FirstName,Email from Person join Student on Person.id=Student.id where Person.id='{0}'", std); var result = DataBaseConnection.getInstance().readData(query2); while (result.Read()) { if (result.GetString(0) != "" && result.GetString(2) != "" && result.GetString(1) != "") { student s = new student(); s.RegistrationNumber = result.GetString(0); s.Name = result.GetString(1); s.Email = result.GetString(2); s.Id = Convert.ToString(std); st_L.Add(s); } } } st_L = st_L.Distinct().ToList(); BindingSource si = new BindingSource(); si.DataSource = st_L; dataGridView1.DataSource = si; st_M = st_L; txtRegistrationSearch.Text = ""; }
private void button1_Click(object sender, EventArgs e) { string query = string.Format("insert into GroupOne(Created_On) values('{0}')", DateTime.Now); DataBaseConnection.getInstance().executeQuery(query); string groupQuery = "select * from GroupOne"; var groupList = DataBaseConnection.getInstance().readData(groupQuery); List <int> intList = new List <int>(); while (groupList.Read()) { intList.Add(groupList.GetInt32(0)); } int count = intList.Count(); foreach (student ob in st_M) { string query2 = string.Format("insert into GroupStudent(GroupId,StudentId,Status,AssignmentDate) values('{0}','{1}',(select id from Lookup where Value='InActive'),'{2}')", intList[count - 1], ob.Id, DateTime.Now); DataBaseConnection.getInstance().executeQuery(query2); } txtRegistrationSearch.Text = ""; dataGridView1.DataSource = null; }
// DataBaseConnection.getInstance().conStr = "Data Source=DESKTOP-3RUJBK3\\SQLEXPRESS;Initial Catalog=deProjectMini;Integrated Security=True"; private void button1_Click(object sender, EventArgs e) { string query = string.Format("insert into Project(Description,Title) values('{0}','{1}')", textBox2.Text, textBox1.Text); DataBaseConnection.getInstance().executeQuery(query); }
private void HomePage_Load(object sender, EventArgs e) { DataBaseConnection.getInstance().conStr = "Data Source=DESKTOP-3RUJBK3\\SQLEXPRESS;Initial Catalog=deProjectMini;Integrated Security=True"; }