public int AddOrganisation(Organisation org)
{
using (var connection = GetOpenMapsConnection())
{
string query = @"INSERT INTO tblOrganisation (OrganisationName, Phone, MailEnabled) VALUES (@OrganisationName, @Phone, @MailEnabled);";
return connection.Execute(query, org);
}
}
public int AddOrganisation2(Organisation org)
{
using (var connection = GetOpenMapsConnection())
{
string query = @"INSERT INTO tblOrganisation (OrganisationName, Phone, MailEnabled) VALUES (@OrganisationName, @Phone, @MailEnabled);
SELECT CAST(SCOPE_IDENTITY() as int);";
org.OrganisationId = connection.Query<int>(query, org).Single();
if (org.OrganisationId > 0)
{
return 1;
}
return 0;
}
}