private void degreeComoboxData(ComboBox comboBox) { try { DB_Connection.OpenConection(); Query = "select degree_name from StudentRegisration.dbo.Degree"; //SqlDataReader sqlDataReader = DB_Connection.DataReader(Query); SqlDataAdapter sqlDataAdapter = DB_Connection.DataAdapter(Query); DataTable degreeDataTable = new DataTable(); sqlDataAdapter.Fill(degreeDataTable); DB_Connection.CloseConnection(); for (int i = 0; i < degreeDataTable.Rows.Count; i++) { comboBox.Items.Add(degreeDataTable.Rows[i]["degree_name"]); } comboBox_Degree.SelectedIndex = 0; } catch (SqlException) { MessageBox.Show("Conneciton is not Allowed."); } }
public string AuthUser(IFormCollection value) { var email = value["signInEmail"]; var password = value["signInPassword"]; var db = new DB_Connection(); try { db.OpenConnection(); string query = $"SELECT * FROM users WHERE email = '{email}' AND password = '******'"; MySqlCommand cmd = new MySqlCommand(query, db.Connection); MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list if (dataReader.HasRows) { while (dataReader.Read()) { var user = new UserModel(dataReader); dataReader.Close(); db.CloseConnection(); return(user.ToString()); } } return("The User email or pass not exist or doesn't match"); } catch (MySqlException) { return("The User email or pass not exist or doesn't match"); } }
//Delete Student private void deleteStudent(string student_id) { string deleteStudent_Query = " delete from StudentInformation where student_id='" + student_id + "' "; DB_Connection.OpenConection(); DB_Connection.ExecuteNoNQueries(deleteStudent_Query); DB_Connection.CloseConnection(); }
//Panel Department,Degree and Fee private void Button_NewDepartment_Click(object sender, EventArgs e) { Query = "insert into Department (department_name) values('" + textBox_NewDepartment.Text + "') "; DB_Connection.OpenConection(); DB_Connection.ExecuteNoNQueries(Query); DB_Connection.CloseConnection(); if (Constants.messageBoxFunction("Department Added...!")) { textBox_NewDepartment.Text = ""; } }
// Set Report private void generateReport() { DB_Connection.OpenConection(); Query = "select student_id,student_FName,student_LName,student_Department,student_Degree from StudentInformation where student_id='" + student_id + "'"; sqlDataAdapter = DB_Connection.DataAdapter(Query); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); DB_Connection.CloseConnection(); RegisterReportViewer registerReportViewer = new RegisterReportViewer(dataTable); registerReportViewer.Show(); }
private void updateStudentData() { Query = "update StudentInformation set" + " student_FName='" + fname + "', " + " student_LName='" + lname + "', " + " student_Email='" + email + "', " + " student_CNIC='" + cnic + "', " + " student_PhoneNo='" + phone + "', " + " student_Address='" + address + "', " + " student_Department='" + department + "', " + " student_Degree='" + degree + "', " + " student_Class='" + studentClass + "', " + " student_InstallmentCount='" + installments + "' where student_id='" + Constants.student_Id + "' "; DB_Connection.OpenConection(); DB_Connection.ExecuteQueries(Query); DB_Connection.CloseConnection(); resetData(); }
private void makeInstallemnts(int installmentAmount, int installmentCount) { DateTime today = DateTime.Today; dateList = DateFunction(today, installmentCount); DB_Connection.OpenConection(); for (int i = 0; i < installmentCount; i++) { Query = "insert into InstallmentInformation (student_id,installment_Amount,installment_DueDate) values ('" + student_id + "','" + installmentAmount + "','" + dateList.ElementAt(i) + "' ) "; DB_Connection.ExecuteNoNQueries(Query); } DB_Connection.CloseConnection(); if (Constants.messageBoxFunction("Successfull Done!!!")) { resetData(); } }
private void Button_PrintChallan_Click(object sender, EventArgs e) { Constants.student_Id = textBox_SearchStudent.Text; try { DB_Connection.OpenConection(); Query = "select * from StudentInformation where student_id='" + textBox_SearchStudent.Text + "' "; sqlDataAdapter = DB_Connection.DataAdapter(Query); DataTable studentDataTable = new DataTable(); sqlDataAdapter.Fill(studentDataTable); DB_Connection.CloseConnection(); DataGridViewRow gridRow = dataGridView1.CurrentRow; FeeChallanViewer feeChallanViewer = new FeeChallanViewer(gridRow, studentDataTable); feeChallanViewer.Show(); } catch (SqlException) { } }
private void Button_NewFee_Click(object sender, EventArgs e) { try { DB_Connection.OpenConection(); string dep_Id = getDepartmentID(comboBox_Dep.Text); string deg_id = getDegreeID(comboBox_Deg.Text); Query = " insert into Fee (department_id,degree_id,fee) values ( '" + dep_Id + "' , '" + deg_id + "' , '" + textBox_Fee.Text + "') "; DB_Connection.ExecuteNoNQueries(Query); DB_Connection.CloseConnection(); if (Constants.messageBoxFunction("Degree Added...!")) { comboBox_Dep.SelectedIndex = 0; comboBox_Deg.SelectedIndex = 0; textBox_Fee.Text = ""; } } catch (SqlException) { MessageBox.Show("Connection Problem"); } }