public IHttpActionResult updatePassword(school_details sd)
        {
            Boolean d = new AdminSignup().updateExamSubjectsList(sd);

            if (d)
            {
                rs.code    = 200;
                rs.message = "succesfully data has updated";
                return(Content(HttpStatusCode.OK, rs));
            }
            else
            {
                rs.code    = 100;
                rs.message = "failed to update";
                return(Content(HttpStatusCode.OK, rs));
            }
        }
        public IHttpActionResult adminSignUp(school_details sdetails)
        {
            Boolean bb = new AdminSignup().addingSchool(sdetails);

            if (bb)
            {
                sdetails.insert_date = DateTime.Now;
                enty.school_details.Add(sdetails);
                enty.SaveChanges();

                rs.code    = 200;
                rs.message = "succesfully data has inserted";
                return(Content(HttpStatusCode.OK, rs));
            }
            else
            {
                rs.code    = 100;
                rs.message = "failed to insert";
                return(Content(HttpStatusCode.OK, rs));
            }
        }
        public IHttpActionResult homeScreenCount(school_details scl)
        {
            var studets_count = (from a in enty.student_details

                                 where a.school_id == scl.school_id
                                 select a.student_father_name
                                 ).Count();

            var teachers_count = (from a in enty.teacher_details
                                  where a.school_id == scl.school_id
                                  select a.teacher_first_name
                                  ).Count();


            //var sections_count = (from a in enty.Sections
            //                      where a.school_id == scl.school_id
            //                      select a.section_name
            //              ).Count();

            //var classes_count = (from a in enty.class_details
            //                      where a.school_id == scl.school_id
            //                      select a.class_name
            //              ).Count();

            //var exams_count = (from a in enty.exam_details
            //                      where a.school_id == scl.school_id
            //                      select a.exam_type
            //              ).Count();

            //var class_exams_count = (from a in enty.examclass_details
            //                      where a.school_id == scl.school_id
            //                      select a.examclass_class
            //              ).Count();


            rs.studentsCount  = studets_count;
            rs.teacherssCount = teachers_count;
            return(Content(HttpStatusCode.OK, rs));
        }
        public IHttpActionResult guestLogin(school_details gsignUp)
        {
            Boolean b = new AdminSignup().adminLogin(gsignUp);

            ResponseMessage rs = new ResponseMessage();

            if (b)
            {
                var studets_count = (from a in enty.school_details
                                     where a.password == gsignUp.password
                                     select new
                {
                    a.school_id,
                    a.admin_image,
                    a.school_image,
                    a.admin_full_name,
                    a.school_name
                });

                rs.code    = 200;
                rs.message = "succesfully logged in";
                rs.Data    = studets_count;

                return(Content(HttpStatusCode.OK, rs));


                /* List<school_details> login = new List<school_details>();
                 *
                 * using (EdujinniEntity entitu = new EdujinniEntity())
                 * {
                 *   login = entitu.school_details.OrderBy(a => a.school_name).ToList();
                 *   int cc = login.Count;
                 *   for (int i = 0; i < cc; i++)
                 *   {
                 *
                 *       // mnumber = login[i].school_phone_no;
                 *       //mnumber = Convert.ToInt64(login[i].admin_mobile_no);
                 *       email = login[i].admin_email;
                 *       password = login[i].password;
                 *
                 *       if (gsignUp.password.Equals(password) && gsignUp.admin_email.Equals(email))
                 *       {
                 *               count = 1;
                 *               scl_id = login[i].school_id;
                 *               break;
                 *       }
                 *       else
                 *       {
                 *           count = 0;
                 *       }
                 *   }
                 * }
                 * if (count == 1)
                 * {
                 *
                 *   rs.code = 200;
                 *   rs.schoolId = scl_id;
                 *   rs.message = "succesfully logged in";
                 *
                 *   return Content(HttpStatusCode.OK, rs);
                 * }
                 * else
                 * {
                 *   rs.code = 100;
                 *
                 *   rs.message = "failed to logged in";
                 *
                 *   return Content(HttpStatusCode.OK, rs); ;
                 * }
                 *
                 */
            }
            else
            {
                rs.code    = 100;
                rs.message = "failed to loggedin";

                return(Content(HttpStatusCode.OK, rs));
            }
        }