protected void saveButton_Click(object sender, EventArgs e)
{
try
{
if (isFormValid())
{
TeacherDetailsEntryDao teacherDetailsEntryDao = new TeacherDetailsEntryDao();
teacherDetailsEntryDao.TeacherName = teacherNameTextBox.Text;
teacherDetailsEntryDao.Subject = courseListDdList.SelectedValue;
teacherDetailsEntryDao.Qualification = qualificationTextBox.Text;
IsExistTeacherSubQualificationDal isExist = new IsExistTeacherSubQualificationDal();
DataTable dt = isExist.IsExistTeacherSubQualiDB(teacherDetailsEntryDao);
if (dt.Rows.Count == 0)
{
TeacherDetailsEntryDal teacherDetailsEntryDal = new TeacherDetailsEntryDal();
string save = teacherDetailsEntryDal.GetInsertTeacherDetailsDB(teacherDetailsEntryDao);
if (save != null)
{
teacherNameTextBox.Text = "";
courseListDdList.ClearSelection();
qualificationTextBox.Text = "";
}
}
else
{
Response.Write("This is exist in course!");
}
}
}
catch (Exception r)
{
Response.Write(r.Message);
}
}
protected void allTeacherListGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
TeacherDetailsEntryDao teacherDetailsEntryDao = new TeacherDetailsEntryDao();
int index = e.RowIndex;
teacherDetailsEntryDao.Id = ((Label)(allTeacherListGridView.Rows[index].FindControl("tIdLabel"))).Text;
TeacherRowDeletedByIdDal teacherRowDeleteByIdDal = new TeacherRowDeletedByIdDal();
string delete = teacherRowDeleteByIdDal.GetDeleteTeacherRowById(teacherDetailsEntryDao);
if (delete != null)
{
LoadInTeacherGrid();
}
}
protected void allTeacherListGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TeacherDetailsEntryDao teacherDetailsEntryDao = new TeacherDetailsEntryDao();
int index = e.RowIndex;
teacherDetailsEntryDao.Id = ((Label)(allTeacherListGridView.Rows[index].FindControl("tIdLabel"))).Text;
teacherDetailsEntryDao.TeacherName = ((TextBox)(allTeacherListGridView.Rows[index].FindControl("teacherNameTextBox"))).Text;
teacherDetailsEntryDao.Subject = ((TextBox)(allTeacherListGridView.Rows[index].FindControl("subjectTextBox"))).Text;
teacherDetailsEntryDao.Qualification = ((TextBox)(allTeacherListGridView.Rows[index].FindControl("qualificationTextBox"))).Text;
TeachersRowUpdatedByValueDal teacherRowsUpdatedByValueDal = new TeachersRowUpdatedByValueDal();
string update = teacherRowsUpdatedByValueDal.GetUpdateTeachersRowByValue(teacherDetailsEntryDao);
if (update != null)
{
allTeacherListGridView.EditIndex = -1;
LoadInTeacherGrid();
}
}
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 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 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 GetDeleteTeacherRowById(TeacherDetailsEntryDao teacherDetailsEntryDao)
{
string isDelete = "";
ConnectionClass connection = new ConnectionClass();
string query = "delete from TeacherManagement_T where id=" + teacherDetailsEntryDao.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);
}
protected void courseListDdList_SelectedIndexChanged(object sender, EventArgs e)
{
TeacherDetailsEntryDao teacherDetailsDao = new TeacherDetailsEntryDao();
teacherDetailsDao.Subject = courseListDdList.SelectedItem.Text;
GetCourseFeeDal getCourseFee = new GetCourseFeeDal();
teacherDetailsDao.Subject = courseListDdList.SelectedItem.Text;
DataTable getFee = getCourseFee.GetCourseFee(teacherDetailsDao);
if (getFee.Rows.Count > 0)
{
courseFeeLabel.Text = getFee.Rows[0]["Course_Fee"].ToString();
}
else
{
courseFeeLabel.Text = "No Fees Found!";
}
TeacherListOnStudentDdlListDal teacherList = new TeacherListOnStudentDdlListDal();
DataTable dt = teacherList.GetAllTeacherByDdlDB(teacherDetailsDao);
if (dt.Rows.Count > 0)
{
teachersDdList.Items.Clear();
teachersDdList.Items.Add("--Select--");
foreach (DataRow dr in dt.Rows)
{
teachersDdList.Items.Add(new ListItem(dr["Teacher_Name"].ToString(), dr["Subject"].ToString()));
}
}
else
{
teachersDdList.Items.Clear();
teachersDdList.Items.Add("--Empty List--");
}
}
