private void downLoadFile(string consecutivo, string pro_codi, string tableName, int emp_codi, string adj_nomb)
{
DAOGnRadju daoRadju = new DAOGnRadju();
DAOGnAdju daoAdju = new DAOGnAdju();
List <Digitalware.Apps.Utilities.TO.TOGnAdjun> adjun = new List <Digitalware.Apps.Utilities.TO.TOGnAdjun>();
string download = HttpContext.Current.Server.MapPath("~/download/");
string ftp = ConfigurationManager.AppSettings["servidorFTP"];
try
{
List <Digitalware.Apps.Utilities.TO.Gn_Adju.TOGnRadju> radju = daoRadju.GetRadju(emp_codi, pro_codi, consecutivo);
if (radju == null || !radju.Any())
{
throw new Exception("No hay adjuntos");
}
int rad_cont = radju.FirstOrDefault().Rad_Cont;
adjun = daoAdju.GetAdjun(emp_codi, rad_cont);
if (adjun.Count == 0)
{
throw new Exception("No hay adjuntos");
}
foreach (Digitalware.Apps.Utilities.TO.TOGnAdjun adjunto in adjun)
{
if (adjunto.Adj_Nomb == adj_nomb)
{
string directoryDefault = string.Format("ftp://{0}/Seven/docs/{1}/{1}_{2}_{3}_{4}", ftp.ToString(), tableName, emp_codi.ToString(), rad_cont, adjunto.Adj_Cont);
List <DirectoryItem> filesExist = FTPManager.GetDirectoryInformation(directoryDefault);
if (filesExist != null && filesExist.Count > 0)
{
DownloadFile(directoryDefault, download + adj_nomb);
string data = System.IO.File.ReadAllText(download + adj_nomb);
using (FileStream stream = System.IO.File.Create(download + adj_nomb))
{
byte[] todecode_byte = Convert.FromBase64String(data);
stream.Write(todecode_byte, 0, todecode_byte.Length);
}
}
}
}
}
catch (Exception ex)
{
ex.ToString();
}
}
public TOTransaction <List <Digitalware.Apps.Utilities.TO.TOGnAdjun> > Get(string consecutivo, string pro_codi, string tableName, int emp_codi)
{
DAOGnRadju daoRadju = new DAOGnRadju();
DAOGnAdju daoAdju = new DAOGnAdju();
DAOGnAdjFi daoAdjF = new DAOGnAdjFi();
List <Digitalware.Apps.Utilities.TO.TOGnAdjun> adjun = new List <Digitalware.Apps.Utilities.TO.TOGnAdjun>();
List <TO.TOGnAdjFi> adjfi = new List <TO.TOGnAdjFi>();
string download = HttpContext.Current.Server.MapPath("~/download/");
string ftp = ConfigurationManager.AppSettings["servidorFTP"];
List <Digitalware.Apps.Utilities.TO.Gn_Adju.TOGnRadju> radju = daoRadju.GetRadju(emp_codi, pro_codi, consecutivo);
try
{
if (radju == null || !radju.Any())
{
throw new Exception("No hay adjuntos");
}
int rad_cont = radju.FirstOrDefault().Rad_Cont;
adjun = daoAdju.GetAdjun(emp_codi, rad_cont);
if (adjun.Count == 0)
{
throw new Exception("No hay adjuntos");
}
foreach (Digitalware.Apps.Utilities.TO.TOGnAdjun adjunto in adjun)
{
string directoryDefault = string.Format("ftp://{0}/Seven/docs/{1}/{1}_{2}_{3}_{4}", ftp.ToString(), tableName, emp_codi.ToString(), rad_cont, adjunto.Adj_Cont);
List <DirectoryItem> filesExist = FTPManager.GetDirectoryInformation(directoryDefault);
if (filesExist != null && filesExist.Count > 0)
{
DownloadFile(directoryDefault, download + adjunto.Adj_Nomb);
}
}
return(new TOTransaction <List <Digitalware.Apps.Utilities.TO.TOGnAdjun> >()
{
objTransaction = adjun, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
try
{
int rad_cont = radju.FirstOrDefault().Rad_Cont;
adjfi = daoAdjF.GetAdjFi(emp_codi, rad_cont);
if (adjfi.Count == 0)
{
throw new Exception("No hay adjuntos");
}
foreach (TO.TOGnAdjFi adjuntF in adjfi)
{
DownloadFileFromDb(adjuntF.adj_nomb, adjuntF.adj_file);
}
return(new TOTransaction <List <Digitalware.Apps.Utilities.TO.TOGnAdjun> >()
{
objTransaction = adjun, retorno = 0, txtRetorno = ""
});
}
catch (Exception exc)
{
return(new TOTransaction <List <Digitalware.Apps.Utilities.TO.TOGnAdjun> >()
{
objTransaction = null, retorno = 1, txtRetorno = exc.Message
});
}
}
}
public TOTransaction <List <Wf_Cdocu> > Get(int consecutivo, string pro_codi, string tableName, int emp_codi)
{
emp_codi = new tools.General().GetEmpCodi(emp_codi);
DAOGnRadju daoRadju = new DAOGnRadju();
DAOGnAdju daoAdju = new DAOGnAdju();
List <Digitalware.Apps.Utilities.TO.TOGnAdjun> adjun = new List <Digitalware.Apps.Utilities.TO.TOGnAdjun>();
string download = HttpContext.Current.Server.MapPath("../download/");
string alias = ConfigurationManager.AppSettings["alias"];
string ftp = ConfigurationManager.AppSettings["servidorFTP"];
List <Digitalware.Apps.Utilities.TO.TOGnAdjun> ficherosDescargados = new List <Digitalware.Apps.Utilities.TO.TOGnAdjun>();
try
{
if (alias == null)
{
throw new Exception("Parámetro alias no definido");
}
if (ftp == null)
{
throw new Exception("Parámetro servidorFTP no definido");
}
string userftp = FTPManager.UserFtp;
string passFtp = FTPManager.PassFtp;
BOWfCdocu documents = new BOWfCdocu();
var result = documents.DownloadWfCdocu(consecutivo, emp_codi);
if (result.Retorno == 1)
{
throw new Exception(result.TxtError);
}
//List<Digitalware.Apps.Utilities.TO.Gn_Adju.TOGnRadju> radju = daoRadju.GetRadju(emp_codi, pro_codi, String.Concat(emp_codi.ToString(), consecutivo));
//if (radju == null || !radju.Any())
// throw new Exception("No hay adjuntos");
//int rad_cont = radju.FirstOrDefault().Rad_Cont;
//adjun = daoAdju.GetAdjun(emp_codi, rad_cont);
//if (adjun.Count == 0)
// throw new Exception("No hay adjuntos");
//foreach(Digitalware.Apps.Utilities.TO.TOGnAdjun adjunto in adjun)
//{
// string directoryDefault = string.Format("ftp://{0}/Seven/docs/{1}/{1}_{2}_{3}_{4}", ftp.ToString(), tableName, emp_codi.ToString(), rad_cont,adjunto.Adj_Cont);
// List<DirectoryItem> filesExist = FTPManager.GetDirectoryInformation(directoryDefault);
// if (filesExist!=null && filesExist.Count> 0)
// {
// foreach (DirectoryItem directories in filesExist)
// {
// byte[] file =FTPManager.DownloadFtp(download, "", adjunto.Adj_Nomb, directoryDefault);
// ficherosDescargados.Add(adjunto);
// }
// }
//}
return(new TOTransaction <List <Wf_Cdocu> >()
{
objTransaction = result.ObjTransaction, retorno = 0, txtRetorno = ""
});
}
catch (Exception ex)
{
return(new TOTransaction <List <Wf_Cdocu> >()
{
objTransaction = null, retorno = 1, txtRetorno = ex.Message
});
}
}
