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");
}
}