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);
}
