public UnitOfWork(string connectionString)
{
_context = new ProjectManagementDBContext(connectionString);
AccountRepository = new AccountRepository(_context);
AccountProjectRepository = new AccountProjectRepository(_context);
CardRepository = new CardRepository(_context);
CommentRepository = new CommentRepository(_context);
ProjectRepository = new ProjectRepository(_context);
}
private void dispose(bool disposing)
{
if (!_isDisposed)
{
if (disposing)
{
if (_context != null)
{
_context.Dispose();
_context = null;
}
}
}
_isDisposed = true;
}
//public static IList<SelectListItem> GetStatus()
//{
// IList<SelectListItem> result = new List<SelectListItem>();
// result.Add(new SelectListItem { Value = "Active", Text = "Active" });
// result.Add(new SelectListItem { Value = "Inactive", Text = "Inactive" });
// return result;
//}
public static IList <SelectListItem> GetAllProjects()
{
IList <SelectListItem> result = new List <SelectListItem>();
using (var db = new ProjectManagementDBContext())
{
var projectlist = db.tb_ProjectInfos.ToList();
foreach (var project in projectlist)
{
result.Add(new SelectListItem {
Value = project.ProjectInfoId.ToString(), Text = project.Name
});
}
}
return(result);
}
public static IList <SelectListItem> GetAllUsers()
{
IList <SelectListItem> result = new List <SelectListItem>();
using (var db = new ProjectManagementDBContext())
{
var userlist = db.tb_UserInfos.ToList();
foreach (var user in userlist)
{
if (user.Status == true && user.Designation != "IT Admin")
{
result.Add(new SelectListItem {
Value = user.UserInfoId.ToString(), Text = user.Name
});
}
}
}
return(result);
}
