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