private void setDataSourceToGrid()
{
//here um setting the data source for this data grid
systemManager objsystemManager = new systemManager();
dgvSubject.DataSource = objsystemManager.GetSubjectData();
}
public void selectedStuRowDetails()
{
if (isSelected == true)
{
Student objstuSemAllocationData = new Student();
objstuSemAllocationData.ObjSemesters = new Semesters();
objstuSemAllocationData.ObjSubjects = new Subjects();
objstuSemAllocationData.StudentID = SelectedStudentID;
objstuSemAllocationData.universityID = cmbStudentID.Text;
objstuSemAllocationData.FullName = txtStudentName.Text;
objstuSemAllocationData.ObjSemesters.SemesterID = SelectedSemesterID;
objstuSemAllocationData.ObjSemesters.SemesterCode = cmbSemster.Text;
objstuSemAllocationData.ObjSemesters.SemesterName = selectedSemesterName;
objstuSemAllocationData.ObjSubjects.SubjectID = SelectedSubjectID;
objstuSemAllocationData.ObjSubjects.SubjectCode = selectedSubCode;
objstuSemAllocationData.StuSemConfigID = SelectedStuSemConfigID;
systemManager objsystemManagerUpdateSem = new systemManager();
if (updateSelected == true)
{
objsystemManagerUpdateSem.updateStuSemConfig(objstuSemAllocationData);
}
if (deleteSelected == true)
{
objsystemManagerUpdateSem.DeleteStuSemConfig(objstuSemAllocationData);
}
}
}
private void setDataSourceToGrid()
{
//here um setting the data source for this data grid
dgvStudentDetails.DataSource = null;
systemManager objsystemManager = new systemManager();
List <Student> lstStudent = new List <Student>();
lstStudent = objsystemManager.GetStudentBasicData();
StudentDetails objStudentDetails;
List <StudentDetails> lstStudentDetails = new List <StudentDetails>();
foreach (var item in lstStudent)
{
objStudentDetails = new StudentDetails();
objStudentDetails.firstName = item.FullName;
objStudentDetails.age = item.age;
objStudentDetails.dateOfBirth = item.dateOfBirth;
objStudentDetails.universityID = item.universityID;
objStudentDetails.StudentID = item.StudentID;
objStudentDetails.adress = item.adress;
objStudentDetails.DepartmentName = item.ObjDepartment.DepartmentName;
objStudentDetails.DepartmentID = item.ObjDepartment.DepartmentID;
lstStudentDetails.Add(objStudentDetails);
}
dgvStudentDetails.DataSource = lstStudentDetails;
}
public void selectedStuRowDetails()
{
if (isSelected == true)
{
Student objUpdateStudens = new Student();
objUpdateStudens.StudentID = SelectedStudentID;
objUpdateStudens.firstName = txtFirstName.Text;
objUpdateStudens.universityID = txtUniversityID.Text;
objUpdateStudens.age = Convert.ToInt32(txtAge.Text);
objUpdateStudens.adress = txtAdress.Text;
objUpdateStudens.dateOfBirth = dtpBirthDate.Value;
objUpdateStudens.ObjDepartment = new Department();
objUpdateStudens.ObjDepartment.DepartmentID = Convert.ToInt32(cmbDepartment.SelectedValue);
systemManager objsystemManagerUpdateSem = new systemManager();
if (updateSelected == true)
{
objsystemManagerUpdateSem.UpdateStudentDetails(objUpdateStudens);
}
if (deleteSelected == true)
{
objsystemManagerUpdateSem.DeleteStudentDetails(objUpdateStudens);
}
}
}
private void setDataSourceToGrid()
{
dgvStuSubSemConfig.AutoGenerateColumns = false;
dgvStuSubSemConfig.DataSource = null;
systemManager objsystemManager = new systemManager();
List <Student> lststuSemAllocationData = new List <Student>();
lststuSemAllocationData = objsystemManager.getStuSemDataToGrid();
stuSemAllocationData objstuSemAllocationData;
List <stuSemAllocationData> lstStuSem = new List <stuSemAllocationData>();
foreach (var item in lststuSemAllocationData)
{
objstuSemAllocationData = new stuSemAllocationData();
objstuSemAllocationData.StuSemConfigID = item.StuSemConfigID;
objstuSemAllocationData.StudentID = item.StudentID;
objstuSemAllocationData.universityID = item.universityID;
objstuSemAllocationData.FullName = item.FullName;
objstuSemAllocationData.SemesterID = item.ObjSemesters.SemesterID;
objstuSemAllocationData.SemesterCode = item.ObjSemesters.SemesterCode;
objstuSemAllocationData.SemesterName = item.ObjSemesters.SemesterName;
objstuSemAllocationData.SubjectID = item.ObjSubjects.SubjectID;
objstuSemAllocationData.SubjectCode = item.ObjSubjects.SubjectCode;
objstuSemAllocationData.SubjectName = item.ObjSubjects.SubjectName;
lstStuSem.Add(objstuSemAllocationData);
}
dgvStuSubSemConfig.DataSource = lstStuSem;
}
private void btnViewSemReport_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
systemManager objsystemManager = new systemManager();
dt = objsystemManager.ViewSemestersData();
if (dt != null && dt.Rows.Count > 0)
{
ReportDocument rptDoc = new ReportDocument();
rptSemesterDetails rpt = new rptSemesterDetails();
rptDoc = rpt;
rptDoc.SetDataSource(dt);
frmReportViewer objfrmReportViewer = new frmReportViewer(rptDoc);
objfrmReportViewer.Show();
}
else
{
MessageBox.Show("No Records");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void setDataSourceToGrid()
{
//here um setting the data source for this data grid
dgvSemDetails.DataSource = null;
systemManager objsystemManager = new systemManager();
dgvSemDetails.DataSource = objsystemManager.GetSemestersData();
}
private void setDataSourceToGrid()
{
//here um setting the data source for this data grid and hide the coloumn name which is called
//clmDepratmentID
systemManager objsystemManager2 = new systemManager();
dgvDepartment.DataSource = objsystemManager2.LoadDepartmentToGrid();
this.dgvDepartment.Columns["clmDepartmentID"].Visible = false;
}
public void SetcmbStudentID()
{
systemManager objsystemManager = new systemManager();
cmbStudentID.DataSource = objsystemManager.GetStudentAllocationData();
cmbStudentID.DisplayMember = "universityID";
cmbStudentID.ValueMember = "StudentID";
}
private List <Student> GetStudentAllocatedData()
{
systemManager objsystemManager = new systemManager();
List <Student> lstStudentData = new List <Student>();
lstStudentData = objsystemManager.GetStudentAllocationData();
return(lstStudentData);
}
public void setSemToCmb()
{
systemManager objsystemManager1 = new systemManager();
cmbSemesterSelect.DataSource = objsystemManager1.GetSemestersData();
cmbSemesterSelect.DisplayMember = "SemesterCode";
cmbSemesterSelect.ValueMember = "SemesterID";
cmbSemesterSelect.SelectedIndex = -1;
}
public void setSubToCmb()
{
systemManager objsystemManager2 = new systemManager();
cmbSubjectSelect.DataSource = objsystemManager2.GetSubjectData();
cmbSubjectSelect.DisplayMember = "SubjectName";
cmbSubjectSelect.ValueMember = "SubjectID";
cmbSubjectSelect.SelectedIndex = -1;
}
public void setCmbSemester()
{
systemManager objsystemManager = new systemManager();
cmbSemster.DataSource = objsystemManager.GetSemeDatatoStuSemAllocation();
cmbSemster.ValueMember = "SemesterID";
cmbSemster.DisplayMember = "SemesterCode";
//because of this department combo's display inedex will shown as a blank index
cmbSemster.SelectedIndex = -1;
}
public void getSubjectDetails()
{
Subjects objSubjects = new Subjects();
objSubjects.SubjectCode = txtSubjectCode.Text;
objSubjects.SubjectName = txtSubjectName.Text;
systemManager objsystemManager = new systemManager();
objsystemManager.insertSubjects(objSubjects);
}
//method which loads the semesters and name into the combobox.
public void setcmbSubject()
{
systemManager objsystemManager = new systemManager();
cmbSubject.DataSource = objsystemManager.GetSubjectData();
cmbSubject.ValueMember = "SubjectID";
cmbSubject.DisplayMember = "SubjectName";
//because of this department combo's display inedex will shown as a blank index
cmbSubject.SelectedIndex = -1;
}
//method which loads the departments to the combobox.
public void setCmbDepartment()
{
systemManager objsystemManager = new systemManager();
cmbDepartment.DataSource = objsystemManager.LoadDepartmentToGrid();
cmbDepartment.ValueMember = "DepartmentID";
cmbDepartment.DisplayMember = "DepartmentName";
//because of this department combo's display inedex will shown as a blank index
cmbDepartment.SelectedIndex = -1;
}
//method which loads the studentID and name into the combobox.
public void setCmbStudent()
{
systemManager objsystemManager = new systemManager();
cmbStudentID.DataSource = objsystemManager.GetStudentBasicData();
cmbStudentID.ValueMember = "StudentID";
cmbStudentID.DisplayMember = "universityID";
//because of this department combo's display inedex will shown as a blank index
cmbStudentID.SelectedIndex = -1;
}
public void getSemesterDetails()
{
Semesters objSemesters = new Semesters();
objSemesters.SemesterName = txtSemName.Text;
objSemesters.SemesterCode = txtSemCode.Text;
//passing above values as a object to the business layer.
systemManager objsystemManager = new systemManager();
objsystemManager.insertSemesters(objSemesters);
}
public void getDepartmentData()
{
//setting the user userinputs to a object of student class which is in the shared library
Department objDepartment1 = new Department();
objDepartment1.DepartmentName = txtDeptName.Text;
objDepartment1.DepartmenCode = txtDeptCode.Text;
//passing above values as a object to the business layer.
systemManager objsystemManager = new systemManager();
objsystemManager.insertDepartments(objDepartment1);
}
//to get user inputs
public void getData()
{
//creating a object from student class
Student objStudent = new Student();
objStudent.firstName = txtFirstName.Text;
//objStudent.lastName = txtLastName.Text;
objStudent.universityID = txtUniversityID.Text;
objStudent.age = Convert.ToInt32(txtAge.Text);
objStudent.dateOfBirth = Convert.ToDateTime(dtpBirthDate.Value);
objStudent.adress = txtAdress.Text;
objStudent.DepartmentID = Convert.ToInt32(cmbDepartment.SelectedValue);
systemManager objsystemManager = new systemManager();
objsystemManager.InsertStudentDetails(objStudent);
}
public void SendDataToBAL()
{
Student objStudent = new Student();
objStudent.ObjSemesters = new Semesters();
//objStudent.ObjSemesters.SemSubConfigID = Convert.ToInt32(cmbSemster.SelectedValue);
objStudent.ObjSemesters.SemesterCode = cmbSemster.Text;
objStudent.ObjSemesters.SemesterID = Convert.ToInt32(cmbSemster.SelectedValue);
objStudent.StudentID = Convert.ToInt32(cmbStudentID.SelectedValue);
objStudent.universityID = cmbStudentID.Text;
systemManager objsystemManager = new systemManager();
objsystemManager.sendStuSemConfig(objStudent);
MessageBox.Show("Student configuration data has been recorded successfully");
}
public void selectedSemeRowDetails()
{
if (isSelected == true)
{
Semesters objUpdateSemesters = new Semesters();
objUpdateSemesters.SemesterCode = txtSemCode.Text;
objUpdateSemesters.SemesterName = txtSemName.Text;
objUpdateSemesters.SemesterID = selectedSemID;
systemManager objsystemManagerUpdateSem = new systemManager();
if (updateSelected == true)
{
objsystemManagerUpdateSem.passSemesterDetailsUpdate(objUpdateSemesters);
}
if (deleteSelected == true)
{
objsystemManagerUpdateSem.passSemesterDetailsDelete(objUpdateSemesters);
}
}
}
private void selectedStuRowDetails()
{
if (isSelected == true)
{
Subjects objSubjects = new Subjects();
objSubjects.SubjectName = txtSubjectName.Text;
objSubjects.SubjectCode = txtSubjectCode.Text;
objSubjects.SubjectID = selectedSubID;
systemManager objSystemManager = new systemManager();
if (updateSelected == true)
{
objSystemManager.updateSubjects(objSubjects);
updateSelected = false;
}
if (deleteSelected == true)
{
objSystemManager.deleteSubjects(objSubjects);
deleteSelected = false;
}
}
}
private void selectedStuRowDetails()
{
if (isSelected == true)
{
Department objDepartment = new Department();
objDepartment.DepartmentName = txtDeptName.Text;
objDepartment.DepartmenCode = txtDeptCode.Text;
objDepartment.DepartmentID = selectedDeptID;
systemManager objSystemManager = new systemManager();
if (updateSelected == true)
{
objSystemManager.updateDepartments(objDepartment);
updateSelected = false;
}
if (deleteSelected == true)
{
objSystemManager.deleteDepartments(objDepartment);
deleteSelected = false;
}
}
}
//created an array which holds all the values of semIDs
//public Array insertSubSemGridToDb()
//{
// int[] semID = new int[dgvSemesterSubject.RowCount];
// int[] subID = new int[dgvSemesterSubject.RowCount];
// foreach (DataGridViewRow dr in dgvSemesterSubject.Rows)
// {
// for (int i =0; i < dgvSemesterSubject.RowCount; i++)
// {
// int semesterID = Convert.ToInt32(dr.Cells[0].Value);
// semID[i] = i;
// }
// for (int x =0; x < dgvSemesterSubject.RowCount; x++)
// {
// int subjectID = Convert.ToInt32(dr.Cells[0].Value);
// subID[x] = x;
// }
// }
// return semID;
//}
private void btnUpdateDatabse_Click(object sender, EventArgs e)
{
try
{
List <SemesterSubject> saveList = (List <SemesterSubject>)dgvSemesterSubject.DataSource;
if (saveList.Count != 0)
{
systemManager objsystemManager = new systemManager();
Subjects objSubjects = null;
List <Subjects> lstSubjects = new List <Subjects>();
foreach (var item in saveList)
{
objSubjects = new Subjects();
objSubjects.ObjSemesters = new Semesters();
objSubjects.SubjectID = item.SubjectID;
objSubjects.ObjSemesters.SemesterID = item.SemesterID;
lstSubjects.Add(objSubjects);
}
bool res = objsystemManager.insertSubSem(lstSubjects);
if (res)
{
MessageBox.Show("Saved Successfully");
dgvSemesterSubject.DataSource = null;
}
}
else
{
MessageBox.Show("No records has found....\nPlease set values to the feilds before update", "System warning");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void sendStuMarks()
{
systemManager objsystemManager = new systemManager();
bool res = objsystemManager.SaveMarks(this.FillStudent());
}
