private bool InsertIntoComments(DataTable dataTable)
{
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings[“ASCGrants_DevConnection”].ConnectionString;
if (string.IsNullOrWhiteSpace(connectionString))
return false;
SqlConnection connection = new SqlConnection(connectionString);
using (connection)
{
SqlTransaction transaction = null;
connection.Open();
try
{
transaction = connection.BeginTransaction();
using (var sqlBulkCopy = new SqlBulkCopy(connection, SqlBulkCopyOptions.TableLock, transaction))
{
sqlBulkCopy.DestinationTableName = “Comments”;
sqlBulkCopy.ColumnMappings.Add(“CommentsGuid”, “CommentsGuid”);
sqlBulkCopy.ColumnMappings.Add(“HostApplicationGuid”, “HostApplicationGuid”);
sqlBulkCopy.ColumnMappings.Add(“GrantsEntityGuid”, “GrantsEntityGuid”);
sqlBulkCopy.ColumnMappings.Add(“StatusGuid”, “StatusGuid”);
sqlBulkCopy.ColumnMappings.Add(“Description”, “Description”);
sqlBulkCopy.ColumnMappings.Add(“Active”, “Active”);
sqlBulkCopy.ColumnMappings.Add(“CreatedBy”, “CreatedBy”);
sqlBulkCopy.ColumnMappings.Add(“CreatedOn”, “CreatedOn”);
sqlBulkCopy.WriteToServer(dataTable);
}
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
connection.Close();
}
return true;
}