private void BindGrid(string sql)
{
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
if (dt.Rows.Count > 0)
{
FeeId = dt.Rows[0]["FeeId"].ToString();
txtStudentName.Text = dt.Rows[0]["StudentName"].ToString();
txtRollNo.Text = dt.Rows[0]["RollNo"].ToString();
txtCourse.Text = dt.Rows[0]["Course"].ToString();
txtSemester.Text = dt.Rows[0]["Semester"].ToString();
objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic");
foreach (DataRow dr in dt.Rows)
{
dataGridFeeView.Rows.Add();
dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["Id"].Value = dr["FeeId"];
dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["CategoryName"].Value = dr["CategoryName"];
dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["PaidDate"].Value = dr["PaidDate"];
dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["TotalAmount"].Value = dr["TotalAmount"];
dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["PaidAmount"].Value = dr["PaidAmount"];
dataGridFeeView.Rows[dataGridFeeView.Rows.Count - 1].Cells["DueAmount"].Value = dr["DueAmount"];
}
}
else
{
MessageBox.Show("Không tìm thấy!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSearch.Focus();
txtSearch.SelectAll();
}
}
private void GetDataBind(string sql)
{
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
if (dt.Rows.Count > 0)
{
_TeacherId = dt.Rows[0]["Id"].ToString();
txtTeacherName.Text = dt.Rows[0]["TeacherName"].ToString();
if (dt.Rows[0]["Gender"].ToString().Trim().Equals("Male") == true)
{
this.rdMale.Checked = true;
}
else
{
this.rdFemale.Checked = true;
}
txtAddress.Text = dt.Rows[0]["Address"].ToString();
mtxtRegisterDate.Text = dt.Rows[0]["RegisterDate"].ToString();
txtPhoneNo.Text = dt.Rows[0]["PhoneNo"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
cmbExperience.Text = dt.Rows[0]["Experience"].ToString();
ObjGlobal.getPictureFromDatabase(picTeacher, dt, 0, "TPhoto");
}
else
{
MessageBox.Show("Record not found!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSearch.Focus();
txtSearch.SelectAll();
}
}
private void BindDataB(string sql)
{
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
foreach (DataRow dr in dt.Rows)
{
CourseId = Convert.ToInt32(dr["Id"]);
}
}
private void cmbSubjectName_SelectedIndexChanged(object sender, EventArgs e)
{
var sql = "SELECT * from SubjectDetails Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "' AND SubjectName='" + cmbSubjectName.Text + "'";
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
foreach (DataRow dr in dt.Rows)
{
this.SubjCode = Convert.ToInt32(dr["Id"]);
}
}
private void cmbSemester_SelectedIndexChanged(object sender, EventArgs e)
{
var sql = "SELECT * from Course Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "'";
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
foreach (DataRow dr in dt.Rows)
{
this.CId = dt.Rows[0]["Id"].ToString();
}
}
private void BindDataA(string sql)
{
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
this.cmbSemester.Items.Clear();
this.cmbSemester.DropDownHeight = 106;
foreach (DataRow dr in dt.Rows)
{
this.cmbSemester.Items.Add(dr["Semester"]);
}
}
private void cmbTeacherName_SelectedIndexChanged(object sender, EventArgs e)
{
picTeacher.Image = null;
var sql = "SELECT * from TeacherRegister Where TeacherName='" + cmbTeacherName.Text + "'";
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
foreach (DataRow dr in dt.Rows)
{
this.TeacherId = Convert.ToInt32(dr["Id"]);
objGlobal.getPictureFromDatabase(picTeacher, dt, 0, "TPhoto");
}
}
private void cmbStudentName_SelectedIndexChanged(object sender, EventArgs e)
{
var sql = "SELECT * from RegStudent Where StudentName='" + cmbStudentName.Text + "'";
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
foreach (DataRow dr in dt.Rows)
{
this.Sid = dr["Id"].ToString();
this.txtRollNo.Text = dr["RollNo"].ToString();
objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic");
}
}
private void cmbCourse_SelectedIndexChanged(object sender, EventArgs e)
{
this.cmbSemester.Enabled = true;
var sql = "SELECT * from Course Where CourseName='" + cmbCourse.Text + "'";
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
this.cmbSemester.Items.Clear();
this.cmbSemester.DropDownHeight = 106;
foreach (DataRow dr in dt.Rows)
{
this.cmbSemester.Items.Add(dr["Semester"]);
}
}
private void cmbSemester_SelectedIndexChanged(object sender, EventArgs e)
{
this.cmbSubjectName.ResetText();
this.cmbSubjectName.Items.Clear();
this.cmbSubjectName.DropDownHeight = 106;
BindDataB("SELECT * from Course Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "'");
var sql = "SELECT * from SubjectDetails Where CourseName='" + cmbCourse.Text + "' AND Semester='" + cmbSemester.Text + "'";
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
foreach (DataRow dr in dt.Rows)
{
this.cmbSubjectName.Items.Add(dr["SubjectName"]);
}
}
private void GetDataBind(string sql)
{
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
if (dt.Rows.Count > 0)
{
txtStudentName.Text = dt.Rows[0]["StudentName"].ToString();
txtRollNo.Text = dt.Rows[0]["RollNo"].ToString();
txtCourse.Text = dt.Rows[0]["Course"].ToString();
txtSemester.Text = dt.Rows[0]["Semester"].ToString();
objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic");
}
else
{
MessageBox.Show("Record not found!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSearch.Focus();
txtSearch.SelectAll();
}
}
private void GetDataBind(string sql)
{
var getdata = new lib.DatabaseConnection();
DataTable dt = new DataTable();
dt = getdata.getSearchData(sql);
if (dt.Rows.Count > 0)
{
StudentId = dt.Rows[0]["Id"].ToString();
txtRollNo.Text = dt.Rows[0]["RollNo"].ToString();
txtStudentName.Text = dt.Rows[0]["StudentName"].ToString();
if (dt.Rows[0]["Gender"].ToString().Trim().Equals("Male") == true)
{
this.rdMale.Checked = true;
}
else
{
this.rdFemale.Checked = true;
}
txtAddress.Text = dt.Rows[0]["Address"].ToString();
mtxtDOB.Text = dt.Rows[0]["DateOfBirth"].ToString();
mtxtAdmissionDate.Text = dt.Rows[0]["AdmissionDate"].ToString();
txtPhoneNo.Text = dt.Rows[0]["PhoneNo"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
cmbCountry.Text = dt.Rows[0]["Country"].ToString();
cmbShift.Text = dt.Rows[0]["Shift"].ToString();
cmbCourse.Text = dt.Rows[0]["Course"].ToString();
cmbSemester.Text = dt.Rows[0]["Semester"].ToString();
objGlobal.getPictureFromDatabase(picStudent, dt, 0, "StudentPic");
}
else
{
MessageBox.Show("Record not found!", Global.Caption, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSearch.Focus();
txtSearch.SelectAll();
}
}
