public string AddRole(TeamTable teamDetails) { string res = ""; try { using (TechLeagueDBEntities objEntity = new TechLeagueDBEntities()) { objEntity.TeamTables.Add(teamDetails); int result = objEntity.SaveChanges(); if (result > 0) { res = "Success"; } else { res = "Failed"; } } } catch (Exception ex) { res = ex.ToString(); } return(res); }
public bool UpdateUser(UserTable userDetails) { bool isUpdated = false; try { using (var objEntity = new TechLeagueDBEntities()) { var existingUserDetails = objEntity.UserTables.Where(x => x.UserId == userDetails.UserId).FirstOrDefault <UserTable>(); if (existingUserDetails != null) { existingUserDetails.Skills = userDetails.Skills; existingUserDetails.Project = userDetails.Project; existingUserDetails.Hobbies = userDetails.Hobbies; existingUserDetails.ModifiedDate = DateTime.Now; } if (objEntity.SaveChanges() > 0) { isUpdated = true; } } } catch (Exception ex) { return(false); } return(isUpdated); }
public IEnumerable <UserTable> userDetails() { IEnumerable <UserTable> userList = new List <UserTable>(); string res = ""; try { using (TechLeagueDBEntities objEntity = new TechLeagueDBEntities()) { userList = objEntity.UserTables.ToList(); } } catch (Exception ex) { res = ex.ToString(); } return(userList); }
public IEnumerable <TeamTable> teamDetails() { IEnumerable <TeamTable> teamList = new List <TeamTable>(); string res = ""; try { using (TechLeagueDBEntities objEntity = new TechLeagueDBEntities()) { teamList = objEntity.TeamTables.ToList(); } } catch (Exception ex) { res = ex.ToString(); } return(teamList); }
public IEnumerable <MatchTable> matchDetails() { IEnumerable <MatchTable> matchList = new List <MatchTable>(); string res = ""; try { using (TechLeagueDBEntities objEntity = new TechLeagueDBEntities()) { matchList = objEntity.MatchTables.ToList(); } } catch (Exception ex) { res = ex.ToString(); } return(matchList); }
public IEnumerable <RoleTable> roleDetails() { IEnumerable <RoleTable> roleList = new List <RoleTable>(); string res = ""; try { using (TechLeagueDBEntities objEntity = new TechLeagueDBEntities()) { roleList = objEntity.RoleTables.ToList(); } } catch (Exception ex) { res = ex.ToString(); } return(roleList); }
public bool ValidateUser(LoginTable userDetails) { LoginTable validate = new LoginTable(); bool isValid = false; try { using (var objEntity = new TechLeagueDBEntities()) { var existingUserDetails = objEntity.LoginTables.Where(x => x.NTID == userDetails.NTID && x.Password == userDetails.Password).FirstOrDefault <LoginTable>(); if (existingUserDetails != null) { isValid = true; } } } catch (Exception) { isValid = false; } return(isValid); }