public int DownloadSigntureDocumentFromServer(DocumentModel doc, int userId) { this.UpdateLeadStatus(userId, "Contract Received", -userId); var canDownload = DownloadSigntureWS(doc.ID, userId, doc.docNoOfSign.Value); if (!canDownload) { return -1; } return 0; }
public ActionResult UploadDocument(DocumentViewModel viewModel) { if (!ModelState.IsValid) { Session["debt_document_isn"] = -1; return RedirectToAction("Index"); } var UserIP = string.Empty; UserIP = Request.ServerVariables["REMOTE_ADDR"]; var document = new DocumentModel(); document.Public = true; document.SignatureStatus = 0; document.MemberISN = this.MemberISN; document.DocName = viewModel.DocName; document.Desc = viewModel.Notes; document.SendIP = UserIP; document.UpdatedBy = -this.MemberISN; if (viewModel.SelectedCreditorID != null) { document.CreditorISN = viewModel.SelectedCreditorID.Value; document.CreditorName = viewModel.GetCreditorName(viewModel.SelectedCreditorID.Value, this.MemberISN); } var addedDate = DateTime.Now; var fullPath = string.Empty; // // get file uploaded if (viewModel.UploadedFile != null && viewModel.UploadedFile.ContentLength > 0) { document.FileName = viewModel.UploadedFile.FileName; document.FileSize = viewModel.UploadedFile.ContentLength; } var documentISN = _docBusiness.UploadDocument(document); // // save file if add document success #region save document isn to session Session["debt_document_isn"] = documentISN; if (documentISN > 0 && !string.IsNullOrEmpty(document.FileName)) { var pathConfig = ConfigurationManager.AppSettings["UploadFolder"]; if (string.IsNullOrEmpty(pathConfig)) { // pathConfig = "C:\\"; pathConfig = Environment.GetLogicalDrives()[0]; // expect C:\\ } // // check path is exist // if not exist, create new folder // document template // yyyyMM\\Documents\\dd\\123 var docPath = _docBusiness.GetDocumentPath(documentISN, addedDate); fullPath = Path.Combine(pathConfig, docPath); if (!Directory.Exists(fullPath)) { try { Directory.CreateDirectory(fullPath); fullPath = Path.Combine(fullPath.TrimEnd('/', '\\'), document.FileName); // // save file if create folder success try { viewModel.UploadedFile.SaveAs(fullPath); } catch (Exception ex) { _logger.Error(ex, "Cannot save image to {0}", fullPath); } } catch (Exception ex) { _logger.Error(ex, "Cannot create directory"); } } } #endregion return RedirectToAction("Index"); }
public ActionResult Edit(DocumentViewModel viewModel) { if (!ModelState.IsValid) { Session["debt_document_isn"] = -1; return RedirectToAction("Index"); } var document = new DocumentModel(); document.Public = true; document.ID = viewModel.DocumentISN; document.MemberISN = this.MemberISN; document.Desc = viewModel.Notes; document.DocName = viewModel.DocName; if (viewModel.SelectedCreditorID != null) { document.CreditorISN = viewModel.SelectedCreditorID.Value; document.CreditorName = viewModel.GetCreditorName(viewModel.SelectedCreditorID.Value, this.MemberISN); } document.AddedDate = viewModel.AddedDate; // // TODO // save file var fullPath = string.Empty; var canSave = false; // // save file #region save file if (viewModel.UploadedFile != null && viewModel.UploadedFile.ContentLength > 0) { document.FileName = viewModel.UploadedFile.FileName; document.FileSize = viewModel.UploadedFile.ContentLength; var pathConfig = ConfigurationManager.AppSettings["UploadFolder"]; if (string.IsNullOrEmpty(pathConfig)) { pathConfig = Environment.GetLogicalDrives()[0]; // expect C:\\ } // // check path is exist // if not exist, create new folder // var path = Server.MapPath("~/" + pathConfig); // var docPath = _docBusiness.GetDocumentPath(viewModel.DocumentISN, document.AddedDate); var docPath = _premierBusiness.GetDocumentPath(viewModel.DocumentISN, document.AddedDate); fullPath = Path.Combine(pathConfig, docPath); if (!Directory.Exists(fullPath)) { try { Directory.CreateDirectory(fullPath); canSave = true; } catch (Exception ex) { canSave = false; _logger.Error(ex.Message, "Cannot create directory {0}.", fullPath); } } fullPath = Path.Combine(fullPath.TrimEnd('/', '\\'), document.FileName); canSave = true; } #endregion var success = _premierBusiness.EditDocument(document); Session["debt_document_edit"] = true; if (success > 0) { Session["debt_document_isn"] = document.ID; if (canSave) { try { viewModel.UploadedFile.SaveAs(fullPath); } catch (Exception ex) { _logger.Error(ex, "Cannot save file"); } } } else { Session["debt_document_isn"] = -1; } return RedirectToAction("Index"); }
public int EditDocument(DocumentModel doc) { string sqlQuery = "update Document set MemberISN=@memberISN, docName=@name, docDesc=@desc, CreditorISN=@creditorISN , docFileName=@fileName, docSize=@fileSize where DocumentISN=@ISN"; if (string.IsNullOrWhiteSpace(doc.FileName)) { sqlQuery = "update Document set MemberISN=@memberISN, docName=@name, docDesc=@desc, CreditorISN=@creditorISN , docSize=@fileSize where DocumentISN=@ISN"; } var query = _db.Sql(sqlQuery); query.WithParameters(new { fileName = doc.FileName, fileSize = doc.FileSize > 0 ? doc.FileSize : 0, memberISN = doc.MemberISN, name = doc.DocName, desc = doc.Desc, creditorISN = doc.CreditorISN, ISN = doc.ID }); return query.AsNonQuery(); }
public int UpdateDocSignature(DocumentModel doc, string appendNotes = "") { var sproc = _db.StoredProcedure("xp_debtext_document_signature_upd").WithParameters( new { DocumentISN = doc.ID, docFileName = doc.FileName, docSignatureIP = doc.SignatureIP, docGUID = doc.DocGUID, AppendNotes = appendNotes, updatedBy = doc.MemberISN } ); int result = sproc.AsScalar<int>(); return result; }
public int EditSignatureDocument(DocumentModel doc) { var query = _db.Sql("update Vw_DebtExt_Document set docFileName=@Filename, docSignatureIP=@SendIP where DocumentISN=@DocId"). WithParameters(new { Filename = doc.FileName, DocId = doc.ID, SendId = doc.SendIP }); return query.AsScalar<int>(); }