public void OutPutStram(string companyId) { string type = HttpContext.Current.Request.QueryString["type"]; HttpContext.Current.Response.ContentType = "image/jpeg"; CompanyDocument companyDocument = null; if (!string.IsNullOrWhiteSpace(companyId)) { companyDocument = AccountCombineService.QueryCompanyDocument(Guid.Parse(companyId)); } if (companyDocument != null) { if (type == "bussiness" && companyDocument.BussinessLicense != null && companyDocument.BussinessLicense.Length > 0) { HttpContext.Current.Response.BinaryWrite(companyDocument.BussinessLicense); } if (type == "certNo" && companyDocument.CertLicense != null && companyDocument.CertLicense.Length > 0) { HttpContext.Current.Response.BinaryWrite(companyDocument.CertLicense); } if (type == "iata" && companyDocument.IATALicense != null && companyDocument.IATALicense.Length > 0) { HttpContext.Current.Response.BinaryWrite(companyDocument.IATALicense); } } }
public async Task <ActionResult> Create([FromBody] CompanyDocument company) { var createdCompany = await _companyService.CreateAsync(_companyDocumentConverter.ToCompanyDto(company)); return(CreatedAtAction(nameof(GetById), new { id = createdCompany.Id }, _companyDocumentConverter.ToCompanyDocument(createdCompany))); }
public int Save(CompanyDocument document) { string sql = @"IF NOT EXISTS(SELECT NULL FROM [dbo].[T_CompanyDocument] WHERE Company =@Company) INSERT INTO [dbo].[T_CompanyDocument]([Company],[BussinessLicense] , [IATALicense],[CertLicense],[BussinessTime]) VALUES(@Company,@BussinessLicense ,@IATALicense,@CertLicense,@BussinessTime) ELSE UPDATE [dbo].[T_CompanyDocument] SET [BussinessLicense] = @BussinessLicense ,[IATALicense] = @IATALicense,[CertLicense] = @CertLicense,[BussinessTime] = @BussinessTime WHERE [Company] = @Company"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { dbOperator.AddParameter("Company", document.Company); if (document.BussinessLicense != null && document.BussinessLicense.Length > 0) { dbOperator.AddParameter("BussinessLicense", document.BussinessLicense); } else { dbOperator.AddParameter("BussinessLicense", DBNull.Value, DbType.Binary); } if (document.IATALicense != null && document.IATALicense.Length > 0) { dbOperator.AddParameter("IATALicense", document.IATALicense); } else { dbOperator.AddParameter("IATALicense", DBNull.Value, DbType.Binary); } if (document.CertLicense != null && document.CertLicense.Length > 0) { dbOperator.AddParameter("CertLicense", document.CertLicense); } else { dbOperator.AddParameter("CertLicense", DBNull.Value, DbType.Binary); } if (document.BussinessTime.HasValue) { dbOperator.AddParameter("BussinessTime", document.BussinessTime); } else { dbOperator.AddParameter("BussinessTime", DBNull.Value); } return(dbOperator.ExecuteNonQuery(sql)); } }
public async Task <ActionResult> Edit(int id, [FromBody] CompanyDocument company) { if (id != company.Id) { return(BadRequest()); } var companyDto = await _companyService.GetByIdAsync(id); if (companyDto == null) { return(NotFound()); } await _companyService.EditAsync(id, _companyDocumentConverter.ToCompanyDto(company)); return(NoContent()); }
public CompanyDocument Query(Guid companyId) { CompanyDocument document = null; string sql = @"SELECT [Company],[BussinessLicense] ,[IATALicense],[CertLicense],[BussinessTime] FROM [dbo].[T_CompanyDocument] WHERE Company = @Company"; using (var dbOperator = new DbOperator(Provider, ConnectionString)){ dbOperator.AddParameter("Company", companyId); using (var reader = dbOperator.ExecuteReader(sql)) { while (reader.Read()) { document = new CompanyDocument(); document.Company = reader.GetGuid(0); if (!reader.IsDBNull(1)) { var length = reader.GetBytes(1, 0, null, 0, 0); byte[] buffer = new byte[length]; reader.GetBytes(1, 0, buffer, 0, (int)length); document.BussinessLicense = buffer; } if (!reader.IsDBNull(2)) { var length = reader.GetBytes(2, 0, null, 0, 0); byte[] buffer = new byte[length]; reader.GetBytes(2, 0, buffer, 0, (int)length); document.IATALicense = buffer; } if (!reader.IsDBNull(3)) { var length = reader.GetBytes(3, 0, null, 0, 0); byte[] buffer = new byte[length]; reader.GetBytes(3, 0, buffer, 0, (int)length); document.CertLicense = buffer; } if (!reader.IsDBNull(4)) { document.BussinessTime = reader.GetInt32(4); } } } } return(document); }
public CompanyDto ToCompanyDto(CompanyDocument companyDocument) => new CompanyDto { Id = companyDocument.Id, Name = companyDocument.Name };