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