private List <UserBoxVM> GetListOfDoccumentToAccept() { List <UserBoxVM> listDocToAccep = new List <UserBoxVM>(); UserAccount tempAcceptUser; User acceptUser; List <Models.DocumentData.Document> listaTemp = new List <Models.DocumentData.Document>(); var user = (string)Session["UserName"]; using (var db = new DocumentDbContext()) { using (var db1 = new AccountDbContext()) { tempAcceptUser = db1.userAccount.Where(x => x.UserName == user).First(); acceptUser = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First(); foreach (var item in db.Documents.Where(x => x.DateOfAcceptance == null && x.Status.StatusId == 1).ToList()) { UserBoxVM temp = new UserBoxVM(); temp.DocumentId = item.DocumentId; temp.DateOfAccept = item.DateOfAcceptance; temp.FileToCheck = item.DocumentFile; temp.Status = item.Status.Description; temp.Index = item.Index; listDocToAccep.Add(temp); } } } return(listDocToAccep); }
private List <UserBoxVM> GetList(int status, User interested) { var user = (string)Session["UserName"]; UserAccount tempAcceptUser; User acceptUser; AuthorUser authorUser; User deleteUser; List <UserBoxVM> tempList = new List <UserBoxVM>(); using (var db = new DocumentDbContext()) { using (var db1 = new AccountDbContext()) { tempAcceptUser = db1.userAccount.Where(x => x.UserName == user).First(); acceptUser = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First(); deleteUser = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First(); } if (status == 2) { authorUser = db.UserAuthor.Where(x => x.User.UserId == acceptUser.UserId).First(); foreach (var item in db.Documents.Where(x => x.Status.StatusId == 2 && x.AuthorUserId == authorUser.AuthorUserId).ToList()) { UserBoxVM temp = new UserBoxVM(); temp.DocumentId = item.DocumentId; temp.DateOfAccept = item.DateOfAcceptance; temp.FileToCheck = item.DocumentFile; temp.Status = item.Status.Description; temp.Index = item.Index; tempList.Add(temp); } } if (status == 7) { foreach (var item in db.Documents.Where(x => x.StatusId == 7 && x.DeleteUserId == deleteUser.UserId).ToList()) { UserBoxVM temp = new UserBoxVM(); temp.DocumentId = item.DocumentId; temp.DateOfAccept = item.DateOfAcceptance; temp.FileToCheck = item.DocumentFile; temp.Status = item.Status.Description; temp.Index = item.Index; tempList.Add(temp); } } } return(tempList); }
// GET: DocBox public ActionResult Index() { List <UserBoxVM> listDocToAccep = new List <UserBoxVM>(); List <UserBoxVM> listAccepted = new List <UserBoxVM>(); List <UserBoxVM> listRejected = new List <UserBoxVM>(); List <UserBoxVM> AllKindOfDocuments = new List <UserBoxVM>(); UserAccount tempAcceptUser; User acceptUser; AcceptedUser acceUser; List <Models.DocumentData.Document> listaTemp = new List <Models.DocumentData.Document>(); var user = (string)Session["UserName"]; using (var db = new DocumentDbContext()) { using (var db1 = new AccountDbContext()) { tempAcceptUser = db1.userAccount.Where(x => x.UserName == user).First(); acceptUser = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First(); listAccepted = GetList(2, acceptUser); listRejected = GetList(7, acceptUser); if (acceptUser.AcceptUser != null) { acceUser = db.UserAccept.Where(x => x.User.UserId == acceptUser.UserId).First(); foreach (var item in db.Documents.Where(x => x.DateOfAcceptance == null && x.Status.StatusId == 1 && x.AccepedUser.AcceptedUserId == acceUser.AcceptedUserId).ToList()) { UserBoxVM temp = new UserBoxVM(); temp.DocumentId = item.DocumentId; temp.DateOfAccept = item.DateOfAcceptance; temp.FileToCheck = item.DocumentFile; temp.Status = item.Status.Description; temp.Index = item.Index; listDocToAccep.Add(temp); } } } } var result = listDocToAccep.Concat(listAccepted); var res = result.Concat(listRejected); AllKindOfDocuments = res.ToList(); return(View(AllKindOfDocuments)); }