public IActionResult AddDocumentFile(DocumentFile df)
{
df.numberOf_document = 0;
dbContext.documentFiles.Add(df);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public DocumentInfo CreateDocument(CreateDocumentInput input, Stream stream)
{
var documentInfo = Mapper.Map <DocumentInfo>(input);
StoreDocumentFile(documentInfo, stream);
HandleTifFile(documentInfo.FileType, documentInfo.Path);
documentInfo.Key = Guid.NewGuid().ToString();
documentInfo.CreateTime = DateTime.Now;
documentInfo.ModifyTime = documentInfo.CreateTime;
documentInfo.ModifyUserId = documentInfo.CreateUserID;
documentInfo.ModifyUserName = documentInfo.CreateUserName;
documentInfo.CurrentVersion = 1;
_context.DocumentInfos.Add(documentInfo);
_context.SaveChanges();
var historyPath = StoreHistoryFile(stream, documentInfo.FileType);
DocumentHistory fileHistory = new DocumentHistory
{
DocumentInfoId = documentInfo.Id,
Version = 1,
PreviousVersion = -1,
Key = documentInfo.Key,
Path = historyPath,
UserId = input.CreateUserID,
UserName = input.CreateUserName,
CreateTime = DateTime.Now
};
_context.DocumentHistories.Add(fileHistory);
_context.SaveChanges();
return(documentInfo);
}
public IActionResult AddUser(User u)
{
if (ModelState.IsValid)
{
dbContext.users.Add(u);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public IActionResult AddDocument(Document d) // yeni doc ekliyo
{
var user = dbContext.users.Where(x => x.user_id == d.User.user_id).FirstOrDefault();
d.User = user;
var docFile = dbContext.documentFiles.Where(x => x.document_file_id == d.DocumentFile.document_file_id).FirstOrDefault();
docFile.numberOf_document++;
d.DocumentFile = docFile;
dbContext.documents.Add(d);
dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public bool RemoveFile(string id)
{
var ids = id.Split(',');
foreach (var item in ids)
{
PersonalFile personalFile = _context.PersonalFiles.Find(int.Parse(item));
if (personalFile != null)
{
_context.PersonalFiles.Remove(personalFile);
}
}
_context.SaveChanges();
return(true);
}
public IActionResult RemoveDoc(int id)
{
var dd = dbContext.deletedDocuments.Find(id);
dbContext.deletedDocuments.Remove(dd);
dbContext.SaveChanges();
TempData.Add("Alert", "Document was completely deleted");
return(RedirectToAction("Index"));
}
public static void EnsureSeeded(this DocumentDbContext context)
{
if (!context.DocumentsTypes.Any())
{
var types = JsonConvert.DeserializeObject <List <DocumentType> >(File.ReadAllText("Seeds" + Path.DirectorySeparatorChar + "DocumentTypes.json"));
context.AddRange(types);
context.SaveChanges();
}
}
public ActionResult AddComments(string doc, int id)
{
using (var db = new DocumentDbContext())
{
db.Documents.Where(x => x.DocumentId == id).First().Comments = doc;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult CancelDocument(int docId)
{
//9 wycofana z obiegu
using (var db = new DocumentDbContext())
{
db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 9).First();
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult CancelPutToArchive(int docId)
{
//Powrot do status id=4
using (var db = new DocumentDbContext())
{
db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 4).First();
db.Documents.Where(x => x.DocumentId == docId).First().DateOfDelete = null;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult SayNo(int docId)
{
//3 status odrzucona w bazie danych
using (var db = new DocumentDbContext())
{
db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 3).First();
db.Documents.Where(x => x.DocumentId == docId).First().DateOfAcceptance = DateTime.Today;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult PutToArchive(int docId)
{
//5 archiwum
using (var db = new DocumentDbContext())
{
db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 5).First();
db.Documents.Where(x => x.DocumentId == docId).First().DateOfDelete = DateTime.Today;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(int UserId, int id)
{
//przypisanie osoby odpowiedzialnej za zaakceptowanie usuniecia
//7 status oczekuje na akceptacje do usuniecia
using (var db = new DocumentDbContext())
{
db.Documents.Where(x => x.DocumentId == id).First().DeleteUser = db.DeleteAuthor.Where(z => z.DeleteUserId == UserId).First();
db.Documents.Where(x => x.DocumentId == id).First().StatusId = 7;
db.SaveChanges();
}
return RedirectToAction("DeleteDocument");
}
public bool AddShareUser(AddShareUserInput input)
{
var fileUsersToRemove = _context.FileUsers.Where(a => a.FileId == input.FileId);
_context.FileUsers.RemoveRange(fileUsersToRemove);
foreach (var item in input.FileUserDtos)
{
var user = _context.Users.FirstOrDefault(a => a.UserID == item.UserId);
if (user == null)
{
user = new User
{
UserID = item.UserId,
UserName = item.UserName,
CreationTime = DateTime.Now
};
_context.Users.Add(user);
}
var fileUser = new FileUser
{
FileId = input.FileId,
UserId = item.UserId,
Permission = item.Permission,
CreationTime = DateTime.Now
};
_context.FileUsers.Add(fileUser);
}
_context.SaveChanges();
return(true);
}
public bool SaveUser(UserDto userDto)
{
if (string.IsNullOrEmpty(userDto.UserID) || string.IsNullOrEmpty(userDto.UserName))
{
return(true);
}
var user = _context.Users.FirstOrDefault(a => a.UserID == userDto.UserID);
if (user == null)
{
user = Mapper.Map <User>(userDto);
user.CreationTime = DateTime.Now;
_context.Users.Add(user);
_context.SaveChanges();
}
return(true);
}
//private byte[] GetExcelFile()
//{
//}
public ActionResult SayYes(int docId)
{
//2 status zatwierdzona w bazie danych
using (var db = new DocumentDbContext())
{
var DocExcel = db.Documents.Where(x => x.DocumentId == docId).First().DocumentFileExcel;
string pathUser = Environment.GetFolderPath(Environment.SpecialFolder.UserProfile);
string pathDownload = Path.Combine(pathUser, "Downloads");
string title = "temp" + DateTime.Now;
title = title.Replace("-", "");
title = title.Replace(":", "");
string title2 = "temp" + ".pdf";
string EndPathPDF = Path.Combine(pathDownload, title2);
string EndPath = Path.Combine(pathDownload, title);
//stworzenie tablicy wielkosci
System.IO.File.WriteAllBytes(EndPath, DocExcel);
MyApp = new Microsoft.Office.Interop.Excel.Application();
MyApp.Visible = false;
MyBook = MyApp.Workbooks.Open(EndPath);
MyWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)MyBook.Sheets[1];
var acceptUser = db.Documents.Where(x => x.DocumentId == docId).First().AcceptedUserId;
string user = db.Users.Where(x => x.AcceptUser.AcceptedUserId == acceptUser).First().FirstName + " " +
db.Users.Where(x => x.AcceptUser.AcceptedUserId == acceptUser).First().LastName;
MyWorkSheet.Cells[5, 13] = user;
MyApp.Save();
MyBook.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, EndPathPDF);
MyBook.Close();
byte[] f1 = new byte[15728640];
f1 = System.IO.File.ReadAllBytes(EndPath);
byte[] fPDF = new byte[15728640];
fPDF = System.IO.File.ReadAllBytes(EndPathPDF);
db.Documents.Where(x => x.DocumentId == docId).First().DocumentFile = fPDF;
db.Documents.Where(x => x.DocumentId == docId).First().DocumentFileExcel = f1;
db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 2).First();
db.Documents.Where(x => x.DocumentId == docId).First().DateOfAcceptance = DateTime.Today;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public bool ExternalRefreshFile(ExternalRefreshFileInput input)
{
var documentInfo = _context.DocumentInfos.FirstOrDefault(a => a.ExternalID == input.ID);
if (documentInfo == null)
{
return(false);
}
DocumentHistory documentHistory = _context.DocumentHistories.FirstOrDefault(a => a.DocumentInfoId == documentInfo.Id && a.Version == documentInfo.CurrentVersion);
documentInfo.Key = Guid.NewGuid().ToString();
documentHistory.Key = documentInfo.Key;
if (!string.IsNullOrEmpty(input.NewID))
{
documentInfo.ExternalID = input.NewID;
}
documentService.StoreDocumentFile(documentInfo, input.FilePath);
_context.SaveChanges();
return(true);
}
public Category AddCategory(Category category)
{
_context.Categories.Add(category);
_context.SaveChanges();
return(category);
}
public ActionResult RegisterDocument(Document doc, HttpPostedFileBase file, string Title, int LineId,
int OperationId, int DocumentTypeId, int AcceptedUserId)
{
//stworzenie sciezki do zapisania pliku
//index idLini-idOperarcji-idInstr
string pathUser = Environment.GetFolderPath(Environment.SpecialFolder.UserProfile);
string pathDownload = Path.Combine(pathUser, "Downloads");
string title = Title + DateTime.Now;
title = title.Replace("-", "");
title = title.Replace(":", "");
string title2 = LineId.ToString() + ".pdf";
string EndPath = Path.Combine(pathDownload, title);
string EndPathPDF = Path.Combine(pathDownload, title2);
//stworzenie tablicy wielkosci
doc.DocumentFile = new byte[file.InputStream.Length];
file.InputStream.Read(doc.DocumentFile, 0, doc.DocumentFile.Length);
System.IO.File.WriteAllBytes(EndPath, doc.DocumentFile);
MyApp = new Microsoft.Office.Interop.Excel.Application();
MyApp.Visible = false;
MyBook = MyApp.Workbooks.Open(EndPath);
MyWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)MyBook.Sheets[1];
using (var db = new DocumentDbContext())
{
MyWorkSheet.Cells[3, 3] = db.Lines.Where(x => x.LineId == LineId).First().LineName;
MyWorkSheet.Cells[2, 5] = Title;
MyWorkSheet.Cells[2, 13] = 1;
MyWorkSheet.Cells[4, 3] = db.Operations.Where(x => x.OperationId == OperationId).First().OperationNumber.ToString();
int NewId;
Document temp = db.Documents.FirstOrDefault();
if (temp == null)
{
doc.DocumentId = 1;;
NewId = 1;
}
else
{
NewId = db.Documents.Max(x => x.DocumentId);
NewId++;
}
doc.DocumentId = NewId;
UserAccount tempAuthor;
User authorUser;
var user = (string)Session["UserName"];
string index = LineId.ToString() + "-" + OperationId.ToString() + "-" + DocumentTypeId.ToString()
+ "-" + NewId;
MyWorkSheet.Cells[5, 5] = db.DocumentTypes.Where(x => x.DocumentTypeId == DocumentTypeId).First().Description;
MyWorkSheet.Cells[2, 3] = index;
using (var db1 = new AccountDbContext())
{
tempAuthor = db1.userAccount.Where(x => x.UserName == user).First();
authorUser = db.Users.Where(x => x.LastName == tempAuthor.LastName).First();
MyWorkSheet.Cells[4, 13] = authorUser.FirstName + " " + authorUser.LastName;
}
Microsoft.Office.Interop.Excel.Range range = (Microsoft.Office.Interop.Excel.Range)MyWorkSheet.Cells[1, 17];
MyWorkSheet.PageSetup.CenterFooter = "Dokument wygenerowany przez program DocumentManager";
string cellValue = range.Value.ToString();
MyApp.Save();
MyBook.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, EndPathPDF);
MyBook.Close();
byte[] f1 = new byte[15728640];
f1 = System.IO.File.ReadAllBytes(EndPath);
byte[] fPDF = new byte[15728640];
fPDF = System.IO.File.ReadAllBytes(EndPathPDF);
if (cellValue != "INSTRDOC")
{
return(RedirectToAction("ErrorTemplate"));
}
else
{
//
doc.DocumentFileExcel = f1;
doc.DocumentFile = fPDF;
doc.Status = db.Status.Where(x => x.StatusId == 1).First();
doc.Version = 1;
doc.Title = Title;
doc.LineId = LineId;
//nadanie indexu IdLini-IdOperacji-IdTypuInstruckji-IdPierwszejInstrukcji
doc.Index = index;
doc.DateOfAdding = DateTime.Now;
doc.OperationId = OperationId;
doc.DocumentTypeId = DocumentTypeId;
doc.AcceptedUserId = AcceptedUserId;
doc.AuthorUserId = authorUser.UserId;
db.Documents.Add(doc);
db.SaveChanges();
if (System.IO.File.Exists(EndPathPDF))
{
System.IO.File.Delete(EndPathPDF);
}
if (System.IO.File.Exists(EndPath))
{
System.IO.File.Delete(EndPath);
}
}
}
return(RedirectToAction("RegisterDocument"));
}
public ActionResult MakeActive(int docId)
{
//4 status wydana na linie
using (var db = new DocumentDbContext())
{
var DocExcel = db.Documents.Where(x => x.DocumentId == docId).First().DocumentFileExcel;
string pathUser = Environment.GetFolderPath(Environment.SpecialFolder.UserProfile);
string pathDownload = Path.Combine(pathUser, "Downloads");
string title = "temp" + DateTime.Now;
title = title.Replace("-", "");
title = title.Replace(":", "");
string title2 = "temp" + ".pdf";
string EndPathPDF = Path.Combine(pathDownload, title2);
string EndPath = Path.Combine(pathDownload, title);
int VersionCurrent = db.Documents.Where(x => x.DocumentId == docId).First().Version;
int VersionPrevious = VersionCurrent - 1;
if (VersionCurrent > 1)
{
string index = db.Documents.Where(x => x.DocumentId == docId).First().Index;
Models.DocumentData.Document DocumentToArchive = db.Documents.Where(x => x.Index == index).Where(x => x.Version == VersionPrevious).First();
DocumentToArchive.Status = db.Status.Where(x => x.StatusId == 5).First();
db.SaveChanges();
}
//stworzenie tablicy wielkosci
System.IO.File.WriteAllBytes(EndPath, DocExcel);
MyApp = new Microsoft.Office.Interop.Excel.Application();
MyApp.Visible = false;
MyBook = MyApp.Workbooks.Open(EndPath);
MyWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)MyBook.Sheets[1];
MyWorkSheet.Cells[3, 13] = DateTime.Now.ToShortDateString();
MyApp.Save();
MyBook.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, EndPathPDF);
MyBook.Close();
byte[] f1 = new byte[15728640];
f1 = System.IO.File.ReadAllBytes(EndPath);
byte[] fPDF = new byte[15728640];
fPDF = System.IO.File.ReadAllBytes(EndPathPDF);
//zamiana indeksu z 4 na 5 w poprzedniej wersji
db.Documents.Where(x => x.DocumentId == docId).First().DocumentFile = fPDF;
db.Documents.Where(x => x.DocumentId == docId).First().DocumentFileExcel = f1;
db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 4).First();
db.Documents.Where(x => x.DocumentId == docId).First().DateOfPublic = DateTime.Today;
db.SaveChanges();
if (System.IO.File.Exists(EndPathPDF))
{
System.IO.File.Delete(EndPathPDF);
}
if (System.IO.File.Exists(EndPath))
{
System.IO.File.Delete(EndPath);
}
}
return(RedirectToAction("Index"));
}
public ActionResult ShowDoc(HttpPostedFileBase file, string Title,string Index, int AcceptedUserId)
{
Document oldDocument;
Document newDocument;
using (var db = new DocumentDbContext())
{
oldDocument = GetOldOne(db, Index);
newDocument = GetNewOne(db, Index);
//stworzenie sciezki do zapisania pliku
string pathUser = Environment.GetFolderPath(Environment.SpecialFolder.UserProfile);
string pathDownload = Path.Combine(pathUser, "Downloads");
string title = Title + DateTime.Now;
title = title.Replace("-", "");
title = title.Replace(":", "");
string title2 = "temp" + ".pdf";
string EndPath = Path.Combine(pathDownload, title);
string EndPathPDF = Path.Combine(pathDownload, title2);
int currentVersion = oldDocument.Version+1;
//stworzenie tablicy wielkosci
newDocument.DocumentFile = new byte[file.InputStream.Length];
file.InputStream.Read(newDocument.DocumentFile, 0, newDocument.DocumentFile.Length);
System.IO.File.WriteAllBytes(EndPath, newDocument.DocumentFile);
MyApp = new Microsoft.Office.Interop.Excel.Application();
MyApp.Visible = false;
MyBook = MyApp.Workbooks.Open(EndPath);
MyWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)MyBook.Sheets[1];
MyWorkSheet.Cells[2, 3] = oldDocument.Index;
MyWorkSheet.Cells[3, 3] = db.Lines.Where(x => x.LineId ==oldDocument.LineId).First().LineName;
MyWorkSheet.Cells[2, 5] = Title;
MyWorkSheet.Cells[2, 13] = currentVersion;
MyWorkSheet.Cells[4, 3] = db.Operations.Where(x => x.OperationId ==oldDocument.OperationId).First().OperationNumber.ToString();
MyWorkSheet.Cells[5, 5] = db.DocumentTypes.Where(x => x.DocumentTypeId == oldDocument.DocumentTypeId).First().Description;
UserAccount tempAuthor;
User authorUser;
var user = (string)Session["UserName"];
using (var db1 = new AccountDbContext())
{
tempAuthor = db1.userAccount.Where(x => x.UserName == user).First();
authorUser = db.Users.Where(x => x.LastName == tempAuthor.LastName).First();
MyWorkSheet.Cells[4, 13] = authorUser.FirstName + " " + authorUser.LastName;
}
MyApp.Save();
MyBook.ExportAsFixedFormat(XlFixedFormatType.xlTypePDF, EndPathPDF);
MyBook.Close();
byte[] f1 = new byte[15728640];
f1 = System.IO.File.ReadAllBytes(EndPath);
byte[] fPDF = new byte[15728640];
fPDF = System.IO.File.ReadAllBytes(EndPathPDF);
newDocument.DocumentFileExcel = f1;
newDocument.DocumentFile = fPDF;
newDocument.Status = db.Status.Where(x => x.StatusId == 1).First();
newDocument.Version = currentVersion;
newDocument.Title = Title;
newDocument.LineId =oldDocument.LineId;
newDocument.DateOfAdding = DateTime.Now;
newDocument.OperationId = oldDocument.OperationId;
newDocument.DocumentTypeId = oldDocument.DocumentTypeId;
newDocument.AuthorUserId = authorUser.UserId;
newDocument.AcceptedUserId = AcceptedUserId;
db.Documents.Add(newDocument);
db.SaveChanges();
if (System.IO.File.Exists(EndPath))
{
System.IO.File.Delete(EndPath);
}
if (System.IO.File.Exists(EndPathPDF))
{
System.IO.File.Delete(EndPathPDF);
}
}
return RedirectToAction("ShowMessage");
}
public Document AddDocument(Document document)
{
_context.Documents.Add(document);
_context.SaveChanges();
return(document);
}
