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