//Determines if document is participant or contractor document /// <summary> /// Determine if document is a participant or contractor document based on DocumentEntity /// </summary> /// <param name="doc">Document to check type on</param> /// <param name="validType">true if validEntityType else false</param> /// <returns>string either 'participant' or 'contractor'</returns> public static string DetermineDocEntityType(this IFameDocument doc, out bool validType) { if (GetFarmBusinessByFarmId(doc.DocumentEntity) == 0) { if (GetParticipantIDFromContractor(doc.DocumentEntity) > 0) { validType = true; return("contractor"); } validType = false; return(null); } else { validType = true; return("participant"); } }
//Insert document information into the FAME database /// <summary> /// Insert document info into the FAME database /// </summary> /// <param name="NewDocument">Document to add to FAME</param> /// <param name="errorMessage">populates any error message received when upload fails</param> /// <returns></returns> public static bool AddFameDoc(this IFameDocument NewDocument, out string errorMessage) { bool finalStatus; int queryResult; string uploadTimestamp = DateTime.Now.ToString("yyyy-MM-dd hh:MM:ss.fff"); string queryString = $@" INSERT INTO { cfgSQLDatabase }.dbo.{ cfgSQLTable } ( [PK_1], [PK_2], [PK_3], [filename_actual], [fk_participantTypeSectorFolder_code], [created], [created_by], [modified], [modified_by], [filename_display], [filepath]) VALUES ('{ NewDocument.PK1 }', { CheckNullPks(NewDocument.PK2) }, { CheckNullPks(NewDocument.PK3) }, '{ NewDocument.DocumentName }', '{ NewDocument.DocumentTypeFolderSectorCode }', '{ uploadTimestamp }', '{ NewDocument.WacUploadUser }', NULL, NULL, '{ NewDocument.DocumentName }', '{ NewDocument.FinalFilePath }') "; using (SqlConnection conn = new SqlConnection(GetConnectionString())) { try { conn.Open(); SqlCommand query = new SqlCommand(queryString, conn); queryResult = query.ExecuteNonQuery(); errorMessage = null; finalStatus = true; } catch (Exception e) { WriteFameLog("error", e.Message); errorMessage = e.Message; finalStatus = false; } } return(finalStatus); }