예제 #1
0
        public Boolean addingAchievemnts(Achievement_details adding)
        {
            List <Achievement_details> list = new List <Achievement_details>();

            using (EdujinniEntity dc = new EdujinniEntity())
            {
                list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList();
                int cc = list.Count;
                for (int i = 0; i < cc; i++)
                {
                    mnumber   = list[i].achievement_type;
                    studentId = list[i].student_id;
                    sclId     = list[i].school_id;

                    if (adding.achievement_type.Equals(mnumber) && adding.student_id.Equals(studentId) && adding.school_id.Equals(sclId))
                    {
                        count = 1;
                        break;
                    }
                    else
                    {
                        count = 0;
                    }
                }
            }

            if (count == 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #2
0
        public Boolean updateAchievements(Achievement_details adetails)
        {
            List <Achievement_details> list = new List <Achievement_details>();

            using (EdujinniEntity dc = new EdujinniEntity())
            {
                list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList();
                int cc = list.Count;
                for (int i = 0; i < cc; i++)
                {
                    int achId = list[i].achievement_id;
                    int sclId = list[i].school_id;
                    //mnumber = list[i].achievement_type;
                    //studentId = list[i].student_id;

                    if (adetails.school_id.Equals(sclId) && adetails.achievement_id.Equals(achId))
                    {
                        count = 1;
                        break;
                    }
                    else
                    {
                        count = 0;
                    }
                }
            }

            if (count == 1)
            {
                using (EdujinniEntity entities = new EdujinniEntity())
                {
                    Achievement_details updatedCustomer = (from c in entities.Achievement_details
                                                           where c.achievement_id == adetails.achievement_id
                                                           where c.school_id == adetails.school_id
                                                           select c).FirstOrDefault();
                    updatedCustomer.class_id   = adetails.class_id;
                    updatedCustomer.section_id = adetails.section_id;
                    updatedCustomer.student_id = adetails.student_id;
                    updatedCustomer.achievement_student_name = adetails.achievement_student_name;
                    updatedCustomer.achievement_description  = adetails.achievement_description;
                    updatedCustomer.achievement_date         = adetails.achievement_date;
                    updatedCustomer.update_date = DateTime.Now;
                    entities.SaveChanges();
                }
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #3
0
        public Boolean deleteAchievements(Achievement_details adata)
        {
            List <Achievement_details> list = new List <Achievement_details>();

            using (EdujinniEntity dc = new EdujinniEntity())
            {
                list = dc.Achievement_details.OrderBy(a => a.achievement_type).ToList();
                int cc = list.Count;
                for (int i = 0; i < cc; i++)
                {
                    int aId = list[i].achievement_id;
                    sclId = list[i].school_id;
                    if (adata.achievement_id.Equals(aId) && adata.school_id.Equals(sclId))
                    {
                        count = 1;
                        break;
                    }
                    else
                    {
                        count = 0;
                    }
                }
            }
            if (count == 1)
            {
                using (EdujinniEntity entities = new EdujinniEntity())
                {
                    Achievement_details custom = (from c in entities.Achievement_details
                                                  where c.achievement_id == adata.achievement_id
                                                  where c.school_id == adata.school_id
                                                  select c).FirstOrDefault();
                    entities.Achievement_details.Remove(custom);
                    entities.SaveChanges();
                }

                return(true);
            }
            else
            {
                return(false);
            }
        }