protected void saveButton_Click(object sender, EventArgs e) { try { if (isFormValid()) { CourseDetailsEntryDao courseDetailsEntryDao = new CourseDetailsEntryDao(); courseDetailsEntryDao.CourseName = courseNameTextBox.Text; courseDetailsEntryDao.CourseFee = Convert.ToInt32(courseFeeTextBox.Text); courseDetailsEntryDao.Duration = courseDurationDdlist.SelectedItem.Text; IsExistCourseNameDal isExistCourseNameDal = new IsExistCourseNameDal(); DataTable dt = isExistCourseNameDal.IsExistCourseNameInDB(courseDetailsEntryDao); if (dt.Rows.Count == 0) { CourseDetailsEntryDal courseDetailsEntryDal = new CourseDetailsEntryDal(); string save = courseDetailsEntryDal.GetInsertInDb(courseDetailsEntryDao); if (save != null) { courseNameTextBox.Text = ""; courseFeeTextBox.Text = ""; courseDurationDdlist.ClearSelection(); } } else { Response.Write("Course Name Is Exist!"); //Course Details Update Once Again.... } } } catch (Exception r) { Response.Write(r.Message); } }
protected void allCourseListGrid_RowDeleting1(object sender, GridViewDeleteEventArgs e) { CourseDetailsEntryDao courseDetailsEntrDao = new CourseDetailsEntryDao(); int index = e.RowIndex; courseDetailsEntrDao.Id = ((Label)(allCourseListGrid.Rows[index].FindControl("idLabel"))).Text; CourseDeleteByIdDal courseDeleteByIdDal = new CourseDeleteByIdDal(); string delete = courseDeleteByIdDal.GetDeleteById(courseDetailsEntrDao); if (delete != null) { LoadGrid(); } }
protected void allCourseListGrid_RowUpdating(object sender, GridViewUpdateEventArgs e) { CourseDetailsEntryDao courseDetailsEntryDao = new CourseDetailsEntryDao(); int index = e.RowIndex; courseDetailsEntryDao.Id = ((Label)(allCourseListGrid.Rows[index].FindControl("idLabel"))).Text; courseDetailsEntryDao.CourseName = ((TextBox)(allCourseListGrid.Rows[index].FindControl("courseNameTextBox"))).Text; courseDetailsEntryDao.CourseFee = Convert.ToInt32(((TextBox)(allCourseListGrid.Rows[index].FindControl("courseFeeTextBox"))).Text); courseDetailsEntryDao.Duration = ((TextBox)(allCourseListGrid.Rows[index].FindControl("durationTextBox"))).Text; CourseUpdateByValueDal courseUpdateByValueDal = new CourseUpdateByValueDal(); string update = courseUpdateByValueDal.GetCourseUpdatedByvalue(courseDetailsEntryDao); if (update != null) { allCourseListGrid.EditIndex = -1; LoadGrid(); } }
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 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 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 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); }
protected void subjectDdList_SelectedIndexChanged(object sender, EventArgs e) { CourseDetailsEntryDao courseDetailsEntryDao = new CourseDetailsEntryDao(); courseDetailsEntryDao.CourseName = subjectDdList.SelectedValue; StudentSearchByCourseNameDal studentSearchByCourseNameDal = new StudentSearchByCourseNameDal(); DataTable dt = studentSearchByCourseNameDal.GetStudentByCourseName(courseDetailsEntryDao); if (dt.Rows.Count > 0) { studentListDdList.Items.Clear(); studentListDdList.Items.Add("--Select--"); foreach (DataRow dr in dt.Rows) { studentListDdList.Items.Add(new ListItem(dr["Student_Name"].ToString(), dr["Registration_No"].ToString())); } } else { studentListDdList.Items.Clear(); studentListDdList.Items.Add("--Empty List--"); } }