public OperationResult AddSignatureGroup(SignatureGroup signatureGroup) { OperationResult operationResult = new OperationResult(); try { string query = "INSERT INTO [AnnotationGroups]" + " (" + " [AnnotationGroup]" + ")" + "VALUES" + "(" + "@AnnotationGroup" + ")"; using (SqlConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection)) { db.Execute(query, new { @AnnotationGroup = signatureGroup.GroupName, } ); } operationResult.Success = true; return operationResult; } catch (Exception er) { operationResult.Success = false; operationResult.AddMessage(er.Message); return operationResult; } }
public List<SignatureGroup> GetSignatureGroups() { List<SignatureGroup> signatureGroupList = new List<SignatureGroup>(); List<SignatureGroup> signatureGroupList2 = new List<SignatureGroup>(); SignatureGroup signatureGroup = new SignatureGroup(); signatureGroup.Id = 0; signatureGroup.GroupName = "Select Group Name"; signatureGroupList.Add(signatureGroup); try { using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection)) { string query = "SELECT [ID],[AnnotationGroup] as GroupName" + " FROM [AnnotationGroups]" + " order by [AnnotationGroup]"; signatureGroupList2 = db.Query<SignatureGroup>(query).ToList(); for (int i = 0; i < signatureGroupList2.Count; i++) { signatureGroupList.Add(signatureGroupList2[i]); } return signatureGroupList; } } catch (Exception er) { Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString()); return signatureGroupList; } }