public int InsertUpload(UploadParceiro up, string datasource, string schema, string cdentifilial)
{
int ret = 0;
string query = string.Format("INSERT INTO uploadparceiro (TXINFO,TXPATH,CDENTIFILIAL,CDFORNECEDOR) VALUES('{0}','{1}',{2},{3})",
up.txinfo, up.txpath, cdentifilial, up.Cdfornecedor);
Util.OracleHelper.ExecProcedureNonQuery(query, null, System.Data.CommandType.Text, datasource, schema);
string querycur = "select uploadparceiro_seq.currval as id from dual";
using (OracleConnection connection = new OracleConnection(Util.OracleHelper.StrConn(schema, datasource)))
{
OracleCommand command = new OracleCommand(querycur, connection);
connection.Open();
using (OracleDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ret = Convert.ToInt32(reader["id"].ToString());
}
}
}
return(ret);
}
public UploadParceiro GetUploadById(UploadParceiro up, string datasource, string schema)
{
UploadParceiro uploadret = new UploadParceiro();
StringBuilder query = new StringBuilder();
query.Append("select cduploadparceiro,u.cdfornecedor,(select nmentidade from entidade where cdentidade = u.cdfornecedor) as nmfornecedor,txinfo,cdentifilial, ");
query.Append(string.Format(" to_char(dtinclusao,'DD/MM/YYYY') as dtinclusao,txpath from uploadparceiro u where cduploadparceiro ={0} and stexcluido = 0", up.CdUploadParceiro));
using (OracleConnection connection = new OracleConnection(Util.OracleHelper.StrConn(schema, datasource)))
{
OracleCommand command = new OracleCommand(query.ToString(), connection);
connection.Open();
using (OracleDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
uploadret.CdUploadParceiro = Convert.ToInt32(reader["cduploadparceiro"].ToString());
uploadret.dtinclusao = reader["dtinclusao"].ToString();
uploadret.nmfornecedor = reader["nmfornecedor"].ToString();
uploadret.txpath = reader["txpath"].ToString();
uploadret.txinfo = reader["txinfo"].ToString();
uploadret.Cdfornecedor = Convert.ToInt32(reader["Cdfornecedor"].ToString());
uploadret.cdentifilial = Convert.ToInt32(reader["cdentifilial"].ToString());
}
}
}
return(uploadret);
}
public int UpdatePath(UploadParceiro up, string datasource, string schema)
{
int ret = 0;
string queryfuncupdate = string.Format("update uploadparceiro set txpath='{0}' where CdUploadParceiro = {1}", up.txpath, up.CdUploadParceiro);
ret = Util.OracleHelper.ExecProcedureNonQuery(queryfuncupdate, null, System.Data.CommandType.Text, datasource, schema);
return(ret);
}
//public async Task<IHttpActionResult> Add()
public async Task <HttpResponseMessage> Add()
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
double ret = 0;
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
var root = ConfigurationManager.AppSettings.Get("PATHARQUIVOS") + "\\UPLOAD";
if (!Directory.Exists(root))
{
Directory.CreateDirectory(root);
}
var provider = new CustomMultipartFormDataStreamProvider(root);
var result = await Request.Content.ReadAsMultipartAsync(provider);
int id = 0;
var model = result.FormData["model"];
UploadParceiroADO upado = new UploadParceiroADO();
UploadParceiro up = JsonConvert.DeserializeObject <UploadParceiro>(model);
up.cdentifilial = Convert.ToInt32(cf.cdentifilial);
id = upado.InsertUpload(up, cf.datasource, cf.schema, cf.cdentifilial);
FileInfo fi = null;
string extensao = string.Empty;
foreach (var file in result.FileData)
{
fi = new FileInfo(file.LocalFileName);
System.IO.File.Move(file.LocalFileName, root + "\\" + id.ToString() + fi.Extension);
up.txpath = id.ToString() + fi.Extension;
up.CdUploadParceiro = id;
upado.UpdatePath(up, cf.datasource, cf.schema);
}
return(Request.CreateResponse(HttpStatusCode.OK, "OK"));
}
public int DeleteArquivo(UploadParceiro up, string datasource, string schema)
{
int ret = 0;
var root = ConfigurationManager.AppSettings.Get("PATHARQUIVOS") + "\\UPLOAD";
UploadParceiro upret = this.GetUploadById(up, datasource, schema);
if (System.IO.File.Exists(root + up.txpath))
{
System.IO.File.Delete(root + up.txpath);
}
string queryfuncupdate = string.Format("delete uploadparceiro where CdUploadParceiro = " + up.CdUploadParceiro);
ret = Util.OracleHelper.ExecProcedureNonQuery(queryfuncupdate, null, System.Data.CommandType.Text, datasource, schema);
return(ret);
}
public static List <UploadParceiro> ConsultarNfe(UploadParceiroPesquisa upp, string cdpai, string cdentifilial, string datasource, string schema)
{
List <UploadParceiro> lstret = new List <UploadParceiro>();
UploadParceiro uploadret = new UploadParceiro();
StringBuilder query = new StringBuilder();
query.Append("select cduploadparceiro,u.cdfornecedor,(select nmentidade from entidade where cdentidade = u.cdfornecedor) as nmfornecedor,txinfo,cdentifilial, ");
query.Append(" to_char(dtinclusao,'DD/MM/YYYY') as dtinclusao,txpath from uploadparceiro u where stexcluido = 0 ");
if (!string.IsNullOrEmpty(upp.dtinicio) && !string.IsNullOrEmpty(upp.dtfim))
{
query.AppendLine(string.Format(" and trunc(dtinclusao) between to_date('{0}','DD/MM/YYYY') and to_date('{1}','DD/MM/YYYY')", upp.dtinicio, upp.dtfim));
}
query.AppendLine(string.Format("and cdfornecedor = {0}", cdpai));
query.AppendLine(string.Format("and cdentifilial = {0}", cdentifilial));
query.AppendLine(" order by dtinclusao desc");
using (OracleConnection connection = new OracleConnection(Util.OracleHelper.StrConn(schema, datasource)))
{
OracleCommand command = new OracleCommand(query.ToString(), connection);
connection.Open();
using (OracleDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
uploadret = new UploadParceiro();
uploadret.CdUploadParceiro = Convert.ToInt32(reader["cduploadparceiro"].ToString());
uploadret.dtinclusao = reader["dtinclusao"].ToString();
uploadret.nmfornecedor = reader["nmfornecedor"].ToString();
uploadret.txpath = "/UPLOAD/" + reader["txpath"].ToString();
uploadret.txinfo = reader["txinfo"].ToString();
uploadret.Cdfornecedor = Convert.ToInt32(reader["Cdfornecedor"].ToString());
uploadret.cdentifilial = Convert.ToInt32(reader["cdentifilial"].ToString());
lstret.Add(uploadret);
}
}
}
return(lstret);
}
