void offer_fail_course(string id)
        {
            //get fail courses
            chk_f_frm_reg_crs(id);

            string session = "summer2016";

            //getting course of a specific session and department
            offer_crs_of_session(session, id);

            foreach (var iteam_f_c in fail_reg_crs_list)
            {
                foreach (var itm_crs in offer_crs_list_of_session)
                {
                    if (iteam_f_c.Course_Code == itm_crs.Courses_Table.Course_Code)
                    {
                        Student_courses course = new Student_courses();


                        course.Courses_Id   = itm_crs.Courses_Id;
                        course.Course_Code  = itm_crs.Courses_Table.Course_Code;
                        course.Course_Title = itm_crs.Courses_Table.Course_Title_;
                        course.Cr_Hrs       = itm_crs.Courses_Table.Cr_Hrs;
                        //course.Remark = itm_crs.Remark_title;
                        // course.status = iteam.status_Table.status_title;
                        genrate_offer_crs_list.Add(course);
                        genrated_offer_crs_list.Add(itm_crs);
                        break;
                    }
                }
            }
        }
 //getting all registerd courses of the student of the given student id
 void registerd_coursea(string id)
 {
     reg_crs = crs_db.Registerd_courses_Table.ToList();
     foreach (var iteam in reg_crs)
     {
         Student_courses course = new Student_courses();
         if (id == iteam.Students_Table.registration_id)
         {
             course.Courses_Id   = iteam.Offerd_course_table.Courses_Id;
             course.Course_Code  = iteam.Offerd_course_table.Courses_Table.Course_Code;
             course.Course_Title = iteam.Offerd_course_table.Courses_Table.Course_Title_;
             course.Cr_Hrs       = iteam.Offerd_course_table.Courses_Table.Cr_Hrs;
             course.Remark       = iteam.Remarks_Table.Remark_title;
             course.status       = iteam.status_Table.status_title;
             reg_crs_full_detail.Add(iteam);
             reg_crs_list.Add(course);
         }
     }
     //return reg_crs_list;
 }
        //completing remaning course of semester

        void offer_remning_crs_semester(string id, string semsester)
        {
            //find courses of this semester from reg course of student
            semser_course_from_regcourses(id, semsester);
            //find courses of this semester from offerd course
            semser_course_from_offercourses(id, semsester);
            foreach (var offer_s_crs in offer_semster_course)
            {
                int check = 1;
                //check function of finding register semester course
                foreach (var reg_s_crs in reg_semester_course)
                {
                    //check this condition
                    if (offer_s_crs.Courses_Table.Course_Code == reg_s_crs.Offerd_course_table.Courses_Table.Course_Code)
                    {
                        check++;
                        break;
                    }
                }
                if (check == 1)
                {
                    if (genrate_offer_crs_list.Count() < 7)
                    {
                        //check pre rack cleard and offer
                        if (offer_s_crs.Courses_Table.Pre_requisite_id == null)
                        {
                            //
                            Student_courses course = new Student_courses();


                            course.Courses_Id   = offer_s_crs.Courses_Id;
                            course.Course_Code  = offer_s_crs.Courses_Table.Course_Code;
                            course.Course_Title = offer_s_crs.Courses_Table.Course_Title_;
                            course.Cr_Hrs       = offer_s_crs.Courses_Table.Cr_Hrs;
                            //course.Remark = itm_crs.Remark_title;
                            // course.status = iteam.status_Table.status_title;
                            genrate_offer_crs_list.Add(course);
                            genrated_offer_crs_list.Add(offer_s_crs);
                        }
                        else
                        {
                            foreach (var cours in reg_crs_full_detail)
                            {
                                if (offer_s_crs.Courses_Table.Pre_requisite_id == cours.Offerd_course_table.Courses_Table.Courses_Id && cours.status_Id == 1)
                                {
                                    Student_courses course = new Student_courses();


                                    course.Courses_Id   = offer_s_crs.Courses_Id;
                                    course.Course_Code  = offer_s_crs.Courses_Table.Course_Code;
                                    course.Course_Title = offer_s_crs.Courses_Table.Course_Title_;
                                    course.Cr_Hrs       = offer_s_crs.Courses_Table.Cr_Hrs;
                                    //course.Remark = itm_crs.Remark_title;
                                    // course.status = iteam.status_Table.status_title;
                                    genrate_offer_crs_list.Add(course);
                                    genrated_offer_crs_list.Add(offer_s_crs);

                                    break;
                                }
                            }
                            //check_pre_rack(id, offer_s_crs.Courses_Table.Course_Code);
                        }
                    }
                    //not valid place for this return
                    //check combined condation
                    else
                    {
                        return;
                    }
                }
            }
        }