// //Summary: // This method is used to check Login details public User Login(string emailId, string password) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { return(collegeDBContext.User.Where(m => m.EmailId == emailId && m.Password == password).FirstOrDefault()); } }
// //Summary: // Check User is already Exists or not. //Return: // Return User Entity public User CheckExistUser(User user) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { return(collegeDBContext.User.Where(m => m.EmailId == user.EmailId).FirstOrDefault()); } }
// //Summary: // This method is to get College using code from database //Return: // Returns College object public College GetCollegeByCode(string code) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { return(collegeDBContext.Colleges.Find(code)); } }
// //Summary: // This method is to get college from database //Return: // returns List of Colleges public IEnumerable <College> GetColleges() { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { return(collegeDBContext.Colleges.ToList()); } }
// //Summary: // Check Exists College in Db //Return: // Returns College Entity public College CheckExistCollege(College college) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { return(collegeDBContext.Colleges.Where(c => c.CollegeCode == college.CollegeCode || c.CollegeName == college.CollegeName || c.CollegeWebsite == college.CollegeWebsite).FirstOrDefault()); } }
// //Summary: // This method is used register user details to the database public void SignUp(User user) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { collegeDBContext.User.Add(user); collegeDBContext.SaveChanges(); } }
// //Summary: // This method is to delete college public void DeleteCollege(string code) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { SqlParameter collegeCode = new SqlParameter("@CollegeCode", code); collegeDBContext.Database.ExecuteSqlCommand("College_Delete @CollegeCode", collegeCode); //College college = GetCollegeByCode(code); //collegeDBContext.Colleges.Remove(college); //collegeDBContext.SaveChanges(); } }
// //Summary: // This method is to Update college to database public void UpdateCollege(College college) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { SqlParameter collegeCode = new SqlParameter("@CollegeCode", college.CollegeCode); SqlParameter collegeName = new SqlParameter("@CollegeName", college.CollegeName); SqlParameter collegeWebsite = new SqlParameter("@CollegeWebsite", college.CollegeWebsite); collegeDBContext.Database.ExecuteSqlCommand("College_Update @CollegeCode, @CollegeName, @CollegeWebsite", collegeCode, collegeName, collegeWebsite); //collegeDBContext.Entry(college).State = EntityState.Modified; //collegeDBContext.SaveChanges(); } }
// //Summary: // This method is to Add college to database public void AddCollege(College college) { using (CollegeDBContext collegeDBContext = new CollegeDBContext()) { SqlParameter collegeCode = new SqlParameter("@CollegeCode", college.CollegeCode); SqlParameter collegeName = new SqlParameter("@CollegeName", college.CollegeName); SqlParameter collegeWebsite = new SqlParameter("@CollegeWebsite", college.CollegeWebsite); collegeDBContext.Database.ExecuteSqlCommand("College_Insert @CollegeCode, @CollegeName, @CollegeWebsite", collegeCode, collegeName, collegeWebsite); //collegeDBContext.Colleges.Add(college); //collegeDBContext.SaveChanges(); } }