private void LogCustomer(CustomerDocument customerDocument) { var url = $"{Properties.Settings.Default.ServerAddress}/api/resource/Sage 50 Export Log"; var resource = new Resource(url); resource.LogCustomer(customerDocument); }
public void AddCustomerDocument(CustomerDocument cd) { var cus = _customerRepository.GetById(cd.CustomerId); cus.Documents.Add(cd); _customerRepository.Update(cus); }
public void Update(CustomerDocument model) { _context.Entry(model).State = System.Data.Entity.EntityState.Modified; _context.SaveChanges(); //_context.CustomerDocuments.Attach(model); //_context.SaveChanges(); }
private void AddContacts(Customer customer, CustomerDocument customerDocument) { foreach (var c in customerDocument.Contacts) { if (!string.IsNullOrEmpty(customer.BillToContact.CompanyName) && !string.IsNullOrEmpty(customer.ShipToContact.CompanyName)) { break; } else if (customer.BillToContact.Address.Address1 != null && (string.IsNullOrEmpty(customer.BillToContact.CompanyName) && (customer.BillToContact.Address.Address1 != null || customer.BillToContact.Address.Address1.Length != 0))) { customer.BillToContact.CompanyName = customerDocument.CustomerName; customer.BillToContact.Email = c.EmailId; customer.BillToContact.FirstName = c.FirstName; customer.BillToContact.Gender = c.Gender == "Male" ? Gender.Male : c.Gender == "Female" ? Gender.Female : Gender.NotSpecified; customer.BillToContact.LastName = c.LastName; customer.BillToContact.Title = c.Salutation; } else if (customer.ShipToContact.Address.Address1 != null && (string.IsNullOrEmpty(customer.ShipToContact.CompanyName) && (customer.ShipToContact.Address.Address1 != null || customer.ShipToContact.Address.Address1.Length != 0))) { customer.ShipToContact.CompanyName = customerDocument.CustomerName; customer.ShipToContact.Email = c.EmailId; customer.ShipToContact.FirstName = c.FirstName; customer.ShipToContact.Gender = c.Gender == "Male" ? Gender.Male : c.Gender == "Female" ? Gender.Female : Gender.NotSpecified; customer.ShipToContact.LastName = c.LastName; customer.ShipToContact.Title = c.Salutation; } } }
private static void AddAddresses(Customer customer, CustomerDocument customerDocument) { var billingAddress = customerDocument.Addresses.Find(x => x.AddressType == "Billing"); var shippingAddress = customerDocument.Addresses.Find(x => x.AddressType == "Shipping"); if (billingAddress != null) { var state = TransformState(billingAddress.State); customer.BillToContact.Address.Address1 = billingAddress.AddressLine1; customer.BillToContact.Address.Address2 = billingAddress.AddressLine2; customer.BillToContact.Address.City = billingAddress.City; customer.BillToContact.Address.State = GetStateFromPredefinedStates(state); customer.BillToContact.Address.Zip = billingAddress.Pincode; customer.BillToContact.Address.Country = billingAddress.Country; } if (shippingAddress != null) { var state = TransformState(shippingAddress.State); customer.ShipToContact.Address.Address1 = shippingAddress.AddressLine1; customer.BillToContact.Address.Address2 = shippingAddress.AddressLine2; customer.BillToContact.Address.City = shippingAddress.City; customer.BillToContact.Address.State = GetStateFromPredefinedStates(state); customer.BillToContact.Address.Zip = shippingAddress.Pincode; customer.BillToContact.Address.Country = shippingAddress.Country; } }
public void ShouldSetBestNewAge() { var service = new MergeService(_dataAccess.Object, _repository.Object); var newCustomer = new MappedCustomerMessage { CustomerId = 1, SourceId = 2, Data = new Dictionary <string, Dictionary <string, object> > { { "edad", new Dictionary <string, object> { { "2", 36 } } } } }; var customerDocument = new CustomerDocument("1") { Data = new Dictionary <string, object> { { "nombre", "cliente prueba" }, { "edad", 35 } }, Full = JObject.Parse(elasticCustomer) }; _dataAccess.Setup(x => x.Get <CustomerDocument>(It.IsAny <string>())).Returns(customerDocument); _dataAccess.Setup(x => x.Put(It.IsAny <CustomerDocument>())); service.Save("1", newCustomer); _dataAccess.Verify(x => x.Put(It.Is <CustomerDocument>(y => y.Data.Any(z => z.Key == "edad" && ((int)z.Value) == 36)))); }
public ActionResult _AddDocument(int id) { var cd = new CustomerDocument { CustomerId = id }; return(PartialView("_EditCustomerDocument", Mapper.Map <CustomerDocument, CustomerDocumentVM>(cd))); }
public void AddsDocument() { var newCustomer = new CustomerDocument { Email = "*****@*****.**", First = "Rob", Last = "Conery" }; docs.Add(newCustomer); Assert.Equal(1, docs.Count); }
public int Insert(CustomerDocument obj) { return(QueryExecutor.Execute(StoreProcedures.sp_CustomerDocument_Insert.ToString(), new { obj.DocumentTypeId, obj.CustomerId, obj.DocumentNumber, obj.DocumentIssueBy, obj.DocumentIssueDate, obj.DocumentExpiryDate, })); }
public void DeletesDocument() { var newCustomer = new CustomerDocument { Email = "*****@*****.**", First = "Rob", Last = "Conery" }; docs.Add(newCustomer); var removed = docs.Remove(newCustomer); Assert.True(removed); }
public void UpdatesDocument() { var newCustomer = new CustomerDocument { Email = "*****@*****.**", First = "Rob", Last = "Conery" }; docs.Add(newCustomer); newCustomer.First = "Bill"; var updated = docs.Update(newCustomer); Assert.Equal(1, updated); }
static void Main(string[] args) { try { PmsEteckContext db = new PmsEteckContext(); Console.WriteLine("We starten nu met het downloaden van de documenten per entiteit"); CustomerDocument _customerDocument = new CustomerDocument(); List <CustomerDocument> documentsForDownload = db.CustomerDocuments.Where(w => !w.bDownloaded && w.sUrl.StartsWith("http://dms.eteck.nl/ufc")).ToList(); Console.WriteLine(string.Format("De lijst met documenten is opgehaald en bevat {0} items", documentsForDownload.Count)); foreach (var item in documentsForDownload) { Console.WriteLine(string.Format("Gestart met het downloaden van document: {0}", item.sDocumentName)); bool result = _customerDocument.SaveFile(item.iCustomerDocumentKey); if (!result) { Console.WriteLine(string.Format("Er heeft zich een fout voorgedaan bij het downloaden van document {0}", item.sDocumentName)); } else { Console.WriteLine(string.Format("Het downloaden van het bestand is voltooid: {0}", item.sDocumentName)); } } Console.WriteLine("We starten met het downloaden van alle documenten."); Hyperlink _hyperlink = new Hyperlink(); List <Hyperlink> hyperlinksForDownload = db.Hyperlinks.Where(w => !w.bDownloaded && w.sUrl.StartsWith("http://dms.eteck.nl/ufc")).ToList(); Console.WriteLine(string.Format("De lijst met hyperlinks is opgehaald. Dit zijn er {0}", hyperlinksForDownload.Count)); foreach (Hyperlink hyperlink in hyperlinksForDownload) { Console.WriteLine(string.Format("Gestart met het downloaden van document: {0}", hyperlink.sLinkName)); bool result = _hyperlink.SaveFile(hyperlink.iHyperlinkKey); if (!result) { Console.WriteLine(string.Format("Er heeft zich een fout voorgedaan bij het downloaden van document {0}", hyperlink.sLinkName)); } else { Console.WriteLine(string.Format("Het downloaden van het bestand is voltooid: {0}", hyperlink.sLinkName)); } } Console.WriteLine("Alle bestanden zijn gedownload."); } catch (Exception e) { Console.WriteLine(e.Message); throw; } }
private void AddSalesRep(Customer customer, CustomerDocument customerDocument) { EmployeeList employees = Company.Factories.EmployeeFactory.List(); employees.Load(); foreach (var item in employees) { if (item.Name != customerDocument.SalesRep) { continue; } customer.SalesRepresentativeReference = item.Key; break; } }
protected void btnUpdate_Click(object sender, EventArgs e) { string Editor_contentHeader = HeaderEditor.Content; string Editor_contentFooter = FooterEditor.Content; string Editor_contentBody = BodyEditor.Content; List <CustomerDocument> custDocs = new List <CustomerDocument>(); int intFileSize = flVendCat.PostedFile.ContentLength; if (flVendCat.HasFile) { if (flVendCat.PostedFile.FileName != "") { if (Request.Files.Count > 0) { HttpFileCollection attachments = Request.Files; for (int i = 0; i < attachments.Count; i++) { HttpPostedFile attachment = attachments[i]; if (attachment.ContentLength > 0 && !String.IsNullOrEmpty(attachment.FileName)) { CustomerDocument cbc = new CustomerDocument(); if (File.Exists(Server.MapPath("../CustomerDocs/VendorEmailDocument/") + attachment.FileName) == true) { File.Delete(Server.MapPath("../CustomerDocs/VendorEmailDocument/") + attachment.FileName); flVendCat.PostedFile.SaveAs(Server.MapPath("../CustomerDocs/VendorEmailDocument/") + attachment.FileName); } else { flVendCat.PostedFile.SaveAs(Server.MapPath("../CustomerDocs/VendorEmailDocument/") + attachment.FileName); } string fPath; fPath = ("../CustomerDocs/VendorEmailDocument/") + attachment.FileName; cbc.DocumentName = attachment.FileName; cbc.DocumentPath = fPath; custDocs.Add(cbc); } } } } } bool result = AdminBLL.Instance.UpdateHTMLTemplate(Editor_contentHeader, Editor_contentBody, Editor_contentFooter, txtSubject.Text, SubHTMLTemplateID, custDocs); if (result) { InitialDataBind(SubHTMLTemplateID); ScriptManager.RegisterStartupScript(this, this.GetType(), "AlertBox", "alert('Auto Email Template Updated Successfully');", true); } }
public IRestResponse LogCustomer(CustomerDocument document) { var log = new Log { document_name = document.Name, export_date = DateTime.Now.ToString("yyyy-MM-dd"), document_date = DateTime.Now.ToString("yyyy-MM-dd"), document_type = "Customer" }; var request = new RestRequest(Method.POST); request.AddJsonBody(log); var response = _restClient.Execute(request); return(response); }
public ValidationMessage Insert(CustomerDocument obj) { var URL = string.Format(AppSettings.BaseApiUrl + ApiUrls.CustomerDocument.Insert); var Content = Post <string>(URL, obj); if (Content.IsSuccessful) { return(new ValidationMessage()); } else { return(new ValidationMessage() { Message = Content.Message }); } }
public void RecordsPopulated() { docs.Clear(); var newCustomer = new CustomerDocument { Email = "*****@*****.**", First = "Buddy", Last = "Conery" }; docs.Add(newCustomer); //load a new, separate list var customers = new PGDocumentList <CustomerDocument>("dvds"); //there should be some records here based on the above Assert.Equal("*****@*****.**", customers.First().Email); Assert.Equal("Buddy", customers.First().First); Assert.Equal("Conery", customers.First().Last); }
public async Task <IActionResult> GetCustomerDocumentById(Int64 CustomerDocumentId) { CustomerDocument Items = new CustomerDocument(); try { Items = await _context.CustomerDocument.Where(q => q.CustomerDocumentId == CustomerDocumentId).FirstOrDefaultAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } return(await Task.Run(() => Ok(Items))); }
private Customer CreateNewCustomer(CustomerDocument customerDocument) { var customer = Company.Factories.CustomerFactory.Create(); if (customer == null) { Logger.Information("Customer data was null when trying to create Sage customer"); return(null); } if (customerDocument == null || customerDocument.Addresses.Count == 0) { Logger.Information("Customer has no address so the customer cannot be created"); return(customer); } try { customer.ID = customerDocument.OldCustomerId; // add a field - ID to Customer doctype customer.Name = customerDocument.CustomerName; AddContact(customer, customerDocument); AddSalesRep(customer, customerDocument); customer.Save(); Logger.Information("Customer - {Customer} saved successfully", customerDocument.CustomerName); } catch (ValidationException e) { Logger.Debug("Validation failed."); Logger.Debug(e.Message); Logger.Debug("{@Name} will be sent back to the queue", customerDocument.Name); customer = null; } catch (RecordInUseException) { customer = null; Logger.Debug("Record is in use. {@Name} will be sent back to the queue", customerDocument.Name); } catch (Exception e) { customer = null; Logger.Debug(e, e.Message); Logger.Debug("{@E}", e); } return(customer); }
public async Task <ActionResult <CustomerDocument> > Insert([FromBody] CustomerDocument _CustomerDocument) { CustomerDocument _CustomerDocumentq = new CustomerDocument(); try { _CustomerDocumentq = _CustomerDocument; _context.CustomerDocument.Add(_CustomerDocumentq); await _context.SaveChangesAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } return(await Task.Run(() => Ok(_CustomerDocumentq))); }
public ActionResult _AddDocument(CustomerDocumentVM mCustomerDocument) { var cd = new CustomerDocument(); if (TryUpdateModel(cd)) { cd.LoadFile(mCustomerDocument.FilePath); DocumentController.RemoveFile(mCustomerDocument.FilePath); if (ExecuteRepositoryAction(() => { _customerService.AddCustomerDocument(cd); _customerService.CommitChanges(); })) { return(ReturnJsonFormSuccess()); } } return(PartialView("_EditCustomerDocument", mCustomerDocument)); }
private void AddContact(Customer customer, CustomerDocument customerDocument) { if (customerDocument.Addresses.Count > 0) { customer.Email = customerDocument.CustomerEmail; customer.ShipVia = customerDocument.ShipVia; customer.WebSiteURL = customerDocument.CompanyWebsite; customer.CustomerSince = DateTime.Now; customer.IsInactive = customerDocument.Disabled == 1; AddAddresses(customer, customerDocument); AddContacts(customer, customerDocument); } else { Logger.Information("Customer {@Name} did not have addresses so will not create a contact", customer.Name); ContactList contactsList = customer.Contacts; contactsList.Clear(); } }
public void Save(string customerId, MappedCustomerMessage message) { var currentDocument = _customersDataAccess.Get <CustomerDocument>(customerId); var upsertCustomer = new CustomerDocument(customerId); var dataToMerge = JObject.FromObject(message.Data); if (currentDocument == null) { upsertCustomer.Data = message.Data.ToDictionary(x => x.Key, x => x.Value.First().Value); upsertCustomer.Full = dataToMerge; } else { var currentCustomerFull = new JObject(currentDocument.Full); currentCustomerFull.Merge(dataToMerge, new JsonMergeSettings { MergeArrayHandling = MergeArrayHandling.Union }); upsertCustomer.Full = currentCustomerFull; upsertCustomer.Data = currentDocument.Data; foreach (var customerFieldName in message.Data.Select(x => x.Key)) { var filters = _fieldMaps.Where(x => x.CustomerField.FieldName.Equals(customerFieldName, StringComparison.InvariantCultureIgnoreCase)); var token = currentCustomerFull.GetValue(customerFieldName, StringComparison.InvariantCultureIgnoreCase); foreach (var fieldMap in filters.Where(x => x.SourceField != null).OrderBy(x => x.Order)) { var customerValue = token[fieldMap.SourceField.SourceId.ToString()]; if (customerValue != null) { upsertCustomer.Data[customerFieldName] = ((JValue)customerValue).Value; break; } } } } _customersDataAccess.Put(upsertCustomer); }
public async Task <IActionResult> Delete([FromBody] CustomerDocument _CustomerDocument) { CustomerDocument _CustomerDocumentq = new CustomerDocument(); try { _CustomerDocumentq = _context.CustomerDocument .Where(x => x.CustomerDocumentId == (Int64)_CustomerDocument.CustomerDocumentId) .FirstOrDefault(); _context.CustomerDocument.Remove(_CustomerDocumentq); await _context.SaveChangesAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}"))); } return(await Task.Run(() => Ok(_CustomerDocumentq))); }
public async Task <ActionResult <CustomerDocument> > Update([FromBody] CustomerDocument _CustomerDocument) { CustomerDocument _CustomerDocumentq = _CustomerDocument; try { _CustomerDocumentq = await(from c in _context.CustomerDocument .Where(q => q.CustomerDocumentId == _CustomerDocument.CustomerDocumentId) select c ).FirstOrDefaultAsync(); _context.Entry(_CustomerDocumentq).CurrentValues.SetValues((_CustomerDocument)); //_context.CustomerDocument.Update(_CustomerDocumentq); await _context.SaveChangesAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}"))); } return(await Task.Run(() => Ok(_CustomerDocumentq))); }
public void Update(CustomerDocument model) { _repository.Update(model); }
public int Create(CustomerDocument model) { return(_repository.Save(model)); }
public HttpResponseMessage UploadImage(string aid, string pass) { string Image = null; string filename = null; var httpRequest = HttpContext.Current.Request; if (httpRequest.Files.GetKey(0).ToString() == "btnPan") { Image = "btnPan"; } else if (httpRequest.Files.GetKey(0).ToString() == "btnVoter") { Image = "btnVoter"; } else if (httpRequest.Files.GetKey(0).ToString() == "btnSalSlip") { Image = "btnSalSlip"; } else if (httpRequest.Files.GetKey(0).ToString() == "btnLoa") { Image = "btnLoa"; } else if (httpRequest.Files.GetKey(0).ToString() == "btnNoc") { Image = "btnNoc"; } else if (httpRequest.Files.GetKey(0).ToString() == "btnAgrSale") { Image = "btnAgrSale"; } //filename = new string(Path.GetFileNameWithoutExtension(postedFile.FileName).Take(10).ToArray()).Replace(" ", "-"); //filename = filename + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(postedFile.FileName); var postedFile = httpRequest.Files[Image]; filename = new String(Path.GetFileName(postedFile.FileName).Take(10).ToArray()); var filepath = HttpContext.Current.Server.MapPath("~/Image/" + filename); //sets file path to Image folder in VS Project postedFile.SaveAs(filepath); //CustomerDocument file = new CustomerDocument(); if (httpRequest.Files.GetKey(0).ToString() == "btnPan") { //file.PanCard = filename; //db.CustomerDocuments.Add(file); //db.SaveChanges(); CustomerDocument cd = new CustomerDocument(); //file.PanCard = filename; cd.ApplicationID = aid; cd.PanCard = filename; db.CustomerDocuments.Add(cd); db.SaveChanges(); } else if (httpRequest.Files.GetKey(0).ToString() == "btnVoter") { //file.VoterID = filename; //db.CustomerDocuments.Add(file); //db.SaveChanges(); CustomerDocument cd = db.CustomerDocuments.ToList().Find(x => x.ApplicationID == aid); cd.VoterID = filename; db.SaveChanges(); } else if (httpRequest.Files.GetKey(0).ToString() == "btnSalSlip") { CustomerDocument cd = db.CustomerDocuments.ToList().Find(x => x.ApplicationID == aid); cd.SalarySlip = filename; db.SaveChanges(); } else if (httpRequest.Files.GetKey(0).ToString() == "btnLoa") { CustomerDocument cd = db.CustomerDocuments.ToList().Find(x => x.ApplicationID == aid); cd.LOA = filename; db.SaveChanges(); } else if (httpRequest.Files.GetKey(0).ToString() == "btnNoc") { CustomerDocument cd = db.CustomerDocuments.ToList().Find(x => x.ApplicationID == aid); cd.BuilderNOC = filename; db.SaveChanges(); } else if (httpRequest.Files.GetKey(0).ToString() == "btnAgrSale") { CustomerDocument cd = db.CustomerDocuments.ToList().Find(x => x.ApplicationID == aid); cd.SaleAgreement = filename; db.SaveChanges(); } return(Request.CreateResponse(HttpStatusCode.Created)); }
private void PersistCustomer() { Record.Customer = CustomerDocument.ToString(SaveOptions.None); }
public long CreateDocument(DocumentViewModel documentViewModel) { Data.Entities.Context.Document document = null; document = repository.GetContext().Documents.Where(e => e.Id == documentViewModel.Id).FirstOrDefault(); if (document == null) { //Directory with same name already exists var documentType = repository.GetContext().DocumentTypes.Where(x => x.Name.ToLower() == documentViewModel.DocumentTypeViewModel.Name.ToLower()).FirstOrDefault(); if (documentType == null) { documentType = repository.GetContext().DocumentTypes.FirstOrDefault(x => x.Name.ToLower() == "file"); } if (documentType != null) { document = new Data.Entities.Context.Document() { DocumentType = documentType, Name = documentViewModel.Name, Title = documentViewModel.Title }; document = repository.SaveNew(document); if (document?.Id > 0) { if (documentViewModel.CustomerId > 0) { ///Customer related documents CustomerDocument customerDocument = new CustomerDocument() { CustomerId = documentViewModel.CustomerId, DocumentId = document.Id }; try { customerDocument = repository.SaveNew(customerDocument); } catch (Exception ex) { throw; } } else if (documentViewModel.LoanId > 0) { ///Loan related documents LoanDocument loanDocument = new LoanDocument() { DocumentId = document.Id, LoanId = documentViewModel.LoanId }; try { loanDocument = repository.SaveNew(loanDocument); } catch (Exception ex) { throw; } } } } } return(document != null ? document.Id : 0); }