Example #1
0
 public bool ValidateUser(string userName, string pwd)
 {
     using (var context = new KPCollegeContext())
     {
         var user = context.User.Where(x => x.Name.Equals(userName) && x.Password.Equals(pwd)).FirstOrDefault();
         if (user != null)
         {
             return(true);
         }
     }
     return(false);
 }
Example #2
0
        public void Post(Student studentdto)
        {
            using (var context = new KPCollegeContext())
            {
                AdmissionInfo adInfo = new AdmissionInfo();
                adInfo.Id              = studentdto.StudentID;
                adInfo.Name            = studentdto.Name;
                adInfo.Dob             = studentdto.DOB;
                adInfo.DateOfAdmission = studentdto.DateOfAdmission;
                adInfo.Branch          = studentdto.Branch;
                adInfo.Address         = studentdto.Address;
                adInfo.Gender          = studentdto.Gender;
                adInfo.AdmissionFee    = studentdto.MaintainanceFee;
                adInfo.TutionFee       = studentdto.TutionFee;

                context.AdmissionInfo.Add(adInfo);
                context.SaveChanges();
            }
        }
Example #3
0
 public Student Get(int id)
 {
     using (var context = new KPCollegeContext())
     {
         Student stu   = new Student();
         var     stuDB = context.AdmissionInfo.Where(x => x.Id == id).FirstOrDefault();
         if (stuDB != null)
         {
             stu.StudentID = stuDB.Id;
             stu.Name      = stuDB.Name;
             stu.DOB       = stuDB.Dob.Value;
             //stu.DateOfAdmission = stuDB.DateOfAdmission.HasValue?? stuDB.DateOfAdmission.Value:;
             stu.Branch          = stuDB.Branch;
             stu.Address         = stuDB.Address;
             stu.Gender          = stuDB.Gender;
             stu.MaintainanceFee = stuDB.AdmissionFee.Value;
             stu.TutionFee       = stuDB.TutionFee.Value;
         }
         return(stu);
     }
 }