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