public async Task CreateFileData_Always_CreatesFileData() { // Arrange CustomerFile customerFile = new CustomerFile("WEE", (ulong)12345); var customerFileGeneratorResult = new IbisFileGeneratorResult <CustomerFile>(customerFile, A.Dummy <List <Exception> >()); IIbisCustomerFileGenerator customerFileGenerator = A.Fake <IIbisCustomerFileGenerator>(); A.CallTo(() => customerFileGenerator.CreateAsync(A <ulong> ._, A <InvoiceRun> ._)) .Returns(customerFileGeneratorResult); TransactionFile transactionFile = new TransactionFile("WEE", (ulong)12345); var ibisFileGeneratorResult = new IbisFileGeneratorResult <TransactionFile>(transactionFile, A.Dummy <List <Exception> >()); IIbisTransactionFileGenerator transactionFileGenerator = A.Fake <IIbisTransactionFileGenerator>(); A.CallTo(() => transactionFileGenerator.CreateAsync(A <ulong> ._, A <InvoiceRun> ._)) .Returns(ibisFileGeneratorResult); IIbisFileDataErrorTranslator errorTranslator = A.Dummy <IIbisFileDataErrorTranslator>(); IbisFileDataGenerator generator = new IbisFileDataGenerator( customerFileGenerator, transactionFileGenerator, errorTranslator); // Act var result = await generator.CreateFileDataAsync(A.Dummy <ulong>(), A.Dummy <InvoiceRun>()); var ibistFileData = result.IbisFileData; // Assert Assert.NotNull(ibistFileData); Assert.False(string.IsNullOrEmpty(ibistFileData.CustomerFileData)); Assert.False(string.IsNullOrEmpty(ibistFileData.TransactionFileData)); }
public IActionResult OnGet(int?Id) { //DBConnection DBCon = new DBConnection(); string DbString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Isaac Bowyer\source\repos\Primark\Primark\Data\Customer_Files.mdf;Integrated Security=True"; SqlConnection conn = new SqlConnection(DbString); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT * FROM CustomerFile WHERE Id = @Id"; command.Parameters.AddWithValue("@Id", Id); var reader = command.ExecuteReader(); CusFileRec = new CustomerFile(); while (reader.Read()) { CusFileRec.Id = reader.GetInt32(0); CusFileRec.CustomerFName = reader.GetString(1); CusFileRec.CustomerLName = reader.GetString(2); CusFileRec.FileName = reader.GetString(3); } Console.WriteLine("File name : " + CusFileRec.FileName); } return(Page()); }
public async Task <FileResult> Download(string fileId, string fileName) { //return File(Path.Combine(Server.MapPath("~/App_Data/Upload/"), p), System.Net.Mime.MediaTypeNames.Application.Octet, d); CustomerFile custFile = await APIServices.DownloadFile(fileId).ConfigureAwait(false); return(File(custFile.DocumentData, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); }
public async Task <IHttpActionResult> DownloadFile() { if (ClaimsPrincipal.Current.FindFirst("http://schemas.microsoft.com/identity/claims/scope").Value != "user_impersonation") { throw new HttpResponseException(new HttpResponseMessage { StatusCode = HttpStatusCode.Unauthorized, ReasonPhrase = "The Scope claim does not contain 'user_impersonation' or scope claim not found" }); } Claim subject = ClaimsPrincipal.Current.FindFirst(ClaimTypes.NameIdentifier); CustomerFile custFile = await ProcessCustomerFileData(); CloudBlobContainer container = GetContainer(); custFile = SqlDBRepository.GetLegalDocumentData(custFile.Id); CloudBlobDirectory caseDirectory = container.GetDirectoryReference("case" + custFile.CaseId.ToString().ToLower()); CloudBlockBlob blockBlob = caseDirectory.GetBlockBlobReference(custFile.Id.ToString() + "_" + custFile.DocumentType); blockBlob.FetchAttributes(); byte[] byteData = new byte[blockBlob.Properties.Length]; blockBlob.DownloadToByteArray(byteData, 0); custFile.DocumentData = byteData; return(Ok(custFile)); }
public async Task <HttpResponseMessage> DeleteFile() { if (ClaimsPrincipal.Current.FindFirst("http://schemas.microsoft.com/identity/claims/scope").Value != "user_impersonation") { throw new HttpResponseException(new HttpResponseMessage { StatusCode = HttpStatusCode.Unauthorized, ReasonPhrase = "The Scope claim does not contain 'user_impersonation' or scope claim not found" }); } Claim subject = ClaimsPrincipal.Current.FindFirst(ClaimTypes.NameIdentifier); CustomerFile custFile = await ProcessCustomerFileData(); CloudBlobContainer container = GetContainer(); custFile = SqlDBRepository.GetLegalDocumentData(custFile.Id); // Delete customer case directory from container for broker. CloudBlobDirectory caseDirectory = container.GetDirectoryReference("case" + custFile.CaseId.ToString().ToLower()); CloudBlockBlob blockBlob = caseDirectory.GetBlockBlobReference(custFile.Id.ToString() + "_" + custFile.DocumentType); blockBlob.DeleteIfExists(); bool status = SqlDBRepository.DeleteLegalDocument(custFile); return(new HttpResponseMessage() { StatusCode = HttpStatusCode.OK }); }
public void OnGet() { //DBConnection DBCon = new DBConnection(); string DbString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Isaac Bowyer\source\repos\Primark\Primark\Data\Customer_Files.mdf;Integrated Security=True"; SqlConnection conn = new SqlConnection(DbString); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT * FROM CustomerFile"; var reader = command.ExecuteReader(); FileRec = new List <CustomerFile>(); while (reader.Read()) { CustomerFile rec = new CustomerFile(); rec.Id = reader.GetInt32(0); rec.CustomerFName = reader.GetString(1); rec.CustomerLName = reader.GetString(2); rec.FileName = reader.GetString(3); FileRec.Add(rec); } } }
public ActionResult AddFile(int customerId, HttpPostedFileBase upload) { var customer = db.Read(customerId); if (isAuthorized(customer.Id) == AuthState.NoAuth) { return(View("NotAuthorized")); } if (upload != null && upload.ContentLength > 0) { var attachment = new CustomerFile() { ContentType = upload.ContentType, CustomerContentType = new CustomerContentType(), Name = System.IO.Path.GetFileName(upload.FileName), }; using (var reader = new System.IO.BinaryReader(upload.InputStream)) { attachment.CustomerContentType.Content = reader.ReadBytes(upload.ContentLength); } attachment.CustomerId = customerId; attachment.Customer = new Customer(); attachment.Customer.Id = customerId; dbFile.Create(attachment); } return(Redirect(Request.UrlReferrer.ToString())); }
public async Task CreateFileData_Always_CreatesFileData() { // Arrange CustomerFile customerFile = new CustomerFile("WEE", (ulong)12345); var customerFileGeneratorResult = new IbisFileGeneratorResult<CustomerFile>(customerFile, A.Dummy<List<Exception>>()); IIbisCustomerFileGenerator customerFileGenerator = A.Fake<IIbisCustomerFileGenerator>(); A.CallTo(() => customerFileGenerator.CreateAsync(A<ulong>._, A<InvoiceRun>._)) .Returns(customerFileGeneratorResult); TransactionFile transactionFile = new TransactionFile("WEE", (ulong)12345); var ibisFileGeneratorResult = new IbisFileGeneratorResult<TransactionFile>(transactionFile, A.Dummy<List<Exception>>()); IIbisTransactionFileGenerator transactionFileGenerator = A.Fake<IIbisTransactionFileGenerator>(); A.CallTo(() => transactionFileGenerator.CreateAsync(A<ulong>._, A<InvoiceRun>._)) .Returns(ibisFileGeneratorResult); IIbisFileDataErrorTranslator errorTranslator = A.Dummy<IIbisFileDataErrorTranslator>(); IbisFileDataGenerator generator = new IbisFileDataGenerator( customerFileGenerator, transactionFileGenerator, errorTranslator); // Act var result = await generator.CreateFileDataAsync(A.Dummy<ulong>(), A.Dummy<InvoiceRun>()); var ibistFileData = result.IbisFileData; // Assert Assert.NotNull(ibistFileData); Assert.False(string.IsNullOrEmpty(ibistFileData.CustomerFileData)); Assert.False(string.IsNullOrEmpty(ibistFileData.TransactionFileData)); }
public async Task CreateFileData_WithFileID_CreatesFilesWithCorrectFileNames() { // Arrange ulong fileID = 123; CustomerFile customerFile = new CustomerFile("WEE", (ulong)12345); var customerFileGeneratorResult = new IbisFileGeneratorResult<CustomerFile>(customerFile, A.Dummy<List<Exception>>()); IIbisCustomerFileGenerator customerFileGenerator = A.Fake<IIbisCustomerFileGenerator>(); A.CallTo(() => customerFileGenerator.CreateAsync(A<ulong>._, A<InvoiceRun>._)) .Returns(customerFileGeneratorResult); TransactionFile transactionFile = new TransactionFile("WEE", (ulong)12345); var ibisFileGeneratorResult = new IbisFileGeneratorResult<TransactionFile>(transactionFile, A.Dummy<List<Exception>>()); IIbisTransactionFileGenerator transactionFileGenerator = A.Fake<IIbisTransactionFileGenerator>(); A.CallTo(() => transactionFileGenerator.CreateAsync(A<ulong>._, A<InvoiceRun>._)) .Returns(ibisFileGeneratorResult); IIbisFileDataErrorTranslator errorTranslator = A.Dummy<IIbisFileDataErrorTranslator>(); IbisFileDataGenerator generator = new IbisFileDataGenerator( customerFileGenerator, transactionFileGenerator, errorTranslator); // Act var result = await generator.CreateFileDataAsync(fileID, A.Dummy<InvoiceRun>()); var ibistFileData = result.IbisFileData; // Assert Assert.NotNull(ibistFileData); Assert.Equal("WEEHC00123.dat", ibistFileData.CustomerFileName); Assert.Equal("WEEHI00123.dat", ibistFileData.TransactionFileName); }
private void accordionControlElement45_Click(object sender, EventArgs e) { cf = new CustomerFile(); cf.Show(); cf.Dock = DockStyle.Fill; panel2.Controls.Clear(); panel2.Controls.Add(cf); }
public IHttpActionResult PostCustomerFile(CustomerFile file) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Create(file); return(CreatedAtRoute("DefaultApi", new { id = file.Id }, file)); }
} // End of the GetCountByCustomerId method #endregion #region Get methods /// <summary> /// Get one customer file based on id /// </summary> /// <param name="customerId">The customer id</param> /// <param name="productId">The product id</param> /// <param name="languageId">The language id</param> /// <returns>A reference to a customer file post</returns> public static CustomerFile GetOneById(Int32 customerId, Int32 productId, Int32 languageId) { // Create the post to return CustomerFile post = null; // Create the connection and the sql statement string connection = Tools.GetConnectionString(); string sql = "SELECT * FROM dbo.customers_files WHERE customer_id = @customer_id AND " + "product_id = @product_id AND language_id = @language_id;"; // The using block is used to call dispose automatically even if there is a exception using (SqlConnection cn = new SqlConnection(connection)) { // The using block is used to call dispose automatically even if there is a exception using (SqlCommand cmd = new SqlCommand(sql, cn)) { // Add parameters cmd.Parameters.AddWithValue("@customer_id", customerId); cmd.Parameters.AddWithValue("@product_id", productId); cmd.Parameters.AddWithValue("@language_id", languageId); // Create a reader SqlDataReader reader = null; // The Try/Catch/Finally statement is used to handle unusual exceptions in the code to // avoid having our application crash in such cases try { // Open the connection. cn.Open(); // Fill the reader with one row of data. reader = cmd.ExecuteReader(); // Loop through the reader as long as there is something to read and add values while (reader.Read()) { post = new CustomerFile(reader); } } catch (Exception e) { throw e; } finally { // Call Close when done reading to avoid memory leakage. if (reader != null) reader.Close(); } } } // Return the post return post; } // End of the GetOneById method
public IHttpActionResult GetCustomerFile(int id) { CustomerFile asset = db.Read(id); if (asset == null) { return(NotFound()); } return(Ok(asset)); }
public IHttpActionResult DeleteCustomerFile(int id) { CustomerFile file = db.Read(id); if (file == null) { return(NotFound()); } db.Delete(file); return(Ok(file)); }
} // End of the delete method #endregion #region Helper methods /// <summary> /// Update the payment status /// </summary> /// <param name="order">A reference to the order</param> /// <param name="paymentStatus">The payment status as a string</param> /// <returns>An error message as a string</returns> private string UpdatePaymentStatus(Order order, string paymentStatus) { // Create the string to return string error_message = ""; // Check the status change if (paymentStatus == "payment_status_invoice_approved" || paymentStatus == "payment_status_paid") { CustomerFile.AddCustomerFiles(order); } // Return the error message return error_message; } // End of the UpdatePaymentStatus method
public IHttpActionResult PutCustomerFile(int id, CustomerFile asset) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != asset.Id) { return(BadRequest()); } db.Update(asset); return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Upload(CustomerUploadVM vm) { var customer = _context.Customers.Include(c => c.CustomerFiles).SingleOrDefault(c => c.Id == vm.CustomerId); try { if (vm.File.ContentLength > 0) { var fileName = Path.GetFileName(vm.File.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/CustomerFiles"), fileName); vm.File.SaveAs(path); var customerFile = new CustomerFile(); var userId = User.Identity.GetUserId(); var user = _context.Users.SingleOrDefault(u => u.Id == userId); customerFile.UploadedBy = user; customerFile.DateTime = DateTime.Now; customerFile.Customer = customer; customerFile.FilePath = path; customerFile.FileName = fileName; _context.CustomerFiles.Add(customerFile); customer.CustomerFiles.Add(customerFile); _context.SaveChanges(); } //ViewBag.Message = "Upload successful"; //find customer by Id and add 'path' to files iCollection //return RedirectToAction("Index"); return(RedirectToAction("CustomerFiles", new { id = customer.Id })); } catch { ViewBag.Message = "Upload failed"; return(RedirectToAction("Uploads")); } }
public ActionResult delete_file(Int32 customerId = 0, Int32 productId = 0, string returnUrl = "") { // Get the current domain Domain currentDomain = Tools.GetCurrentDomain(); ViewBag.CurrentDomain = currentDomain; // Get query parameters ViewBag.QueryParams = new QueryParams(returnUrl); // Check if the administrator is authorized if (Administrator.IsAuthorized(new string[] { "Administrator" }) == true) { ViewBag.AdminSession = true; } else if (Administrator.IsAuthorized(Administrator.GetAllAdminRoles()) == true) { ViewBag.AdminSession = true; ViewBag.AdminErrorCode = 1; ViewBag.TranslatedTexts = StaticText.GetAll(currentDomain.back_end_language, "id", "ASC"); return View("index"); } else { // Redirect the user to the start page return RedirectToAction("index", "admin_login"); } // Create an error code variable Int32 errorCode = 0; // Delete the customer file and all the connected posts (CASCADE) errorCode = CustomerFile.DeleteOnId(customerId, productId); // Check if there is an error if (errorCode != 0) { ViewBag.AdminErrorCode = errorCode; ViewBag.TranslatedTexts = StaticText.GetAll(currentDomain.back_end_language, "id", "ASC"); return View("index"); } // Redirect the user to the list return Redirect("/admin_customers" + returnUrl); } // End of the delete_file method
private async Task <CustomerFile> ProcessCustomerFileData() { CustomerFile custFile = new CustomerFile(); if (!Request.Content.IsMimeMultipartContent()) { throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType); } var outerMultipart = await Request.Content.ReadAsMultipartAsync(); var multipart = outerMultipart.Contents[0]; String jsonObj = await multipart.ReadAsStringAsync(); custFile = JsonConvert.DeserializeObject <CustomerFile>(jsonObj); return(custFile); }
public async Task CreateFileData_WithErrorGeneratingIbisFile_TranslatesError_AndReturnNoIbisFileData() { // Arrange ulong fileID = 123; var customerFile = new CustomerFile("WEE", fileID); var customerFileGeneratorResult = new IbisFileGeneratorResult <CustomerFile>(customerFile, A.Dummy <List <Exception> >()); var customerFileGenerator = A.Fake <IIbisCustomerFileGenerator>(); A.CallTo(() => customerFileGenerator.CreateAsync(A <ulong> ._, A <InvoiceRun> ._)) .Returns(customerFileGeneratorResult); var transactionFile = new TransactionFile("WEE", (ulong)12345); var error = new Exception(); var transactionFileGeneratorResult = new IbisFileGeneratorResult <TransactionFile>(transactionFile, new List <Exception> { error }); var transactionFileGenerator = A.Fake <IIbisTransactionFileGenerator>(); A.CallTo(() => transactionFileGenerator.CreateAsync(A <ulong> ._, A <InvoiceRun> ._)) .Returns(transactionFileGeneratorResult); var errorTranslator = A.Fake <IIbisFileDataErrorTranslator>(); A.CallTo(() => errorTranslator.MakeFriendlyErrorMessages(A <List <Exception> > ._)) .Returns(new List <string> { "error" }); IbisFileDataGenerator generator = new IbisFileDataGenerator( customerFileGenerator, transactionFileGenerator, errorTranslator); // Act var result = await generator.CreateFileDataAsync(fileID, A.Dummy <InvoiceRun>()); // Assert Assert.NotEmpty(result.Errors); Assert.Null(result.IbisFileData); }
internal static async Task <CustomerFile> DownloadFile(string fileId) { CustomerFile custFile = new CustomerFile(); custFile.Id = new Guid(fileId); var json = JsonConvert.SerializeObject(custFile); var strContent = new StringContent(json, Encoding.UTF8, "application/json"); var content = new MultipartContent(); content.Add(strContent); HttpResponseMessage response = await SendApiRequest("api/Upload/DownloadFile", content); if (response.IsSuccessStatusCode) { custFile = await response.Content.ReadAsAsync <CustomerFile>(); } return(custFile); }
} // End of the Add method /// <summary> /// Add customer files /// </summary> /// <param name="order">A reference to the order</param> public static void AddCustomerFiles(Order order) { // Get the current domain Domain domain = Tools.GetCurrentDomain(); // Get the order rows List<OrderRow> orderRows = OrderRow.GetByOrderId(order.id); // Get the customer Customer customer = Customer.GetOneById(order.customer_id); // Loop all of the order rows for (int i = 0; i < orderRows.Count; i++) { // Get the product Product product = Product.GetOneById(orderRows[i].product_id, domain.back_end_language); // Continue if the product is null if (product == null) { continue; } // Check if the product has a downloadable files if (product.downloadable_files == true) { // Create the customer file CustomerFile customerFile = new CustomerFile(); customerFile.customer_id = customer.id; customerFile.product_id = product.id; customerFile.language_id = customer.language_id; customerFile.order_date = order.order_date; // Check if the file already exists CustomerFile savedFile = CustomerFile.GetOneById(customerFile.customer_id, customerFile.product_id, customerFile.language_id); if (savedFile == null) { // Add the customer file CustomerFile.Add(customerFile); } } } } // End of the AddCustomerFiles method
public Task <IbisFileGeneratorResult <CustomerFile> > CreateAsync(ulong fileID, InvoiceRun invoiceRun) { CustomerFile customerFile = new CustomerFile("WEE", fileID); var errors = new List <Exception>(); IEnumerable <Scheme> schemes = invoiceRun.MemberUploads .Select(mu => mu.Scheme) .Distinct(); foreach (Scheme scheme in schemes) { try { var postCode = GetIbisPostCode(scheme.Address); Address address = new Address( scheme.Contact.FullName, scheme.Address.Address1, scheme.Address.Address2, null, scheme.Address.TownOrCity, scheme.Address.CountyOrRegion, postCode); Customer customer = new Customer( scheme.IbisCustomerReference, scheme.Organisation.OrganisationName, address); customerFile.AddCustomer(customer); } catch (Exception ex) { errors.Add(new SchemeFieldException(scheme, ex)); } } var ibisFileGeneratorResult = new IbisFileGeneratorResult <CustomerFile>(errors.Count == 0 ? customerFile : null, errors); return(Task.FromResult(ibisFileGeneratorResult)); }
public Task<IbisFileGeneratorResult<CustomerFile>> CreateAsync(ulong fileID, InvoiceRun invoiceRun) { CustomerFile customerFile = new CustomerFile("WEE", fileID); var errors = new List<Exception>(); IEnumerable<Scheme> schemes = invoiceRun.MemberUploads .Select(mu => mu.Scheme) .Distinct(); foreach (Scheme scheme in schemes) { try { var postCode = GetIbisPostCode(scheme.Organisation.OrganisationAddress); Address address = new Address( scheme.Organisation.Contact.FullName, scheme.Organisation.OrganisationAddress.Address1, scheme.Organisation.OrganisationAddress.Address2, null, scheme.Organisation.OrganisationAddress.TownOrCity, scheme.Organisation.OrganisationAddress.CountyOrRegion, postCode); Customer customer = new Customer( scheme.IbisCustomerReference, scheme.Organisation.OrganisationName, address); customerFile.AddCustomer(customer); } catch (Exception ex) { errors.Add(new SchemeFieldException(scheme, ex)); } } var ibisFileGeneratorResult = new IbisFileGeneratorResult<CustomerFile>(errors.Count == 0 ? customerFile : null, errors); return Task.FromResult(ibisFileGeneratorResult); }
public JsonResult InsertFile([FromBody] CustomerFile obj) { var msg = new JMessage { Error = false, Title = "" }; try { obj.FileType = System.IO.Path.GetExtension(obj.FileName); obj.CreatedTime = DateTime.Now.Date; _context.CustomerFiles.Add(obj); _context.SaveChanges(); msg.Title = "Thêm tệp tin thành công!"; } catch (Exception ex) { msg.Error = true; msg.Title = "Có lỗi xảy ra!"; } return(Json(msg)); }
public JsonResult UpdateFile([FromBody] CustomerFile obj) { var msg = new JMessage { Error = false, Title = "" }; try { obj.UpdatedTime = DateTime.Now.Date; _context.CustomerFiles.Update(obj); _context.SaveChanges(); msg.Title = "Chỉnh sửa tệp tin thành công!"; } catch (Exception ex) { msg.Error = true; msg.Title = "Có lỗi xảy ra!"; msg.Object = ex; } return(Json(msg)); }
/// <summary> /// Creates the data representing 1B1S customer and transaction files for the specified list /// of member uploads. /// </summary> /// <param name="fileID">The ID that the 1B1S files will use. This must be unique for every pair of 1B1S files /// and must be in the range of 0 to 99999. To avoid clashes with IDs used by the incumbent system, a seed /// value may need to be used.</param> /// <param name="invoiceRun">The invoice run specifying the list of member uploads to be included.</param> /// <returns>Returns an <see cref="IbisFileDataGeneratorResult"/> which provides the data and file names of the /// generated 1B1S customer and transaction files or a list of error which occurred during the process.</returns> public async Task <IbisFileDataGeneratorResult> CreateFileDataAsync(ulong fileID, InvoiceRun invoiceRun) { var customerFileGeneratorResult = await ibisCustomerFileGenerator.CreateAsync(fileID, invoiceRun); var ibisTransactionFileGeneratorResult = await ibisTransactionFileGenerator.CreateAsync(fileID, invoiceRun); IbisFileData ibisFileData = null; var errors = new List <string>(); if (customerFileGeneratorResult.Errors.Count == 0 && ibisTransactionFileGeneratorResult.Errors.Count == 0) { CustomerFile customerFile = customerFileGeneratorResult.IbisFile; TransactionFile transactionFile = ibisTransactionFileGeneratorResult.IbisFile; string customerFileName = string.Format("WEEHC{0:D5}.dat", fileID); string transactionFileName = string.Format("WEEHI{0:D5}.dat", fileID); string customerFileData = customerFile.Write(); string transactionFileData = transactionFile.Write(); ibisFileData = new IbisFileData( fileID, customerFileName, customerFileData, transactionFileName, transactionFileData); } else { errors = ibisFileDataErrorTranslator .MakeFriendlyErrorMessages(customerFileGeneratorResult .Errors .Union(ibisTransactionFileGeneratorResult.Errors) .ToList()); } return(new IbisFileDataGeneratorResult(ibisFileData, errors)); }
public void Write_WithOneCustomer_GeneratesCorrectOutput() { // Arrange Address address = new Address("1 High Street", "Flat 123", "Business Park", "Newtown", "Nr Oldtown", "Testshire", "AA1 1AA"); Customer customer = new Customer("WEE0001", "Test customer", address); CustomerFile file = new CustomerFile("WEE", 0); file.AddCustomer(customer); // Act string result = file.Write(); // Assert string expectedDate = DateTime.UtcNow.Date.ToString("dd-MMM-yyyy").ToUpperInvariant(); string expectedOutput = "\"H\",\"0000000\",\"WEE\",\"H\",\"C\",\"00000\",\"" + expectedDate + "\"" + Environment.NewLine + "\"D\",\"0000001\",\"WEE0001\",\"Test customer\",\"1 High Street\",\"Flat 123\",\"Business Park\",\"Newtown\",\"Nr Oldtown\",\"Testshire\",\"AA1 1AA\"" + Environment.NewLine + "\"T\",\"0000002\",\"0000003\"" + Environment.NewLine; Assert.Equal(expectedOutput, result); }
internal static bool DeleteLegalDocument(CustomerFile custFile) { try { using (SqlConnection sqlConnection = new SqlConnection(sqlConnectionString)) { sqlConnection.Open(); string deleteLegDocQuery = "DELETE FROM LegalDocument WHERE LegalDocumentID = @legalDocId;"; using (SqlCommand sqlCommand = new SqlCommand(deleteLegDocQuery, sqlConnection)) { sqlCommand.Parameters.Add("@legalDocId", SqlDbType.UniqueIdentifier).Value = custFile.Id; sqlCommand.ExecuteNonQuery(); } } } catch (Exception ex) { } return(true); }
internal static async Task <bool> DeleteFile(string id) { CustomerFile custFile = new CustomerFile(); custFile.Id = new Guid(id); //custFile.DocumentType = docType; //custFile.CaseId = caseId; var json = JsonConvert.SerializeObject(custFile); var strContent = new StringContent(json, Encoding.UTF8, "application/json"); var content = new MultipartContent(); content.Add(strContent); HttpResponseMessage response = await SendApiRequest("api/Upload/DeleteFile", content); if (response.IsSuccessStatusCode) { return(true); } return(false); }
public ActionResult Create(Customer customer) { try { if (customer.UploadFiles != null && customer.UploadFiles[0] != null) { var customerFiles = new List <CustomerFile>(); foreach (var uploadFile in customer.UploadFiles) { var customerFile = new CustomerFile(); var fileByte = new byte[uploadFile.ContentLength]; uploadFile.InputStream.Read(fileByte, 0, uploadFile.ContentLength); customerFile.File = fileByte; customerFile.FileName = uploadFile.FileName; customerFiles.Add(customerFile); } customer.CustomerFiles = customerFiles; } var isSaved = _customerManager.Save(customer); if (isSaved) { ViewBag.SMsg = "Saved Successful"; } else { ViewBag.FMsg = "Save Failed"; } } catch (Exception e) { ViewBag.FMsg = e.Message; } return(RedirectToAction("ShowCustomers")); }
} // End of the constructor #endregion #region Insert methods /// <summary> /// Add one customer file post /// </summary> /// <param name="post">A reference to a customer file post</param> public static void Add(CustomerFile post) { // Create the connection and the sql statement string connection = Tools.GetConnectionString(); string sql = "INSERT INTO dbo.customers_files (customer_id, product_id, language_id, order_date) " + "VALUES (@customer_id, @product_id, @language_id, @order_date);"; // The using block is used to call dispose automatically even if there are an exception. using (SqlConnection cn = new SqlConnection(connection)) { // The using block is used to call dispose automatically even if there are an exception. using (SqlCommand cmd = new SqlCommand(sql, cn)) { // Add parameters cmd.Parameters.AddWithValue("@customer_id", post.customer_id); cmd.Parameters.AddWithValue("@product_id", post.product_id); cmd.Parameters.AddWithValue("@language_id", post.language_id); cmd.Parameters.AddWithValue("@order_date", post.order_date); // The Try/Catch/Finally statement is used to handle unusual exceptions in the code to // avoid having our application crash in such cases try { // Open the connection cn.Open(); // Execute the insert cmd.ExecuteNonQuery(); } catch (Exception e) { throw e; } } } } // End of the Add method
public static CustomerFile GetLegalDocumentData(Guid fileId) { string GetQuery = "Select * from LegalDocument ld inner join customer c on ld.CustomerId = c.CustomerId where LegalDocumentID='" + fileId.ToString() + "'"; //List<Customer> customerList = new List<Customer>(); CustomerFile customer = null; using (SqlConnection connection = new SqlConnection(sqlConnectionString)) { SqlCommand command = new SqlCommand(GetQuery, connection); command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { customer = new CustomerFile(); customer.Id = fileId; customer.CaseId = reader["CaseId"].ToString(); customer.DocumentType = reader["DocumentType"].ToString(); } } return(customer); }
public async Task CreateFileData_WithErrorGeneratingCustomerFile_TranslatesError() { // Arrange ulong fileID = 123; var customerFile = new CustomerFile("WEE", fileID); var error = new Exception(); var customerFileGeneratorResult = new IbisFileGeneratorResult<CustomerFile>(customerFile, new List<Exception> { error }); var customerFileGenerator = A.Fake<IIbisCustomerFileGenerator>(); A.CallTo(() => customerFileGenerator.CreateAsync(A<ulong>._, A<InvoiceRun>._)) .Returns(customerFileGeneratorResult); var transactionFile = new TransactionFile("WEE", (ulong)12345); var transactionFileGeneratorResult = new IbisFileGeneratorResult<TransactionFile>(transactionFile, A.Dummy<List<Exception>>()); var transactionFileGenerator = A.Fake<IIbisTransactionFileGenerator>(); A.CallTo(() => transactionFileGenerator.CreateAsync(A<ulong>._, A<InvoiceRun>._)) .Returns(transactionFileGeneratorResult); var errorTranslator = A.Fake<IIbisFileDataErrorTranslator>(); IbisFileDataGenerator generator = new IbisFileDataGenerator( customerFileGenerator, transactionFileGenerator, errorTranslator); // Act await generator.CreateFileDataAsync(fileID, A.Dummy<InvoiceRun>()); // Assert A.CallTo(() => errorTranslator.MakeFriendlyErrorMessages(A<List<Exception>>._)) .MustHaveHappened(); }