public List <UserDetail> GetUserList(int roleId)
{
List <UserDetail> list = null;
using (LegaSysEntities db = new LegaSysEntities())
{
list = db.LegaSys_UserDetails.Where(x => (x.IsActive && x.Master_Role_ID < roleId) || x.Master_Role_ID == 2).AsEnumerable().Select(y => new UserDetail
{
UserDetailID = y.UserDetailID,
Fullname = $"{y.Firstname} {y.Lastname}"
}).ToList();
}
return(list);
}
public List <LegaSys_Master_Technologies> GetAllTechnologyByDomainId(int id)
{
try
{
using (LegaSysEntities db = new LegaSysEntities())
{
var tech = db.LegaSys_Master_Technologies.AsEnumerable().Where(x => x.Master_DomainID == id).Select(x => new LegaSys_Master_Technologies
{
TechnologyID = x.TechnologyID,
Name = x.Name
}).ToList();
return(tech);
}
}
catch (Exception)
{
throw;
}
}
// Get All client details
public List <ClientDetail> GetAllClient()
{
List <ClientDetail> lstClient = null;
//declare the object to return
try
{
using (LegaSysEntities db = new LegaSysEntities())
{
lstClient = db.LegaSys_ClientDetails.Where(s => s.IsActive == true).Select(s =>
new ClientDetail()
{
ClientDetailID = s.ClientDetailID,
ClientName = s.ClientName,
Address = s.Address,
Country = s.Country,
CoClient = s.CoClient,
//CoClient2 = s.CoClient2,
//CoClient3 = s.CoClient3,
//CoClient4 = s.CoClient4,
EmailID = s.EmailID,
//EmailID2 = s.EmailID2,
//EmailID3 = s.EmailID3,
//EmailID4 = s.EmailID4,
//Created_By = s.Created_By,
//Updated_By = s.Updated_By,
IsActive = (bool)s.IsActive
}).ToList();
}
}
catch (Exception)
{
throw;
}
return(lstClient);
}
public UOWLocations(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWDomains(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWProjects(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWClient(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWResources(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWTask(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWShifts(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWTechnologies(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public LegaSysEntities Init()
{
return(dbContext ?? (dbContext = new LegaSysEntities()));
}
public UOWRoles(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWUsers(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWExceptionLogger(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
public UOWLeaves(IDbFactory dbFactory)
{
db = dbFactory.Init();
}
