/// <summary> /// Retrieve the parent folder for a given document /// </summary> /// <param name="parentDocumentUID"></param> /// <returns></returns> private static string GetClientDocumentLocation(int clientDocumentUID) { string ret = ""; var rs = BUSClientDocument.ClientDocumentReadS(clientDocumentUID: clientDocumentUID); ClientDocument clientDocument = new ClientDocument(); if (rs.ReturnCode == 1 && rs.ReasonCode == 1) { clientDocument = (ClientDocument)rs.Contents; // This is to prevent the first level from taking an extra \\ at the front // it was causing the folder to be like \\%CLIENTFOLDER%\\ // At the end the client folder was replace by a physical path // and it appears like "\\c:\\fcm\\document\\" clientDocument.Location = clientDocument.Location.Trim(); if (string.IsNullOrEmpty(clientDocument.Location)) { ret = clientDocument.FileName; } else { ret = clientDocument.Location + "\\" + clientDocument.FileName; } } if (rs.ReturnCode == 1 && rs.ReasonCode == 2) { // Client document not found } return(ret); }
public static ResponseStatus GetClientDocumentPath(ClientDocument clientDocument) { ResponseStatus response = new ResponseStatus(); response = ClientDocument.GetDocumentPath(clientDocument); return(response); }
void Deletes_Range_of_Documents_With_Serial_PK() { int INSERT_QTY = 100; var bulkList = new List <ClientDocument>(); for (int i = 1; i <= INSERT_QTY; i++) { var newBuildingDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newBuildingDocument); } clientDocs.Add(bulkList); var inserted = clientDocs.Load(); int insertedCount = inserted.Count; var deleteUs = inserted.Where(b => b.ClientDocumentId > 50); clientDocs.Remove(deleteUs.ToList()); var remaining = clientDocs.Load(); Assert.True(insertedCount > remaining.Count && remaining.Count == 50); }
public UIClientDocumentEdit(ClientDocument clientDocument) : this() { txtUID.Text = clientDocument.UID.ToString(); txtClientID.Text = clientDocument.FKClientUID.ToString(); txtClientDocumentSetID.Text = clientDocument.FKClientDocumentSetUID.ToString(); txtDocumentID.Text = clientDocument.FKDocumentUID.ToString(); txtIssueNumber.Text = clientDocument.SourceIssueNumber.ToString(); txtSourceLocation.Text = clientDocument.SourceLocation; txtSourceFileName.Text = clientDocument.SourceFileName; // Destination Location txtLocation.Text = clientDocument.Location; txtFileName.Text = clientDocument.FileName; txtSequenceNumber.Text = clientDocument.SequenceNumber.ToString(); txtClientDocumentVersionNumber.Text = clientDocument.ClientIssueNumber.ToString(); txtSourceDocumentVersionNumber.Text = clientDocument.SourceIssueNumber.ToString(); cbxIsProjectPlan.Checked = clientDocument.IsProjectPlan == "Y" ? true : false; cbxIsGenerated.Checked = clientDocument.Generated == 'Y' ? true : false; cbxIsRoot.Checked = clientDocument.IsRoot == 'Y' ? true : false; cbxIsFolder.Checked = clientDocument.IsFolder == 'Y' ? true : false; cbxIsVoid.Checked = clientDocument.IsVoid == 'Y' ? true : false; txtStatus.Text = "Not used"; txtParentUID.Text = clientDocument.ParentUID.ToString(); txtRecordType.Text = clientDocument.RecordType; txtDocumentType.Text = clientDocument.DocumentType; txtDocumentCUID.Text = clientDocument.DocumentCUID; if (!cbxIsGenerated.Checked) { btnEdit.Enabled = false; } }
private void btnSave_Click(object sender, EventArgs e) { // Save details ClientDocument clientDocument = new ClientDocument(); clientDocument.UID = Convert.ToInt32(txtUID.Text); clientDocument.FKClientDocumentSetUID = Convert.ToInt32(txtClientDocumentSetID.Text); clientDocument.FKDocumentUID = Convert.ToInt32(txtDocumentID.Text); clientDocument.FKClientUID = Convert.ToInt32(txtClientID.Text); clientDocument.SourceLocation = txtSourceLocation.Text; clientDocument.SourceFileName = txtSourceFileName.Text; clientDocument.Location = txtLocation.Text; clientDocument.FileName = txtFileName.Text; if (!string.IsNullOrEmpty(txtSequenceNumber.Text)) { clientDocument.SequenceNumber = Convert.ToInt32(txtSequenceNumber.Text); } else { clientDocument.SequenceNumber = 0; } // clientDocument.Update(); BUSClientDocument.ClientDocumentUpdate(clientDocument); MessageBox.Show("Client document updated successfully."); this.Close(); }
// ---------------------------------------------------------- // Save client documents // ---------------------------------------------------------- private static void Save( ClientDocumentSet clientDocumentSet, int documentSetUID, TreeView tvFileList ) { ClientDocument cdsl = new ClientDocument(); ClientDocumentSet docSet = new ClientDocumentSet(); var lodsl = new ListOfscClientDocSetDocLink(); lodsl.list = new List <scClientDocSetDocLink>(); // Move data into views.. int selUID = documentSetUID; docSet.Get(clientDocumentSet.FKClientUID, selUID); docSet.ClientSetID = selUID; docSet.Folder = clientDocumentSet.Folder; docSet.SourceFolder = clientDocumentSet.SourceFolder; docSet.Description = clientDocumentSet.Description; docSet.Update(); // Save complete tree... SaveTreeViewToClient(tvFileList, 0, clientDocumentSet); }
// ------------------------------------------------------------ // Cop\y document links from Document Set Document Link // ------------------------------------------------------------ public void ReplicateDocSetDocLinkToClient(int ClientUID, int ClientSetUID, int DocumentSetUID) { // 1... GetClientDocument // List documents for a Client Set Document // var clientDocumentList = new ClientDocument(); clientDocumentList.List(ClientUID, ClientSetUID); // 2... foreach( clientDocument ) // For each client document, retrieve the linked documents // foreach (var clientDocument in clientDocumentList.clientDocSetDocLink) { // 3...... GetDocumentChildren( currentClientDocument) // This part retrieves Document Links and not ClientDocument Links var children = DocumentSetDocumentLinkList.ListRelatedDocuments(DocumentSetUID, clientDocument.document.UID, type: "ALL"); // 4...... foreach (GetDocumentChildren) foreach (var child in children.documentSetDocumentLinkList) { // 5..... CreateClientDocumentLink(Client,ClientSet,DocumentParent,DocumentChild, Type) ClientDocumentLink newLink = new ClientDocumentLink(); newLink.FKClientDocumentSetUID = ClientSetUID; newLink.FKClientUID = ClientUID; newLink.FKParentDocumentUID = clientDocument.document.UID; newLink.FKChildDocumentUID = child.FKChildDocumentUID; newLink.LinkType = child.LinkType; newLink.Add(); } } }
public void Updates_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; _clientDocuments.Add(newCustomer); int idToFind = newCustomer.ClientDocumentId; // Go find the new record after reloading: _clientDocuments = new BiggyList <ClientDocument>(new PGDocumentStore <ClientDocument>(_connectionStringName)); var updateMe = _clientDocuments.FirstOrDefault(cd => cd.ClientDocumentId == idToFind); // Update: updateMe.FirstName = "Bill"; _clientDocuments.Update(updateMe); // Go find the updated record after reloading: _clientDocuments = new BiggyList <ClientDocument>(new PGDocumentStore <ClientDocument>(_connectionStringName)); var updated = _clientDocuments.FirstOrDefault(cd => cd.ClientDocumentId == idToFind); Assert.True(updated.FirstName == "Bill"); }
/// <summary> /// Client document read /// </summary> /// <param name="clientContract"></param> /// <returns></returns> public static ResponseStatus ClientDocumentReadS(int clientDocumentUID) { ResponseStatus response = new ResponseStatus(); response = ClientDocument.ReadS(clientDocumentUID); return(response); }
public ActionResult UploadDocument(int id, ClientDocumentType docType) { List <FileUploadResponse> files = new List <FileUploadResponse>(); foreach (string fileName in HttpContext.Request.Files) { var file = Request.Files[fileName]; if (file != null && file.ContentLength > 0) { ClientDocument clientDoc = _fileService.SaveDocument(file, User.Identity.GetUserId(), docType, id); files.Add(new FileUploadResponse { name = clientDoc.File.Name, size = clientDoc.File.ContentLengthInBytes, thumbnailUrl = clientDoc.File.ThumbnailPath ?? "/Content/assets/img/filetypes/" + clientDoc.File.Extension.Replace(".", "") + ".png", deleteUrl = Url.Action("DeleteDoc", "File", new { id = clientDoc.FileId, area = "Agent", fn = clientDoc.File.Name }), deleteType = "GET", url = clientDoc.File.RelativePath, docType = clientDoc.DocumentType.ToString() }); } } return(Json(new FileResponseModel { files = files }, JsonRequestBehavior.AllowGet)); }
public async Task CreateAsync(UploadClientDocumentViewModel input, string userId, string imagePath) { Directory.CreateDirectory($"{imagePath}/clientDocuments/"); foreach (var image in input.Images) { var extension = Path.GetExtension(image.FileName).TrimStart('.'); if (!this.allowedExtensions.Any(x => extension.EndsWith(x))) { throw new Exception($"Invalid image extension {extension}"); } var dbImage = new ClientDocument { Size = (image.Length / 1000).ToString(), // size is in kb AddedByUserId = userId, CaseId = input.CaseId, Name = input.Name, Extension = extension, }; await this.clientDocumentsRepository.AddAsync(dbImage); await this.clientDocumentsRepository.SaveChangesAsync(); var physicalPath = $"{imagePath}/clientDocuments/{dbImage.Id}.{extension}"; using Stream fileStream = new FileStream(physicalPath, FileMode.Create); await image.CopyToAsync(fileStream); } }
/// <summary> /// Calculate the number of documents in the set /// </summary> /// <param name="iClientID"></param> /// <returns></returns> public int GetNumberOfDocuments() { int DocoCount = 0; DocoCount = ClientDocument.GetNumberOfDocuments(this.FKClientUID, this.ClientSetID); return(DocoCount); }
public static Client ToModel(this ClientDocument s) { if (s == null) { return(null); } return(Mapper.Map <ClientDocument, Client>(s)); }
/// <summary> /// Client document list /// </summary> /// <param name="clientContract"></param> /// <returns></returns> public static List <scClientDocSetDocLink> List(int clientUID, int clientDocumentSetUID) { var response = new List <scClientDocSetDocLink>(); response = ClientDocument.ListS(clientUID, clientDocumentSetUID); return(response); }
public void Adds_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; clientDocs.Add(newCustomer); Assert.Equal(1, clientDocs.Count); }
public void Adds_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; _clientDocuments.Add(newCustomer); Assert.Equal(1, _clientDocuments.Count()); }
public void Adds_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; IBiggyStore<ClientDocument> docStore = clientDocs as IBiggyStore<ClientDocument>; docStore.Add(newCustomer); docStore.Load(); Assert.Equal(1, docStore.Load().Count()); }
public ActionResult SendToClientConfirmed(FormCollection form) { long documentID = long.Parse(form["document_id"]); long clientID = long.Parse(form["client_id"]); Document document = db.Documents.Find(documentID); UserData client = db.UsersData.Find(clientID); ClientDocument clientDocument = new ClientDocument(); clientDocument.Document = document; clientDocument.Client = client; db.ClientDocuments.Add(clientDocument); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Adds_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; IBiggyStore <ClientDocument> docStore = clientDocs as IBiggyStore <ClientDocument>; docStore.Add(newCustomer); docStore.Load(); Assert.Equal(1, docStore.Load().Count()); }
// GET: /ClientDocument/Details/5 public ActionResult Details(int?id) { if (id == null) { return(RedirectToAction("BadRequest", "Error")); } ClientDocument clientdocument = db.ClientDocuments.Find(id); if (clientdocument == null) { return(RedirectToAction("NotFound", "Error")); } return(View(clientdocument)); }
// GET: /ResourceDocument/Create public ActionResult Upload(int clientId) { try { ViewBag.DocumentTypes = new SelectList(db.DocumentTypes.Where(d => d.DocumentGroup == (int)DocumentGroup.ClientDocument).OrderBy(d => d.Name), "DocumentTypeId", "Name"); var clientDoc = new ClientDocument(); clientDoc.ClientId = clientId; return(View(clientDoc)); } catch (Exception exp) { Logger.LogException(exp); return(RedirectToAction("AppError", "Error")); } }
public ActionResult Upload([Bind(Include = "ClientDocumentId,ClientId,DocumentTypeId,Description")] ClientDocument clientdocument) { try { if (ModelState.IsValid) { if (Request.Files.Count > 0) { foreach (string fileName in Request.Files) { HttpPostedFileBase file = file = Request.Files[fileName]; if (file != null && file.ContentLength > 0) { var allowedExtensions = new Utility().DocumentExtensions; var extension = Path.GetExtension(file.FileName); if (!allowedExtensions.Contains(extension)) { ModelState.AddModelError("FilePath", "The extension " + extension + " files are not allowed."); ViewBag.DocumentTypes = new SelectList(db.DocumentTypes, "DocumentTypeId", "Name", clientdocument.DocumentTypeId); return(View(clientdocument)); } string path = clientdocument.DocumentPath + clientdocument.ClientId.ToString() + "_" + clientdocument.DocumentTypeId.ToString() + "_" + DateTime.Now.ToString("MMddyyyyhhmmss") + "_" + Path.GetFileName(file.FileName); string savedFileName = Path.Combine(Server.MapPath("~" + path)); file.SaveAs(savedFileName); clientdocument.ContentType = file.ContentType; clientdocument.FilePath = path; clientdocument.FileName = file.FileName; clientdocument.UploadedBy = User.Identity.GetUserId(); clientdocument.UploadedTimestamp = DateTime.Now; db.ClientDocuments.Add(clientdocument); db.SaveChanges(); return(RedirectToAction("Index", new { clientId = clientdocument.ClientId })); } } } } ViewBag.DocumentTypes = new SelectList(db.DocumentTypes.Where(d => d.DocumentGroup == (int)DocumentGroup.ClientDocument).OrderBy(d => d.Name), "DocumentTypeId", "Name"); return(View(clientdocument)); } catch (Exception exp) { Logger.LogException(exp); return(RedirectToAction("AppError", "Error")); } }
// GET: /ClientDocument/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(RedirectToAction("BadRequest", "Error")); } ClientDocument clientdocument = db.ClientDocuments.Find(id); if (clientdocument == null) { return(RedirectToAction("NotFound", "Error")); } ViewBag.ClientId = new SelectList(db.Clients, "ClientId", "Name", clientdocument.ClientId); ViewBag.DocumentTypeId = new SelectList(db.DocumentTypes, "DocumentTypeId", "Name", clientdocument.DocumentTypeId); return(View(clientdocument)); }
public void Deletes_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; clientDocs.Add(newCustomer); // Count after adding new: int initialCount = clientDocs.Load().Count(); var removed = clientDocs.Remove(newCustomer); // Count after removing and reloading: int finalCount = clientDocs.Load().Count(); Assert.True(finalCount < initialCount); }
/// <summary> /// This operation updates the destination folder following the /// hierarchy of the tree instead of the initial location. /// </summary> /// <param name="documentsTreeNode"></param> public static ResponseStatus UpdateDestinationFolder(int clientID, int clientDocumentSetUID) { ResponseStatus response = new ResponseStatus(); response.Contents = "Destination folder updated successfully."; var listOfDocuments = ClientDocument.ListS(clientID, clientDocumentSetUID); foreach (var doco in listOfDocuments) { // Update location // ResponseStatus destLocationDerivedClient = ClientDocument.GetDocumentPath(doco.clientDocument); string destLocationDerived = destLocationDerivedClient.Contents.ToString(); ClientDocument.UpdateFieldString(doco.clientDocument.UID, "Location", destLocationDerived); } return(new ResponseStatus()); }
/// <summary> /// Generate document for client (no treeview required) /// </summary> public void GenerateDocumentForClient() { // Load documents in tree // TreeView tvFileList = new TreeView(); // List client document list // var documentSetList = new ClientDocument(); documentSetList.List(this.clientID, this.clientDocSetID); tvFileList.Nodes.Clear(); documentSetList.ListInTree(tvFileList, "CLIENT"); // Generate document // this.GenerateDocumentsForClient(tvFileList.Nodes[0]); }
// ---------------------------------------------------------------------- // List documents available for selection in list box tvListOfDocuments // ---------------------------------------------------------------------- public void loadDocumentList() { // Image list // ImageList imageList = ControllerUtils.GetImageList(); // Binding tvListOfDocuments.ImageList = imageList; // Clear nodes tvListOfDocuments.Nodes.Clear(); var docoList = new ClientDocument(); // docoList.List(Utils.ClientID, Utils.ClientSetID); var cdlr = new BUSClientDocument.ClientDocumentListRequest(); cdlr.clientUID = Utils.ClientID; cdlr.clientDocumentSetUID = Utils.ClientSetID; var response = BUSClientDocument.List(cdlr); // Load document in the treeview // // docoList.ListInTree(tvListOfDocuments); Document root = new Document(); root.CUID = "ROOT"; root.RecordType = FCMConstant.RecordType.FOLDER; root.UID = 0; // root.Read(); // root = RepDocument.Read(false, 0, "ROOT"); root = BUSDocument.GetRootDocument(); // docoList.ListInTree(tvListOfDocuments, "CLIENT"); BUSClientDocument.ListInTree(docoList, tvListOfDocuments, "CLIENT"); tvListOfDocuments.ExpandAll(); }
public void Deletes_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; _clientDocuments.Add(newCustomer); // Count after adding new: int initialCount = _clientDocuments.Count(); var removed = _clientDocuments.Remove(newCustomer); // Reload, make sure everything was persisted: _clientDocuments = new BiggyList <ClientDocument>(new PGDocumentStore <ClientDocument>(_connectionStringName)); // Count after removing and reloading: int finalCount = _clientDocuments.Count(); Assert.True(finalCount < initialCount); }
public ActionResult Edit([Bind(Include = "ClientDocumentId,ClientId,DocumentTypeId,FilePath")] ClientDocument clientdocument) { try { if (ModelState.IsValid) { db.Entry(clientdocument).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClientId = new SelectList(db.Clients, "ClientId", "Name", clientdocument.ClientId); ViewBag.DocumentTypeId = new SelectList(db.DocumentTypes, "DocumentTypeId", "Name", clientdocument.DocumentTypeId); return(View(clientdocument)); } catch (Exception exp) { Logger.LogException(exp); return(RedirectToAction("AppError", "Error")); } }
void Bulk_Inserts_Documents_With_Serial_PK() { int INSERT_QTY = 100; var bulkList = new List <ClientDocument>(); for (int i = 0; i < INSERT_QTY; i++) { var newClientDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newClientDocument); } clientDocs.Add(bulkList); var inserted = clientDocs.Load(); Assert.True(inserted.Count() == INSERT_QTY); }
public void Bulk_Inserts_Documents_With_Serial_PK() { int INSERT_QTY = 100; var bulkList = new List<ClientDocument>(); for (int i = 0; i < INSERT_QTY; i++) { var newClientDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newClientDocument); } _clientDocuments.Add(bulkList); // Reload, make sure everything was persisted: _clientDocuments = new BiggyList<ClientDocument>(new PGDocumentStore<ClientDocument>(_connectionStringName)); var last = _clientDocuments.Last(); Assert.True(_clientDocuments.Count() == INSERT_QTY && last.ClientDocumentId >= INSERT_QTY); }
public ActionResult DeleteConfirmed(int id) { try { ClientDocument clientdocument = db.ClientDocuments.Find(id); string path = Request.MapPath(clientdocument.FilePath); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } db.ClientDocuments.Remove(clientdocument); db.SaveChanges(); return(RedirectToAction("Index", new { clientId = clientdocument.ClientId })); } catch (Exception exp) { Logger.LogException(exp); return(RedirectToAction("AppError", "Error")); } }
// ------------------------------------------------------- // Populate combo box with list of client Documents // ------------------------------------------------------- private void PopulateDocumentCombo(char ProjectPlan) { // List documents // ------------------------------------------------------- var documentSetList = new ClientDocument(); // documentSetList.List(Utils.ClientID, Utils.ClientSetID); var cdlr = new BUSClientDocument.ClientDocumentListRequest(); cdlr.clientUID = Utils.ClientID; cdlr.clientDocumentSetUID = Utils.ClientSetID; var response = BUSClientDocument.List(cdlr); documentSetList.clientDocSetDocLink = response.clientList; cbxDocument.Items.Clear(); cbxDocument.SelectedText = ""; int i = 0; foreach (var doco in documentSetList.clientDocSetDocLink) { string item = doco.document.UID + ";" + doco.document.CUID + ";" + doco.document.Name; cbxDocument.Items.Add(item); if (i == 0) { cbxDocument.ResetText(); cbxDocument.SelectedText = item; } if (i == 0) { cbxDocument.Text = item; } i++; } }
public void Updates_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; clientDocs.Add(newCustomer); int idToFind = newCustomer.ClientDocumentId; // Go find the new record after reloading: clientDocs.Reload(); var updateMe = clientDocs.FirstOrDefault(cd => cd.ClientDocumentId == idToFind); // Update: updateMe.FirstName = "Bill"; clientDocs.Update(updateMe); // Go find the updated record after reloading: clientDocs.Reload(); var updated = clientDocs.FirstOrDefault(cd => cd.ClientDocumentId == idToFind); Assert.True(updated.FirstName == "Bill"); }
void Deletes_Range_of_Documents_With_Serial_PK() { int INSERT_QTY = 100; var bulkList = new List<ClientDocument>(); for (int i = 1; i <= INSERT_QTY; i++) { var newBuildingDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newBuildingDocument); } clientDocs.Add(bulkList); var inserted = clientDocs.Load(); int insertedCount = inserted.Count; var deleteUs = inserted.Where(b => b.ClientDocumentId > 50); clientDocs.Remove(deleteUs.ToList()); var remaining = clientDocs.Load(); Assert.True(insertedCount > remaining.Count && remaining.Count == 50); }
void Bulk_Inserts_Documents_With_Serial_PK() { var updateable = clientDocs as IUpdateableBiggyStore<ClientDocument>; int INSERT_QTY = 100; var bulkList = new List<ClientDocument>(); for (int i = 0; i < INSERT_QTY; i++) { var newClientDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newClientDocument); } updateable.Add(bulkList); var inserted = updateable.Load(); Assert.True(inserted.Count() == INSERT_QTY); }
public void Deletes_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; var docStore = clientDocs as IUpdateableBiggyStore<ClientDocument>; docStore.Add(newCustomer); // Count after adding new: int initialCount = docStore.Load().Count(); var removed = docStore.Remove(newCustomer); // Count after removing and reloading: int finalCount = docStore.Load().Count(); Assert.True(finalCount < initialCount); }
public void Updates_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; _clientDocuments.Add(newCustomer); int idToFind = newCustomer.ClientDocumentId; // Go find the new record after reloading: _clientDocuments = new BiggyList<ClientDocument>(new PGDocumentStore<ClientDocument>(_connectionStringName)); var updateMe = _clientDocuments.FirstOrDefault(cd => cd.ClientDocumentId == idToFind); // Update: updateMe.FirstName = "Bill"; _clientDocuments.Update(updateMe); // Go find the updated record after reloading: _clientDocuments = new BiggyList<ClientDocument>(new PGDocumentStore<ClientDocument>(_connectionStringName)); var updated = _clientDocuments.FirstOrDefault(cd => cd.ClientDocumentId == idToFind); Assert.True(updated.FirstName == "Bill"); }
static void Bulk_Inserts_Documents_With_Serial_PK() { int insertQty = 100; var ClientDocuments = new PGDocumentList<ClientDocument>("chinookPG"); var bulkList = new List<ClientDocument>(); for (int i = 0; i < insertQty; i++) { var newClientDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newClientDocument); } int inserted = ClientDocuments.AddRange(bulkList); var last = ClientDocuments.Last(); Assert.True(inserted == insertQty && last.ClientDocumentId >= insertQty); }
public void Deletes_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; _clientDocuments.Add(newCustomer); // Count after adding new: int initialCount = _clientDocuments.Count(); var removed = _clientDocuments.Remove(newCustomer); // Reload, make sure everything was persisted: _clientDocuments = new BiggyList<ClientDocument>(new PGDocumentStore<ClientDocument>(_connectionStringName)); // Count after removing and reloading: int finalCount = _clientDocuments.Count(); Assert.True(finalCount < initialCount); }
public void Deletes_Document_With_Serial_PK() { var newCustomer = new ClientDocument { Email = "*****@*****.**", FirstName = "Rob", LastName = "Conery" }; clientDocs.Add(newCustomer); // Count after adding new: int initialCount = clientDocs.Count; var removed = clientDocs.Remove(newCustomer); clientDocs.Reload(); // Count after removing and reloading: int finalCount = clientDocs.Count; Assert.True(finalCount < initialCount && removed); }
static void Bulk_Inserts_Documents_With_Serial_PK() { int insertQty = 100; var ClientDocuments = new SQLDocumentList<ClientDocument>("chinook"); var bulkList = new List<ClientDocument>(); for (int i = 0; i < insertQty; i++) { var newClientDocument = new ClientDocument { FirstName = "ClientDocument " + i, LastName = "Test", Email = "*****@*****.**" }; bulkList.Add(newClientDocument); } int inserted = ClientDocuments.AddRange(bulkList); // I have NO IDEA why this silliness suddenly became necessary (the .ToList().Last() bit). // This test worked fine last nite. Now says SQLDocumentList<> has no extension Last() JA - 3/12/2014 Assert.True(inserted == insertQty && ClientDocuments.ToList().Last().ClientDocumentId > insertQty); }