public bool UserInsert() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { if (dc.tblUsers.Where(u => u.UserName == this.UserName).FirstOrDefault() == null) { tblUser user = new tblUser(); user.Id = Guid.NewGuid(); user.UserName = this.UserName; user.Password = GetHash(); dc.tblUsers.Add(user); dc.SaveChanges(); return(true); } else { return(false); } } } catch (Exception ex) { throw ex; } }
public void EmployerUpdate(Guid employerId) { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEmployer employer = dc.tblEmployers.Where(e => e.Id == employerId).FirstOrDefault(); tblUser user = dc.tblUsers.Where(u => u.Id == employer.UserId).FirstOrDefault(); if (employer != null && user != null) { employer.RepresentativeFirstName = (this.RepresentativeFirstName == null) ? employer.RepresentativeFirstName : this.RepresentativeFirstName; employer.RepresentativeLastName = (this.RepresentativeLastName == null) ? employer.RepresentativeLastName : this.RepresentativeLastName; employer.Phone = (this.Phone == null) ? employer.Phone: this.Phone; employer.Email = (this.Email == null) ? employer.Email : this.Email; employer.Industry = (this.Industry == null) ? employer.Industry : this.Industry; employer.OrganizationName = (this.OrganizationName == null) ? employer.OrganizationName: this.OrganizationName; user.UserName = (this.UserName == null) ? user.UserName : this.UserName; user.Password = (this.Password == null) ? user.Password: this.Password; employer.ProfilePicture = (this.ProfilePicture == null) ? employer.ProfilePicture: this.ProfilePicture; dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public bool AddUserInterestedInEvent(Guid userId) { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblUserInterested eventInterested = dc.tblUserInteresteds.Where(e => (e.UserId == userId) && (e.EventId == this.Id)).FirstOrDefault(); // Check to see if user already joined event if (eventInterested == null) { eventInterested = new tblUserInterested(); eventInterested.Id = Guid.NewGuid(); eventInterested.UserId = userId; eventInterested.EventId = this.Id; dc.tblUserInteresteds.Add(eventInterested); dc.SaveChanges(); return(true); } else { return(false); // User already interested in event. } } } catch (Exception ex) { throw ex; } }
public void StudentUpdate() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblStudent student = dc.tblStudents.Where(s => s.Id == this.StudentID).FirstOrDefault(); tblUser user = dc.tblUsers.Where(u => u.Id == student.UserId).FirstOrDefault(); if (student != null && user != null) { student.StudentFirstName = (this.StudentFirstName == null) ? student.StudentFirstName: this.StudentFirstName; student.StudentLastName = (this.StudentLastName == null) ? student.StudentLastName: this.StudentLastName; student.Phone = this.Phone = (this.Phone == null) ? student.Phone : this.Phone; student.Email = (this.Email == null) ? student.Email : this.Email; student.School = (this.School == null) ? student.School : this.School; student.Field = (this.FieldOfStudy == null) ? student.Field : this.FieldOfStudy; user.UserName = (this.UserName == null) ? user.UserName : this.UserName; user.Password = (this.Password == null) ? user.Password : this.Password; student.ProfilePicture = (this.ProfilePicture == null) ? student.ProfilePicture : this.ProfilePicture; dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public bool Insert() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEvent tevent = new tblEvent(); tevent.Id = Guid.NewGuid(); tevent.Name = this.Name; tevent.Type = this.Type; tevent.StartDate = Convert.ToDateTime(this.StartDate); tevent.EndDate = Convert.ToDateTime(this.EndDate); //the error was the same thing as above all good now :) dc.tblEvents.Add(tevent); dc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public bool AddUserToEvent(Guid userId) { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEventShowing eventShowing = dc.tblEventShowings.Where(e => (e.UserId == userId) && (e.EventId == this.Id)).FirstOrDefault(); if (eventShowing == null) { eventShowing = new tblEventShowing(); eventShowing.Id = Guid.NewGuid(); eventShowing.UserId = userId; eventShowing.EventId = this.Id; dc.tblEventShowings.Add(eventShowing); dc.SaveChanges(); return(true); } else { return(false); // User already attending event. } } } catch (Exception ex) { throw ex; } }
public void UserDelete() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblUser user = dc.tblUsers.Where(u => u.Id == this.BaseUserID).FirstOrDefault(); if (user != null) { dc.tblUsers.Remove(user); dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public void UserUpdate() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblUser user = dc.tblUsers.Where(u => u.Id == this.BaseUserID).FirstOrDefault(); if (user != null) { user.UserName = this.UserName; user.Password = GetHash(); dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public void EmployerDelete() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEmployer employer = dc.tblEmployers.Where(e => e.Id == this.EmployerId).FirstOrDefault(); tblUser user = dc.tblUsers.Where(u => u.Id == employer.UserId).FirstOrDefault(); if (employer != null & user != null) { dc.tblEmployers.Remove(employer); dc.tblUsers.Remove(user); dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public bool StudentInsert() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblUser user = new tblUser(); user.UserName = this.UserName; user.Password = this.Password; this.UserInsert(); tblUser userGetUserId = dc.tblUsers.Where(u => u.UserName == this.UserName).FirstOrDefault(); Guid guidUserId = userGetUserId.Id; tblStudent student = new tblStudent(); student.Id = Guid.NewGuid(); student.StudentFirstName = this.StudentFirstName; student.StudentLastName = this.StudentLastName; student.Phone = this.Phone; student.Email = this.Email; student.School = this.School; student.Field = this.FieldOfStudy; student.UserId = guidUserId; student.ProfilePicture = this.ProfilePicture; dc.tblStudents.Add(student); dc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public void StudentDelete() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblStudent student = dc.tblStudents.Where(s => s.Id == this.StudentID).FirstOrDefault(); tblUser user = dc.tblUsers.Where(u => u.Id == student.UserId).FirstOrDefault(); if (student != null) { dc.tblStudents.Remove(student); dc.tblUsers.Remove(user); dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public bool EmployerInsert() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblUser user = new tblUser(); user.UserName = this.UserName; user.Password = this.Password; this.UserInsert(); tblUser userGetUserId = dc.tblUsers.Where(u => u.UserName == this.UserName).FirstOrDefault(); Guid guidUserId = userGetUserId.Id; tblEmployer employer = new tblEmployer(); employer.Id = Guid.NewGuid(); employer.RepresentativeFirstName = this.RepresentativeFirstName; employer.RepresentativeLastName = this.RepresentativeLastName; employer.Phone = this.Phone; employer.Email = this.Email; employer.OrganizationName = this.OrganizationName; employer.Industry = this.Industry; employer.UserId = guidUserId; employer.ProfilePicture = this.ProfilePicture; dc.tblEmployers.Add(employer); dc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public void Delete() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEvent tevent = dc.tblEvents.Where(e => e.Id == this.Id).FirstOrDefault(); if (tevent != null) { var eventShowings = dc.tblEventShowings.Where(e => e.EventId == this.Id); dc.tblEventShowings.RemoveRange(eventShowings); dc.tblEvents.Remove(tevent); dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public void Update() { try { using (ITIndeedEntities dc = new ITIndeedEntities()) { tblEvent tevent = dc.tblEvents.Where(e => e.Id == this.Id).FirstOrDefault(); if (tevent != null) { tevent.Name = this.Name; tevent.Type = this.Type; tevent.StartDate = this.StartDate; tevent.EndDate = this.EndDate; dc.SaveChanges(); } } } catch (Exception ex) { throw ex; } }