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())); }