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