public int insertWfCdocu(TOWfCdocu wfdocu)
{
//Consulta si ya hay adjuntos
List <TOWfCdocu> wfcdocu = DAODocu.getWfCdocu(wfdocu.cas_cont);
int doc_cont = wfcdocu == null || !wfcdocu.Any() ? 1 : wfcdocu.Max(d => d.doc_cont + 1);
wfdocu.doc_cont = doc_cont;
int retorno = DAODocu.insertWfCodcu(wfdocu);
return(retorno);
}
public int insertWfCodcu(TOWfCdocu wfcdocu)
{
DateTime date = DateTime.Now;
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO WF_CDOCU ");
sql.Append(" (EMP_CODI,CAS_CONT,DOC_CONT,DOC_DESC,DOC_BLOB,AUD_ESTA,AUD_USUA,AUD_UFAC) ");
sql.Append(" VALUES(@EMP_CODI,@CAS_CONT,@DOC_CONT,@DOC_DESC,@DOC_BLOB,@AUD_ESTA,@AUD_USUA,@AUD_UFAC) ");
List <Parameter> parametros = new List <Parameter>();
parametros.Add(new Parameter("@EMP_CODI ", emp_codi));
parametros.Add(new Parameter("@CAS_CONT", wfcdocu.cas_cont));
parametros.Add(new Parameter("@DOC_CONT", wfcdocu.doc_cont));
parametros.Add(new Parameter("@DOC_DESC", wfcdocu.doc_desc));
parametros.Add(new Parameter("@DOC_BLOB", wfcdocu.doc_blob));
parametros.Add(new Parameter("@AUD_ESTA", "A"));
parametros.Add(new Parameter("@AUD_USUA", usu_codi));
parametros.Add(new Parameter("@AUD_UFAC", DateTime.Now));
OTOContext pTOContext = new OTOContext();
var conection = DBFactory.GetDB(pTOContext);
return(conection.Insert(pTOContext, sql.ToString(), parametros.ToArray()));
}
