private void BindGrid(string Category)
{
try
{
UploadFileBL objUploadFileBL = new UploadFileBL();
UploadFileSchema objUploadFileSchema = new UploadFileSchema();
if (Category != null)
{
DataTable dt;
dt = new DataTable();
objUploadFileSchema.FileCategory = Convert.ToInt32(Category);
ds = objUploadFileBL.ShowUploadFileBL(objUploadFileSchema);
dt = ds.Tables[0];
if (dt.Rows.Count < 1)
{
dt = null;
}
if (ds.Tables[1].Rows.Count > 0)
{
HdnExt.Value = ds.Tables[1].Rows[0]["FileExtension"].ToString();
HdnSizeLimit.Value = ds.Tables[1].Rows[0]["FileSize_Kb"].ToString();
}
if (objUploadFileSchema.FileCategory == 1)
{
Session["KeyPersonCount"] = ds.Tables[0].Rows.Count;
}
grdupload.DataSource = dt;
grdupload.DataBind();
}
}
catch (Exception ex) { throw ex; }
}
public HttpResponseMessage RetornarArquivo(string docClienteId)
{
//docClienteId = System.Web.HttpUtility.UrlDecode(docClienteId);
docClienteId = MD5Crypt.Descriptografar(docClienteId);
DocumentoCliente _documentoCliente = new UploadFileBL().RetornarArquivo(new DocumentoCliente()
{
DocClienteId = long.Parse(docClienteId)
});
UploadFileBL uploadFileBl = new UploadFileBL();
WorkingFolder += "\\" + new UploadFileBL().RecuperarCaminhoPastaDocumentosByDocClienteId(long.Parse(docClienteId));
var file = WorkingFolder + "\\" + _documentoCliente.DocClienteNomeArquivoSalvo;
HttpResponseMessage result = null;
if (!File.Exists(file))
{
result = new HttpResponseMessage(HttpStatusCode.Conflict);
return(result);
}
else
{
result = new HttpResponseMessage(HttpStatusCode.OK);
var stream = new FileStream(file, FileMode.Open);
result.Content = new StreamContent(stream);
result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = _documentoCliente.DocClienteNomeArquivoOriginal
};
result.Content.Headers.ContentType =
new MediaTypeHeaderValue("application/octet-stream");
return(result);
}
}
protected void grdupload_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "delete")
{
int retnval = 0;
UploadFileBL objUploadFileBL = new UploadFileBL();
UploadFileSchema objUploadFileSchema = new UploadFileSchema();
objUploadFileSchema.RowId = Convert.ToInt32(e.CommandArgument);
retnval = objUploadFileBL.DeleteFileBL(objUploadFileSchema);
if (retnval > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Message", "alert('Record Deleted Sucessfully!!! ');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Message", "alert('Record Not Deleted !!! ');", true);
}
}
if (e.CommandName == "view")
{
ds = new DataSet();
UploadFileBL objUploadFileBL = new UploadFileBL();
UploadFileSchema objUploadFileSchema = new UploadFileSchema();
objUploadFileSchema.RowId = Convert.ToInt32(e.CommandArgument);
objUploadFileSchema.FileCategory = Convert.ToInt32(DDLcategory.SelectedValue);
ds = objUploadFileBL.ShowFileDetailsdBL(objUploadFileSchema);
if (ds.Tables[0].Rows.Count > 0)
{
txtFDtl.Text = ds.Tables[0].Rows[0]["FileDtl"].ToString();
txtFDtlLL.Text = ds.Tables[0].Rows[0]["FileDtlLL"].ToString();
txtFTitle.Text = ds.Tables[0].Rows[0]["FileTitle"].ToString();
txtFTitleLL.Text = ds.Tables[0].Rows[0]["FileTitleLL"].ToString();
chkActive.Checked = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsActive"]);
txtSeqNo.Text = ds.Tables[0].Rows[0]["SequenceNo"].ToString();
HdnDelete.Value = e.CommandArgument.ToString();;
HdnExt.Value = ds.Tables[0].Rows[0]["FileExtension"].ToString();
HdnSizeLimit.Value = ds.Tables[0].Rows[0]["FileSize_Kb"].ToString();
txtFDtlUL.Text = ds.Tables[0].Rows[0]["FileDtlUL"].ToString();
txtFTitleUL.Text = ds.Tables[0].Rows[0]["FileTitleUL"].ToString();
}
}
BindGrid(DDLcategory.SelectedValue);
}
catch (Exception ex)
{ throw ex; }
}
private void SaveUpdateDB()
{
DateTime date = Convert.ToDateTime(DateTime.Now);
int retnVal = 0;
string ext = null;;
byte[] t_Image = null;
Double FileSize = 0;
UploadFileBL objUploadFileBL = new UploadFileBL();
UploadFileSchema objUploadFileSchema = new UploadFileSchema();
if (DDLcategory.SelectedIndex == 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('Please Select File Category ')", true);
return;
}
if (HdnDelete.Value != "0" && UploadImage.HasFile)
{
if (isValidAttachmentFile(UploadImage))
{
objUploadFileSchema.RowId = Convert.ToInt32(HdnDelete.Value);
ext = System.IO.Path.GetExtension(UploadImage.FileName);
t_Image = UploadImage.FileBytes;
FileSize = UploadImage.PostedFile.ContentLength / 1024;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('Supports Only " + HdnExt.Value + " File types Upto " + HdnSizeLimit.Value + " KB')", true);
return;
}
}
else if (HdnDelete.Value == "0")
{
if (isValidAttachmentFile(UploadImage))
{
ext = System.IO.Path.GetExtension(UploadImage.FileName);
t_Image = UploadImage.FileBytes;
FileSize = UploadImage.PostedFile.ContentLength / 1024;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('Supports Only " + HdnExt.Value + " File types Upto " + HdnSizeLimit.Value + " KB')", true);
return;
}
}
//if ((UploadImage.HasFile))
//{
// FileInfo file = new FileInfo(UploadImage.FileName);
// Bitmap img = new Bitmap(UploadImage.FileContent);
// var imageHeight = img.Height;
// var imageWidth = img.Width;
// if (DDLcategory.SelectedValue == "1")
// {
// if (imageHeight != 54 && imageWidth != 51)
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('The Key Person photograph should fall between 51 to 54 pixels.')", true);
// return;
// }
// }
// else if (DDLcategory.SelectedValue == "2")
// {
// if (imageHeight != 627 && imageWidth != 2000)
// {
// ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('The Banner photograph should fall between 2000 to 627 pixels.')", true);
// return;
// }
// }
//}
try
{
byte[] t_Image1 = new byte[UploadImage.PostedFile.ContentLength];
objUploadFileSchema.FileCategory = Convert.ToInt32(DDLcategory.SelectedValue);
objUploadFileSchema.FileTitle = txtFTitle.Text;
objUploadFileSchema.FileTitleLL = txtFTitleLL.Text;
objUploadFileSchema.FileDetail = txtFDtl.Text;
objUploadFileSchema.FileDetailLL = txtFDtlLL.Text;
objUploadFileSchema.ImageType = ext;
objUploadFileSchema.FileSize = FileSize.ToString();
objUploadFileSchema.IsActive = chkActive.Checked;
objUploadFileSchema.SequenceNo = Convert.ToInt32(txtSeqNo.Text);
objUploadFileSchema.CreatedBy = HttpContext.Current.Profile.UserName;
objUploadFileSchema.CreatedDate = Convert.ToDateTime(date.ToString("yyyy-MM-dd"));
objUploadFileSchema.UpdatedDate = Convert.ToDateTime(date.ToString("yyyy-MM-dd"));
objUploadFileSchema.IpAddress = Request.UserHostAddress;
objUploadFileSchema.FileDetailUL = txtFDtlUL.Text;
objUploadFileSchema.FileTitleUL = txtFTitleUL.Text;
ClearControls();
if (HdnDelete.Value != "0")
{
if ((UploadImage.HasFile))
{
objUploadFileSchema.ImageContent = t_Image;
}
else
{
objUploadFileSchema.ImageContent = t_Image1;
}
objUploadFileSchema.RowId = Convert.ToInt32(HdnDelete.Value);
retnVal = objUploadFileBL.UpdateUploadFileBL(objUploadFileSchema);
}
else
{
int count = Convert.ToInt32(Session["KeyPersonCount"]);
if (objUploadFileSchema.FileCategory == 1)
{
if (count >= 6)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", "alert('Key Person should not be more than 6')", true);
return;
}
}
objUploadFileSchema.ImageContent = t_Image;
retnVal = objUploadFileBL.SaveUploadFileBL(objUploadFileSchema);
}
if (retnVal > 0)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Message", "alert('Data Saved sucessfully !!! ');", true);
}
BindGrid(DDLcategory.SelectedValue);
}
catch (Exception ex)
{
throw ex;
}
finally
{
HdnDelete.Value = "0".ToString();
}
}
public async Task <IHttpActionResult> EnviarArquivo(int usuarioId, long clienteId, int docCliTipoId, bool reenvio)
{
// Check if the request contains multipart/form-data.
if (!Request.Content.IsMimeMultipartContent("form-data"))
{
return(BadRequest("Unsupported media type"));
}
DocumentoCliente _documentoCliente = new DocumentoCliente();
try
{
string directory = new UploadFileBL().RecuperarCaminhoPastaDocumentosByClienteId(clienteId);
WorkingFolder += "\\" + directory;
if (!Directory.Exists(WorkingFolder))
{
Directory.CreateDirectory(WorkingFolder);
}
var streamProvider = new MultipartFormDataStreamProvider(WorkingFolder);
await Request.Content.ReadAsMultipartAsync(streamProvider);
_documentoCliente = new DocumentoCliente()
{
UsuarioId = usuarioId,
ClienteId = clienteId,
DocCliTipoId = docCliTipoId,
DocClienteCaminhoCompletoArquivoSalvo = streamProvider.FileData.Select(entry => entry.LocalFileName).First(),
DocClienteNomeArquivoSalvo = System.IO.Path.GetFileName(streamProvider.FileData.Select(entry => entry.LocalFileName).First()),
DocClienteNomeArquivoOriginal = System.IO.Path.GetFileName(streamProvider.FileData.Select(entry => entry.Headers.ContentDisposition.FileName).First().Replace("\"", "")),
DocClienteTipoArquivo = streamProvider.FileData.Select(entry => entry.Headers.ContentType.MediaType).First(),
DocClienteDataUpload = DateTime.Now
};
#region 1 - Verifica tipo/ versão pdf
if (UtilFile.GetMIMEType(_documentoCliente.DocClienteNomeArquivoOriginal).ToLower() != "application/pdf")
{
throw new Exception("Erro - Documento deve ser do tipo PDF");
}
#endregion
Cliente cliente = new Cliente()
{
ClienteId = _documentoCliente.ClienteId
};
UploadFileBL uploadFileBL = null;
switch (cliente.ClienteNomeEnum)
{
case Cliente.EnumCliente.Bradesco:
uploadFileBL = new UploadFileBradescoBL();
((UploadFileBradescoBL)uploadFileBL).Reenvio = reenvio;
((UploadFileBradescoBL)uploadFileBL).WorkingFolder = WorkingFolder;
_documentoCliente = uploadFileBL.EnviarDocumentoCliente(_documentoCliente);
break;
default:
uploadFileBL = new UploadFileBL();
_documentoCliente = uploadFileBL.EnviarDocumentoCliente(_documentoCliente);
break;
}
return(Ok((new Retorno()
{
Dados = _documentoCliente, Mensagem = "Arquivo(s) incluído(s) com sucesso.", TipoMensagem = EnumTipoMensagem.Sucesso
})));
}
catch (BusinessException ex)
{
if (File.Exists(WorkingFolder + "\\" + _documentoCliente.DocClienteNomeArquivoSalvo))
{
File.Delete(WorkingFolder + "\\" + _documentoCliente.DocClienteNomeArquivoSalvo);
}
return(Ok(ex.GetRetorno()));
}
catch (Exception ex)
{
if (File.Exists(WorkingFolder + "\\" + _documentoCliente.DocClienteNomeArquivoSalvo))
{
File.Delete(WorkingFolder + "\\" + _documentoCliente.DocClienteNomeArquivoSalvo);
}
throw new CustomException.CustomException(ex.Message, ex);
}
}
