public static string FindUserName(int useriD) { using (var context = new AssessmentContext()) { var userexists = from userinfo in context.userprofiles where userinfo.iD == useriD select userinfo.UserName; return(userexists.First()); } }
public static int FindUserId(string user_name) { using (var context = new AssessmentContext()) { var userexists = from userinfo in context.userprofiles where userinfo.UserName == user_name select userinfo.iD; return(userexists.First()); } }
public static bool CreateStudent(studentprofile stuprofile) { using (var context = new AssessmentContext()) { context.Database.Connection.Open(); stuprofile.CreatedDate = DateTime.Now; stuprofile.LastModifiedDate = DateTime.Now; context.studentprofile.Add(stuprofile); context.SaveChanges(); var userexists = context.studentprofile.Select(x => x.FirstName == stuprofile.FirstName && x.LastName == stuprofile.LastName && x.DoB == stuprofile.DoB).FirstOrDefault(); return(userexists); } }
public static bool ValidateCredential(string uname, string upass) { if (string.IsNullOrWhiteSpace(uname) || string.IsNullOrWhiteSpace(upass)) { return(false); } using (var context = new AssessmentContext()) { context.Database.Connection.Open(); var userexists = context.userprofiles.Where(x => x.UserName == uname && x.Password == upass).FirstOrDefault(); return(userexists != null?true:false); } }
public static bool CreateKCSAssessment(KCSAssessment kcsAssessment) { using (var context = new AssessmentContext()) { context.Database.Connection.Open(); kcsAssessment.CIIndex = CIDevision(kcsAssessment); kcsAssessment.AQIIndex = AQIPoints(kcsAssessment); kcsAssessment.CreatedDate = DateTime.Now; kcsAssessment.LastModifiedDate = DateTime.Now; kcsAssessment.CreatedBy = UserValidation.FindUserId(HttpContext.Current.Session["LoginedUser"].ToString()); kcsAssessment.LastModifiedBy = UserValidation.FindUserId(HttpContext.Current.Session["LoginedUser"].ToString()); context.kcsassessment.Add(kcsAssessment); context.SaveChanges(); var userexists = context.kcsassessment.Select(x => x.AInfo5 == kcsAssessment.AInfo5 && x.AInfo6 == kcsAssessment.AInfo6).FirstOrDefault(); return(userexists); } }
public static bool ModifyStudent(studentprofile stuprofile) { using (var context = new AssessmentContext()) { try { context.Database.Connection.Open(); studentprofile studentPro = context.studentprofile.Where(x => x.iD == stuprofile.iD).First(); studentPro.FirstName = stuprofile.FirstName; studentPro.LastName = stuprofile.LastName; studentPro.DoB = stuprofile.DoB; studentPro.Emailaddress = stuprofile.Emailaddress; studentPro.LastModifiedDate = DateTime.Now; context.SaveChanges(); } catch (System.Data.Entity.Core.OptimisticConcurrencyException) { } var userexists = context.studentprofile.Select(x => x.FirstName == stuprofile.FirstName && x.LastName == stuprofile.LastName && x.DoB == stuprofile.DoB).FirstOrDefault(); return(userexists); } }