/// <summary> /// Function to make entry in database for uploaded document /// </summary> /// <param name="userID">userID</param> /// <param name="docID">docID</param> /// <param name="docName">docName</param> /// <returns></returns> public bool UploadDocument(int userID, int docID, string docName) { try { using (var unitOfWork = new EFUnitOfWork()) { var userDocRepo = new UserDocumentRepository(new EFRepository <UserDocument>(), unitOfWork); UserDocument doc = new UserDocument(); doc.UserDocumentName = docName; doc.FK_DocumentID = docID; doc.Status = "Pending"; doc.FK_UserID = userID; doc.IsDeleted = false; userDocRepo.Add(doc); userDocRepo.Save(); return(true); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); return(false); } }
/// <summary> /// This method deletes user document by setting IsDeleted column to true /// </summary> /// <param name="userID">userID</param> /// <param name="docID">docID</param> /// <returns></returns> public string ClearUserDocument(int userID, int docID) { try { using (var unitOfWork = new EFUnitOfWork()) { var userDocRepo = new UserDocumentRepository(new EFRepository <UserDocument>(), unitOfWork); ObjectSet <UserDocument> userDocObjSet = ((CurrentDeskClientsEntities)userDocRepo.Repository.UnitOfWork.Context).UserDocuments; var userDoc = userDocObjSet.Where(doc => doc.FK_UserID == userID && doc.FK_DocumentID == docID && doc.IsDeleted == false).FirstOrDefault(); if (userDoc != null) { userDoc.IsDeleted = true; userDocRepo.Save(); return(userDoc.UserDocumentName); } return(String.Empty); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); throw; } }