public void AddEditDel_GroupUploadDocument(DO_ProfileDocuments objDocument, UploadDocument flag)
{
SqlConnection conn = new SqlConnection();
SQLManager co = new SQLManager();
conn = co.GetConnection();
cmd = new SqlCommand("Scrl_AddEditDelGroupUploadDocument", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = flag;
cmd.Parameters.Add("@intGroupDocId", SqlDbType.BigInt).Value = objDocument.intGroupDocId;
cmd.Parameters.Add("@AddedBy", SqlDbType.BigInt).Value = objDocument.AddedBy;
cmd.Parameters.Add("@FilePath", SqlDbType.VarChar, 200).Value = objDocument.FilePath;
cmd.Parameters.Add("@DocumentTitle", SqlDbType.VarChar, 200).Value = objDocument.DocTitle;
cmd.Parameters.Add("@intModifiedBy", SqlDbType.Int).Value = objDocument.ModifiedBy;
cmd.Parameters.Add("@intDocumentTypeID", SqlDbType.Int).Value = objDocument.intDocumentTypeID;
cmd.Parameters.Add("@strAuthors", SqlDbType.VarChar, 255).Value = objDocument.strAuthors;
cmd.Parameters.Add("@IsDocsSale", SqlDbType.VarChar, 2).Value = objDocument.IsDocsSale;
cmd.Parameters.Add("@IsDocsDownload", SqlDbType.VarChar, 2).Value = objDocument.IsDocsDownload;
cmd.Parameters.Add("@intDocsSee", SqlDbType.VarChar, 200).Value = objDocument.intDocsSee;
cmd.Parameters.Add("@Price", SqlDbType.Float).Value = objDocument.Price;
cmd.Parameters.Add("@intSubjectCategoryId", SqlDbType.Int).Value = objDocument.intSubjectCategoryId;
cmd.Parameters.Add("@strDocName", SqlDbType.VarChar, 500).Value = objDocument.strDocName;
cmd.Parameters.Add("@intGroupId", SqlDbType.Int).Value = objDocument.intGroupId;
objDocument.DocId = Convert.ToInt32(cmd.ExecuteScalar());
co.CloseConnection(conn);
}
public string LoadDocument([FromForm] UploadDocument uploadDocument)
{
string documentPath = Path.Combine(path, uploadDocument.DocumentName);
Stream stream = null;
if (System.IO.File.Exists(documentPath))
{
byte[] bytes = System.IO.File.ReadAllBytes(documentPath);
stream = new MemoryStream(bytes);
}
else
{
bool result = Uri.TryCreate(uploadDocument.DocumentName, UriKind.Absolute, out Uri uriResult) &&
(uriResult.Scheme == Uri.UriSchemeHttp || uriResult.Scheme == Uri.UriSchemeHttps);
if (result)
{
stream = GetDocumentFromURL(uploadDocument.DocumentName).Result;
if (stream != null)
{
stream.Position = 0;
}
}
}
WordDocument document = WordDocument.Load(stream, FormatType.Docx);
string json = Newtonsoft.Json.JsonConvert.SerializeObject(document);
document.Dispose();
return(json);
}
public IHttpActionResult DeleteCommonUploadDocumentDetails(UploadDocumentModel _objModel)
{
string status = string.Empty;
try
{
UploadDocument _UploadDocument = _commonList.getCommonUploadDocumentById(Convert.ToInt32(_objModel.Id));
_UploadDocument.Deactivate = "Y";
_UploadDocument.DeactivateBy = _objModel.EnteredBy;
_UploadDocument.DeactivateDate = DateTime.Now;
_commonList.DeleteUploadDocumentDetails(_UploadDocument);
status = _localizationService.GetResource("Master.API.Success.Message");
}
catch (ACSException ex)
{
_ILog.LogException("", Severity.ProcessingError, "MasterController.cs", "UploadDocumentCommon", ex);
status = ex.InnerException.Message;
}
catch (Exception ex)
{
_ILog.LogException("", Severity.ProcessingError, "MasterController.cs", "UploadDocumentCommon", ex);
status = ex.InnerException.Message;
}
return(Json(status));
}
public IHttpActionResult SaveTranslatedDocument(long Id, UploadDocument obj)
{
TranslatorBusinessService objTBS = new TranslatorBusinessService();
int res = objTBS.SaveTranslatedDocument(Id, obj);
if (res > 0)
{
#region "Attachments"
if (obj.Document != null && obj.Document.Content != "")
{
try
{
byte[] bytes = null;
if (obj.Document.Content.IndexOf(',') >= 0)
{
var myString = obj.Document.Content.Split(new char[] { ',' });
bytes = Convert.FromBase64String(myString[1]);
}
else
{
bytes = Convert.FromBase64String(obj.Document.Content);
}
if (obj.Document.FileName.Length > 0 && bytes.Length > 0)
{
string filePath = HttpContext.Current.Server.MapPath("/Attachments/NotificationDocument_Translated/" + obj.NotificationDocumentId + "_" + obj.Document.FileName);
File.WriteAllBytes(filePath, bytes);
}
}
catch (Exception ex) { }
}
#endregion
}
return(Ok());
}
public async Task <OutbreakDocument> Execute(UploadDocument command)
{
var documentId = (int)await sequenceGenerator.GetNextAsync(SequenceType.EpiDocument);
var document = new EpiDocument
{
BlEpiDocument = command.FilesBytes,
DsMimeContentType = command.MIMEType,
IdEpiDocument = documentId
};
var obDocument = new OutbreakDocument
{
IdEpiDocument = documentId,
NmFile = command.FileName,
CdEpiDocumentType = command.DocumentType,
DsDesc = command.Description,
DtEpiDocument = command.DocumentDate,
IdSequence = command.Sequence,
IdOutbreak = command.OutbreakId
};
await writeContext.EpiDocument.AddAsync(document);
await writeContext.OutbreakDocument.AddAsync(obDocument);
await writeContext.SaveChangesAsync();
return(obDocument);
}
public int SaveTranslatedDocument(long Id, UploadDocument obj)
{
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = Procedures.UploadTranslatedDocument_Translator;
sqlCommand.Parameters.AddWithValue("@TranslatorId", Id);
sqlCommand.Parameters.AddWithValue("@NotificationId", obj.NotificationId);
sqlCommand.Parameters.AddWithValue("@NotificationDocumentId", obj.NotificationDocumentId);
sqlCommand.Parameters.AddWithValue("@TranslatedDocumentName", obj.DisplayName);
sqlCommand.Parameters.AddWithValue("@TranslatedDocument", obj.Document.FileName);
return(DAL.ExecuteNonQuery(ConfigurationHelper.connectionString, sqlCommand));
}
}
public ActionResult UploadDocuments(UploadDocument uploadDocument)
{
try
{
if (uploadDocument.FileAttach.ContentLength > 0)
{
string _FileName = Path.GetFileName(uploadDocument.FileAttach.FileName);
string _path = Path.Combine(Server.MapPath("~/UploadedFiles"), _FileName);
uploadDocument.FileAttach.SaveAs(_path);
}
ViewBag.Message = "File Uploaded Successfully!!";
return(View());
}
catch
{
ViewBag.Message = "File upload failed!!";
return(View());
}
}
public Account(Client client)
: base(client)
{
_closeAccount = new CloseAccount(this);
_closeAccountHolder = new CloseAccountHolder(this);
_createAccount = new CreateAccount(this);
_createAccountHolder = new CreateAccountHolder(this);
_checkAccountHolder = new CheckAccountHolder(this);
_deletePayoutMethods = new DeletePayoutMethods(this);
_deleteBankAccount = new DeleteBankAccount(this);
_deleteShareholder = new DeleteShareholder(this);
_getAccountHolder = new GetAccountHolder(this);
_getUploadedDocuments = new GetUploadedDocuments(this);
_suspendAccountHolder = new SuspendAccountHolder(this);
_unSuspendAccountHolder = new UnSuspendAccountHolder(this);
_updateAccount = new UpdateAccount(this);
_updateAccountHolder = new UpdateAccountHolder(this);
_updateAccountHolderState = new UpdateAccountHolderState(this);
_uploadDocument = new UploadDocument(this);
}
public async Task <IActionResult> UploadDocument([FromForm] UploadDocument command, [FromForm] IFormFile fileReference)
{
if (fileReference == null)
{
ModelState.AddModelError(nameof(fileReference), $"No file selected to upload.");
return(BadRequest(ModelState));
}
command.MIMEType = fileReference.ContentType;
command.FileName = fileReference.FileName;
using (var stream = new MemoryStream())
{
await fileReference.CopyToAsync(stream);
command.FilesBytes = stream.ToArray();
}
await rules.Apply(command, ModelState);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var document = await service.Execute(command);
var uri = Url.Action("Get", new { id = document.IdEpiDocument });
return(Created(uri, new OutbreakDocumentsDTO
{
Id = document.IdEpiDocument,
Description = document.DsDesc,
FileName = document.NmFile,
DocumentType = document.CdEpiDocumentType,
DocumentDate = document.DtEpiDocument,
UserAdded = document.IdAdded,
DateAdded = document.DtAdded
}));
}
public async Task <Documents> SendDocument(UploadDocument document)
{
HttpResponseMessage responseMessage = null;
try
{
responseMessage = await _instance._client.PostAsync(_instance._getAllString, (HttpContent) new StringContent(JsonConvert.SerializeObject(document), System.Text.Encoding.UTF8, "application/json"));
string response = await responseMessage.Content.ReadAsStringAsync();
return(JsonConvert.DeserializeObject <Documents>(response));
}
catch (Exception ex)
{
if (responseMessage == null)
{
responseMessage = new HttpResponseMessage();
}
responseMessage.StatusCode = HttpStatusCode.InternalServerError;
responseMessage.ReasonPhrase = string.Format("RestHttpClient.SendRequest failed: {0}", ex);
return(null);
}
}
public IHttpActionResult UploadDocumentCommon(UploadDocumentModel _objModel)
{
string status = string.Empty;
try
{
foreach (UploadFileDetails _FilesData in _objModel.FileDetails)
{
UploadDocument _UploadDocument = new UploadDocument();
_UploadDocument.MasterName = _objModel.MasterName;
_UploadDocument.MasterId = Convert.ToInt32(_objModel.MasterId);
_UploadDocument.FileName = _FilesData.FileName;
_UploadDocument.UploadFileName = _FilesData.UploadFileName;
_UploadDocument.Deactivate = "N";
_UploadDocument.EnteredBy = _objModel.EnteredBy;
_UploadDocument.EntryDate = DateTime.Now;
_UploadDocument.ModifiedBy = null;
_UploadDocument.ModifiedDate = null;
_UploadDocument.DeactivateBy = null;
_UploadDocument.DeactivateDate = null;
_commonList.InsertUploadDocumentDetails(_UploadDocument);
}
status = _localizationService.GetResource("Master.API.Success.Message");
}
catch (ACSException ex)
{
_ILog.LogException("", Severity.ProcessingError, "MasterController.cs", "UploadDocumentCommon", ex);
status = ex.InnerException.Message;
}
catch (Exception ex)
{
_ILog.LogException("", Severity.ProcessingError, "MasterController.cs", "UploadDocumentCommon", ex);
status = ex.InnerException.Message;
}
return(Json(status));
}
public int SaveTranslatedDocument(long Id, UploadDocument obj)
{
TranslatorDataService objTDS = new TranslatorDataService();
return(objTDS.SaveTranslatedDocument(Id, obj));
}
public void DeleteUploadDocumentDetails(UploadDocument _UploadDocument)
{
_UploadDocumentRepository.Update(_UploadDocument);
}
public void InsertUploadDocumentDetails(UploadDocument _UploadDocument)
{
_UploadDocumentRepository.Insert(_UploadDocument);
}
