public DataTable GetCourseFee(TeacherDetailsEntryDao teacherDetailsDao)
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "Select *from CourseManagement_T Where Course_Name='" + teacherDetailsDao.Subject + "'";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable IsExistTeacherSubQualiDB(TeacherDetailsEntryDao teacherDetailsEntryDao)
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "select *from TeacherManagement_T where Teacher_Name='" + teacherDetailsEntryDao.TeacherName + "' and Subject='" + teacherDetailsEntryDao.Subject + "' and Qualification='" + teacherDetailsEntryDao.Qualification + "'";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable IsExistCourseNameInDB(CourseDetailsEntryDao courseDetailsEntryDao)
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string qurery = "select *from CourseManagement_T where Course_Name='" + courseDetailsEntryDao.CourseName + "'";
try
{
SqlDataAdapter da = new SqlDataAdapter(qurery, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable GetUserMatchOnDB(RegistrationFormEntryDao registrationFormEntryDao)
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "select *from User_T where User_Name='" + registrationFormEntryDao.UserName + "' and Password='******'";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable GetAllCourseNameDB()
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "select *from CourseManagement_T";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable GetStudentByCourseName(CourseDetailsEntryDao courseDetailsEntryDao)
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "Select *from StudentManagement_T Where Selected_Course='" + courseDetailsEntryDao.CourseName + "'";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable ShowAllTeacherDetailsInGrid()
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "Select *from TeacherManagement_T";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public DataTable StudentSearchByRegistrationNoDB(AddStudentEntryDao addStudentEntryDao)
{
DataTable dt = new DataTable();
ConnectionClass connection = new ConnectionClass();
string query = "Select *from StudentManagement_T Where Registration_No='" + addStudentEntryDao.RegistraionNo + "'";
try
{
SqlDataAdapter da = new SqlDataAdapter(query, connection.GetOpen());
da.Fill(dt);
}
catch
{
dt = null;
}
finally
{
connection.GetClose();
}
return(dt);
}
public string GetCourseUpdatedByvalue(CourseDetailsEntryDao courseDetailsEntryDao)
{
string isUpdate = "";
ConnectionClass connection = new ConnectionClass();
string query = "update CourseManagement_T set Course_Name='" + courseDetailsEntryDao.CourseName + "', Course_Fee='" + courseDetailsEntryDao.CourseFee + "',Duration='" + courseDetailsEntryDao.Duration + "' where id='" + courseDetailsEntryDao.Id + "'";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isUpdate = "Update Successful.";
}
catch
{
isUpdate = "Update Fialed!";
}
finally
{
connection.GetClose();
}
return(isUpdate);
}
public string GetInsertOnDB(RegistrationFormEntryDao registrationFormEntryDao)
{
string isSuccess = "";
ConnectionClass connection = new ConnectionClass();
string query = "Insert Into User_T values('" + registrationFormEntryDao.UserName + "','" + registrationFormEntryDao.Password + "')";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isSuccess = "Save Successful.";
}
catch
{
isSuccess = "Not Saved!";
}
finally
{
connection.GetClose();
}
return(isSuccess);
}
public string GetUpdateStudentByValue(AddStudentEntryDao addStudentEntryDao)
{
string isUpdate = "";
ConnectionClass connection = new ConnectionClass();
string query = "update StudentManagement_T set Student_Name='" + addStudentEntryDao.StudentName + "', Address='" + addStudentEntryDao.Address + "',Email='" + addStudentEntryDao.Email + "' where id='" + addStudentEntryDao.Id + "'";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isUpdate = "Update Successful.";
}
catch
{
isUpdate = "Update Fialed!";
}
finally
{
connection.GetClose();
}
return(isUpdate);
}
public string GetInsertTeacherDetailsDB(TeacherDetailsEntryDao teacherDetailsEntryDao)
{
string isSuccess = "";
ConnectionClass connection = new ConnectionClass();
string query = "Insert Into TeacherManagement_T values('" + teacherDetailsEntryDao.TeacherName + "','" + teacherDetailsEntryDao.Subject + "','" + teacherDetailsEntryDao.Qualification + "')";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isSuccess = "Save Successful.";
}
catch
{
isSuccess = "Not Saved!";
}
finally
{
connection.GetClose();
}
return(isSuccess);
}
public string GetUpdateTeachersRowByValue(TeacherDetailsEntryDao teacherDetailsEntryDao)
{
string isUpdate = "";
ConnectionClass connection = new ConnectionClass();
string query = "update TeacherManagement_T set Teacher_Name='" + teacherDetailsEntryDao.TeacherName + "', Subject='" + teacherDetailsEntryDao.Subject + "',Qualification='" + teacherDetailsEntryDao.Qualification + "' where id='" + teacherDetailsEntryDao.Id + "'";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isUpdate = "Update Successful.";
}
catch
{
isUpdate = "Update Fialed!";
}
finally
{
connection.GetClose();
}
return(isUpdate);
}
public string AddstudentDB(AddStudentEntryDao addStudentEntryDao)
{
string isSuccess = "";
ConnectionClass connection = new ConnectionClass();
string query = "Insert Into StudentManagement_T (Student_Name,Address,Email,Date,Selected_Course,Course_Fee,Selected_Teacher,Registration_No) values('" + addStudentEntryDao.StudentName + "','" + addStudentEntryDao.Address + "','" + addStudentEntryDao.Email + "','" + addStudentEntryDao.Date + "','" + addStudentEntryDao.SelectedCourse + "','" + addStudentEntryDao.CourseFee + "','" + addStudentEntryDao.SelectedTeacher + "','" + addStudentEntryDao.RegistraionNo + "')";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isSuccess = "Save Successful.";
}
catch
{
isSuccess = "Not Saved!";
}
finally
{
connection.GetClose();
}
return(isSuccess);
}
public string GetDeleteById(CourseDetailsEntryDao courseDetailsEntryDao)
{
string isDelete = "";
ConnectionClass connection = new ConnectionClass();
string query = "delete from CourseManagement_T where id=" + courseDetailsEntryDao.Id + "";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isDelete = "Delete Successful.";
}
catch (Exception r)
{
isDelete = "Delete Failed!";
}
finally
{
connection.GetClose();
}
return(isDelete);
}
public string GetInsertInDb(CourseDetailsEntryDao courseDetailsEntryDao)
{
string isSuccess = "";
ConnectionClass connection = new ConnectionClass();
string query = "Insert Into CourseManagement_T values('" + courseDetailsEntryDao.CourseName + "','" + courseDetailsEntryDao.CourseFee + "','" + courseDetailsEntryDao.Duration + "')";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isSuccess = "Save Success.";
}
catch
{
isSuccess = "Not Saved!";
}
finally
{
connection.GetClose();
}
return(isSuccess);
}
public string GetUpdateStudentFeeDB(AddStudentEntryDao addStudentEntryDao)
{
string isSuccess = "";
ConnectionClass connection = new ConnectionClass();
string query = "Update StudentManagement_T Set Paid_Fee='" + addStudentEntryDao.PaidFee + "',Remaining_Fee='" + addStudentEntryDao.RemainingFee + "' Where Registration_No='" + addStudentEntryDao.RegistraionNo + "'";
try
{
SqlCommand cmd = new SqlCommand(query, connection.GetOpen());
cmd.ExecuteNonQuery();
isSuccess = "Upate Successful.";
}
catch
{
isSuccess = "Update Failed!";
}
finally
{
connection.GetClose();
}
return(isSuccess);
}